Grist Integration for AI Agents

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Grist MCP or direct API to query tables, update records, automate workflows, and generate reports through natural language.
BOOK A CALLGET STARTED FOR FREE
Grist Logo
Gradient Top
Gradient Middle
Gradient Bottom
divider

Supported Tools

Tools
Add RecordsTool to add records to a specified table in a Grist document.
Create DocumentTool to create a document in a workspace.
Create SCIM UserTool to create a new SCIM user.
Create TableTool to create tables in a document.
Create Document WebhookTool to create a new webhook for a specified document.
Delete AttachmentTool to delete a specified attachment from a Grist document.
Delete ColumnTool to delete a column from a Grist document table.
Delete Grist Table RecordsTool to delete records from a specified Grist table.
Delete SCIM UserTool to delete a specified user via SCIM.
Delete WebhookTool to delete a webhook from a Grist document.
Download All Attachments ArchiveTool to download all attachments from a Grist document as a .
Download AttachmentTool to download the binary data of an attachment.
Download Grist Attachment ContentTool to download the raw bytes of an attachment.
Fetch Column MetadataTool to fetch metadata for a specific column in a Grist document table.
Fetch Document MetadataTool to fetch metadata for a specified Grist document.
Fetch Table MetadataTool to retrieve metadata for a specified table in a Grist document.
Get Org AccessTool to fetch org access details.
Get UsersTool to retrieve a list of users via SCIM v2.
List AttachmentsTool to list all attachments in a Grist document.
List ColumnsTool to list all columns in a specified Grist table.
List OrganizationsTool to list all organizations accessible to the authenticated user.
List RecordsTool to retrieve records from a specified table within a Grist document.
List TablesTool to list all tables within a specified document.
List WebhooksTool to list webhooks configured for a document.
List WorkspacesTool to list all workspaces and documents accessible to the authenticated user on the current site.
Run SQL QueryTool to execute a read-only SQL SELECT query on a Grist document.
Update Column MetadataTool to update metadata for one or more columns in a Grist document table.
Update Document MetadataTool to update metadata for a specified Grist document.
Update RecordsTool to update records in a specified table within a document.
Update Table MetadataTool to update metadata for a specified table.
Update WebhookTool to update an existing webhook for a specified document.
Upload AttachmentTool to upload one or more attachments to a Grist document.

Connect Grist MCP Tool with your Agent

Python
TypeScript

Install Composio

python
pip install composio claude-agent-sdk
Install the Composio SDK and Claude Agent SDK

Create Tool Router Session

python
from composio import Composio
from claude_agent_sdk import ClaudeSDKClient, ClaudeAgentOptions

composio = Composio(api_key='your-composio-api-key')
session = composio.create(user_id='your-user-id')
url = session.mcp.url
Initialize the Composio client and create a Tool Router session

Connect to AI Agent

python
import asyncio

options = ClaudeAgentOptions(
    permission_mode='bypassPermissions',
    mcp_servers={
        'tool_router': {
            'type': 'http',
            'url': url,
            'headers': {
                'x-api-key': 'your-composio-api-key'
            }
        }
    },
    system_prompt='You are a helpful assistant with access to Grist tools.',
    max_turns=10
)

async def main():
    async with ClaudeSDKClient(options=options) as client:
        await client.query('Add a new row to the "Sales" table in my Grist document with today\'s date and amount $5000')
        async for message in client.receive_response():
            if hasattr(message, 'content'):
                for block in message.content:
                    if hasattr(block, 'text'):
                        print(block.text)

asyncio.run(main())
Use the MCP server with your AI agent

Connect Grist API Tool with your Agent

Python
TypeScript

Install Composio

python
pip install composio_openai
Install the Composio SDK

Initialize Composio and Create Tool Router Session

python
from openai import OpenAI
from composio import Composio
from composio_openai import OpenAIResponsesProvider

composio = Composio(provider=OpenAIResponsesProvider())
openai = OpenAI()
session = composio.create(user_id='your-user-id')
Import and initialize Composio client, then create a Tool Router session

Execute Grist Tools via Tool Router with Your Agent

python
tools = session.tools
response = openai.responses.create(
  model='gpt-4.1',
  tools=tools,
  input=[{
    'role': 'user',
    'content': 'Add new rows to the “Sales” table for today’s transactions'
  }]
)
result = composio.provider.handle_tool_calls(
  response=response,
  user_id='your-user-id'
)
print(result)
Get tools from Tool Router session and execute Grist actions with your Agent

Why Use Composio?

AI Native Grist Integration

  • Supports both Grist MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for reading, writing, and querying your Grist data

Managed Auth

  • Built-in API key handling with secure storage and rotation
  • Central place to manage, scope, and revoke Grist access
  • Per user and per environment credentials instead of hard-coded keys

Agent Optimized Design

  • Tools are tuned using real error and success rates to improve reliability over time
  • Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

  • Fine-grained RBAC so you control which agents and users can access Grist
  • Scoped, least privilege access to Grist resources
  • Full audit trail of agent actions to support review and compliance

Use Grist with any AI Agent Framework

Choose a Framework you want to connect Grist with

Frequently Asked Questions

Do I need my own developer credentials to use Grist with Composio?

Yes, Grist requires you to configure your own API key credentials. Once set up, Composio handles secure credential storage and API request handling for you.

Can I use multiple toolkits together?

Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.

Is Composio secure?

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. Learn more.

What if the API changes?

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

Used by agents from

Context
ASU
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
ASU
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
ASU
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai

Never worry about agent reliability

We handle tool reliability, observability, and security so you never have to second-guess an agent action.

Book a call↗Get started for free