nodes / builtin / integration
Baserow / NocoDB
Create, read, update, and delete rows in a Baserow or NocoDB table — hosted or self-hosted, including localhost.
Read and write rows in a Baserow or NocoDB table, on their cloud or on your own server.
What it does
Section titled “What it does”Baserow and NocoDB are open-source alternatives to Airtable that you can host yourself, even on your own computer. Pick the Provider, then one Operation on a table:
- Create row, Update row: write the Fields you list.
- Get row, Delete row: act on one row by its Row ID.
- List rows: read rows from the table, up to Limit if set.
You name fields by their column name as it appears in your table, for both providers. Update row only changes the fields you list.
When to use it
Section titled “When to use it”- Keep your data on your own machine: pair a local Baserow or NocoDB with local AI nodes.
- Log scraped prices, bookmarks or leads into a table you own.
- Read a table to drive a workflow, for example one row per URL to check.
- Use Airtable or Google Sheets instead if your data lives there.
Inputs and settings
Section titled “Inputs and settings”| Setting | Type | What it does |
|---|---|---|
| Credential (required) | Credential | A Baserow database token or a NocoDB API token, stored as a Bearer Token credential. Keep it secret — it grants access to your tables. |
5 choices · pick provider and operation to see its settings
Settings for Create row
| Setting | Type | What it does |
|---|---|---|
| Base URL (required) | Text | Your instance URL — e.g. https://api.baserow.io, https://app.nocodb.com, or a self-hosted address like http://localhost:8080. |
| Table ID (required) | Text | The numeric table ID (Baserow) or table ID (NocoDB, e.g. m8f…) to work with. |
| Fields (required) | Key-value pairs | Field name → value pairs (use the column names from your table). |
Settings for Get row
| Setting | Type | What it does |
|---|---|---|
| Base URL (required) | Text | Your instance URL — e.g. https://api.baserow.io, https://app.nocodb.com, or a self-hosted address like http://localhost:8080. |
| Table ID (required) | Text | The numeric table ID (Baserow) or table ID (NocoDB, e.g. m8f…) to work with. |
| Row ID (required) | Number | The ID of the row/record. |
Settings for Update row
| Setting | Type | What it does |
|---|---|---|
| Base URL (required) | Text | Your instance URL — e.g. https://api.baserow.io, https://app.nocodb.com, or a self-hosted address like http://localhost:8080. |
| Table ID (required) | Text | The numeric table ID (Baserow) or table ID (NocoDB, e.g. m8f…) to work with. |
| Row ID (required) | Number | The ID of the row/record. |
| Fields (required) | Key-value pairs | Field name → value pairs (use the column names from your table). |
Settings for List rows
| Setting | Type | What it does |
|---|---|---|
| Base URL (required) | Text | Your instance URL — e.g. https://api.baserow.io, https://app.nocodb.com, or a self-hosted address like http://localhost:8080. |
| Table ID (required) | Text | The numeric table ID (Baserow) or table ID (NocoDB, e.g. m8f…) to work with. |
| Limit | Number | Maximum number of rows to return. |
Settings for Delete row
| Setting | Type | What it does |
|---|---|---|
| Base URL (required) | Text | Your instance URL — e.g. https://api.baserow.io, https://app.nocodb.com, or a self-hosted address like http://localhost:8080. |
| Table ID (required) | Text | The numeric table ID (Baserow) or table ID (NocoDB, e.g. m8f…) to work with. |
| Row ID (required) | Number | The ID of the row/record. |
Showing settings for Create row
- Base URL is the address of your instance only, without a path:
https://api.baserow.iofor Baserow cloud,https://app.nocodb.comfor NocoDB cloud, or for examplehttp://localhost:8080for a self-hosted one. - Table ID: in Baserow it is a number (for example
482), listed in the database’s API documentation; in NocoDB it is a text id that starts withm, shown in the table’s details. - Fields: one pair per column, for example
Name={{ $input.title }}andURL={{ $input.url }}.
Outputs
Section titled “Outputs”-
Output
- Create row, Get row and Update row return the row as the provider sends it, with its id (
idin Baserow,Idin NocoDB) and its columns. - List rows returns the provider’s page of results: Baserow puts the rows in
results, NocoDB inlist. Use Split Out on that field to get one item per row.
Dependencies and credentials
Section titled “Dependencies and credentials”- Credential (connection, Bearer Token): required. See Connect Baserow / NocoDB.
- Baserow: create a database token in Baserow under Settings → Database tokens, with access to the workspace that holds the table.
- NocoDB: create an API token in NocoDB under Account settings → Tokens.
Save the token as a Bearer Token credential: see Create a credential. The node sends it the way each provider expects.
Example workflow
Section titled “Example workflow”- A Context Menu trigger runs when you right-click a page.
- Get Page Metadata reads its
titleandurl. - Baserow / NocoDB, Provider
Baserow, Create row, Base URLhttp://localhost:8080, Table ID482, FieldsTitle={{ $input.title }},Link={{ $input.url }}. - Browser Notification confirms the row was saved.
Common issues
Section titled “Common issues”- “Baserow API Error: 401 Unauthorized” or “NocoDB API Error: 401”. The token is wrong, or has no access to this table. Create a new token that covers the table and update the credential.
- “… API Error: 404 Not Found”. Check Base URL (no path after the address, right port) and Table ID.
- A value is not written. The field name must match the column name exactly, including capitals and spaces.
- The run is blocked in the web app. This node runs in the browser extension, which can reach self-hosted addresses like
localhost. Install the extension, or run the workflow from it.
Related nodes
Section titled “Related nodes”- Airtable: the hosted service these tools replace.
- Supabase: rows in a Postgres database.
- Data Store: keep small values inside AWFlow, no account needed.