Delete sheet - Automate.ax

googleSheets.deleteSheet deletes a sheet and returns its identifying metadata.

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

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

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

Inputs

Provide spreadsheet and sheet: string | number. Strings match exact titles and numbers are immutable sheet IDs. Second argument { 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 won’t let a spreadsheet have zero sheets.