How to automate data enrichment for a list of businesses
Add phone, website, rating, position and a fit score to a list of names, once or every time a row is added. What to add, how matching goes wrong, and how to check it.
Part of the guide Location intelligence automation
To automate data enrichment for a list of businesses, give each row enough to be found (a name plus an address or a city), look each one up by its name near where it is, add the fields you will actually use, such as phone, website, rating and kind of place, and keep a column that says how sure the match is. Do it once for a list you already have, or set it to run every time someone adds a row.
Enrichment is the step between a list of names and a list people can work: a rep cannot call a name, and a planner cannot map one. This article is for sales, operations and marketing teams who keep lists in spreadsheets or a CRM. It covers what to add, the one-off and the continuous ways to do it, a worked example and the mistakes that put wrong phone numbers in front of a sales team. The workflow automation guide explains the wider idea.
What to add, and what to leave out
Add only fields someone will use within a week. Each extra column is something to check and keep fresh. For most lists of businesses, these are worth adding:
- Position (latitude and longitude). Everything location-based depends on it: maps, distances, territories, routes.
- Phone and website. The two fields a sales team asks for first.
- Rating and number of reviews. A quick sense of how established and well thought of a business is.
- Kind of place. A clean category, so the list can be split and filtered.
- A fit score with a reason. How good a prospect each one is for you, written by an AI step from the fields above.
Leave out what you cannot keep up to date, and anything you have no use for yet. A wide list goes stale faster than a narrow one.
Once, or every time a row arrives
Once suits a list you already have: last year's trade show contacts, a purchased list of dealers, a sheet of target accounts. On the My data page, Enrich a list takes a CSV, gives each row a position from its address or city, shows what enriching it will cost before anything runs, and looks the rows up up to 100 at a time. It can also score each row with xMap AI from a sentence you write. The result is a new table, named after your list with (enriched) on the end, and a CSV to download.
Every time suits a list that keeps growing: leads a team types into a shared sheet, sign-ups from a form, sites a broker sends. A flow starts with the New rows trigger on a Google Sheets sheet or a My data table, so each new row becomes an item. Map business scan, set to look around each incoming place for Each place itself, finds each business by its name near where it is and adds its address, phone, website, rating and status. An xMap LLM block then scores it, and the enriched row goes where the team works: back to a sheet, into a CRM, or to your own database with Save to my database.
A worked example
This example is made up. A company that supplies commercial kitchens in Lisbon has a shared sheet where its two reps paste restaurants they hear about: a name and a neighbourhood, nothing else. By Friday the sheet has forty rows nobody has called, because each needs a phone number found by hand.
- The sales lead starts from the template Enrich a lead sheet and push it to HubSpot, which begins with New rows on the lead sheet.
- Map business scan looks each restaurant up by its name near its neighbourhood and adds the address, phone, website and rating.
- An xMap LLM block scores each one from 0 to 100 as a kitchen equipment customer and writes one opening line a rep could use.
- The enriched company goes into the CRM and the sales lead gets a short email with what was added.
Now a rep pastes a name, and a few minutes later the row has a phone number, a score and an opener. Before trusting it, the sales lead checks the first twenty matches by hand against the names in the sheet.
Where matching goes wrong
Enrichment is a guess that a name in your list and a business on the map are the same thing. Most of the time it is right; the misses follow patterns you can watch for.
- Short or common names. A one-word name such as Central or Bella can match the wrong business. Give the full trading name and a street or neighbourhood.
- No place at all. A name with no address or city cannot be searched near anywhere. Rows without a position stay as they came.
- Chains. A brand name matches its nearest branch, which may not be the one you meant. Add the branch's street.
- Closed businesses. A business that closed may still be found, marked closed. Keep the status column and filter on it.
- Overwriting your own data. Write enriched fields into new columns, so a wrong match never replaces a phone number a rep checked.
Keeping an enriched list fresh
Phone numbers change, places close and ratings move. A list enriched once in spring is partly wrong by autumn. To refresh it, run the same list through the lookup on a schedule: a Schedule, then My data with your table, then Map business scan on each place. Add What changed after it to pass on only the places whose details changed since the last run, such as a business that closed or a rating that moved, so the email holds the few rows to update, not the whole list again.
For the people to talk to at each company, the Apollo block adds names and job titles from your own Apollo account. More detail is in Enrich a list once and Data enrichment.
Questions
What does a row need to be enriched?
A business name and something that says where it is: an address, a city, or a latitude and longitude. Rows with no position cannot be looked up and stay as they came.
How many rows can I enrich at once?
Enrich a list looks up to 100 rows at a time and shows the cost before it runs. A flow with Map business scan looks up to 100 places a run.
Will it overwrite my own columns?
The enriched fields are added beside your own. Keep them in separate columns so a wrong match never replaces data your team checked.
Can it add contact people too?
Yes, with the Apollo block and your own Apollo account: names, job titles and, in real runs, work emails at each company.
Templates that do this
Read next
More on business and places data · Every article · Templates