How to Sync Notion Tables With Airtable Bases Using Unito
Logos for Airtable, Unito, and Notion, representing our guide to syncing Airtable and Notion.
How to Sync Notion Tables With Airtable Bases Using Unito
Logos for Airtable, Unito, and Notion, representing our guide to syncing Airtable and Notion.

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

  • Generate an API key in Airtable so you can connect it to Unito. More on that here.
  • 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.

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’re connecting an Airtable base called Marketing Data with a Notion database called Campaign Performance, flow direction will affect which one gets new work items from the other. For instance, a one-way flow from Marketing Data to Campaign Performance would automatically create new pages in Campaign Performance each time you create a new record in Marketing Data, but not the other way around. In contrast, a two-way flow would automatically create new work items in both directions.

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.

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 build 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?

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