Enrich a lead sheet and push it to HubSpot
Add a business name to a sheet and get it enriched, scored and in HubSpot with an opening line.
What it does
When your team adds a business to a Google Sheet: find it on the map with its phone, website and rating, score it with xMap AI and write an opening line for the rep, then create the company in HubSpot.
In one sentence: When a Google Sheet gets new rows, look each one up on online maps, score and rank them with xMap AI, then create company in HubSpot and email the list to you.
Why it is useful
Field reps and event teams collect names in a sheet. This flow turns each row into a complete CRM record with a score and something to say on the phone.
Who it is for
B2B sales & business development. Sales teams, SDRs and founders who need a steady list of the right businesses to call, with the person to ask for. Every use case for b2b sales
Best use cases
- Trade show leads typed into a sheet
- A partner team logging referrals
- Reps noting businesses they drove past
What each run gives you
- Companies in HubSpot
- An opener for the rep
- A summary email
The time it saves
Whenever a row is added to your sheet or table. Doing the same work by hand takes about 12 minutes each time, so it saves about 24 hours a month (an estimate). It is easy: 5 blocks.
The flow, block by block
- New row in the lead sheetTrigger · New rowsStarts the flow when new rows appear in a Google Sheet or in a table in My data.
- Find the businessxMap data · Map business scanFinds businesses on online maps live: name, category, rating, address, phone, website and whether it is open.
- Score and write an openerxMap AI · xMap LLMTell the AI what to do in plain words.
- Create the company in HubSpotApp · HubSpotPowerful CRM that offers tools for sales, customer service, and marketing automation.
- Email me a summaryAction · EmailSends one email per run with all the items, or one email per item.
Every block can be changed after you use the template: the city, the type of place, the score, where the results go.
Use it now
Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.
How to set it up
- Enrich a list once: A CSV of addresses or companies back with phone, website, rating and an AI score.
- Build your first flow in ten minutes: From a blank page to a flow that emails you a ranked list every morning.
- Map business scan: A live scan of online maps by type or your own search words.
- Your own tables and lists (My data): Upload a CSV, save lists of results, and use them in flows.
- How to find companies hiring for a role near you: Hiring signals by role and city, with the company's details and the person to call.
- POI data (points of interest): Records of places such as shops, clinics and offices, with their category, position and details.
- Lead scoring: Ranking prospects by how likely they are to buy.
More for B2B sales & business development
- Full outbound engine: find, research, approve, send: A complete outbound engine: find, research, write the first email, approve, then HubSpot.
- New businesses in my territory, researched, into HubSpot: Every new business in your territory, scored, with the decision maker, straight into HubSpot.
- Morning call list with decision makers and call notes: The 20 best clinics to call today, with the owner or director, in a sheet.
- Companies hiring buyers, and who to call: Companies hiring buyers this week, sized and scored, with their purchasing managers in HubSpot.
- New businesses routed by size: key accounts to Slack, the rest to a sheet: New businesses scored and routed by size: the established ones to key accounts, the rest to inside sales.
- More businesses like my best customers: Businesses that look like your best customers, near them, not yet in HubSpot.