Write values

googleSheets.writeValues atomically replaces values in one or more A1 or named ranges.

Example

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

export default automation("Write an order summary", () => {
  onDashboardRun({ title: "Write an order summary" })

  googleSheets.writeValues({
    spreadsheet: "spreadsheet-id",
    inputMode: "userEntered",
    includeValues: true,
    updates: [
      {
        range: "Summary!A1:B2",
        values: [
          ["Orders", 42],
          ["Total", "=SUM(Orders!D:D)"],
        ],
      },
    ],
  })
})

Inputs

Provide spreadsheet and one update or non-empty update array. Each update contains range, values, and optional majorDimension: "rows" | "columns", which defaults to rows. Cell values are string, number, boolean, or null. Null clears the cell. inputMode defaults to userEntered, which parses formula-looking strings and other UI input. raw stores strings literally. includeValues defaults to false. Optional responseValueRender and responseDateTimeRender use the modes from Read values. Second argument { account } selects the Google Account binding.

Output

Returns spreadsheet ID, total updated cells/rows/columns/sheets, and an updates array with updatedRange, counts, and optional returned { range, majorDimension, values }. Returned values appear only when includeValues is true.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output