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.
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.
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.
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.
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 webhooksOnce 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.
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
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.
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.
The teams that lean on Grist most, a question each of them asks, and what they connect beside it.
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.
Using something else for the same job, or both? Each connector has its own tools; connect as many as you like.
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
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
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
Ask what the customers table says about Northwind
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.
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.
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.
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.
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.
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.
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.
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