Update sheet - Automate.ax

updateSheet patches common sheet properties and returns refreshed metadata.

Example

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

export default automation("Freeze the header", () => {
  onHttpRequest({ scope: "automation" })

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

Inputs

spreadsheet and sheet (exact title or numeric sheet ID) are required. Provide at least one property from Create sheet: title, counts, zero-based index, hidden, or rightToLeft. 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.

⌘I