grist

name

grist

description

A flexible data workspace that combines spreadsheet simplicity with database structure, enabling teams to organize, analyze, and collaborate on structured data, build custom apps, and automate workflows without coding. Read and write Grist data through One: documents, attachments, workspaces, serviceaccounts, records, tables and more, 120 actions with real parameter documentation. Use whenever the user asks to look something up in Grist, create or update a record there, or build code against the Grist API.

Grist through One

A flexible data workspace that combines spreadsheet simplicity with database structure, enabling teams to organize, analyze, and collaborate on structured data, build custom apps, and automate workflows without coding.

One exposes Grist through four MCP tools. The table below carries real action ids from One's knowledge base, so for a common operation you can skip search and go straight to reading the action's parameters.

How to run an action

1. Find the action in the table below, or call search_one_platform_actions with platform grist if it is not listed.
2. Call get_one_action_knowledge with the action id. Do this every time, including for actions in this table. The table gives you the id, not the parameters.
3. Call execute_one_action with parameters copied from that knowledge.

Never guess a parameter name, a body field, or an enum value. The knowledge has the real schema, and a guessed field is either a 400 or a silent write of the wrong thing.

Before you start

Call list_one_integrations once and confirm Grist is connected. If it is missing, the user has not connected it: say so and point them at https://app.withone.ai rather than reaching for raw HTTP.

Each connection carries an access field. If it reports {"policy": "methods", "methods": ["GET"]} the agent is read-only here, so plan a read-only answer instead of attempting a write that will be refused.