Clear values - Automate.ax

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

Example

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

export default automation("Clear staging data", () => {
  onHttpRequest({ scope: "automation" })

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

Inputs

spreadsheet and one A1/named range or non-empty ranges array are required. account selects the Google account.

Output

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

⌘I