Skip to main content

Insert Column

Inserts a column of data into 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 where the column data will be inserted.
  • Start Cell - The cell reference (e.g., "A1", "B2") indicating where to start inserting the column data.
  • Column Data - An array of values to be inserted as a column in the spreadsheet.

Options​

No additional options available for this node.

Output​

No output variables for this node.

How It Works​

The Insert Column node adds a column of data to a Google Spreadsheet starting from a specified cell. When executed, the node:

  1. Validates all input parameters
  2. Connects to the Google Spreadsheet using the provided ID
  3. Converts the cell reference to grid coordinates
  4. Calculates the range for inserting the column data
  5. Prepares the column data in the required format
  6. Sends an append request to insert the column data
  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")
  • Valid column data as an array of values
  • 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
  • Empty or invalid Column Data
  • 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 where the column data will be inserted
  • The Column Data should be provided as an array of values
  • The data will be inserted as a column, with each array element in a separate row
  • This operation modifies the spreadsheet data, so use with caution
  • Ensure your Google account has proper permissions to modify the target spreadsheet