Automate Notion with n8n: Read, Write, and Query Without Code

If you rely on Notion for project tracking, content management, or customer records, repetitive tasks like copying data or updating databases can slow you down. The n8n Notion node eliminates manual work by letting you read, create, update, and search Notion databases directly from n8n—without writing code or paying for Zapier.

This guide covers the entire process, from setting up Notion integrations to configuring the n8n Notion node for common automation tasks. A complimentary workflow JSON is provided at the end to help you get started immediately.

Setting Up the Notion Integration in n8n

Before automating anything, you need to link your Notion workspace to n8n. This involves creating an integration in Notion and sharing your database with it.

Creating a Notion Integration

1. Visit Notion’s integration page at notion.so/my-integrations.
2. Click + New integration and assign it a name like "n8n Automation".
3. Select the workspace where your database resides.
4. Enable the capabilities Read content, Update content, and Insert content.
5. Click Submit and copy the Internal Integration Token, which starts with ntn_ or secret_.

⚠️ Important: This token only accesses pages you explicitly share. Skipping the next step will result in 404 errors, even with a valid token.

Sharing Your Database with the Integration

1. Open the Notion database you want to automate.
2. Click the ... menu in the top-right corner and select Add connections.
3. Search for your integration by name and select it.
4. Confirm the selection.

Without this step, the integration cannot interact with your database, no matter how valid the token is.

Adding the Credential in n8n

1. In n8n, go to Credentials → New and search for Notion API.
2. Paste your Internal Integration Token.
3. Save the credential and run a test. A successful connection will display "Connection tested successfully".

Mastering the n8n Notion Node: Core Operations

The Notion node in n8n supports two resource types: Database Page and Block. For most workflows, Database Page is the primary focus.

Database Page Operations

• Create: Add new rows to a database.
• Get: Retrieve a single database entry using its ID.
• Get Many: Query multiple pages with filters, sorting, and pagination.
• Update: Modify existing page properties.

Querying and Filtering Notion Databases

The Get Many operation is ideal for reading data. It functions like Notion’s built-in filter views, allowing you to narrow down results based on specific criteria.

Finding Your Database ID

The database ID is a 32-character string found in your database URL. Example URL structure:

notion.so/myworkspace/abc123def456789012345678901234ab?v=xyz

The segment abc123def456789012345678901234ab is your unique Database ID. n8n also accepts IDs with dashes, such as abc123de-f456-7890-1234-5678901234ab.

Applying Filters

Filters help refine your queries. Here are common filter types by property:

• Text / Title: Use rich_text with `{