> For the complete documentation index, see [llms.txt](https://docs.n8n.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.grist.md).

# Grist

Use the Grist node to automate work in Grist, and integrate Grist with other applications. n8n has built-in support for a wide range of Grist features, including creating, updating, deleting, and reading rows in a table.

On this page, you'll find a list of operations the Grist node supports and links to more resources.

{% hint style="info" %}
**Credentials**

Refer to [Grist credentials](/integrations/builtin/credentials/grist.md) for guidance on setting up authentication.
{% endhint %}

## Operations <a href="#operations" id="operations"></a>

* Create rows in a table
* Delete rows from a table
* Read rows from a table
* Update rows in a table

## Templates and examples <a href="#templates-and-examples" id="templates-and-examples"></a>

[Browse Grist node documentation integration templates](https://n8n.io/integrations/grist) or [search all templates](https://n8n.io/workflows/)

## Get the Row ID <a href="#get-the-row-id" id="get-the-row-id"></a>

To update or delete a particular record, you need the Row ID. There are two ways to get the Row ID:

**Create a Row ID column in Grist**

Create a new column in your Grist table with the formula `$id`.

**Use the Get All operation**

The **Get All** operation returns the Row ID of each record along with the fields.

You can get it with the expression `{{$("GristNodeName").item.json.id}}`.

## Filter records when using the Get All operation <a href="#filter-records-when-using-the-get-all-operation" id="filter-records-when-using-the-get-all-operation"></a>

* Select **Add Option** and select **Filter** from the dropdown list.
* You can add filters for any number of columns. The result will only include records which match all the columns.
* For each column, you can enter any number of values separated by commas. The result will include records which match any of the values for that column.