Sheets for Agents (API)
NewLet AI agents read and write your spreadsheets cell-by-cell with personal API keys — over REST or the aiinak MCP server.
Spreadsheets your agents can use
AI Sheets exposes a public REST API so agents and scripts can work with your spreadsheets the way you do: list and search them, read any range as structured rows, create new sheets seeded with data, write values and formulas, and append rows. Everything an agent writes appears in your Sheets app, complete with version history you can restore from.
Create an API key from the “API keys” button on the Sheets home page. Keys are platform-wide: the same key can carry Drive, Sheets and Docs scopes.
Authentication and scopes
The base URL is https://sheets.aiinak.com/api/v1. Send your key as a Bearer token; sheets:read covers listing and reading, sheets:write covers creating and editing.
# Everything in use, as JSON rows
curl "https://sheets.aiinak.com/api/v1/spreadsheets/SHEET_ID" \
-H "Authorization: Bearer $KEY"
# A specific range, as CSV
curl "https://sheets.aiinak.com/api/v1/spreadsheets/SHEET_ID?range=A1:C10&format=csv" \
-H "Authorization: Bearer $KEY"Endpoints
| Endpoint | Scope | Description |
|---|---|---|
| GET /spreadsheets | sheets:read | List your spreadsheets (?query= filters by name) |
| GET /spreadsheets/{id} | sheets:read | Read a range (?range=, ?sheetName=, ?format=csv); omit range for the used region |
| POST /spreadsheets | sheets:write | Create, optionally seeded with rows (first row as headers works well) |
| POST /spreadsheets/{id}/values | sheets:write | Write values into a range; strings starting with = become formulas |
| POST /spreadsheets/{id}/append | sheets:write | Add rows after the last used row — no range math needed |
Writes to a spreadsheet that someone has open in the editor are refused with 409 open_in_editor rather than silently lost — retry after the editor closes. Every successful write records a revision in the sheet's version history.
MCP tools
The @aiinak/workspace-mcp server (npm) includes the Sheets tools sheets_list, sheets_read, sheets_create, sheets_write_range and sheets_append_rows alongside the Drive and Docs tools — one server for the whole workspace.