Grist logo

Grist + Memtro

Ask what a Grist table says about a customer, or count rows with SQL.

Connect Grist with an API key and Memtro reads your sites, workspaces and documents, each table's columns and types, and rows filtered by value, with SQL queries that cannot change data for counts, ranges and joins. Leave the host blank for Grist Cloud or name your own server. The key carries all of its account's access, and there is no hourly sync. When you ask, and once an administrator has granted them by name, it can add, change and delete rows, add tables and columns, delete a column with its data, and create, copy, rename, move or trash documents.

In Memtro

What you can do with Grist in Memtro

Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Grist tool, reads what it needs, and answers with the source cited.

What it does

  1. 01Sites, workspaces and documents the key can reach, with document ids and names
  2. 02A document's tables and their columns, with type and whether each is a formula
  3. 03Rows of a table filtered by exact values and sorted, up to 200 at a time
  4. 04SQL SELECT queries for ranges, counts, joins and paging, at most 200 rows back
  5. 05When asked and granted, adds, changes, upserts or deletes rows, which may fire webhooks, adds tables and columns, renames tables, or deletes a column with every value in it
  6. 06When asked and granted, creates workspaces and documents, copies, renames or moves a document, which can change who may open it, and moves it to the trash or back

Acts when asked

When you ask it to

These tools change something in Grist. The model is told to use them only when you ask for exactly that, and an administrator grants each one by name to the teams that may use it; a personal connection acts only after its owner allows it.

  1. 01Add rows to a table
  2. 02Change values in existing rows
  3. 03Delete rows from a table
  4. 04Add or update rows matched on chosen columns (upsert)
  5. 05Add a table, add columns, rename a table, or delete a column with its data
  6. 06Create a document in a workspace, copy one, rename it, or move it to another workspace
  7. 07Move a document to the trash or restore it from there
  8. 08Create a workspace

Events

When it happens

Turn events on in the connection's Events tab on the Connections page, then add the address it shows as a webhook in Grist, choosing the same kinds; the tab shows Grist's own steps. Each event can start a job, with the event as its input. Grist sends a secret with every delivery, and one without it is refused.

Events and webhooks
  • 01A row was added or changed in the webhook's table (Grist does not say which)
In practice

Ask it like you would a colleague

Once Grist is connected, these are the kinds of things people ask. Plain questions, no syntax. If the answer lives partly in another system you have connected, Memtro looks there too.

Grist logoGrist + Memtro
  • What does our customers table say about Northwind?

  • How many open orders are in the Sales document this month?

  • Which suppliers in Grist have no contract end date?

  • Add a row to the Leads table for Brightwave Ltd

  • Copy the Q4 Pipeline document as a template for Q1

01

Counting the pipeline

The founder asks how many deals closed in October and their total. Memtro runs one SQL SELECT query on the Pipeline document and answers with 14 deals worth £86,400, Acme the largest.

02

Updating after a call

After a renewal call Sarah Collins asks Memtro to set BigCo's renewal date to 31 January and add a row for Globex as a new lead. With the actions granted, Memtro changes that one cell in the Customers table and adds the Globex row, and the document's webhooks fire as they would for any edit.

Teams

Where it fits

The teams that lean on Grist most, a question each of them asks, and what they connect beside it.

Better together

Works with

A record in Grist is rarely the whole story. Connect the systems that hold the rest and Memtro checks them together, then remembers what it learned so the next question starts further along.

Setup

How to connect

Connect withAPI key
  1. 1

    In Grist open your profile picture → Account settings → Developer → API Key, click Create and copy it. The key carries all of its account's access with no scopes, so consider a dedicated user shared into only the right documents

  2. 2

    Leave Host blank for your personal Grist Cloud site, type <team>.getgrist.com for a team site, or your self-hosted server's host name with a publicly trusted certificate, no https:// or path

  3. 3

    Grist Cloud's free plan allows 3,000 API calls a month across the site, and self-hosted Grist has no such limit. Paste the API key into Connections → Grist in Memtro

  4. 4

    Ask what the customers table says about Northwind

Also works from

Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Grist tools are the same everywhere.

FAQ

Questions

Can Memtro change anything in Grist?+

Only when you ask, and only what it has been granted: add rows to a table; change values in existing rows; delete rows from a table; add or update rows matched on chosen columns (upsert); add a table, add columns, rename a table, or delete a column with its data; create a document in a workspace, copy one, rename it, or move it to another workspace; move a document to the trash or restore it from there; create a workspace. Every other tool reads, searches or lists. The Connections page labels the tools that act, an administrator grants each one by name to the teams that may use it, and a personal connection acts only after its owner allows it.

Who can use a Grist connection?+

A personal connection serves only your own requests. A shared connection serves the organisation: everyone, or only the teams an admin chooses. Admins can always add shared connections; other members need the permission.

Does Memtro store my Grist data?+

Credentials are encrypted at rest. Tool results are cached briefly so agent loops do not repeat identical calls, and the facts the model extracts are saved to your organisation's memory with provenance (system, record and link) so they can be checked and superseded.

How do I connect Grist?+

API key. In Grist open your profile picture → Account settings → Developer → API Key, click Create and copy it. The key carries all of its account's access with no scopes, so consider a dedicated user shared into only the right documents.

Can Grist start a job?+

Yes. Turn events on in the connection's Events tab on the Connections page, then add the address it shows as a webhook in Grist, choosing the same kinds; the tab shows Grist's own steps. A job set to start "When an event arrives" then runs once for each matching event, with the event as its input. The run treats the event as outside data, never as instructions, and anything the run remembers is kept as unverified.

Connect Grist in a few minutes

Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.

Where agents remember your company

Sign in, add a provider key, create an API key and point your tools at Memtro. It takes about five minutes.

7-day free trial · card on file, nothing charged until it ends · cancel any time