Featured image with Logos for Airtable and Notion, representing Unito's guide to syncing Airtable and Notion work items with a 2-way integration.
How to Sync Notion Tables With Airtable Bases Using Unito
Featured image with Logos for Airtable and Notion, representing Unito's guide to syncing Airtable and Notion work items with a 2-way integration.

How to Sync Notion Tables With Airtable Bases Using Unito

Published in Use cases on , last updated .

In this guide, you’ll learn how to sync records from Airtable with pages in Notion using Unito’s two-way no-code integration. By connecting these tools, you’ll be able to ensure all your databases are up-to-date, no matter which tool they live in. No manual updates needed and no copy-pasting. Because you can use Airtable and Notion for just about anything, being able to sync data between them can supercharge all kinds of workflows.

You can use this integration to streamline project management tasks, data analysis, software development work, and so much more.

Here’s a similar demo showing how to sync Airtable with Unito:

In this Airtable Notion article:

Before you connect Airtable and Notion to Unito

Each tool has a few steps to follow before you can dive into creating your flow. Here they are.

Airtable

  • Make sure your Airtable has a Single-line text field called Title and a Last Modified Time field.
Last Modified Field in Airtable

Notion

  • Add the Last edited Time field: Right-click on any column, click on Insert Left or Insert Right. Then click on the new column and change Property Type to Last Edited Time.
  • Add Notion to your Unito workspace.
  • Add a Last Edited Time field to every Notion page.
    • Right-click on any column, click on Insert Left or Insert Right. Then click on the new column and change Property Type to Last Edited Time.
  • Add Unito as a connection in Notion

Add Unito as a connection in Notion

Click here for instructions on how to set up each Notion page to sync with Unito

You can sync pages from any Notion database in your account as long as you have “edit permission” in that database. Here’s an example of how databases appear in Unito:

Notion Databases 1

Add Unito 2-way Sync as a connection for each page you want to include in your flows. Otherwise, Unito won’t be able to detect your databases in Notion. Here’s more from Notion’s knowledge base on adding connections.

Troubleshooting your Notion integration

If you need help setting up your Notion integration, you can browse this guide on adding Notion to Unito or you can find a more general overview of this Notion integration here.

Note: Only one Notion user per workspace can connect to Unito. So make sure you create a Notion user specifically for Unito and give it access to all pages and databases in your workspace.

Step 1: Connect Airtable and Notion to Unito

  1. In the Unito App and click +Create Flow.
  2. Next, click Start Here to connect your tools.
  3. Select +Add a tool to this flow in either column, and connect Airtable. Then +Choose account to specify the Airtable account you want to use.
  4. Pick the Airtable base you want to connect to Unito.
  5. Repeat steps 3 and 4 to connect Notion with Unito.
  6. Click Confirm.
Connecting Notion and Airtable with Unito

Learn more about adding Notion to your Unito workspace.

If this is your first time connecting Airtable to Unito, you’ll have to go through a quick authorization process:

Step 2. Choose a flow direction for creating new data in Notion or Airtable

Flow direction determines how new work items are created by Unito. What does that mean? If you set up a one-way flow from an Airtable base called Research to a Notion database called Marketing Roadmap, then your Notion page will be populated by new data synced from the Airtable base.

Set flow direction between Airtable and Notion

In contrast, a two-way flow will automatically create new records in each tool based on data from the other.

Note: Later, you’ll be able to add field mappings to determine which fields will be kept updated in both tools — regardless of the flow direction you set here.

Select Confirm when you’ve chosen a flow direction.

Step 3. Filter out unrelated records and pages from syncing between Notion and Airtable

This is where you can set up triggers to determine which actions taken in one tool will create new work items in the other. In a two-way flow, you can set up rules for both Airtable and Notion.

Select Add a new trigger to begin setting up your rules. There can be some variability here, depending on your particular setup in each tool.

Set rules to filter data between Airtable and Notion

Without additional triggers, every record from your source tool base or page might appear as a new work item in the destination. In the above example, we can specify that only specific records with the status of our choice will sync over.

Rules can filter data using almost any field, from dropdowns to text and tags.

You can learn more about setting up rules here.

Fields represent the details of your Airtable records and Notion pages. Text, dropdowns, dates, and emails are all examples of fields you can map with Unito.

This step sets the relationship between fields in Notion and Airtable, even if they have different names and serve different purposes.

First, you’ll be asked whether you want to set up your field mappings from scratch or let Unito do this automatically. If you select the auto-map option, you can still change mappings afterwards. If you prefer a DIY approach, start from scratch.

Your fields will be automatically mapped for two-way updates, but you can modify each individually if you prefer one-way updates in some cases. With two-way updates, changes made in either tool will automatically update the other. A one-way update restricts changes to a single direction.

Select +Add Mapping, then Select a field in both tools to pair the fields together.

You can choose any field with a gear icon to map them further. Usually, this will apply to fields like dropdowns, which have multiple options.

Click confirm when you’re satisfied with your field mappings.

Step 5: Launch your Airtable Notion integration

And that’s it! You’ve just built a flow between Airtable and Notion. Congratulations!

If you followed the steps above, your flow will now:

  • Automatically create new Airtable records and Notion pages.
  • Keep fields up to date in both tools.

If you have any questions, please don’t hesitate to reach out and let us know.

What’s next after setting up a two-way integration between Notion and Airtable?

See how Passport Shipping uses Notion to report on Jira issues. Then, you can try out these Airtable templates and sync them with Unito to match your use case:

If you want to know what else you can do with Unito, here’s some inspiration to help you power up your workflows.

Why use Unito to sync Airtable and Notion?

Airtable and Notion are both some of the most flexible tools in your stack. You can use them for anything, from a task management system to a database and even a full project management suite. But whether you’re dealing with two teams who each have their own preferred tool or you’re using each tool for a distinct purpose, Unito is the best way to connect them.

That’s because Unito is the only solution that can sync data between Airtable and Notion in both directions.

Unito is SOC 2 Type 2 compliant and adheres to major global data privacy regulations. Your information is fully encrypted while in transit. If you need more details, you can read about our Unito’s security policy here.