DocumentationWorkflowsApps and services
Notion Databases node
Query Notion databases, read the schema, create or update entries. Learn how to configure it, map inputs and outputs, run a test and resolve common errors.
8 min readUpdated
What this node does
Query Notion databases, read the schema, create or update entries.
Use Notion Databases as a clearly defined step in an anymize workflow.
- Processes one input.
- Provides one output for following steps.
- Runs as a regular step in the flow.
Set up the node
- 01Open a workflow and add Notion Databases from the node catalog.
- 02If your Notion account is not connected yet, connect it right in the node panel or under Connectors.
- 03Complete the required fields and map values from previous steps.
- 04Run the node with a small test record and inspect its output.
- 05Connect the successful output and activate the workflow after an end-to-end test.
Operations and modes
Choose the required function in Action. The panel then shows the relevant settings.
- Query database
- Read schema
- Create entry
- Update entry
Settings
| Field | Meaning | Area |
|---|---|---|
| Action | Choices: Query database, Read schema, Create entry, Update entry | Standard |
| Database | Link or ID of the database. The ID is in the database's Notion URL. | Standard |
| Data source | Only needed if the database has several data sources. Otherwise leave it empty. | Standard |
| Entry | Link or ID of the entry. Open the entry as a page, the ID is at the end of the URL. | Standard |
| Filter | Fetches only matching entries. One condition per line made of column, comparison and value, every line must match. Examples: "Status is Open" or "Due date before 31.12.2026". Comparisons: is, is not, contains, does not contain, is empty, is not empty, greater than, less than, on or after, on or before, before, after. If a value itself starts with a comparison word, put it in quotes: Status is "Not started". If the text starts with {, it is read as a Notion filter in JSON format. | Standard |
| Count (max. 100) | Configure this value in the node panel. | Standard |
| Fetch all entries | Fetches more result pages, up to 1000 entries. | Standard |
| Next page marker | Picks up where the last fetch left off. Use the next page marker from the previous step. | Standard |
| Fields | Column and value, e.g. Status and Open. The names must match your database's columns. Dates as 31.12.2026, separate multiple values with commas. | Standard |
| Content | Optional text in the new entry. Markdown is supported. | Standard |
| Run once per item | Off (default): the node runs once for the whole input. On: if it receives several items (e.g. from Split Out), it runs once PER item, and {{ $json }} is that one item each time. This is how you work through a file list entry by entry. | Standard |
| If one item fails | "Skip" writes an `error` field for the failed item and keeps processing the rest, instead of losing the whole run to a single unreadable file. | Standard |
| Pause between items (milliseconds) | Wait before every run except the first. 1000 = 1 second per item. Useful when the other side would otherwise throttle you. Maximum 300000 (5 minutes). | Standard |
Inputs and outputs
| Input | Meaning | Type |
|---|---|---|
| Standard | Receives the complete result from the previous step. | JSON |
| Output | Meaning | Type |
|---|---|---|
| Standard | Makes the result available to the next step as JSON. | JSON |
This node can process lists item by item. Error handling and the delay between items are available in advanced settings.
Example and test run
Add a new entry to a database: begin with a small, recognizable record. Inspect the output and only map fields that are present there.
Test-run example
{}Access and security
The node works with your own connected Notion account. It only sees and changes what this account is allowed to. Check the permissions shown when you connect. The matching area (Pages, Databases) must also be switched on in the settings of your Notion connection under Connectors. All areas are on by default.
"Allowed actions" in the settings of your Notion connection under Connectors also applies to this node and is checked on every run. With "Read only" or "Read and draft", only the read actions run: Query database, Read schema. These actions need "Allow changes": Create entry, Update entry.
Keys and credentials belong in Workflow Secrets or your connected accounts. Never paste them as plain text into workflow fields, test data or descriptions.
Troubleshooting
- No output: inspect the latest run and confirm that the previous node returned the expected fields.
- Empty variable: open the previous step output and use a field name from the real test data.
- Connection rejected: reconnect the service and grant the permissions required by this step.
- Action blocked: set "Allowed actions" of the connection under Connectors to "Allow changes", or pick a read action.
- List processed once: enable per-item execution in advanced settings.