Use
COMPOSIOFOR YOU
Give Claude, Codex, or any harness secure access to 1700+ tools
CLI
One command to add tools and auth to your coding agent
Build
DEVELOPER PLATFORM
SDKs, tools, and auth for agents and backend apps
MCP GATEWAY
One managed MCP endpoint for all your tools and agents
ENTERPRISE
SSO, governance, and audit controls for deploying agents org-wide
Features
TRIGGERS
Start background agents from events across your connected apps
FIREWALLNEW
Blocks instructions hidden in tool results before your agent reads them
INSTANTNEW
Audio, video, search, browser and data tools, with no keys to manage
OPTIMIZATION
Lower cost per completed task with optimised tools and skills
FOR AGENTS
CLAUDE CODEX OPENCLAW CURSOR HERMES
BUILT FOR
OFFICE WORK SALES MARKETING PRODUCT & DESIGN CUSTOMER SUPPORT ENGINEERING HR & RECRUITING FINANCE & OPS E-COMMERCE CONTENT & MEDIA IT & SECURITY
ALL USE CASES
DOCS

How to integrate Grist MCP with Codex

Connect Codex to Grist MCP. Add new sales data to q2 table, create a document for project planning, and more using natural language, with authentication handled for you.

Get started for free Get a demo

Grist

Api Key

Grist is a relational spreadsheet platform combining spreadsheet flexibility with database power. It helps you build custom applications tailored to your unique data needs.

30 Tools

Managed auth

Connect Grist without auth hassles

We manage OAuth, API keys, token refresh, and scopes — you just build.

Book a call

Explore the MCP Gateway

Introduction

Codex is one of the most popular coding harnesses out there. And MCP makes the experience even better. With the Grist MCP integration, Codex can add and update records, create documents and tables, run SQL queries, manage attachments, and set up webhooks, all without leaving the terminal or the app, whichever you prefer.

For exact tool slugs and parameter tables, see the tool catalog in the Composio docs.

Also integrate Grist with

Claude Code Claude Cowork OpenAI Agents SDK Claude Agent SDK Grok Bot OpenClaw Hermes Atomic Agent Google ADK LangChain Vercel AI SDK Mastra AI LlamaIndex CrewAI Pydantic AI AutoGen

Why use Composio?

Apart from a managed and hosted MCP server, you will get:

CodeAct: A dedicated workbench that allows GPT to write its code to handle complex tool chaining. Reduces to-and-fro with LLMs for frequent tool calling.
Large tool responses: Handle them to minimise context rot.
Dynamic just-in-time access to 20,000 tools across 1700+ other Apps for cross-app workflows. It loads the tools you need, so GPTs aren't overwhelmed by tools you don't need.

How to install Grist MCP in Codex

Run the setup command

Run this command in your terminal to add the Composio MCP server to Codex.

Terminal

It will initiate the authentication in a browser window, authorize Codex to access your Composio account.

(Optional) Authenticate with OAuth

To authenticate manually, run the login command to open a browser window and authorize Codex to access your Composio account.

bash

codex mcp login composio

Verify the connection

Run codex mcp list to confirm Composio appears as a registered MCP server.

bash

codex mcp list

Codex App

Codex App follows the same approach as VS Code.

Click ⚙️ on the bottom left → MCP Servers → + Add servers → Streamable HTTP:
Fill the header and Key fields with { "x-consumer-api-key" = "ck_*******" }.
The Key is the Composio API key, that you can find on dashboard.composio.dev
Click on Authenticate and authorize Codex to your Composio account and you're all set.

Restart and verify if it's there in .codex/config.toml

bash

[mcp_servers.composio]
url = "https://connect.composio.dev/mcp"
http_headers = { "x-consumer-api-key" = "ck_*******" }

Try it

Ask Codex for a Grist task. The first time, Composio asks you to connect your Grist account.

For example, ask it to:

"Add new sales data to Q2 table"
"Create a document for project planning"
"Delete outdated rows from inventory sheet"

What is the Grist MCP server, and what's possible with it?

The Grist MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Grist account. It provides structured and secure access to your spreadsheets and documents, so your agent can perform actions like adding records, creating tables, managing documents, and handling attachments on your behalf.

Automated data entry and record management: Instruct your agent to add, update, or delete records in specific Grist tables, streamlining your workflows and reducing manual input.
Table and document creation: Let your agent create new tables or entire documents in your workspaces, helping you quickly set up and expand your data structures as your needs grow.
Attachment and file management: Ask your agent to remove unwanted attachments from Grist documents, keeping your files organized and storage efficient.
Custom webhook integration: Have your agent register or delete webhooks for documents, enabling real-time notifications and integrations with other tools or services you rely on.
User and access provisioning via SCIM: Direct your agent to create or delete SCIM users as needed, making it easy to manage who has access to your Grist environment.

Conclusion

You've successfully integrated Grist with Codex using Composio's MCP server. Now you can interact with Grist directly from your terminal, VS Code, or the Codex App using natural language commands.

Key benefits of this setup:

Seamless integration across CLI, VS Code, and standalone app
Natural language commands for Grist operations
Managed authentication through Composio
Access to 20,000+ tools across 1700+ apps for cross-app workflows
CodeAct workbench for complex tool chaining

Next steps:

Try asking Codex to perform various Grist operations
Explore cross-app workflows by connecting more toolkits
Build automation scripts that leverage Codex's AI capabilities

