Google Sheets · New row — When a row is added to the end of a Google Sheet — checks a sheet on a schedule. Each row added to the end since the last check starts a run, with the row's values by their column headings.

Who can do this

Workspace Admins and Editors, on every plan.

Before you start

Steps

  1. Open the workflow in the designer and open the trigger picker — Browse all triggers, or Change how it starts on an existing trigger.
  2. Type Sheets in Search triggers, and select New row.
  3. In Connection, choose your Google Workspace connection.
  4. Under Spreadsheet, select Choose. Google's own picker opens; pick the spreadsheet. Chosen with Google's picker — Bizomate sees only the files you pick.
  5. In Sheet, choose the tab.
  6. Under Checks, choose Every 5 minutes or Every 15 minutes.
  7. Open the Output tab and select Fetch a sample. The newest row comes in, and Test run starts with it. A toast says Sample fetched — Test run starts with it. Unpin it on Output to test with something else.
  8. Add the steps, test, then Publish.

What happens next

  • The first check after publishing only counts the rows. Rows already there never start a run — only rows added after you publish.
  • Each new row starts one run, with each column by its heading — {{ trigger.Customer }} — and {{ trigger.rowNumber }}. An empty heading is named by its column, Column C.
  • Up to 100 new rows start runs in one check; the rest wait for the next check, in order.
  • A check that finds nothing starts no run and costs nothing.
  • The trigger's Settings show what it is doing: Checking every 5 minutes — Last checked 10:45 · next 10:50, and Recent checks — Nothing new, or 2 found · 2 runs. Only checks that found something become runs and count. The list keeps a day of checks.

Good to know

  • Every 5 minutes is for paid plans. On Free it checks every 15 minutes whatever is chosen.
  • New means past the end. Bizomate remembers how many rows the sheet had, counted down its first column. Sorting or deleting rows above the end can make a row look new again — keep a sheet you add to at the end.
  • Keep the first column filled in. A row with nothing in column A is not counted.
  • If rows are deleted so the sheet is shorter than before, counting starts again from there.
  • Changing the spreadsheet, sheet or connection and publishing starts counting again from then.
  • Runs start in Production and count in the month's allowance.

If something goes wrong

What you see Why What to do
Nothing matches yet — add one, then fetch again. The sheet has no rows below its headings. Add a row, then Fetch a sample.
Choose the spreadsheet and its sheet. One of them is not chosen. Choose both.
Not checking since 10:45 with Google Sheets refused the check: … The connection may need reconnecting, or lacks permission. Google stopped accepting the connection. Select Reconnect, then Check now. See When an app trigger stops checking.
New row is not in the trigger picker App triggers only appear when you search. Type Sheets in Search triggers.
An old row started a run Rows above the end were sorted or deleted. Add rows only at the end of the sheet.