Get rows - Automate.ax

googleSheets.getRows retrieves one or more one-based row numbers from a header-backed sheet or native table.

Example

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

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

  googleSheets.getRows({
    spreadsheet: "spreadsheet-id",
    source: { table: "OrdersTable" },
    rowNumbers: [12, 18],
  })
})

Inputs

Provide spreadsheet, source, and one row number or an array of up to 1,000. See List rows for source and optional valueRender. Second argument { account } selects the Google Account binding.

Output

Returns SheetRow[] in the same order as requested row numbers, including a record of nulls for an empty row. Rows outside the source body fail validation.