Delete table - Automate.ax

googleSheets.deleteTable() deletes the table identified by name or immutable ID and all cell contents in its range.

Example

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

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

  googleSheets.deleteTable({
    spreadsheet: "spreadsheet-id",
    table: "StagingTable",
  })
})

Inputs

Provide spreadsheet and table. Second argument { account } selects the Google Account.

Google deletes the table and its cell contents. Use deleteBandedRange() when you only want to remove ordinary alternating-color formatting while preserving values.

Output

Returns the deleted table’s { tableId, name, range, columns, style } metadata.