> ## 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.

# Find rows

> Find header-keyed Google Sheets rows that match structured filters.

`findRows` scans a sheet or native table and returns rows satisfying every
filter (logical AND).

## Example

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

export default automation("Find large open orders", () => {
  onHttpRequest({ scope: "automation" })

  findRows({
    spreadsheet: "spreadsheet-id",
    source: { sheet: "Orders" },
    filters: [
      { column: "Status", operator: "equals", value: "Open" },
      { column: "Total", operator: "greaterThan", value: 1000 },
    ],
    limit: 100,
  })
})
```

## Inputs

`spreadsheet`, `source`, and non-empty `filters` are required. Operators are
`equals`/`notEquals` with a typed cell value; `contains`/`matchesRegex` with a
string and optional `caseSensitive`; numeric `greaterThan`,
`greaterThanOrEqual`, `lessThan`, `lessThanOrEqual`; and `empty`, `notEmpty`,
`isTrue`, or `isFalse`. Column names must exactly match headers. `limit`
defaults to 100 and accepts up to 10,000. `valueRender` determines both returned
and compared values.

`account` optionally selects the Google account binding.

## Output

Returns matching `SheetRow[]` in source order, capped at `limit`. Numeric
comparisons only match actual numeric values; formatted rendering can turn them
into strings, so keep `unformatted` for numeric filters.