Skip to main content

Add Sheet

Adds a new sheet 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 new sheet will be added.
  • Sheet Name - The name of the new sheet to be created in the spreadsheet.

Options​

No additional options available for this node.

Output​

No output variables for this node.

How It Works​

The Add Sheet node creates a new sheet within an existing Google Spreadsheet. When executed, the node:

  1. Validates the provided Spreadsheet Id and Sheet Name inputs
  2. Checks if a sheet with the specified name already exists in the spreadsheet
  3. Creates a new sheet with the specified name in the target spreadsheet
  4. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet ID
  • A unique sheet name that doesn't already exist in the spreadsheet
  • 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 Sheet Name
  • Sheet with the specified name already exists in the spreadsheet
  • Google Sheets API authentication or permission errors

Usage Notes​

  • The Spreadsheet Id can be obtained from the URL of your Google Spreadsheet
  • The sheet name must be unique within the spreadsheet
  • If a sheet with the same name already exists, the node will return an error
  • Ensure your Google account has proper permissions to modify the target spreadsheet