Skip to main content

Get Column

Retrieves a column 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 column data.
  • Start Cell - The cell reference (e.g., "A1", "B2") indicating the starting point of the column to retrieve.

Options​

No additional options available for this node.

Output​

  • Column - An array of values from the specified column in the spreadsheet.

How It Works​

The Get Column node retrieves a column of data from a Google Spreadsheet starting from a specified cell. When executed, the node:

  1. Validates the provided Spreadsheet Id and Start Cell inputs
  2. Connects to the Google Spreadsheet using the provided ID
  3. Converts the cell reference to grid coordinates
  4. Retrieves all values from the specified sheet
  5. Extracts the column data starting from the specified row
  6. Sets the retrieved column data to the output variable
  7. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet ID
  • A valid cell reference in the format of a letter followed by a number (e.g., "A1", "B2")
  • Proper Google Sheets API authentication and permissions

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid Spreadsheet Id
  • Empty or invalid Start Cell reference
  • Invalid cell reference format
  • 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
  • The Start Cell reference determines which column to retrieve and from which row to start
  • The output Column variable will contain an array of values from the specified column
  • Empty cells in the column will be represented as empty strings in the output array
  • Ensure your Google account has proper permissions to read from the target spreadsheet