n8n Airtable to Notion Sync: The Full Tutorial (+ Free Template)

Quick answer: Add an Airtable trigger node in n8n that polls your base for new records, then connect a Notion node that creates a page in your target database and maps each Airtable field to a Notion property. Setup takes about 15 minutes, and the workflow JSON below imports directly.

This tutorial covers the full setup, the property mapping step where most people get stuck, and how to extend the sync to handle updates.

What You Need Before Starting

Create the Notion integration at notion.so/my-integrations, then share the target database with it. This step is mandatory: an integration that has not been added to the database sees nothing, and it is the number one setup mistake.

Step 1: Add the Airtable Trigger

Create a new workflow and add the Airtable Trigger node. Authenticate with your personal access token, then select the base and table to watch.

Set the trigger to fire on new records and choose the polling interval. Every minute is right for active tables.

Step 2: Add the Notion Node and Map Properties

Add a Notion node, set the resource to Database Page and the operation to Create. Select your target database.

Now map the fields. For each Notion property, switch the value to expression mode and reference the Airtable field by its exact column name:

Name property: {{ $json.fields.Name }}
Email property: {{ $json.fields.Email }}
Status property: {{ $json.fields.Status }}

Two rules save an hour of debugging. Airtable nests everything under fields, so the path is always $json.fields.YourColumn. And Notion select properties reject values that do not already exist as options, so create the options in Notion first.

Step 3: Test and Activate

Click Execute Workflow, add a record in Airtable, and watch it appear as a page in your Notion database. When the mapping looks right, activate the workflow. The sync now runs unattended.

The Free Workflow Template

Import this JSON into a blank n8n canvas, then reconnect your own credentials and reselect your base, table, and database:

{
  "name": "Airtable to Notion Sync",
  "nodes": [
    {
      "parameters": {
        "pollTimes": { "item": [{ "mode": "everyMinute" }] },
        "baseId": { "__rl": true, "mode": "list", "value": "REPLACE_WITH_BASE_ID" },
        "tableId": { "__rl": true, "mode": "list", "value": "REPLACE_WITH_TABLE_ID" },
        "triggerField": "Created"
      },
      "id": "airtable-trigger-1",
      "name": "Airtable Trigger",
      "type": "n8n-nodes-base.airtableTrigger",
      "typeVersion": 1,
      "position": [260, 300]
    },
    {
      "parameters": {
        "resource": "databasePage",
        "operation": "create",
        "databaseId": { "__rl": true, "mode": "list", "value": "REPLACE_WITH_DATABASE_ID" },
        "title": "={{ $json.fields.Name }}",
        "propertiesUi": {
          "propertyValues": [
            { "key": "Email|email", "emailValue": "={{ $json.fields.Email }}" },
            { "key": "Status|select", "selectValue": "={{ $json.fields.Status }}" }
          ]
        }
      },
      "id": "notion-1",
      "name": "Notion",
      "type": "n8n-nodes-base.notion",
      "typeVersion": 2.2,
      "position": [520, 300]
    }
  ],
  "connections": {
    "Airtable Trigger": {
      "main": [[{ "node": "Notion", "type": "main", "index": 0 }]]
    }
  },
  "active": false,
  "settings": { "executionOrder": "v1" }
}

How Do You Handle Updates to Existing Records?

Add a Last Modified Time field in Airtable and switch the trigger to watch it. Then, before the Notion create step, add a Notion search that looks up the page by a unique property such as the Airtable record ID. An IF node routes the result: page found goes to an update operation, page missing goes to create.

Store the Airtable record ID in a dedicated Notion property from day one. It is the reliable join key that makes updates, deduplication, and debugging possible.

What Should You Build Next?

The same trigger-map-create pattern drives most database mirroring: CRM to reporting base, form tool to project tracker, support tool to knowledge base. If this is your first n8n workflow, our Google Sheets to Slack tutorial is the simplest next rep, and the workflow audit helps you pick which process deserves automation next. Watching costs as your workflows multiply? See the EU pricing breakdown.