How to get a fresh business list in Google Sheets every week
Set up a weekly run that searches your area, keeps only the places it has not added before and writes each one as a new row in your team's sheet.
Part of the guide Location intelligence automation
To get a business list in Google Sheets every week, set up a flow with four parts: a Schedule set to one morning a week, a search of your area for the kinds of business you want, an Only new step that drops every place already sent, and the Google Sheets app block that adds each remaining place as a row. Your team opens the same sheet on Monday and finds this week's additions at the bottom, with name, type, address, phone, website and rating already filled in.
This is for sales, partnership and account teams who already live in a spreadsheet and do not want another tool to check. It covers how to lay out the sheet before you start, the order of the blocks, the choices that decide whether the sheet stays clean, a made-up example, and the mistakes that quietly break a weekly sheet.
Decide what the sheet is for first
A weekly sheet works when every row means the same thing. Before building anything, write down in one line what a row is. "A business in our delivery area that could buy from us and that nobody has contacted yet" is a good line. "Interesting places" is not, because nobody can tell when a row is done.
Then fix the columns. The flow can fill these on its own, so give each one a heading in the first row of the tab:
| Column | Filled by | Why keep it |
|---|---|---|
| Name | The search | What the rep looks up |
| Type | The search | Lets you filter the tab later |
| Address and city | The search | Where to go, and for territory splits |
| Phone and website | The search, when known | How to reach them |
| Rating and reviews | The search, when rated | A quick sense of size and quality |
| First seen | Only new | The week it entered the sheet |
| Score and reason | xMap LLM, if you add it | Which rows to call first |
| Owner, status, notes | Your team, by hand | The work done on each row |
A suggested layout. Leave the last columns empty for your team; the flow never writes into them.
The flow, block by block
- Schedule: every week, on the day and hour your team plans its week, in your own time zone.
- Area of interest: the cities or the shapes you draw on the map. A delivery zone is often better drawn than named.
- Nearby places: the types of business, up to 12 in one block, searched across the area. Add Only places with a phone or website if your team calls or emails.
- Only new: set to remember forever, so a business sent once never comes back as new.
- Optional: xMap LLM scores each new place against a sentence about your best customers, and writes one line of reason.
- The Google Sheets app block: your connected account, the spreadsheet, the tab, and a row for each item, with each column matched to a field.
Put Only new before the scoring step, not after. You pay for scoring only the rows that will actually be written, and a quiet week stays quiet.
Add Row or Find or Create Row
The Google Sheets app gives two ways to write. Add Row writes every item as a new row at the bottom; a new row takes the look of the rows above it, or the table it sits under. Find or Create Row first looks for the business in a column you choose, such as the name or website, and adds it only when it is not there, saying "already in the sheet as row N" otherwise.
With Only new in the flow, Add Row is usually enough: the flow already knows what it sent. Find or Create Row helps when people also add businesses to the same tab by hand, or when you start the flow on a sheet that already has a year of rows in it.
A made-up example
Say a coffee roaster in Lisbon sells beans to cafes, bakeries and small hotels. Its two reps keep a shared tab called Prospects. The flow runs every Monday at 07:00 Lisbon time, searches the city and two neighbouring towns for coffee shops, bakeries and bed and breakfasts, keeps only places that are open and have a phone, drops anything already sent, scores the rest for "independent, well rated, likely to serve specialty coffee", and adds the rows.
The first Monday, the tab fills with a few hundred rows, because everything is new. That is the starting stock. From the second Monday on, only places that appeared in the database since then arrive, so the reps see a short batch, sorted by score, rather than the whole city again.
Mistakes that break a weekly sheet
- Renaming or moving the columns after the flow is set up. The block writes to the columns it was matched to; change the match too.
- Sorting the tab in place by score or city. That is fine for reading, but use a filter view so rows keep their order and people do not overwrite each other.
- Two flows writing to one tab. Each flow has its own memory of what it sent, so the same bakery can arrive twice. Give each flow its own tab, or use Find or Create Row.
- Testing on the live tab. Test runs send nothing, but Run once does. Point the block at a test tab while you build.
- Expecting yesterday's openings. Nearby places reads xMap's places database, refreshed every month. For places that opened this week, add Map business scan, which searches online maps live.
When a sheet is not the best home
A sheet is good for a small team working a list together. When the list grows into thousands of rows, or when you want each business's history, the Results page in the app keeps every place a flow found, when it was first and last seen, and its score. Many teams keep both: the sheet for this week's work, Results for the record. For the bigger picture of putting location data on a timetable, see location intelligence automation.
You can also send the same weekly batch to email or Slack in the same flow, so the reps get a note that the sheet has new rows without opening it to check.
Questions
Can the flow update rows that are already in the sheet?
Find or Create Row can find a business already there. To follow changes such as a place closing or its rating moving, add the What changed block and write those to a second tab.
Do I need to keep the sheet open for the flow to work?
No. The flow runs on xMap's side on its timetable and writes through the account you connected for Google Sheets, whether anyone has the sheet open or not.
What if a week finds nothing new?
Nothing is written. The sheet simply has no new rows that week, and the run shows that Only new let nothing through.
Can different reps get different tabs?
Yes. Split the items by city or by territory first, then use one Google Sheets block per tab, each fed by its own share of the list.
Templates that do this
Read next
More on business and places data · Every article · Templates