Skip to content
ClickRuntime

Connect Airtable to Notion

Some teams track operations in Airtable and write plans and client pages in Notion. Connect them to create Notion pages from new Airtable records, log incoming data to both, and check that the two agree.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Airtable and Notion

Records and pages kept in step between an Airtable base and your Notion workspace. These are ready-made starting points. Anything else you can describe works too.
The moment it happens

Log calls or sales to both Airtable and Notion

Each time your call tool or store sends a record, it is added as a row in Airtable and a page in Notion with the same details.

See how it works
Every 15 minutes

Create a Notion onboarding page when an Airtable lead is won

When a lead is marked Won in your Airtable Clients table, an onboarding page with your checklist is created in Notion and linked back to the record.

See how it works
On a schedule

Compare stock counts in Notion with Airtable every day

Each morning you get an email listing items where Notion and Airtable disagree and items that need reordering.

See how it works
The moment it happensAI

Classify developer questions into Notion and Airtable

Each question or error report sent to your trigger link is classified, written up as a Notion page, tracked as an Airtable record, and flagged in Slack when severe.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Airtable and Notion, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Airtable and Notion automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Airtable and Notion in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Copy Airtable records to Notion only when the Priority field is High, and update the Notion page whenever the Airtable Status changes.

Every night, find records that exist in Airtable but have no Notion page, or the other way round, and add them to a Sync issues page in Notion.

Use cases

Why people connect Airtable and Notion

How the two apps work together

  • ClickRuntime checks an Airtable table every few minutes for new or modified records and creates or updates Notion pages.
  • Notion changes can be checked on a schedule and written back to Airtable fields.
  • Each record stores the other side's ID, so later runs update the same page instead of creating a new one.

  • Ops data in Airtable, docs in Notion

    Operations teams keep inventory or vendor records in Airtable and write process docs in Notion. A Notion page per vendor with key fields copied over keeps both views consistent.

  • Move a base into Notion over time

    Teams switching tools can copy records from an Airtable table into a Notion database. New records keep flowing until the move is done.

  • Content production tracker

    Editorial teams plan in Airtable and draft in Notion. When a record reaches Assigned, a Notion draft page is created with the brief and its link stored back in Airtable.

  • Status sync for client work

    Agencies track deliverables in Airtable for reporting while clients see Notion pages. Status changes in Airtable can be copied to the matching Notion page.

More apps

Airtable, Notion and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Assigned Airtable records become Notion drafts

When an Airtable content record moves to Assigned, create a Notion draft page from the brief and Slack the writer the link.

Weekly status counts from both tools

Every Friday, count records by status in our Airtable deliverables table and in our Notion projects database and write the totals to a Google Sheet.

Email clients when work is approved

When a Notion page is marked Approved, update the matching Airtable record and send the client a Gmail note with the page link.

Setup

Connect Airtable and Notion once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Airtable

Database / No-code

  1. In Airtable, go to airtable.com/create/tokens and create a new token with a name you'll recognise.
  2. Add the scopes the automation needs, such as data.records:read, data.records:write and schema.bases:read.
  3. Add the bases or workspaces the token may use.
  4. Copy the token. Airtable only shows it once.
  5. In the ClickRuntime dashboard, open Connections & secrets and save the token as a secret for Airtable.

Notion

Productivity / Docs

  1. In Notion, open the developer portal at notion.so/profile/integrations and create a new internal integration.
  2. On its Configuration tab, copy the integration secret.
  3. On each page or database the automation should use, open ••• → Add connections and pick your integration.
  4. In the ClickRuntime dashboard, open Connections & secrets and save the secret as a secret for Notion.

FAQ

Questions about connecting Airtable and Notion

How does it connect to Airtable?
With a personal access token from Airtable, saved in your ClickRuntime dashboard. Give the token access only to the bases it needs.
Which Notion databases can it use?
Only the ones shared with your Notion connection, from the database's ••• menu under Connections.
How are records matched between the two?
By a shared field such as an ID, SKU or email, stored in both. Matching on a name alone can break when someone renames a record.
Will records be created twice?
No. Records already handled are remembered, so each new Airtable record gets one Notion page.
Is the sync two-way?
It can be. You describe which fields move each way, and the script handles both directions on its schedule.
Are Airtable attachments copied?
The script can add attachment links to Notion or upload the files to a Notion files property, depending on what you ask.
What happens if both sides change the same field?
You decide the rule, for example Airtable wins or the most recent change wins, and the script applies it.

Related pages

Keep exploring

Tell your assistant what Airtable and Notion should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude