Upsert rows - Automate.ax

googleSheets.upsertRows matches records by one or more exact header columns, updates existing matches, and appends new keys.

Example

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

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

  googleSheets.upsertRows({
    spreadsheet: "spreadsheet-id",
    source: { table: "OrdersTable" },
    keyColumns: ["Order ID"],
    rows: [
      { "Order ID": "A-1042", Status: "Closed" },
      { "Order ID": "A-1043", Status: "Open", Total: 80 },
    ],
  })
})

Inputs

Provide spreadsheet, source, non-empty exact keyColumns, and one or more records. Every input record must have a non-null value for every key. Partial non-key fields patch existing rows, while omitted fields become null on new rows. inputMode defaults to userEntered. Second argument { account } selects the Google Account binding.

Output

Returns { affectedCells, insertedRows, insertedRange?, updatedRowNumbers }. insertedRange is available for ordinary sheets, not native tables. The action fails when existing rows share a composite key or input records contain duplicate keys, preventing ambiguous updates.