Trigger Google Sheets
Google Sheets Change Monitor
Monitors a Google Sheet for changes by polling the API at regular intervals. Fires when data changes are detected.
Node IDGoogleSheetsChangeTrigger
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Spreadsheet ID spreadsheet_id | string | Yes | — | The Google Sheets spreadsheet ID (found in the URL). |
Range to Monitor range | string | Yes | Sheet1!A1:Z100 | The A1 notation range to monitor for changes (e.g., "Sheet1!A1:D10"). |
Access Token Secret Key access_token_secret_key | string | Yes | GOOGLE_SHEETS_ACCESS_TOKEN | The key in the Secrets store that holds your Google OAuth 2.0 access token. |
Poll Interval (seconds) poll_interval_seconds | integer | No | 60 | How often to check for changes (minimum 10 seconds, maximum 3600 seconds). |
Outputs
| Output | Type | Identifier | Description |
|---|---|---|---|
On Data Changed output0 | object | sheet_changed | Fired when the sheet data changes. Emits the current sheet values. |