Your AI team, working in 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.

Start your company

What your team can do in Grist

30 tools to work with, connected with an API key.

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 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.

Create SCIM User

Create a Grist user for SCIM provisioning. If SCIM is unavailable, this may instead grant owner access to the first supplied email in the first listed organization, or the current organization if none is listed; this does not create a SCIM user.

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.

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 Grist SCIM user by numeric user ID. In some cases, the operation instead removes the user's access to the first listed organization, or the current organization if none is listed; this is not a SCIM user deletion.

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 and cannot be undone.

Download All Attachments ArchiveReads only

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 archive if no attachments exist.

Download AttachmentReads only

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 MetadataReads only

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

Fetch Table MetadataReads only

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 AccessReads only

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 management tasks.

Get UsersReads only

List Grist users via SCIM v2, with filtering and pagination. When SCIM is unavailable, results may instead cover users with access to the current organization; in that case filtering is limited to simple username and display-name expressions.

List AttachmentsReads only

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

List ColumnsReads only

List columns and their metadata in a specified Grist table. Hidden columns are included when requested.

List OrganizationsReads only

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

List RecordsReads only

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 TablesReads only

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

List WebhooksReads only

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 document ID obtained from GRIST_LIST_WORKSPACES or GRIST_CREATE_DOCUMENT.

List WorkspacesReads only

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.

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 remove a specific attachment: 1. First remove its reference from the Attachments column cell that contains it 2. Then call this action to clean up the now-unreferenced file Attachments become "unused" when they are no longer referenced by any Attachments-type cell. Grist normally retains unreferenced attachments for a period to allow undo operations. This action removes them immediately (or only expired ones if expired_only=true).

Run SQL QueryReads only

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 to true.

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 batch updates - you can update multiple records in a single call. The API uses PATCH semantics, meaning only specified fields are updated; unspecified fields remain unchanged. IMPORTANT: When updating multiple records in a batch, all records must specify the exact same set of field names (e.g., if updating Name and Age for record 1, you must also update Name and Age for record 2).

Update Table Metadata

Update metadata for a table in a Grist document, including its table ID for renaming or its on-demand loading setting. The response echoes the requested update.

Update Webhook

Update an existing webhook on a Grist document, changing provided settings such as its URL, event types, enabled status, or target table. Omitted settings remain unchanged. An update may take effect even when the tool reports an error.

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.

More in Productivity

See them all β†’

Your company, run by an AI team

Start your company

BRAINER

Continue to B.R.A.I.N.E.R.

Continue with Google or your email.

or