TOOLS

Supported Tools

Every Grist action and event your agent gets out of the box.

Add Records

Add one or more records to a Grist table.

Create Document

Creates a new Grist document in a specified workspace.

Create SCIM User

Create a Grist user for SCIM provisioning.

Create Table

Tool to create tables in a document.

Create Document Webhook

Tool to create a new webhook for a specified document.

Remove Unused Attachments

Remove unused attachments from a Grist document to free up storage space.

Delete Column

Tool to delete a column from a Grist document table.

Delete Grist Table Records

Tool to delete records from a specified Grist table.

Delete SCIM User

Delete a Grist SCIM user by numeric user ID.

Delete Webhook

Permanently removes a webhook from a Grist document.

Download All Attachments Archive

Download all attachments from a Grist document as a single archive file (.

Download Attachment

Download a file attachment from a Grist document.

Fetch Document Metadata

Tool to fetch metadata for a specified Grist document.

Fetch Table Metadata

Tool to retrieve metadata for a specified table in a Grist document.

Get Org Access

Retrieves the list of users who have access to a Grist organization along with their access roles (owners, editors, viewers).

Get Users

List Grist users via SCIM v2, with filtering and pagination.

List Attachments

Tool to list all attachments in a Grist document.

List Columns

List columns and their metadata in a specified Grist table.

List Organizations

Tool to list all organizations accessible to the authenticated user.

List Records

Tool to retrieve records from a specified table within a Grist document.

List Tables

Tool to list all tables within a specified document.

List Webhooks

List all webhooks configured for a Grist document.

List Workspaces

Tool to list all workspaces and documents accessible to the authenticated user on the current site.

Run SQL Query

Tool to execute a read-only SQL SELECT query on a Grist document.

Update Column Metadata

Updates metadata (label, type, description, formula, etc.

Update Document Metadata

Tool to update metadata for a specified Grist document.

Update Records

Update existing records in a Grist table by their row IDs.

Update Table Metadata

Update metadata for a table in a Grist document, including its table ID for renaming or its on-demand loading setting.

Update Webhook

Update an existing webhook on a Grist document, changing provided settings such as its URL, event types, enabled status, or target table.

Upload Attachment

Upload one or more file attachments to a Grist document.

FRAMEWORKS

How to build Grist MCP Agent with another framework

Claude Code

Use Grist MCP with Claude Code

Claude Cowork

Use Grist MCP with Claude Cowork

OpenAI Agents SDK

Use Grist MCP with OpenAI Agents SDK

Claude Agent SDK

Use Grist MCP with Claude Agent SDK

Grok Bot

Use Grist MCP with Grok Bot

OpenClaw

Use Grist MCP with OpenClaw

Hermes

Use Grist MCP with Hermes

Atomic Agent

Use Grist MCP with Atomic Agent

Google ADK

Use Grist MCP with Google ADK

LangChain

Use Grist MCP with LangChain

Vercel AI SDK

Use Grist MCP with Vercel AI SDK

Mastra AI

Use Grist MCP with Mastra AI

LlamaIndex

Use Grist MCP with LlamaIndex

CrewAI

Use Grist MCP with CrewAI

Pydantic AI

Use Grist MCP with Pydantic AI

AutoGen

Use Grist MCP with AutoGen

MORE TOOLKITS

Explore Other Toolkits

Toolkit marketplace

Google Sheets

Oauth2

Google Sheets is a cloud-based spreadsheet tool for real-time collaboration and data analysis. It lets teams work together from anywhere, updating information instantly.

Notion

Oauth2Api Key

Notion is a collaborative workspace for notes, docs, wikis, and tasks. It streamlines team knowledge, project tracking, and workflow customization in one place.

Airtable

Oauth2Api Key

Airtable combines the flexibility of spreadsheets with the power of a database for easy project and data management. Teams use Airtable to organize, track, and collaborate with custom views and automations.

Asana

Oauth2

Asana is a collaborative work management platform for teams to organize and track projects. It streamlines teamwork, boosts productivity, and keeps everyone aligned on goals.

FAQ

Frequently asked questions

With a standalone Grist MCP server, the agents and LLMs can only access a fixed set of Grist tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Grist and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Codex fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Grist tools.

Yes, absolutely. You can configure which Grist scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Grist data and credentials are handled as safely as possible.

Start with Grist.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Grist tool your agent needs.Free to start.

Start building

How to integrate Grist MCP with Codex

Connect Grist without auth hassles

Introduction

Also integrate Grist with

Why use Composio?

How to install Grist MCP in Codex

Run the setup command

(Optional) Authenticate with OAuth

Verify the connection

Codex App

Try it

What is the Grist MCP server, and what's possible with it?

Conclusion

Supported Tools

How to build Grist MCP Agent with another framework

Claude Code

Claude Cowork

OpenAI Agents SDK

Claude Agent SDK

Grok Bot

OpenClaw

Hermes

Atomic Agent

Google ADK

LangChain

Vercel AI SDK

Mastra AI

LlamaIndex

CrewAI

Pydantic AI

AutoGen

Explore Other Toolkits

Google Sheets

Notion

Airtable

Asana

Frequently asked questions

What are the differences in Tool Router MCP and Grist MCP?

Can I use Tool Router MCP with Codex?

Can I manage the permissions and scopes for Grist while using Tool Router?

How safe is my data with Composio Tool Router?

Start with Grist.It takes 30 seconds.