Skip to main content

Merge

Merges data from one Google Spreadsheet sheet to another.

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 (destination).
  • First Sheet Name - The name of the sheet in the first spreadsheet where data will be merged.
  • Second File Descriptor - The ID of the second Google Spreadsheet (source).
  • Second Sheet Name - The name of the sheet in the second spreadsheet from which data will be merged.

Options​

No additional options available for this node.

Output​

No output variables for this node.

How It Works​

The Merge node combines data from two Google Spreadsheet sheets by appending data from the source sheet to the destination 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 second (source) spreadsheet
  4. Retrieves existing data from the specified sheet in the first (destination) spreadsheet
  5. Calculates the appropriate range for inserting the source data next to the existing data
  6. Updates the first spreadsheet with the merged data
  7. 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 data from the second sheet will be appended to the right of the existing data in the first sheet
  • 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
  • This operation modifies the destination spreadsheet data, so use with caution
  • The number of rows in both sheets should ideally match for proper merging