Find rows

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

Example

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.

⌘I

Get started

Concepts

Reference

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output