Grist
Grist is a relational spreadsheet platform that combines the flexibility of a spreadsheet with the robustness of a database, allowing users to create custom applications tailored to their data needs.
This is a first-class FlyMyAI MCP. Agents discover it automatically via tool search and call the actions below on demand - you never wire it up by hand. See the Composio catalog for how discovery works.
Connect
Grist authenticates with an API key. Generate the credential in your Grist account, then paste it into FlyMyAI the first time an agent uses a Grist action.
Fields to fill in FlyMyAI
| Field | Details |
|---|---|
Grist Team Subdomain | The subdomain of the Grist team site, used to construct the base URL for API requests. (required) |
Grist API Key | The API key for authenticating requests to the Grist API. (required) |
Actions
Every action this integration exposes. Agents pick the right one from the task; you do not call them by name.
| Action | What it does | Required inputs |
|---|---|---|
GRIST_ADD_RECORDS | Tool to add records to a specified table in a Grist document. Use after confirming doc and table IDs. | docId, tableId, records |
GRIST_CREATE_DOCUMENT | Tool to create a document in a workspace. Use when you need to add a new document programmatically after selecting a workspace. | workspaceId |
GRIST_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. | schemas, userName, name, emails |
GRIST_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. | docId, tables |
GRIST_CREATE_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. | docId, webhooks |
GRIST_DELETE_ATTACHMENT | Tool to delete a specified attachment from a Grist document. Use when you need to remove a file by providing its document and attachment IDs. | doc_id, attachment_id |
GRIST_DELETE_COLUMN | Tool to delete a column from a Grist document table. Use after confirming document, table, and column IDs. | doc_id, table_id, col_id |
GRIST_DELETE_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. | doc_id, table_id, row_ids |
GRIST_DELETE_SCIM_USER | Tool to delete a specified user via SCIM. Use after confirming the user's SCIM user ID exists. | user_id |
GRIST_DELETE_WEBHOOK | Tool to delete a webhook from a Grist document. Use when you need to remove a specific webhook after confirming its ID. | doc_id, webhook_id |
GRIST_DOWNLOAD_ALL_ATTACHMENTS_ARCHIVE | Tool to download all attachments from a Grist document as a .zip or .tar archive. Use after ensuring attachments exist in the specified document. | doc_id |
GRIST_DOWNLOAD_ATTACHMENT | Tool to download the binary data of an attachment. Use when you have the document ID and attachment ID and need the raw file content. | docId, attachmentId |
GRIST_DOWNLOAD_ATTACHMENT_CONTENT | Tool to download the raw bytes of an attachment. Use when you need to retrieve the binary data of a specific Grist document attachment after confirming the document and attachment IDs. | docId, attachmentId |
GRIST_FETCH_COLUMN_METADATA | Tool to fetch metadata for a specific column in a Grist document table. Use when you need to inspect column properties before data operations. | doc_id, table_id, col_id |
GRIST_FETCH_DOCUMENT_METADATA | Tool to fetch metadata for a specified Grist document. Use after obtaining the document ID. | doc_id |
GRIST_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. | doc_id, table_id |
GRIST_GET_ORG_ACCESS | Tool to fetch org access details. Use when you need to retrieve numeric user IDs for actions like SCIM user deletion when SCIM API is disabled. | - |
GRIST_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. | - |
GRIST_LIST_ATTACHMENTS | Tool to list all attachments in a Grist document. Use after confirming the document ID to retrieve attachment metadata. | docId |
GRIST_LIST_COLUMNS | Tool to list all columns in a specified Grist table. Use after selecting the document and table to inspect column metadata. | doc_id, table_id |
GRIST_LIST_ORGANIZATIONS | Tool to list all organizations accessible to the authenticated user. Use when you need to select a Grist organization for subsequent operations. | - |
GRIST_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'. | docId, tableId |
GRIST_LIST_TABLES | Tool to list all tables within a specified document. Use after obtaining the document ID to retrieve its tables. | docId |
GRIST_LIST_WEBHOOKS | Tool to list webhooks configured for a document. Use when you need to retrieve all webhooks for a document after obtaining its ID. | doc_id |
GRIST_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. | - |
GRIST_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. | docId, sql |
GRIST_UPDATE_COLUMN_METADATA | Tool to update metadata for one or more columns in a Grist document table. Use after confirming document and table IDs. Example: change label or type of columns. | docId, tableId, columns |
GRIST_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. | doc_id |
GRIST_UPDATE_RECORDS | Tool to update records in a specified table within a document. Use after fetching record IDs. | docId, tableId, records |
GRIST_UPDATE_TABLE_METADATA | Tool to update metadata for a specified table. Use after confirming document and table IDs to modify properties such as onDemand or visibility. | docId, tableId, fields |
GRIST_UPDATE_WEBHOOK | Tool to update an existing webhook for a specified document. Use when you need to modify webhook settings after confirming document and webhook IDs. | doc_id, webhook_id |
GRIST_UPLOAD_ATTACHMENT | Tool to upload one or more attachments to a Grist document. Use when you need to add files to a document after preparing file data. | docId, files |
Links
We love our partners - FlyMy.AI builds with the best. Thanks, Grist!