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

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.

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.

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

  • Create a shared Notion account: Only one Notion user per workspace can connect to an app like Unito. So make sure you create a Notion user specifically for using Unito and give it access to all pages and databases in your workspace.
  • 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.

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: Set flow direction between Airtable and Notion

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: Set rules to filter data between Airtable and Notion

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.

Step 4: Set up field mappings between Airtable and Notion

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.

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: Save, close, and launch your flow!

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.