Insert rows - Automate.ax

insertRows shifts existing rows down and writes new records atomically.

Example

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

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

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

Inputs

spreadsheet, source, one-based rowNumber, and one or more header-keyed rows are required. Record and inputMode behavior match Append rows. The position must be in the source body or immediately after its current end. account optionally selects the Google account binding.

Output

Returns { affectedCells, rowNumbers, updatedRange }. rowNumbers contains the consecutive new rows. Formatting is inherited from the previous body row when inserting below the first body row.

⌘I