Insert rows - Automate.ax

googleSheets.insertRows shifts existing rows down and writes new records atomically.

Example

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

export default automation("Insert a priority order", () => {
  onDashboardRun({ title: "Insert a priority order" })

  googleSheets.insertRows({
    spreadsheet: "spreadsheet-id",
    source: { sheet: "Orders" },
    rowNumber: 2,
    rows: { "Order ID": "A-1042", Status: "Priority" },
  })
})

Inputs

Provide spreadsheet, source, one-based rowNumber, and one or more header-keyed rows. Record and inputMode behavior match Append rows. The position must be in the source body or immediately after its current end. Second argument { account } selects the Google Account binding.

Output

Returns { affectedCells, rowNumbers, updatedRange }. rowNumbers contains the consecutive new rows. Rows inserted below the first body row inherit formatting from the previous body row.