# Grist AI integration on Definable

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

## What this connects

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.

Vendor: https://www.getgrist.com/

## Tools available

**30** tools available. First 12:

- `GRIST_ADD_RECORDS` — 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.
- `GRIST_CREATE_DOCUMENT` — 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.
- `GRIST_CREATE_SCIM_USER` — 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.
- `GRIST_CREATE_TABLE` — 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.
- `GRIST_CREATE_WEBHOOK` — 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.
- `GRIST_DELETE_ATTACHMENT` — 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).
- `GRIST_DELETE_COLUMN` — Delete Column — Tool to delete a column from a Grist document table. Use after confirming document, table, and column IDs.
- `GRIST_DELETE_RECORDS` — 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.
- `GRIST_DELETE_SCIM_USER` — 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.
- `GRIST_DELETE_WEBHOOK` — 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.
- `GRIST_DOWNLOAD_ALL_ATTACHMENTS_ARCHIVE` — 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.
- `GRIST_DOWNLOAD_ATTACHMENT` — 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.

## Auth

Auth schemes: `API_KEY`.

## How agents use Grist

Inside a Definable workflow, Grist is one of the tools the **Distributor specialist** can call. Example coordination patterns:

- **Researcher → Grist** — the Researcher (GPT-5.5) pulls context from Grist (records, threads, documents), synthesises findings, and briefs the rest of the team.
- **Writer → Distributor → Grist** — the Writer (Claude Opus 4.7) drafts copy in brand voice, the Verifier passes it, then the Distributor writes the result into Grist (create record, post message, draft email).
- **Designer / Engineer → Distributor → Grist** — the Designer ships an asset or the Engineer ships a code change, the Distributor delivers it via Grist (attach file, open PR comment, post status).

The Verifier checks every Grist call. On rate limit, schema drift, or auth refresh it self-heals and retries — the workflow completes without manual intervention.

## Categories

- productivity — https://definable.ai/apps/category/productivity/
- spreadsheets — https://definable.ai/apps/category/spreadsheets/
- databases — https://definable.ai/apps/category/databases/

## Related

- HTML page: https://definable.ai/apps/grist/
- Same category (productivity): https://definable.ai/apps/category/productivity/
- All integrations: https://definable.ai/apps/
- Workflow (multi-agent loop): https://definable.ai/workflow/
- Apps llms.txt index: https://definable.ai/llms-apps.txt
