Clear values - Automate.ax

googleSheets.clearValues removes cell contents while preserving formatting, validation, comments, and other cell properties.

Example

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

export default automation("Clear staging data", () => {
  onDashboardRun({ title: "Clear staging data" })

  googleSheets.clearValues({
    spreadsheet: "spreadsheet-id",
    ranges: ["Staging!A2:Z", "LastImport"],
  })
})

Inputs

Provide spreadsheet and one A1/named range or non-empty ranges array. Second argument { account } selects the Google Account.

Output

Returns { spreadsheetId: string; clearedRanges: string[] }. Google bounds unbounded input ranges to the actual cleared grid. This doesn’t delete or shift rows.