Google Sheets Trigger Nexviahub icon

Google Sheets Trigger Nexviahub

Starts the workflow when Google Sheets events occur

Google Sheets Trigger Nexviahub

AI-generated

Summary

Polls a selected Google Sheets tab for row changes and emits changed rows as workflow items. Choose a polling schedule, spreadsheet and sheet, then select whether to detect added rows, updated rows, or both.

Inputs

  • Poll Times (required) — Set one or more polling intervals, such as every minute, hourly, daily, weekly, monthly, every X minutes or hours, or a custom cron expression.
  • Google OAuth credentials (required) — Provide the Client ID, Client Secret, Refresh Token, and Access Token fields shown in the node. The request code obtains an access token using the client ID, client secret, and refresh token.
  • Document (required) — Select a spreadsheet from the list, or provide its Google Sheets URL or ID.
  • Sheet (required) — Select a tab in the chosen spreadsheet, or provide its sheet URL or ID.
  • Trigger On (required) — Choose Row Added, Row Updated, or Row Added or Updated. Update-based modes compare spreadsheet revisions and require edit access; without Columns to Watch, new columns can also trigger a change.
  • Include in Output — For update-based modes, return the new row values, old values, or both versions with per-field differences. This setting is used during automatic workflow execution.
  • Columns to Watch — For update-based modes, limit change detection to selected columns. If omitted or empty, changes across the row are checked.
  • Data Location on Sheet — Set the watched range in A1 notation, or choose row-based configuration and specify the header row and first data row. With no custom location, the node reads columns A through ZZZ, using row 1 for headers and row 2 onward for data.
  • Value Render — For Row Added mode, choose whether cell values are returned unformatted, formatted, or as formulas. Defaults to unformatted.
  • DateTime Render — For Row Added mode, choose serial-number or formatted-string date values. Defaults to serial numbers.

Output shape

A list of n8n items, each containing a changed spreadsheet row as JSON keyed by the sheet's header values.

Row Added emits new rows with their column values. Update-based modes include a row_number field; Row Added or Updated also includes change_type (added or updated). Both Versions wraps old and new row objects and includes a differences object. Manual runs return current rows for Row Added and, on the initial update-based run, current sheet rows; automatic polling stores revision or row-index state and emits changes after its baseline is established. A poll with no detected changes returns no items.

Links

Discussion