Skip to main content
Use Google Sheets to start a flow when a row is added to a sheet, and to read and change spreadsheets from inside a flow. This flow marks every new order Received as soon as it lands in the sheet. Press Run to watch it. Every trigger and node needs a Google Sheets connection. See Connect Google Workspace to set one up. Create Google Sheet also needs a Google Drive connection, with the same Google account, when you pick a folder. Every node that reads or changes rows expects the column headers in row 1. Row numbers are the sheet’s own: row 1 is the header row, so data rows start at 2, and no node reads, updates or deletes the header row.

​
Triggers

The trigger checks the sheet every minute. When you save it, it records the ID of every row already in the sheet, and those rows never start a flow. Each row starts a flow once, the first time its ID appears in the Key Column. Edits, sorting and deleted rows never start a flow, and a row that is deleted and added again with the same ID does not start one either.

​
Nodes

Most nodes start with Spreadsheet, picked from your Drive, and then ask for the Worksheet (the tab). The worksheet list fills in once the spreadsheet is set, and the column lists fill in once the worksheet is set.

​
Troubleshooting

Open the trigger’s events. A row whose ID is already used by another row is listed as skipped with Another row has the same key, so this row did not trigger. A row with an empty Key Column waits until it has an ID, and rows that were in the sheet when you saved the trigger never start a flow.
Type the header exactly as it appears in row 1 of the sheet, or of the Filter Range. Case does not matter.
The tab was renamed or deleted. If it was renamed, choose it again in the trigger.
Google could not find the spreadsheet with this connection. Check that it still exists, then pick it again in the node.
Row 1 of the tab is empty. Put the column headers in row 1.
The header was renamed or removed. Pick the column again in the node.
Row numbers start at 2. Use a row_numbers output from Read Sheet Rows to get the right numbers.
Use a cell or a range with both corners, such as B5 or B2:D10. Open ranges such as B2:B or A:A do not work.
In Update Sheet Cells, the grid in Value must have as many rows and columns as the range. Change the range, or write one value to fill every cell.
Append Sheet Rows only writes to existing headers. Fix the column name, or turn on Add missing columns to create it.
Update Sheet Row found no matching row. Check the value, or set If no row matches to Insert a new row.
Several rows matched while If several rows match is Fail. Set it to Update the first or Update all.
Read from Columns read Maximum number of rows rows and more data may follow. Raise the limit under Advanced.
Connect Google Drive in Settings > Integrations with the same Google account, or leave Folder empty to create the spreadsheet in My Drive.
Tab names must be unique, whatever the case. Choose another Tab name or New tab name.
A spreadsheet must keep at least one tab. Add another tab before deleting this one.
The error ends with Google’s own reason. Check that the connection’s Google account can open and edit the spreadsheet.