Append rows

googleSheets.appendRows orders each record by the source headers before appending it.

Example

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

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

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

Inputs

Provide spreadsheet, source, and one record or non-empty records array. See List rows for source syntax. Values are string, number, boolean, or null. Record keys must exactly match headers. Omitted columns become null. inputMode defaults to userEntered, which parses formula strings. raw stores them literally. Second argument { account } selects the Google Account binding.

Output

Returns { affectedCells, rowNumbers, updatedRange? }. rowNumbers is empty because Google append APIs don’t reliably return row identities. Ordinary sheets can return updatedRange. Native-table appends don’t.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output