Update rows - Automate.ax

googleSheets.updateRows writes only the supplied cells and preserves other columns.

Example

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

export default automation("Close processed orders", () => {
  onDashboardRun({ title: "Close processed orders" })

  googleSheets.updateRows({
    spreadsheet: "spreadsheet-id",
    source: { table: "OrdersTable" },
    updates: [
      { rowNumber: 12, values: { Status: "Closed" } },
      { rowNumber: 18, values: { Status: "Closed", Total: null } },
    ],
  })
})

Inputs

Provide spreadsheet, source, and non-empty updates. Each update has a one-based rowNumber and non-empty values record whose keys exactly match headers. null clears a cell. inputMode defaults to userEntered. Second argument { account } selects the Google Account.

Output

Returns { affectedCells, rowNumbers }. affectedCells counts supplied cells, not the full row width. The action accepts duplicate row numbers and retains them in output. Later writes to the same cell win in request order.