Niches · Spreadsheets & operational tables
Find the records that match a condition
Four or more companies' docs show a full fit.
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.
| Listing | Why |
|---|---|
| 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.
| Listing | Why |
|---|---|
| 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.
| Listing | Why |
|---|---|
| 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.
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.