Update spreadsheet - Automate.ax

googleSheets.updateSpreadsheet changes selected spreadsheet properties.

Example

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

export default automation("Configure a workbook", () => {
  onDashboardRun({ title: "Configure a workbook" })

  googleSheets.updateSpreadsheet({
    spreadsheet: "spreadsheet-id",
    title: "2026 Operations",
    autoRecalc: "onChange",
  })
})

Inputs

Provide spreadsheet. Provide at least one of title, locale, timeZone, or autoRecalc: "onChange" | "minutely" | "hourly". Second argument { account } selects the Google Account.

Output

Returns the updated Spreadsheet.