Delete sheet - Automate.ax

deleteSheet resolves a sheet, deletes it, and returns the metadata that identified the removed tab.

Example

import { automation, onHttpRequest } from "automate.ax"
import { deleteSheet } from "automate.ax/google-sheets"

export default automation("Delete a staging sheet", () => {
  onHttpRequest({ scope: "automation" })

  deleteSheet({ spreadsheet: "spreadsheet-id", sheet: "Staging" })
})

Inputs

spreadsheet and sheet: string | number are required. Strings match exact titles and numbers are immutable sheet IDs. account selects the Google account.

Output

Returns the deleted Sheet metadata. The operation permanently removes its values, formatting, tables, charts, and other sheet-owned content; Google will not let a spreadsheet have zero sheets.

⌘I