> ## Documentation Index
> Fetch the complete documentation index at: https://docs.automate.ax/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> Automate.ax automations are TypeScript programs.
> Use Bun for installation and command examples.
> Use Automate.ax for the product name and automate.ax for the package, CLI, and domain.
> Treat documented public APIs as current; do not invent transitional or deprecated names.

# Get rows

> Get explicitly numbered Google Sheets rows as header-keyed records.

`getRows` retrieves one or many known one-based row numbers from a header-backed
sheet or native table.

## Example

```ts theme={null}
import { automation, onHttpRequest } from "automate.ax"
import { getRows } from "automate.ax/google-sheets"

export default automation("Load selected orders", () => {
  onHttpRequest({ scope: "automation" })

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

## Inputs

`spreadsheet`, `source`, and one row number or an array of up to 1,000 are
required. Source and optional `valueRender` are described by [List rows](/reference/integrations/google-sheets/actions/list-rows#inputs).

`account` optionally 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.