Skip to main content

Append

Appends data from one Google Spreadsheet sheet to another sheet.

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​

  • First File Descriptor - The ID of the first Google Spreadsheet (source).
  • First Sheet Name - The name of the sheet in the first spreadsheet to get data from.
  • Second File Descriptor - The ID of the second Google Spreadsheet (destination).
  • Second Sheet Name - The name of the sheet in the second spreadsheet to append data to.

Options​

No additional options available for this node.

Output​

No output variables for this node.

How It Works​

The Append node copies data from one Google Spreadsheet sheet and appends it to another sheet. When executed, the node:

  1. Validates all four input parameters (both spreadsheet IDs and sheet names)
  2. Connects to both Google Spreadsheets using their IDs
  3. Retrieves data from the specified sheet in the first spreadsheet
  4. Retrieves data from the specified sheet in the second spreadsheet
  5. Appends the data from the first sheet (excluding the header row) to the second sheet
  6. Returns any errors encountered during the process

Requirements​

  • Valid Google Spreadsheet IDs for both source and destination spreadsheets
  • Valid sheet names in both spreadsheets
  • Proper Google Sheets API authentication and permissions for both spreadsheets

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid First File Descriptor
  • Empty or invalid Second File Descriptor
  • Empty or invalid First Sheet Name
  • Empty or invalid Second Sheet Name
  • Google Sheets API authentication or permission errors
  • Network or connectivity issues with Google Sheets API

Usage Notes​

  • The first row of the source sheet is treated as a header and is not included in the append operation
  • Both spreadsheets must be accessible with the current Google account credentials
  • Ensure your Google account has proper permissions to read from the source spreadsheet and write to the destination spreadsheet
  • The append operation adds data to the end of the existing data in the destination sheet