Grist MCP server

Connect Grist to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Grist MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the update webhook tool in Grist
  • Use the update document tool in Grist
  • Use the delete document tool in Grist
  • Use the list organizations tool in Grist
  • Use the add records tool in Grist
  • Use the delete webhook tool in Grist

Supported Tools

update_webhook

Update Webhook

Update an existing webhook's configuration such as URL, event types, enabled state, or ready column.

update_document

Update Document

Update a document's properties such as name and pinned status. Can also move the document to a different workspace.

delete_document

Delete Document

Soft-delete a document (move to trash) or permanently delete it. Soft-deleted documents can be restored.

list_orgs

List Organizations

List all accessible organizations (team sites and personal spaces). Returns org IDs, names, and domains that the authenticated user can access.

add_records

Add Records

Add one or more records (rows) to a table. Each record is an object of column ID to value mappings.

delete_webhook

Delete Webhook

Delete a webhook from a document. Optionally clear the pending delivery queue for a specific webhook or all webhooks.

list_webhooks

List Webhooks

List all webhooks configured for a document, including their URLs, target tables, event types, and delivery status.

delete_records

Delete Records

Delete records from a table by their record IDs.

list_tables

List Tables

List all tables in a Grist document. Returns table IDs and metadata.

create_table

Create Table

Create one or more tables in a Grist document. Each table can be initialized with columns.

add_or_update_records

Add or Update Records

Upsert records: for each record, check if a matching record exists using the "require" fields. If found, update it with the "fields" values. If not found, create a new record combining "require" and "fields".

fetch_records

Fetch Records

Fetch records (rows) from a table with optional filtering, sorting, and limiting. Supports filtering by column values and sorting in ascending/descending order.

create_document

Create Document

Create a new empty document in a workspace.

list_columns

List Columns

List all columns in a table. Returns column IDs, types, labels, and other metadata.

delete_workspace

Delete Workspace

Soft-delete a workspace (move to trash) or permanently delete it. Soft-deleted workspaces can be restored.

get_document

Get Document

Retrieve details about a specific Grist document, including its name, workspace, and access information.

list_workspaces

List Workspaces

List all workspaces in an organization, including their documents. Use the org ID from the List Organizations tool.

run_sql

Run SQL Query

Execute a read-only SQL SELECT query against a document's SQLite database. Supports parameterized queries to prevent SQL injection. Only SELECT statements are allowed.

update_records

Update Records

Update existing records in a table by their record IDs. Only specified fields will be modified.

create_workspace

Create Workspace

Create a new workspace in an organization.

modify_columns

Modify Columns

Create, update, or delete columns in a table. Supports adding new columns with types and formulas, updating existing column properties, or removing columns.

list_attachments

List Attachments

List attachment metadata for a document. Returns file names, sizes, and upload times.

create_webhook

Create Webhook

Create a webhook that sends POST requests to a URL when data changes in a document table. Supports filtering by event types (add, update) and gating with a ready column.

get_current_user

Get Current User

Get the identity and profile of the user who owns the connected API key.

update_workspace

Update Workspace

Rename a workspace. Call list_workspaces to discover workspace IDs.

restore_document

Restore Document

Restore a document that was moved to trash. Permanently deleted documents cannot be restored.

get_workspace

Get Workspace

Retrieve workspace details. Call list_workspaces to discover workspace IDs.

download_attachment

Download Attachment

Download a document attachment. Call list_attachments to discover attachment IDs.

restore_workspace

Restore Workspace

Restore a workspace that was moved to trash. Permanently deleted workspaces cannot be restored.

download_document

Download Document

Download a Grist document as a SQLite file, optionally removing its history or exporting its structure as a template.

Connect Grist to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Grist in Metorial. In your Metorial portal, enable the Grist MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Grist tools.

Run Grist through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Grist and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Grist tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Grist

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

Google Sheets

Create, read, and update spreadsheets and their cell data. Read and write values to individual cells, ranges, or multiple ranges using A1 notation or named ranges. Apply cell formatting including text styles, backgrounds, borders, number formats, and conditional formatting. Manage sheets (tabs) within a spreadsheet—add, delete, copy, rename, and reorder them. Create and manage embedded charts, pivot tables, filter views, data validation rules, protected ranges, named ranges, and merged cells. Perform batch operations to apply multiple updates atomically.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Microsoft Outlook

Send, read, reply to, forward, and manage email messages in user mailboxes. Organize messages into folders, apply categories, flags, and importance levels. Manage file and item attachments. Create, update, delete, and respond to calendar events and meetings. Find available meeting times, manage attendees, handle recurrence, and work with shared or delegated calendars. Create, read, update, and delete contacts, organize them into contact folders, and manage contact photos. Manage tasks and task lists via Microsoft To Do, including due dates, reminders, recurrence, and checklist items. Support for Focused Inbox, @-mentions, mail tips, send-on-behalf, and send-as capabilities.

Technical notes for Grist

Manage organizations, workspaces, documents, tables, columns, and records in Grist's relational spreadsheet-database. Create and modify tables and columns with typed fields (Text, Numeric, Date, Choice, Ref, etc.). Fetch, add, update, and delete records with filtering, sorting, and upsert support. Upload and manage file attachments. Execute read-only SQL queries against document data. Apply batch operations via user actions. Create and manage webhooks for row-added and row-updated events. Download documents as .grist or .sqlite files. Manage workspace and document access, pinning, and organization.

Frequently asked questions

Common questions about connecting Grist to AI agents with Metorial.

  1. How many tools does the Grist MCP server have?
    The Grist MCP server exposes 30 tools, including Update Webhook, Update Document, Delete Document. Each one is governed and traced through Metorial.
  2. Grist exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Grist MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Grist and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Grist MCP server yourself or use the hosted gateway.

Connect Grist to production AI agents

See how Metorial gives your team governed access to Grist, with tracing and security controls built in.