Niches · Spreadsheets & operational tables

Find the records that match a condition

Four or more companies' docs show a full fit.

4companies, full fit
4companies, fit with a limit
10companies carry the tag
11share of the category's work
4first-hand accounts

What counts as done

Only the matching records returned by a server-side filter in one call per page.

Measured, for our own tests: the count agrees with the same filter in the product's own view. No docs we read state these figures, so they don't count against a listing here.

How agents ask for it: which deals are still open, show the rows where checked is true, find customers in Berlin, list tasks due this week

Does the job 4

The docs show it meets the test above, and nothing we read says otherwise.

ListingWhy
Airtable BB
Formagrid Inc (doing business as Airtable)
filterByFormula filters on the server and pages with offset; a view parameter applies a saved view's filter, and POST /listRecords carries long formulas. source
Baserow C
Baserow B.V.
List rows takes filter__{field}__{type} with filter_type AND or OR, a JSON filters tree, or view_id to apply a saved view, server-side and paged. source
SeaTable B
SeaTable GmbH
POST /sql/ runs SELECT with WHERE, sort, group and join on the server with ? placeholders, across normal and big-data storage; List Rows with view_name applies a saved view's filter. source
Teable B
Teable AI, Inc.
List records takes a filter object of field, operator and value (or filterByTql), enforced on the server and paged, and /aggregation/row-count takes the same filter to check the count. source

Does the job, with a limit 4

It does the job, but something in the docs or a user's account will get in an agent's way. The limit is named in each row.

ListingWhy
Coda (Superhuman Docs) BB
Superhuman Platform Inc. (parent of Coda Project LLC)
List rows takes query as one column:value equality, filtered on the server and paged. Ranges, dates such as due this week, and several conditions cannot be expressed, so those need a pre-filtered view or client-side filtering. source
Grist E
Grist Labs Inc.
The filter parameter maps a column to a list of allowed values, enforced on the server. Ranges such as due this week need the SQL endpoint instead, which loses the records shape. source
NocoDB BB
NocoDB Inc (doing business as NocoDB)
where takes field conditions joined by and or or, with whereTz for dates and a /count endpoint to check. acc-16 (open) reports the filter ignored and every row returned after 2026.10.1. source
Smartsheet API + MCP B
Smartsheet Inc.
GET /sheets/{id} takes filterId for a filter already saved on the sheet and rowsModifiedSince, and /search/sheets/{id} does text search. An ad hoc condition cannot be sent, so a new filter needs to exist in the sheet first. source

Doesn't do this job 2

Listings in the category that do something else, with the reason.

ListingWhy
Google Sheets API A
Google LLC
Reads take A1 ranges or data filters on grid ranges and developer metadata, not conditions on cell values, so the agent reads the range and filters itself; the map names this blocker. source
Microsoft Excel (Microsoft Graph workbook API) D
Microsoft Corporation
Listing rows supports $top and $skip paging; no server-side condition on cell values returns only matching rows, so the agent reads the table and filters itself. source

What stops agents finishing

  • filter silently ignored and every row returned
  • no query on the API, only A1 ranges (Google Sheets)

Around it

Before: spreadsheets.read-table. After: spreadsheets.update-in-place, email.send.

Where this comes from

Weight 11 of 100 in Spreadsheets & operational tables: 4 of 35 accounts: NocoDB checkbox filter ignored, Grist paging, Teable linked fields, Grist with n8n; Google Sheets has no server-side filter at all

The same as data: /api/v1/use-cases/spreadsheets.filter-records.json, or the MCP tool get_use_case with id spreadsheets.filter-records. Other jobs in this category: /api/v1/niches?category=spreadsheets.

Draft, read 2026-11-15 from public docs and first-hand accounts, not yet reviewed by a person. A mark says what the docs show, not what a run measured.

For companies

Do agents find, use and choose your tools?

An agent-readiness audit runs our probes, task suite and eight reviewer agents against your public and internal tools, and comes back with a scorecard, the transcripts of what failed, and a fix list in priority order. From $2,500, re-run included. We never take payment to move a rank. We do help companies earn one.