Databases

Grist integrations

Connect Grist to any other app, or use it from your AI client over MCP. Grist combines the flexibility of a spreadsheet with the robustness of a database to organize your data, your way.

Connects with an API keygetgrist.com

What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.

Build solutions, not workarounds.

What do you want to automate with Grist?

Ask the assistant

You'll sign in before anything runs. What you typed comes with you.

Connect your AI client

Give your AI client this address.

https://mcp.apiant.ai

Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.

Set it up in your client
Claude Code

Run this in the directory you want to work in.

claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai

Start Claude Code there, approve the server, and sign in in the browser page it opens.

Claude Code guide (opens in a new tab)
Claude, web and desktop

Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.

Setup guide (opens in a new tab)
Cursor

Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.

Setup guide (opens in a new tab)
Zed

Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.

Setup guide (opens in a new tab)
Codex and the ChatGPT desktop app

Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.

Setup guide (opens in a new tab)
Any other MCP client

Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.

Setup guide (opens in a new tab)

Pair it

Connect Grist with another app

What your agent can do with Grist

Triggers and actions 4 triggers · 21 actions

  • Trigger
    New or Updated Record

    Triggered when a row in a Grist table is created or updated.

  • Trigger
    New or Updated Record (Instant)

    Triggers when a Record is updated, or a new Record is added.

  • Trigger
    New Record

    Triggered when a new row is added to a Grist table.

  • Trigger
    New Record (Instant)

    Triggers when a new Record is created

  • Action
    Add Column

    Adds a column to a table in a Grist document.

  • Action
    Add Table

    Creates a new table in a Grist document, optionally with a starting set of columns.

  • Action
    Create Document

    Creates a new document in a Grist workspace and returns its document ID.

  • Action
    Create or Update Record

    Adds a row to a Grist table, or updates the existing row when the match column already holds the match value. Returns the row ID.

  • Action
    Create Record

    Adds a new row to a Grist table and returns its row ID.

  • Action
    Create Workspace

    Creates a new workspace in a Grist organization and returns its ID.

  • Action
    Delete Document

    Deletes a Grist document permanently.

  • Action
    Delete Records

    Deletes one or more rows from a Grist table by row ID.

  • Action
    Delete Workspace

    Deletes a Grist workspace along with every document inside it.

  • Action
    Find Record

    Searches a Grist table for a row whose column holds a given value and returns that row's ID and column values.

  • Action
    Get Document

    Returns the details of one Grist document — its name, web address, workspace, and organization.

  • Action
    Get Org

    Returns the details of one Grist organization (team site) — its name, subdomain, owner, and your access level.

  • Action
    Get Workspace

    Returns the details of one Grist workspace, including the documents it contains.

  • Action
    List Columns

    Returns the columns of a Grist table, with each column's ID, label, and type.

  • Action
    List Orgs

    Returns every Grist organization (team site) this connection can reach.

  • Action
    List Tables

    Returns the tables in a Grist document.

  • Action
    List Workspaces

    Returns the workspaces in a Grist organization, each with the documents it contains.

  • Action
    Run SQL Query

    Runs a read-only SELECT statement against a Grist document and returns the rows.

  • Action
    Update Document

    Renames a Grist document or changes whether it is pinned. Anything left blank stays as it is.

  • Action
    Update Record

    Changes the column values of one row in a Grist table. Columns left blank keep their current values.

  • Action
    Update Workspace

    Renames a Grist workspace.

Related apps

More in Databases

Reviews

What our customers say

Questions

Grist, answered

Is there a Grist MCP server?

APIANT's MCP server at https://mcp.apiant.ai works with Grist. Add that address to any AI client that takes a remote MCP server, sign in once in your browser, and your client can build, test and run automations that use Grist. Nothing to install.

What can start an automation from Grist?

Any of Grist's 4 triggers in the catalog, including New or Updated Record, New or Updated Record (Instant), New Record and New Record (Instant). Describe the moment in plain language and your agent picks the right one.

What can your agent do in Grist?

Any of Grist's 21 actions, including Create Document, Create or Update Record, Create Record and Create Workspace. Your agent maps the data both ways and tests every scenario before it ships.

Which apps can Grist connect to?

Any app in the catalog; the list on this page pairs Grist with each of them. If the other app is missing, point your agent at its API documentation and it builds the connector.

What happens when something fails?

Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.

Is there a free plan?

Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.