Skip to main content

Append Range

Appends a range of data to 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 data range will be appended.
  • Table - A structured table of data to be appended to the spreadsheet.

Options​

No additional options available for this node.

Output​

No output variables for this node.

How It Works​

The Append Range node adds a structured table of data to the end of a Google Spreadsheet. When executed, the node:

  1. Validates all input parameters
  2. Connects to the Google Spreadsheet using the provided ID
  3. Processes the table data to convert it to the required format
  4. Determines the appropriate location to append the data (typically at the end of the sheet)
  5. Sends an append request to add the data to the spreadsheet
  6. Automatically inserts new rows as needed to accommodate the appended data
  7. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet ID
  • Valid table data in the required format
  • 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 Table data
  • 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 or from the Open Spreadsheet node
  • The Table input should be a structured data object with columns and rows
  • Data is appended to the end of the sheet, preserving existing data
  • New rows are automatically inserted to accommodate the appended data
  • This operation modifies the spreadsheet data by adding new content
  • Ensure your Google account has proper permissions to modify the target spreadsheet