Sync data into Airtable

Any sync has two key components: A source and a destination. 

Your synced data (and any changes made to that data) flow in one direction. When changes are made to the source data, those updates will automatically change in the destination. 

Decide what (and where) data is synced

Like any other facet of your workflow, your sync set-up will be specific to you and your team’s needs —whether you need to sync data between bases, or from an external tool via a sync integration. 

You have the flexibility to sync from one source or multiple sources to the same destination, and determine what is synced, and how frequently. 

Let’s explore two different ways to set up a sync, depending on your workflow needs: 

1. Sync from a single source

The most straightforward way to sync your information is from a single source. This is useful when you need to break down data silos between bases, or bring in data from an important tool in your workflow. 

Imagine you're on a product team managing a roadmap. Your marketing team needs to be able to see your launch dates in order to plan their upcoming campaigns. 

With sync, you can make your launch date information directly available to the marketing team, so they can plug your plans their Campaigns base. 

Any changes you make in source view will update in real time in the synced table in the Campaigns base, keeping them informed as timelines shift—no meetings, emails, or Slack messages necessary. 

2. Sync from multiple sources

If you need to sync information from more than one source, multi-source syncing allows you to bring in data from multiple bases and external tools into one place.

For example, if you’re managing creative assets for a campaign, you might have two teams uploading their assets onto two different platforms—maybe your in-house creative team is using an Airtable base, while your outside agency uses a Box folder.

With multi-source sync, information from both sources can come into a single base, giving you top-level control, tracking, and management for information from both groups.

If you’re syncing from a source that isn’t set up identically to your target base, be that another base or another tool, you can use a technique called “field mapping” to make sure each field of incoming data ends up in the right place.

Make the most of a synced table ⚡

Sync settings go beyond choosing your source and destination. You can also control how a synced table behaves—when and how it syncs. 

Determine how a sync behaves by updating the settings:

• Manual or automatic? You can set the sync to occur automatically, every five minutes, or manually, depending on your needs and plan type. 

• Choose which specific fields to sync from the source table.

• What to do with hidden fields—do you want to import them, or not?

If you’re working in a synced table, you can still group records and add views, or hide or add fields. But because your destination view mirrors the data in the source view, you won’t be able to add, remove, or edit the data in the destination.  

Take action: Set up your first sync

Now that you’re familiar with sync, it’s time to try it out in your workflow! If you’re working across multiple bases, try syncing data from one view to another base. 

First, choose the view that will serve as the source. The data visible in that view is what will be synced. Any updates to that view will update what’s visible in the synced table. To enable syncing, go into the share view button, and toggle to allow data to be synced from this view. 

Then, determine the destination base by adding a table and select your source from the “Sync data from” menu. Paste your share view link to turn this into a synced table. 

Now, you can configure your sync settings including frequency, what fields go where, and which fields to include. Sync complete!