Skip to main content

Open Spreadsheet

Opens a Google Spreadsheet and retrieves its ID for use in other nodes.

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 open.

Options​

  • Credentials - The Google Sheets API credentials used to authenticate with the service.

Output​

  • Spreadsheet Id - The ID of the opened Google Spreadsheet, which can be used in other nodes.

How It Works​

The Open Spreadsheet node establishes a connection to a Google Spreadsheet using its URL and retrieves the spreadsheet's unique ID. When executed, the node:

  1. Validates the provided Spreadsheet URL and Credentials
  2. Authenticates with the Google Sheets API using the provided credentials
  3. Opens the spreadsheet specified by the URL
  4. Extracts and returns the spreadsheet's unique ID
  5. Handles token refresh if necessary
  6. 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

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

Usage Notes​

  • The Spreadsheet URL should be the full web address of your Google Spreadsheet
  • The output Spreadsheet Id can be used as input for other Google Sheets nodes
  • Credentials must have appropriate permissions to access the specified spreadsheet
  • This node is typically used at the beginning of a workflow to obtain the spreadsheet ID
  • The node handles credential token refresh automatically when needed