Find rows

googleSheets.findRows returns rows from a sheet or native table that satisfy every filter.

Example

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

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

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

Inputs

Provide spreadsheet, source, and non-empty filters. equals and notEquals compare cell values. contains and matchesRegex accept a string and optional caseSensitive. Numeric operators are greaterThan, greaterThanOrEqual, lessThan, and lessThanOrEqual. Other operators are empty, notEmpty, isTrue, and isFalse. Column names must exactly match headers. limit defaults to 100 and accepts up to 10,000. valueRender determines both returned and compared values. Second argument { account } 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.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output