# Append rows the agent produced

> Append rows the agent produced: 1 companies fully do it, 9 with a limit, 10 carry the tag. Every listing in Spreadsheets & operational tables with the reason and a source.

- Canonical: https://www.anchorterminal.com/niches/spreadsheets.append-rows/
- Markdown: https://www.anchorterminal.com/niches/spreadsheets.append-rows/index.md (~1,200 tokens)
- Slim: https://www.anchorterminal.com/niches/spreadsheets.append-rows/index.min.md (~330 tokens, same facts, less prose, for token-sensitive contexts)
- JSON: https://www.anchorterminal.com/niches/spreadsheets.append-rows/index.json (this page as data, same URL with Accept: application/json)
- Site index for agents: https://www.anchorterminal.com/llms.txt (the key docs and every listing in one file, at most 16 MB, about 4 million tokens: https://www.anchorterminal.com/llms-full.txt)
- API: https://www.anchorterminal.com/api/v1/index.json
- MCP: https://www.anchorterminal.com/mcp (the whole catalogue as tools, no key)
- DNS: dig +short TXT <slug>.grade.anchorterminal.com (the grade as a DNS TXT record, for a sandbox with no HTTP where names still resolve; also top., best.<category>. and <a>.vs.<b>. under the zone, and the same under grade.letme.dev)
- Licence: CC BY 4.0, credit Anchor Terminal and link this page (https://www.anchorterminal.com/terms/#data)
- Updated: 2026-11-15

One company's docs show a full fit.

| Companies, full fit | With a limit | Carry the tag | Share of the category's work | First-hand accounts |
| --- | --- | --- | --- | --- |
| 1 | 9 | 10 | 20 | 7 |

## What counts as done

All rows written in the fewest calls the batch limit allows, visible to a read straight after, with no duplicate rows when a timed-out call is retried.

How agents ask for it: add these leads to the sheet; log this to the spreadsheet; put the scraped results in a table; append today's file to the tracker

## Does the job

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

- **Grist (Grist Labs Inc.)**: PUT /records with require adds or updates by key, so a retried write after a timeout doesn't duplicate rows, and POST /records adds many rows in one call.

## Does the job, with a limit

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.

- **Airtable (Formagrid Inc (doing business as Airtable))**: performUpsert with fieldsToMergeOn makes a retried write update instead of duplicate. The map and the last assessment put the batch cap at 10 records a call, though the create page read doesn't state it, and Free allows 1,000 calls a month.
- **Baserow (Baserow B.V.)**: POST .../batch/ creates many rows in one call (200 a call per the last assessment and the map). No upsert or unique key exists, so a retried timed-out batch duplicates rows.
- **Coda (Superhuman Docs) (Superhuman Platform Inc. (parent of Coda Project LLC))**: POST .../rows inserts many rows with keyColumns as upsert keys, so a retry updates instead of duplicating. The write returns 202 queued, so a read straight after may not show it until mutationStatus reports done, and writes are limited to 10 requests per 6 seconds.
- **Google Sheets API (Google LLC)**: values.append with INSERT_ROWS writes many rows in one call, but there is no idempotency key or key column, so a retry after the 180-second timeout can add the rows twice; acc-26 saw wider writes abort.
- **Microsoft Excel (Microsoft Graph workbook API) (Microsoft Corporation)**: POST .../tables/{id}/rows/add takes many rows in one two-dimensional values array, but the page says to repeat the request on a 504 with no idempotency key, so a retry can add the rows twice.
- **NocoDB (NocoDB Inc (doing business as NocoDB))**: Create takes an array capped at 10 records by default (422 beyond), the blocker the map names, though /records/upsert with a merge key makes a retry update instead of duplicate. The Free plan allows 1,000 API calls a month.
- **SeaTable (SeaTable GmbH)**: Append Row(s) writes many rows in one call (1,000 per the map), but there is no idempotency key or merge key, so a retried timed-out append adds the rows twice, and the Free team quota is 3,000 calls a month.
- **Smartsheet API + MCP (Smartsheet Inc.)**: POST /sheets/{id}/rows adds many rows in one call (500 per the map) with allowPartialSuccess, but no idempotency or merge key exists, so a retry duplicates rows; acc-32's multi-row add with location specifiers failed.
- **Teable (Teable AI, Inc.)**: POST /table/{id}/record creates many records in one call, but no upsert or unique constraint exists, and acc-22 (open) shows retries and races inserting the same logical row twice.

## What stops agents finishing

- batch limit of 10 records forces many calls (Airtable, NocoDB)
- large write times out and a retry duplicates rows
- monthly API call quota on a free plan

## Around it

Before: web-scrapers.page-to-markdown, email.read-attachment. After: spreadsheets.read-table, notifications.send.

## Where this comes from

Weight 20 of 100 in Spreadsheets & operational tables: 7 of 35 accounts: scraped data into Sheets, outreach logs, CSV checks, a large DataFrame write, Smartsheet imports, Teable duplicate inserts

As data: https://www.anchorterminal.com/api/v1/use-cases/spreadsheets.append-rows.json, or the MCP tool get_use_case with id spreadsheets.append-rows. Draft, read 2026-11-15 from public docs and first-hand accounts, not yet reviewed by a person.

---

Query this catalogue directly over MCP: https://www.anchorterminal.com/mcp (Streamable HTTP, no key). How: https://www.anchorterminal.com/agents/#mcp
