Skip to main content

Get Range

Retrieves a range of data from 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 Id - The ID of the Google Spreadsheet from which to retrieve the data range.
  • From Cell - The starting cell of the range to retrieve (e.g., "A1"). Used when targeting a specific range.
  • To Cell - The ending cell of the range to retrieve (e.g., "Z100"). Used when targeting a specific range.

Options​

  • Target - Specifies whether to retrieve all ranges or a specific range:
    • All Range - Retrieves all data from the sheet
    • Specific Range - Retrieves only data within the specified range (From Cell to To Cell)
  • Headers - If enabled, the first row of the range will be used as column headers.
  • Jsonify - If enabled, the output data will be formatted as JSON.

Output​

  • Table - A structured representation of the retrieved data range, including column headers and row data.

How It Works​

The Get Range node retrieves a range of data from a Google Spreadsheet and formats it as a structured table. When executed, the node:

  1. Validates all input parameters
  2. Connects to the Google Spreadsheet using the provided ID
  3. Determines the range to retrieve based on the Target option
  4. Retrieves the specified data range from the spreadsheet
  5. Processes the data to create a structured table with columns and rows
  6. Applies header formatting if the Headers option is enabled
  7. Converts to JSON format if the Jsonify option is enabled
  8. Sets the processed data to the output variable
  9. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet ID
  • Valid cell references for the range (if using specific range)
  • Proper Google Sheets API authentication and permissions

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid Spreadsheet Id
  • Invalid cell references for From Cell or To Cell
  • Google Sheets API authentication or permission errors
  • Network or connectivity issues with Google Sheets API

Usage Notes​

  • The Spreadsheet Id can be obtained from the URL of your Google Spreadsheet
  • When using specific range, both From Cell and To Cell should be specified
  • The Headers option is useful when the first row contains column names
  • The Jsonify option converts the output to a standardized JSON format
  • The output Table variable contains both column headers and row data
  • Ensure your Google account has proper permissions to read from the target spreadsheet