Skip to main content

Trigger

Triggers automation based on changes in a Google Spreadsheet.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Spreadsheet URL - The full URL of the Google Spreadsheet to monitor for changes.

Options​

  • Trigger Event - Specifies what changes will trigger the automation:
    • When New Row Added to Sheet - Triggers when a new row is added to the sheet
    • Any Changes are Made to Document - Triggers when any changes are made to the spreadsheet
  • Polling Interval (Minute) - How often to check for changes (between 1-15 minutes).
  • Sheet Name - The name of the specific sheet to monitor (only available for new row event).
  • Credentials - The Google Sheets API credentials used to authenticate with the service.

Output​

  • Spreadsheet Id - The ID of the Google Spreadsheet that triggered the automation.

How It Works​

The Trigger node monitors a Google Spreadsheet for specified changes and initiates automation workflows when those changes occur. When configured, the node:

  1. Validates all input parameters and credentials
  2. Authenticates with the Google Sheets API using the provided credentials
  3. Establishes a monitoring loop that periodically checks for changes
  4. For "New Row Added" events:
    • Monitors the specified sheet (or first sheet if none specified) for new rows
    • Triggers automation when the row count increases
  5. For "Any Changes" events:
    • Monitors the entire spreadsheet for any modifications
    • Triggers automation when the spreadsheet's revision history shows changes
  6. Outputs the Spreadsheet Id when triggering conditions are met
  7. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet URL
  • Valid Google Sheets API credentials with appropriate permissions
  • Internet connectivity to access Google Sheets API
  • Proper permissions to read the specified spreadsheet

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid Spreadsheet URL
  • Invalid or missing Google Sheets API credentials
  • Authentication failures with Google Sheets API
  • Network or connectivity issues with Google Sheets API
  • Spreadsheet not found or inaccessible
  • Invalid Polling Interval (must be between 1-15 minutes)
  • Specified Sheet Name does not exist (for new row events)

Usage Notes​

  • This is a trigger node that starts workflows rather than processing data within them
  • The Polling Interval determines how frequently the node checks for changes
  • For "New Row Added" events, you can specify which sheet to monitor
  • For "Any Changes" events, the node monitors the entire spreadsheet
  • The output Spreadsheet Id can be used in subsequent nodes in the workflow
  • Credentials must have appropriate permissions to access the specified spreadsheet
  • The node runs continuously while the flow is active