Grist Integration — Automate Grist with AI on Beauto

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.

Category: productivity, spreadsheets, databases · 30 actions available

What you can automate with Grist

Beauto connects Grist with 900+ other apps so you can build AI-powered workflows in minutes. Trigger automations from Grist events, enrich Grist data with AI, or sync Grist with the rest of your stack — without writing code.

  • Sync Grist data with Gmail, Slack, Notion, HubSpot, Google Sheets, and more
  • Trigger AI agents on new Grist events and route the output anywhere
  • Schedule recurring Grist tasks — daily reports, cleanups, or bulk updates
  • Use natural language to describe the workflow; Beauto builds it for you

Grist actions Beauto supports

  • 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 nam
  • 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 attach
  • 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
  • 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). Retur
  • 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
  • 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 b
  • 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. R
  • 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 'untieColIdFr
  • 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 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
  • 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.

Related integrations

Browse all 900+ integrations →

Get started with Grist on Beauto

Sign up free, connect your Grist account in one click, and describe the workflow you want in plain English. Beauto's AI handles the rest — no API keys or code required.

Try Beauto free · Browse all 900+ integrations · How it works