Skip to main content

Get Row

Retrieves a specific row 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 row data.
  • Row Number - The row number (1-based index) to retrieve.

Options​

  • Headers - If enabled, the first row of the sheet will be used as column headers.
  • Jsonify - If enabled, the output data will be formatted as JSON.

Output​

  • Row - A structured representation of the retrieved row data, either as a map or array depending on the Headers option.

How It Works​

The Get Row node retrieves a specific row of data from a Google Spreadsheet. When executed, the node:

  1. Validates all input parameters
  2. Connects to the Google Spreadsheet using the provided ID
  3. Retrieves all data from the specified sheet
  4. Extracts the specified row based on the Row Number input
  5. Processes the row data based on the Headers option:
    • If Headers is enabled, uses the first row as column names
    • If Headers is disabled, uses column letters as keys
  6. Converts to JSON format if the Jsonify option is enabled
  7. Sets the processed data to the output variable
  8. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet ID
  • A valid row number (1-based index)
  • 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 Row Number (negative or zero)
  • 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
  • Row numbers are 1-based, meaning the first row is row 1, not row 0
  • When Headers is enabled, the first row of the sheet is used as column names
  • When Headers is disabled, column letters (A, B, C, etc.) are used as keys
  • The Jsonify option converts the output to a standardized JSON format
  • The output Row variable contains the data from the specified row
  • Ensure your Google account has proper permissions to read from the target spreadsheet