How to automate Google Sheets updates with fresh rows every morning
Add new rows to a sheet on a timetable without repeats, update rows that are already there, and start work when your team types a row: the three patterns, with an example.
Part of the guide Location intelligence automation
To automate Google Sheets updates, connect a flow to the sheet with your own sign-in, have it find new data on a timetable, drop anything it has already added, and write only the rest as new rows at the bottom. When rows may already be in the sheet, use a find-or-create step so a match is left alone instead of copied. And when the sheet is where your team types requests, turn it around: let each new row start the flow.
This is for teams whose shared spreadsheet is the real system: a prospect list, a supplier register, a site tracker. Below are the three patterns, the setting that stops duplicate rows, a made-up example, the mistakes that scramble a sheet, and how an AI employee in xMap Flows keeps it current while you sleep. For the bigger picture of triggers and actions, see the workflow automation guide.
Three ways a sheet gets updated automatically
- Append. Each run adds new rows: the businesses that opened this week, the jobs posted overnight, the sites that changed. This is the most common pattern and the easiest to keep clean.
- Find or create. Each item is looked up in the sheet first; if a row with the same key exists it is left alone, otherwise a row is added. Use this when two flows, or a person and a flow, may add the same thing.
- Read and react. The sheet is the input. When someone adds a row (a lead, an address, a request), a flow picks it up, does the work and writes the result somewhere: back to the sheet, to email, to a chat channel.
Keeping rows from repeating
A daily flow that searches the same city finds mostly the same places every day. Without memory, your sheet would grow by the same rows each morning. In xMap Flows the Only new block solves this before anything reaches the sheet: it remembers every item the flow found in its real runs and lets through only the ones it has not seen, each with the date it was first found. Put it straight after the block that finds things, so only new items are scored and written.
Only new remembers per flow, not per sheet. If a colleague also pastes rows by hand, use the Google Sheets app block's Find or Create Row action instead of plain Add Row: it reports back on each item whether it was already in the sheet (with its row number, so it was not added again) or added as a new row.
Rows added by the flow take the sheet's own look: if the sheet has a table just above, the table is stretched over the new row, otherwise the row above's format and data checks are copied, so your colours and drop-downs survive.
A worked example
This example is made up. An office furniture dealer in Chicago keeps a sheet called "New offices" that its two reps work from. Every morning it should gain the businesses that look like new offices near the showroom, with a phone number, and nothing twice.
- A Schedule starts the flow at 07:00 on weekdays.
- Nearby places searches within 10 km of the showroom for coworking spaces, corporate offices and law firms that opened in the last 6 months, keeping only places with a phone or website.
- Only new drops everything a previous morning already found.
- The Google Sheets app block, run once per item, uses Add Row on the "New offices" sheet, mapping name, type, address, phone, website and the date first found into columns A to F.
- An Email to the sales manager says how many rows were added today and links the sheet.
On the first morning the sheet gains every match; after that it gains only the handful that are new each day, and the reps sort by date to see the latest at the top of their view.
When the sheet is the starting point
Reverse the direction with the New rows trigger. Point it at a Google Sheets sheet and choose how often to check: every 5 minutes, every 15 minutes or every hour. Its first look only counts the rows already there; every row added after that becomes an item, with the first row's column names as its fields. A rep types a business name and a city; the flow looks it up, adds the phone, website and rating, scores it and posts it to Slack. The template Score new leads from a Google Sheets sheet does exactly this.
Mistakes that scramble a sheet
- Sorting the sheet the flow watches. New rows counts rows by their place, so add rows at the bottom. Sorting or deleting rows above can make old rows look new or hide new ones. Sort in a filter view instead.
- Renaming the header row. The flow maps fields to columns; if someone renames "Phone" to "Tel", check the mapping.
- Leaving out Only new on a schedule. The result is the same businesses pasted every day.
- One giant sheet for everything. A tab per purpose (new offices, follow-ups, lost) is easier to watch and to point a flow at.
- Expecting instant reaction. A sheet is checked on the timetable you choose, not the second a row appears; a table in My data starts the flow as soon as rows arrive.
Setting it up as an AI employee
Connect your account once on the Google Sheets app block (it is a personal connection: it uses only spreadsheets whose link or ID you paste, or ones the flow creates for you with the fields as a header row). Start from a template that already ends in a sheet, such as New businesses routed by size, which sends key accounts to Slack and the rest to a sheet, or Best-rated suppliers near me. Deploy it, and each morning the AI employee writes its rows and leaves a short note in its Team inbox thread saying what it added.
Questions
Will the flow overwrite rows my team edited?
No. Add Row only appends at the bottom, and Find or Create Row leaves an existing row alone. Your team's edits stay as they are.
How many rows can one run add?
Run once per item, the Google Sheets app block writes up to 100 items a run. Run once per run, it writes a single summary row, or a whole CSV to Google Drive if you prefer a file.
Can it update a row instead of adding one?
Find or Create Row checks for an existing row and adds only when none matches. For lists that change, the What changed block can pass on only the places whose details changed, which you then write as new dated rows.
How quickly does a new row start the flow?
A Google Sheets sheet is checked every 5 minutes, 15 minutes or hour, as you choose. Up to 500 new rows are taken a run; any more wait for the next check.
Templates that do this
Read next
More on business and places data · Every article · Templates