Update sheet - Automate.ax

googleSheets.updateSheet changes selected sheet properties and returns current metadata.

Example

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

export default automation("Freeze the header", () => {
  onDashboardRun({ title: "Freeze the header" })

  googleSheets.updateSheet({
    spreadsheet: "spreadsheet-id",
    sheet: "Orders",
    frozenRowCount: 1,
  })
})

Inputs

Provide spreadsheet and an exact title or numeric sheet ID in sheet. Provide at least one property from Create sheet: title, counts, zero-based index, hidden, or rightToLeft. Second argument { account } selects the Google Account.

Output

Returns current Sheet metadata. Shrinking row or column allocation can discard cells outside the new grid. Google also rejects duplicate titles and invalid frozen counts.