Grist
Read and write the records of a Grist document's tables, and list its tables and columns, through the Grist REST API.
OCNORA ships 7 typed Grist operations. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run. Endpoints not covered by a typed node are called at https://docs.getgrist.com/api through the HTTP node with the same credential.
Before you connect Grist
- Authentication
- API key
- Credential
- the API key, or {"api_key": "…"}
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
What you can do with Grist
Operations, grouped by what they do to your data.
Create and send 2
Read and search 3
Update 1
Delete and cancel 1
A sample Grist workflow
- 1A core triggerStart the run from a chat, form, manual, schedule, webhook, workflow trigger — no Grist trigger is needed.
- 2List Columnsgrist.list_columnsList the columns of a table, with each column's type and label.
- 3Add Recordsgrist.add_recordsAdd one or more rows to a table and return the ids Grist assigned.
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
Operations 7
- Add RecordsAdd one or more rows to a table and return the ids Grist assigned.grist.add_records
- Delete RecordsRemove rows from a table by their Grist row ids.grist.delete_records
- List ColumnsList the columns of a table, with each column's type and label.grist.list_columns
- List RecordsRead the rows of a table, optionally filtered, sorted and limited.grist.list_records
- List TablesList the tables in a Grist document, optionally with their columns.grist.list_tables
- Update RecordsChange the cell values of existing rows, each addressed by its row id.grist.update_records
- Add or Update RecordsAdd rows or update the ones already matching, using a 'require' matcher per record instead of a row id.grist.upsert_records
Grist questions
- How does OCNORA authenticate with Grist?
- With a stored API key credential, shaped the API key, or {"api_key": "…"}. A connection test can check it when you add it.
- What can I automate with Grist?
- 7 typed operations, each with a reference page listing its config fields and the shapes it emits.
- What if the Grist operation I need is not listed?
- Call https://docs.getgrist.com/api from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use Grist?
- Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
- How are Grist calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
More in Databases & warehouses
See your first Grist workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.