Grist

productivity 30 tools available

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.

Connect Grist Visit Grist

About this integration

Connect Grist to Definable to capture notes by voice or chat, roll up daily activity, retrieve anything by description. Personas call Grist's 30 tools directly from chat or scheduled flows. Wire it to your assistant — capture, organise, and recall through one conversation.

Connect Grist to Definable and it becomes a set of typed tools your agents plan with — triggered by events, run on schedules, or invoked mid-conversation. Every write is checked by the verifier before it lands.

Auth OAuth2 · 2 clicks

Tools 30 exposed

Plans All, incl. Free

Data Never trained on

Grist · in workflows

What teams actually run.

Three patterns teams run with Grist on day one. Each one is a plain-English prompt — no canvas, no glue code — and you can remix them into anything.

Capture from chat

│ Tell the persona to remember something

│ Agent writes it to this tool

└ Returns a link for confirmation

Daily roll-up

│ Pull yesterday's activity

│ Summarise as a digest

└ Save it back into this tool

Smart retrieval

│ Ask "where did I write about X?"

│ Agent searches

└ Returns the page with context

30 tools available

The Grist toolbox.

Every Grist capability your agents can call, each with a typed schema the planner reads. The router picks the right tool per step; the verifier checks the result.

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

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

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

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

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

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 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 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_LIST_WEBHOOKS). Only provided fields will be updated; omitted fields remain unchanged.

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.

See it run

One prompt, start to finish.

A real prompt, the Grist tools it calls, and what comes back. This is the whole interface — describe the outcome, agents handle the rest.

❯

Run a real Grist task end-to-end — plan it, execute across the API, and hand back a verified result.

grist.add_records Add one or more records to a Grist table. First use GRIST_LIST_WORKSPACES to get docId, GR

grist.create_document Creates a new Grist document in a specified workspace. Use this tool when you need to add

grist.create_scim_user Tool to create a new SCIM user. Use when provisioning new user accounts via SCIM. Run afte · verified

done

Done. Grist responded across 3 calls, the verifier signed off, and the result is logged with every payload.

Pairs well with Grist

Connect Grist to your stack with Workflow

AI-native automation between Grist and 64+ other tools — built, run, and self-healed by Workflow.

All integrations →

Grist + ActiveCampaign

FAQ · Grist

Questions, answered.

What teams ask before connecting Grist.

01 What can I automate with Grist on Definable?

Anything Grist exposes through its API. Common productivity workflows on Definable include capture notes by voice or chat, roll up daily activity, retrieve anything by description. Personas can call any of the 30 Grist tools directly, then chain the result into another integration without you writing code.

02 How does Grist authentication work?

Grist uses API_KEY on Definable. You connect once from the integrations page, scoped to the permissions you choose, and from then on any persona that has the integration enabled can act on your behalf. Tokens are encrypted at rest and rotated automatically.

03 Is the Grist integration included in my Definable plan?

Yes — every Definable plan, including Starter, includes access to all 30 Grist tools. You only need a separate Grist subscription if Grist itself charges per seat or per API call.

04 Is using Grist through Definable secure?

Every call from a persona to Grist is logged with the user, persona, prompt, and response. Tokens never leave Definable's secrets vault, scopes are configurable per persona, and you can revoke access at any time from the integration page.

05 How do I get started with Grist on Definable?

Sign up for Definable, open the integrations page, find Grist, and connect via OAuth or API key. You can immediately attach Grist to any persona and start running workflows. The free Starter plan includes 5,000 credits/month.

06 What Grist actions does Definable expose?

Definable exposes all 30 Grist actions as callable tools — including `Add Records`, `Create Document`, `Create SCIM User`, plus 27 more. Each tool gets a typed parameter schema so personas know exactly how to call it.