Connectors · Developer & infrastructure
Grist MCP server for AI agents.
actionlake is an MCP gateway: one remote MCP server that connects Claude and other MCP clients to Grist and the rest of your systems. It gives your agent 108 Grist actions (38 reads, 50 writes and 20 that wait for a confirmation) and holds the Grist credential itself, so the agent never does. It paces Grist's limits and records every call.
100,000 free calls a month. No card, no email, no password: press Start a free sandbox on the next screen and keep the key it shows you.
claude mcp add --transport http actionlake https://connect.actionlake.com/mcpdo { action: "grist.orgs.list_orgs", intent: "check which Grist account is connected"}# List the orgs you have access to · read · 1 upstream call- 108actionsin one signed file
- 38readlook, never change
- 50writecreate and update
- 20wait for a yesdestructive, confirmed first
Set up
Connect Grist in three steps.
- 01
Add actionlake to Claude.
Run the command once in Claude Code; its consent page can create a free sandbox: 100,000 calls a month, no card. In the Claude app, add a custom connector with the URL below and paste your key on the consent page. Creating a new sandbox from the Claude app is not yet tested by us.
https://connect.actionlake.com/mcp - 02
Connect Grist.
Bearer token. No consent screen: your agent can connect it for you, but the key then passes through your chat. To keep it out of the model's context, paste it in the console instead. actionlake stores what you paste write-only, sealed under your tenant's key.
access_tokenGrist API key, sent as `AuthorizationhostWhere your Grist lives: your host
account { op: "connections.requirements", service: "grist" } # free: exactly what to paste, and what is found for you - 03
Make the first call. Check before a write.
Ask in plain words; Claude picks the action. Before anything changes,
checkvalidates the call and prices it, for free.do { action: "grist.orgs.list_orgs" }# list the orgs you have access to · read · 1 upstream callcheck { action: "grist.tables.add_tables", input: { … } }# free: inputs, permissions, cost and confirmations, nothing sent
Grist at a glance
- Sign-in
- Bearer token. No consent screen: your agent can connect it for you, but the key then passes through your chat. To keep it out of the model's context, paste it in the console instead.
- You provide
access_token- Setup fields
host- Limits we pace to
- 10 calls a second, per connection
- API covered
- Grist API 1.0.1 (OpenAPI 3.0.0), at your Grist instance's API base URL, which you enter when connecting (path /api)
- Built from
- Grist's documentation, read 23 October 2026OpenAPI spec (GitHub)support.getgrist.com
- Service file
- Version 1.0.0, signed (Ed25519)
- Cached reads
- 38 of 38 reads, for up to 5 minutes; a write clears what it affects
- Shared entities
- 5, so ask can line Grist up with your other systems
- Data
- Processed and stored in Sydney, Australia. No US region yet
Capabilities
What an AI agent can do in Grist.
108 actions in 17 areas. Every one carries its effect, so a key can allow the reads and hold the rest.
- 38readlook, never change
- 50writecreate and update
- 20destructivewait for a confirmation
Docs
3610 read · 22 write · 4 destructive
Create an empty document · Describe a document · Modify document metadata (but not its contents) · Delete a document
Attachments
105 read · 3 write · 2 destructive
List external attachment stores · Get attachment transfer status · Get external store · Set external store
Workspaces
93 read · 4 write · 2 destructive
List workspaces and documents within an org · Create an empty workspace · Describe a workspace · Modify a workspace
Orgs
74 read · 2 write · 1 destructive
List the orgs you have access to · Describe an org · Modify an org · Delete an org
Service accounts
72 read · 3 write · 2 destructive
Get all your service accounts · Create a service account · Get a service account's details · Modify a service account
Webhooks
61 read · 2 write · 3 destructive
Create new webhooks for a document · Webhooks associated with a document · Modify a webhook · Remove a webhook
Columns
51 read · 3 write · 1 destructive
Add columns to a table · List columns in a table · Modify columns of a table · Delete a column of a table
Records
51 read · 3 write · 1 destructive
Add records to a table · Fetch records from a table · Modify records of a table · Delete records of a table
9 more areas · 23 actions
- Data 4
- Profile 4
- Session 3
- Tables 3
- Users 3
- SQL 2
- Templates 2
- Forms 1
- Widgets 1
Top actions
The Grist API, shaped for agents.
The ids your agent types, what each does, and the one name it shares with other systems. 37 of Grist's 37 action names are shared with at least one other connector, so an agent learns them once.
| Action | What it does | Effect | Same name in |
|---|---|---|---|
grist.tables.list_tablesList tables in a document | List tables in a document | read | content.table.list21 connectors |
grist.profile.get_profileGet current user's profile | Get current user's profile | read | identity.current_user.get307 connectors |
grist.workspaces.list_workspacesList workspaces and documents within an org | List workspaces and documents within an org | read | work.workspace.list50 connectors |
grist.tables.add_tablesAdd tables to a document | Add tables to a document | write | content.table.create16 connectors |
grist.service_accounts.list_service_accountsGet all your service accounts | Get all your service accounts | read | identity.service_account.list35 connectors |
grist.workspaces.create_workspaceCreate an empty workspace | Create an empty workspace | write | work.workspace.create36 connectors |
grist.records.add_recordsAdd records to a table | Add records to a table | write | content.record.create15 connectors |
grist.records.list_recordsFetch records from a table | Fetch records from a table | read | content.record.list13 connectors |
grist.service_accounts.create_service_accountCreate a service account | Create a service account | write | identity.service_account.create32 connectors |
grist.orgs.list_orgsList the orgs you have access to | List the orgs you have access to | read | platform.tenant.list70 connectors |
grist.docs.create_docCreate an empty document | Create an empty document | write | content.spreadsheet.create4 connectors |
grist.users.delete_userDelete a user from Grist | Delete a user from Grist | destructive | identity.user.delete253 connectors |
Try it
Prompts to paste into Claude.
Each one names the Grist actions it will call, so you know what it reads and what it changes before you send it.
- Readread
List the orgs you have access to in Grist and tell me what stands out.
calls
grist.orgs.list_orgs - Writewrite
Add tables to a document in Grist. Show me exactly what you will send before you save it.
calls
grist.tables.add_tables
Governance for Grist
Destructive actions wait for a yes.
20 Grist actions are destructive. These are all of them:
- Delete a workspace
grist.workspaces.delete_workspace - Delete records of a table
grist.records.delete_records - Delete a user from Grist
grist.users.delete_user - Delete a service account
grist.service_accounts.delete_service_account - Delete user's API key
grist.profile.delete_api_key - Delete a document
grist.docs.delete_doc - Remove a webhook
grist.webhooks.delete_webhook - Delete an org
grist.orgs.delete_org - Move document to trash
grist.docs.remove_doc - Truncate the document's action history
grist.docs.delete_actions - Delete a column of a table
grist.columns.delete_column - Remove document snapshots
grist.docs.remove_snapshots - Move workspace to trash
grist.workspaces.remove_workspace - Delete rows of a table
grist.data.delete_rows - Disable a user
grist.users.disable_user - Empty a document's queue of undelivered payloads
grist.webhooks.clear_webhook_queue - Delete unused attachments from the document
grist.attachments.remove_unused_attachments - Start transferring attachments
grist.attachments.start_attachment_transfer - Clear queue for a specific webhook
grist.webhooks.clear_webhook_queue_for_webhook - Delete a service account's api key
grist.service_accounts.delete_service_account_api_key
A destructive action runs only with confirm: true. Under the human policy the agent cannot confirm for itself: the run stops until a named person approves, in the console or from a signed link in an email. The cap on a key is refused before the call is sent, never after.
Delete a workspace?
intent: the user asked me to delete a workspace
account { op: "keys.create", name: "grist-agent", allowed_actions: ["grist.*"], cap_calls: 2000, confirm_policy: "human_for_writes", approval_rules: [ { match: "grist.workspaces.delete_workspace", approver: "[email protected]" }, { match: "grist.records.delete_records", approver: "[email protected]" }, { match: "grist.users.delete_user", approver: "[email protected]" } ]}Cost
What Grist costs on actionlake.
Every Grist action is one upstream call, the only thing actionlake bills. Searching, check, cost, account and any call Grist refused with 401, 403, 429 or a 5xx are free. Paid plans start at US$49 a month for 250,000 calls, with overage from US$0.30 down to US$0.18 per 1,000.
- 1upstream call per actionall 108 Grist actions
- 108actions pageeach page of a long list is one call
- 38reads can be cacheda cache hit costs nothing
- 100,000calls a month, freepaid plans from US$49 a month for 250,000
Action index
Every Grist action.
108 actions by area: the id your agent calls, what it does, and its effect.
Docs36
grist.docs.apply_proposalApply a change proposalwritegrist.docs.apply_user_actionsApply a list of user actionswritegrist.docs.assign_docReassign document to appropriate workerwritegrist.docs.compare_documentsCompare two documentsreadgrist.docs.compare_versionsCompare document versionsreadgrist.docs.copy_docCopies a document to a workspace.writegrist.docs.create_docCreate an empty documentwritegrist.docs.create_doc_unifiedCreate a documentwritegrist.docs.create_proposalCreate a change proposalwritegrist.docs.delete_actionsTruncate the document's action historydestructivegrist.docs.delete_docDelete a documentdestructivegrist.docs.describe_docDescribe a documentreadgrist.docs.disable_docDisable a document.writegrist.docs.download_table_schemaThe schema of a tablereadgrist.docs.enable_docEnable a document.writegrist.docs.flush_docFlush document to storagewritegrist.docs.force_reloadReload a documentwritegrist.docs.fork_docFork a documentwritegrist.docs.get_statesGet document action history statesreadgrist.docs.get_timing_statusGet formula timing statusreadgrist.docs.get_users_for_view_asGet users for 'View As' featurereadgrist.docs.list_doc_accessList users with access to documentreadgrist.docs.list_proposalsList change proposalsreadgrist.docs.list_snapshotsList document snapshotsreadgrist.docs.modify_docModify document metadata (but not its contents)writegrist.docs.modify_doc_accessChange who has access to documentwritegrist.docs.move_docMove document to another workspace.writegrist.docs.pin_docPin a documentwritegrist.docs.recover_docSet recovery mode for a documentwritegrist.docs.remove_docMove document to trashdestructivegrist.docs.remove_snapshotsRemove document snapshotsdestructivegrist.docs.replace_docReplace document contentwritegrist.docs.start_timingStart formula timingwritegrist.docs.stop_timingStop formula timingwritegrist.docs.unpin_docUnpin a documentwritegrist.docs.unremove_docRestore document from trashwrite
Attachments10
grist.attachments.get_attachment_metadataGet the metadata for an attachmentreadgrist.attachments.get_attachment_transfer_statusGet attachment transfer statusreadgrist.attachments.get_document_attachment_storeGet external storereadgrist.attachments.list_attachment_storesList external attachment storesreadgrist.attachments.list_attachmentsList metadata of all attachments in a docreadgrist.attachments.remove_unused_attachmentsDelete unused attachments from the documentdestructivegrist.attachments.set_document_attachment_storeSet external storewritegrist.attachments.start_attachment_transferStart transferring attachmentsdestructivegrist.attachments.update_used_attachmentsUpdate attachment usage trackingwritegrist.attachments.verify_attachment_filesVerify attachment file integritywrite
Workspaces9
grist.workspaces.create_workspaceCreate an empty workspacewritegrist.workspaces.delete_workspaceDelete a workspacedestructivegrist.workspaces.describe_workspaceDescribe a workspacereadgrist.workspaces.list_workspace_accessList users with access to workspacereadgrist.workspaces.list_workspacesList workspaces and documents within an orgreadgrist.workspaces.modify_workspaceModify a workspacewritegrist.workspaces.modify_workspace_accessChange who has access to workspacewritegrist.workspaces.remove_workspaceMove workspace to trashdestructivegrist.workspaces.unremove_workspaceRestore workspace from trashwrite
Orgs7
grist.orgs.delete_orgDelete an orgdestructivegrist.orgs.describe_orgDescribe an orgreadgrist.orgs.get_org_usageGet organization usage summaryreadgrist.orgs.list_org_accessList users with access to orgreadgrist.orgs.list_orgsList the orgs you have access toreadgrist.orgs.modify_orgModify an orgwritegrist.orgs.modify_org_accessChange who has access to orgwrite
Service accounts7
grist.service_accounts.create_service_accountCreate a service accountwritegrist.service_accounts.delete_service_accountDelete a service accountdestructivegrist.service_accounts.delete_service_account_api_keyDelete a service account's api keydestructivegrist.service_accounts.get_service_accountGet a service account's detailsreadgrist.service_accounts.list_service_accountsGet all your service accountsreadgrist.service_accounts.modify_service_accountModify a service accountwritegrist.service_accounts.regenerate_service_account_api_keyGenerate a new service account's api keywrite
Webhooks6
grist.webhooks.clear_webhook_queueEmpty a document's queue of undelivered payloadsdestructivegrist.webhooks.clear_webhook_queue_for_webhookClear queue for a specific webhookdestructivegrist.webhooks.create_webhooksCreate new webhooks for a documentwritegrist.webhooks.delete_webhookRemove a webhookdestructivegrist.webhooks.list_webhooksWebhooks associated with a documentreadgrist.webhooks.modify_webhookModify a webhookwrite
Columns5
grist.columns.add_columnsAdd columns to a tablewritegrist.columns.delete_columnDelete a column of a tabledestructivegrist.columns.list_columnsList columns in a tablereadgrist.columns.modify_columnsModify columns of a tablewritegrist.columns.replace_columnsAdd or update columns of a tablewrite
Records5
grist.records.add_recordsAdd records to a tablewritegrist.records.delete_recordsDelete records of a tabledestructivegrist.records.list_recordsFetch records from a tablereadgrist.records.modify_recordsModify records of a tablewritegrist.records.replace_recordsAdd or update records of a tablewrite
Data4
grist.data.add_rowsAdd rows to a tablewritegrist.data.delete_rowsDelete rows of a tabledestructivegrist.data.get_table_dataFetch data from a tablereadgrist.data.modify_rowsModify rows of a tablewrite
Profile4
grist.profile.delete_api_keyDelete user's API keydestructivegrist.profile.get_profileGet current user's profilereadgrist.profile.update_user_localeUpdate user's localewritegrist.profile.update_user_nameUpdate user's namewrite
Session3
grist.session.get_active_sessionGet active session informationreadgrist.session.get_all_sessionsGet all session users and organizationsreadgrist.session.set_active_userSet active user for organizationwrite
Tables3
grist.tables.add_tablesAdd tables to a documentwritegrist.tables.list_tablesList tables in a documentreadgrist.tables.modify_tablesModify tables of a documentwrite
Users3
grist.users.delete_userDelete a user from Gristdestructivegrist.users.disable_userDisable a userdestructivegrist.users.enable_userEnable a userwrite
SQL2
grist.sql.run_sqlRun an SQL query against a document, with options or parametersreadgrist.sql.run_sql_getRun an SQL query against a documentread
Templates2
grist.templates.get_templateGet template detailsreadgrist.templates.list_templatesList available templatesread
Forms1
grist.forms.get_form_dataGet form view dataread
Widgets1
grist.widgets.list_widgetsList available custom widgetsread
Questions
The Grist MCP server, answered.
Is there a Grist MCP server for Claude?
Yes. actionlake is an MCP gateway: a remote MCP server that gives Claude, or another MCP client, 108 Grist actions across docs, attachments, workspaces and orgs, through the same eight tools it uses for every other connector. actionlake is independent; it is not made or endorsed by Grist.
What do I need to connect Grist?
Grist API key, sent as `Authorization. Plus your host. The free call account { op: "connections.requirements", service: "grist" } lists exactly what to paste.
Can an AI agent delete or change things in Grist?
Only if its key allows it, and only with an explicit confirmation. 20 Grist actions are destructive, including delete a workspace, delete records of a table and delete a user from Grist. Each runs only with confirm: true. Under the human confirm policy, or an approval rule on the key, the run waits until a named person approves it.
Will an AI agent use up my Grist API limit?
actionlake paces every call to the limits in the Grist service file: 10 calls a second per connection. Repeated reads are answered from cache (38 Grist actions can be), which never reaches Grist.
What does a Grist action cost?
One upstream call, the only unit actionlake bills. A list that pages bills one call per page (108 Grist actions page). Cache hits, searches, dry runs and calls Grist refused with 401, 403, 429 or a 5xx are free. The Free plan includes 100,000 calls a month with no card. Paid plans start at US$49 a month for 250,000 calls, with overage from US$0.30 down to US$0.18 per 1,000.
Which Grist API does it cover?
The Grist API 1.0.1 (OpenAPI 3.0.0) at your Grist instance's API base URL, which you enter when connecting (path /api). It is built from Grist's documentation as read on 23 October 2026. 108 actions in 17 areas, each one in the signed service file (version 1.0.0).
Does actionlake keep my Grist data, and where?
actionlake processes and stores data in Sydney, Australia; there is no US region yet. Reads may be cached for up to 5 minutes, and a write clears the reads it affects. Each run's request and response is kept, sealed, for your plan's trace window: 1 day on Free, 3 days on Starter, 7 days on Pro, 14 days on Team, 30 days on Business and 30 days on Enterprise. Your Grist credential is sealed under your tenant's key, never logged and never returned. Your traffic is not used to train models.
Which AI clients can use it?
Claude Code, tested by us end to end, and the Claude app as a custom connector, tested by us with an existing key. Other MCP clients that support remote servers over Streamable HTTP (MCP revisions 2025-06-18 and 2025-11-25) and OAuth dynamic client registration, or a bearer header, should connect the same way; we have not tested them. Or plain REST, under the same action names.
Give your agent Grist today.
Start free - 100,000 calls/month, no card. No signup. Hard caps on every key. Cached answers are free.
