Skip to content

delete-sheet.md

Latest commit

 

History

History
31 lines (20 loc) · 925 Bytes

delete-sheet.md

File metadata and controls

31 lines (20 loc) · 925 Bytes
Raw

Delete Sheet

➡️ See the sendTo API documentation for general usage and all available commands.

The delete-sheet feature allows you to delete a specific sheet from a Google spreadsheet.

Used API endpoint: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/batchUpdate

The feature accepts the following parameters:

  • sheetName: The name of the sheet to be deleted.
  • alias (optional): The spreadsheet alias if you have multiple spreadsheets configured.

Callback result: { success: true } on success, or { error: string } on failure.

Blockly

Blockly

In Blockly, the parameter sheetName is passed to the Google API.

Javascript

The given code snippet deletes a sheet from the spreadsheet with the specified name.

sendTo(
  "google-spreadsheet.0",
  "deleteSheet",
  { sheetName: "nameOfSheet" }
);