Write values

writeValues replaces cell values in one or several A1 or named ranges in one atomic value request.

Example

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

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

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

Inputs

spreadsheet and one update or non-empty update array are required. Each update contains range, values, and optional majorDimension: "rows" | "columns" (default 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. account optionally 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.

Get started

Concepts

Reference

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output