Skip to main content

Create Spreadsheet

Creates a new 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​

  • Title - The name/title for the new Google Spreadsheet.

Options​

  • Credentials - The Google Sheets API credentials used to authenticate with the service.
  • Share With - An array of users to share the spreadsheet with, each containing Role Type and EmailAddress.
  • Send Notification Mail - If enabled, sends notification emails to users when sharing the spreadsheet.

Output​

  • Spreadsheet Id - The ID of the newly created Google Spreadsheet.

How It Works​

The Create Spreadsheet node generates a new Google Spreadsheet with the specified title. When executed, the node:

  1. Validates all input parameters
  2. Authenticates with the Google Sheets API using the provided credentials
  3. Creates a new spreadsheet with the specified title
  4. Shares the spreadsheet with any specified users if the Share With option is used
  5. Sends notification emails if the Send Notification Mail option is enabled
  6. Returns the unique ID of the newly created spreadsheet
  7. Handles token refresh if necessary
  8. Returns any errors encountered during the process

Requirements​

  • Valid Google Sheets API credentials with appropriate permissions
  • Internet connectivity to access Google Sheets API
  • Valid title for the new spreadsheet

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid Title
  • Invalid or missing Google Sheets API credentials
  • Authentication failures with Google Sheets API
  • Network or connectivity issues with Google Sheets API
  • Insufficient permissions to create spreadsheets

Usage Notes​

  • The output Spreadsheet Id can be used in other Google Sheets nodes
  • The Share With option allows you to specify users and their roles (e.g., owner, writer, reader)
  • When using service account credentials, sharing may have limitations
  • The node handles credential token refresh automatically when needed
  • The newly created spreadsheet will be owned by the authenticated account
  • Ensure your Google account has proper permissions to create spreadsheets in Google Drive