How do I connect Grist to Operator?

You authorize Grist once from your Operator dashboard. Operator holds the connection and refreshes the access token for you, so your agent keeps working with Grist without you signing in again.

Can my agent manage tasks and projects in Grist?

Yes. It can create and update items, move them between stages, add notes, and read the current state back to you. Use it to file new work as it arrives, check status without opening the app, or keep Grist aligned with what is happening elsewhere.

Do I need to write code or manage Grist API keys?

No code and no API keys. You authorize Grist through a normal sign in and Operator handles the connection, so there is nothing to wire up or host.

Can my agent use Grist together with my other apps?

Yes. The same agent reaches every app you connect, so it can move between Grist and tools like Google Sheets, Notion, Linear in one job, reading from one and acting in another without you wiring anything between them.

← All integrations

Connect Grist to OpenClaw on Operator.io

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

Productivity & Project Management30 actions

Try for free

Automate Grist with AI

Operator puts an OpenClaw agent in front of Grist. You describe the job from Telegram or Discord and it handles the rest inside Grist, picking the right calls from the 30 Grist actions and checking its own work as it goes.

Your agent reaches Grist directly or through connectors like Composio MCP and Pipedream MCP, which handle the sign in and token refresh for you, so there is nothing to wire up and no API keys to paste.

What your agent can do with Grist

Your agent can call any of these Grist actions by name as part of a larger task. Ask for the outcome you want and it picks the right ones.

Add Records

Add one or more records to a Grist table. First use GRIST_LIST_WORKSPACES to get docId, GRIST_LIST_TABLES to get tableId, and GRIST_LIST_COLUMNS to get column IDs for the fields mapping.

Create Document

Creates a new Grist document in a specified workspace. Use this tool when you need to add a new spreadsheet document to a workspace. Requires a valid workspace ID (obtainable via GRIST_LIST_WORKSPACES) and a document name.

Create SCIM User

Tool to create a new SCIM user. Use when provisioning new user accounts via SCIM. Run after gathering all required user details.

Create Table

Tool to create tables in a document. Use after confirming the document ID. Creates one or more tables with specified columns in the given document.

Create Document Webhook

Tool to create a new webhook for a specified document. Use when you need to register webhook endpoints for document events in Grist. Run after confirming document ID.

Remove Unused Attachments

Remove unused attachments from a Grist document to free up storage space. IMPORTANT: This action removes ALL attachments that are not currently referenced by any cell in the document. It does NOT delete a specific attachment by ID. To re...

Delete Column

Tool to delete a column from a Grist document table. Use after confirming document, table, and column IDs.

Delete Grist Table Records

Tool to delete records from a specified Grist table. Use when you need to remove specific rows by their IDs. Use after confirming the row IDs exist.

Delete SCIM User

Delete a user from the Grist organization by their numeric user ID. Use GRIST_GET_USERS first to find the user's ID. Falls back to org access API if SCIM is not enabled. Note: Cannot delete your own account.

Delete Webhook

Permanently removes a webhook from a Grist document. Use this tool when you need to stop receiving notifications for document changes. First use GRIST_LIST_WEBHOOKS to find the webhook_id you want to delete. This action is destructive an...

Download All Attachments Archive

Download all attachments from a Grist document as a single archive file (.zip or .tar). Use this to bulk-download attachments. Ensure the document has attachments before calling (check with GRIST_LIST_ATTACHMENTS). Returns an empty archi...

Download Attachment

Download a file attachment from a Grist document. Returns the file content as a downloadable file. Use GRIST_LIST_ATTACHMENTS first to get valid attachment IDs.

Fetch Document Metadata

Tool to fetch metadata for a specified Grist document. Use after obtaining the document ID.

Fetch Table Metadata

Tool to retrieve metadata for a specified table in a Grist document. Use when you need to inspect table schema details before data operations.

Get Org Access

Retrieves the list of users who have access to a Grist organization along with their access roles (owners, editors, viewers). Use this to find user IDs, emails, or check access permissions within an organization. Useful for user manageme...

Get Users

Tool to retrieve a list of users via SCIM v2. Use when you need to page through and filter enterprise users in Grist.

List Attachments

Tool to list all attachments in a Grist document. Use after confirming the document ID to retrieve attachment metadata.

List Columns

Tool to list all columns in a specified Grist table. Use after selecting the document and table to inspect column metadata.

List Organizations

Tool to list all organizations accessible to the authenticated user. Use when you need to select a Grist organization for subsequent operations.

List Records

Tool to retrieve records from a specified table within a Grist document. Use when you need to fetch rows by applying optional filters, sorting, limits, or hidden columns. Example: list records where pet is 'cat' sorted by '-age'.

List Tables

Tool to list all tables within a specified document. Use after obtaining the document ID to retrieve its tables.

List Webhooks

List all webhooks configured for a Grist document. Returns webhook configuration details (URL, event types, table binding) and delivery status information. Use this to inspect, audit, or manage webhooks for a document. Requires a valid d...

List Workspaces

Tool to list all workspaces and documents accessible to the authenticated user on the current site. Use when you need to select a workspace or document for subsequent operations.

Run SQL Query

Tool to execute a read-only SQL SELECT query on a Grist document. Use after confirming the document ID and preparing a valid SQL SELECT statement.

Update Column Metadata

Updates metadata (label, type, description, formula, etc.) for one or more columns in a Grist table. Use List Columns first to get valid column IDs. Warning: changing 'label' may rename the column ID unless 'untieColIdFromLabel' is set t...

Update Document Metadata

Tool to update metadata for a specified Grist document. Use when you need to rename or pin/unpin a document after obtaining its ID.

Update Records

Update existing records in a Grist table by their row IDs. Use this tool to modify field values for one or more records in a specified document and table. First use GRIST_LIST_RECORDS to obtain the record IDs you want to update. Supports...

Update Table Metadata

Update metadata properties for a table in a Grist document. Currently the main updatable property is 'onDemand' which controls lazy loading of table data. Use List Tables to find valid table IDs first.

Update Webhook

Update an existing webhook configuration for a Grist document. Use to modify webhook settings such as URL, event types, enabled status, or target table. Requires valid document ID (from GRIST_LIST_WORKSPACES) and webhook ID (from GRIST_L...

Upload Attachment

Upload one or more file attachments to a Grist document. Returns attachment IDs that can be used to link files to records in Attachments-type columns. First use GRIST_LIST_WORKSPACES to get a valid document ID.

How to connect Grist

You authorize Grist once from your dashboard. Operator holds the connection and refreshes the access tokens on its own, so your agent keeps working with Grist without you signing in again. The same setup unlocks every other app your agent can reach, so you only do it once.

When you are ready, the get started guide walks through standing up your OpenClaw agent.

Common questions about Grist

How do I connect Grist to Operator?: You authorize Grist once from your Operator dashboard. Operator holds the connection and refreshes the access token for you, so your agent keeps working with Grist without you signing in again.
Can my agent manage tasks and projects in Grist?: Yes. It can create and update items, move them between stages, add notes, and read the current state back to you. Use it to file new work as it arrives, check status without opening the app, or keep Grist aligned with what is happening elsewhere.
Do I need to write code or manage Grist API keys?: No code and no API keys. You authorize Grist through a normal sign in and Operator handles the connection, so there is nothing to wire up or host.
Can my agent use Grist together with my other apps?: Yes. The same agent reaches every app you connect, so it can move between Grist and tools like Google Sheets, Notion, Linear in one job, reading from one and acting in another without you wiring anything between them.

More apps to automate

Apps your agent runs alongside Grist, or browse all integrations.

Put your agent on Grist

Try for free