Google Sheets Trigger
Start a flow automatically whenever a new row is added to a Google Sheet.
The Google Sheets Trigger watches a Google Sheet for new rows and fires the flow once for each one. Connect your Google account, select a spreadsheet, and the trigger handles the rest — no polling, no manual runs.
It's designed to work with flows that process one record at a time. Each new row in your sheet becomes one flow run, with the row data passed downstream as JSON.
Setup
- Click Connect Google Account in the node and complete the OAuth flow
- Select the spreadsheet and sheet tab to watch
- Set the URL Column if you're feeding URLs to a Web Scraper node
- Toggle Active to deploy the trigger — the flow will start firing on new rows
Configuration
| Field | Description |
|---|---|
| Connected Google Account | Your linked Google account (set via OAuth) |
| Spreadsheet | The Google Sheet to watch |
| Worksheet | The specific tab to monitor (defaults to the first sheet) |
| URL Column | Column key that contains the URL value — e.g. url, A, or Website. Used when passing rows to a Web Scraper node. |
| Active | Whether the trigger is currently live and listening for new rows |
Output
| Name | Description | |
|---|---|---|
| Output | row_data | The new row as JSON: {"url": "...", "row": {"col1": "val1", ...}} |
The url field is extracted from whichever column you set in URL Column. The full row is available under row for downstream nodes that need other columns.
Tips
- The trigger fires once per new row — adding 10 rows at once will queue 10 flow runs
- Your sheet must have a header row; column names in the header become the keys in
row - Set Active to off if you want to pause the trigger without deleting it
- Connect a Web Scraper directly to this node's output to build a fully automated scraping pipeline
- Pair with a Flow Completion Event and Email Notification to get alerted if any row fails to process