Skip to main content

Delete Sheet

Deletes a specific sheet from 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 from which to delete the sheet.
  • Sheet Name - The name of the sheet to be deleted.

Options​

No additional options available for this node.

Output​

No output variables for this node.

How It Works​

The Delete Sheet node removes a specific sheet from a Google Spreadsheet. When executed, the node:

  1. Validates the provided Spreadsheet Id and Sheet Name inputs
  2. Connects to the Google Spreadsheet using the provided ID
  3. Checks if a sheet with the specified name exists in the spreadsheet
  4. Gets the sheet ID for the sheet to be deleted
  5. Constructs a delete sheet request
  6. Sends the delete request to the Google Sheets API
  7. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet ID
  • A valid sheet name that exists 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 does not exist
  • 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
  • The sheet name must exactly match an existing sheet in the spreadsheet
  • This operation cannot be undone, so use with caution
  • Deleting a sheet will remove all data contained in that sheet
  • Ensure your Google account has proper permissions to modify the target spreadsheet