How to display your Airtable data
in WordPress with Air WP Sync

Airtable to WordPress

This game-changing plugin will allow you to view data from Airtable on WordPress.

The resulting applications are aplenty: you can now import any database on WordPress (product catalogue, job offers, contacts, events, projects, etc.) while benefiting from a user-friendly dashboard to manage data via Airtable. You can even publish articles and pages directly from Airtable to feed a blog or a whole ecosystem of websites.

Air WP Sync enables you to import data from Airtable to WordPress in various formats: pages, posts, custom post types and custom fields (in the Pro version). You can also sync all the data manually or automatically.

In this short tutorial, we show you how to set up Air WP Sync.

Airtable to WordPress integration Tutorial Summary

  1. Create a new connection
  2. Collect your Airtable API key
  3. Create your Airtable database
  4. Get your app ID and table ID
  5. Select content type to import, status and author
  6. Fields mapping between WordPress and Airtable
  7. Define sync settings
  8. Publish and sync

Download Air WP Sync

Download the Air WP sync free version from the official WordPress library. This free version allows you to import any Airtable database in the following formats: posts or WordPress pages.

The Pro version offers you additional functionalities.

The extension is available in French and English.

Installation and settings

  • Create a new connection

Once the plugin is set up and activated, a new Air WP Sync menu appears on your WordPress dashboard.

You can create as many connections as you want between Airtable and WordPress.

Create your first connection by clicking on Add. Don’t forget to name that first connection!

  • Collect your Airtable API key

Now then, please get hold of your API key on your Airtable account. You’ll find it right here. Your API key is masked, but you can view it and copy paste it by clicking on the right field (in mauve).

Go back to the settings of your Air WP Sync connection and paste your key in the correct field “API key”.

  • Create your Airtable database

You’ll now be able to create an Airtable database from scratch or from an existing one with the data you wish to import from WordPress.

For this tutorial, we’re going to create a brand new Airtable database, with an articles table including four columns (Title, Category, Content, Tags) and three savings in this table.

  • Get your app ID and table ID

You will now need to tell Air WP Sync your Airtable database and table credentials. You will find them in the URL of your Airtable table, which looks like this: https://airtable.com/**appZbeJWwIdgeVF**/**tbli9358Z5aeKu1**/viwd0LfnNOcND

The string that begins with “app” is your app ID; the line that begins “tbl” is your table ID (in bold).

In the configuration page of your Air WP Sync connection on WordPress, paste this string of characters in the relevant areas.

  • Select content type to import, status and author

You will then be able to determine the format in which you want to import your data into WordPress.

The Free version of Air WP Sync allows you to import your data as a post or a page. The Pro version lets you import your data in templates or custom post types.

Finally, you can choose the status of the imported content (published, planned, draft, etc.) and its author.

  • Fields mapping between WordPress and Airtable

You can now associate the columns of your Airtable table with the fields of WordPress.

On the left column of your connection configuration screen, enter the exact name of the columns of your Airtable table, and opposite, choose the associated WordPress field, as in the example below.

Repeat for each column.

Here are the WordPress field types available in the free version of Air WP Sync for import from Airtable:

– Title
– Content (of the page, of the article, etc.)
– Extract
– Slug
– Publication date
– Featured image
– Category
-Tags

Custom fields are available in the Pro version.

Note that if an Airtable column contains rich text (bold, italics, links, titles, etc.), you can check the “Convert Airtable rich text” option, which converts the text to fit WordPress perfectly.

  • Define sync settings

All that remains is to choose the desired synchronization parameters.

You can define the strategy or synchronization method:

– To add
– Add and update
– Add, update and delete

It would be best if you also chose the synchronization triggering criterion:

– Manual (on request)
– Recurring (every week, every day, etc.)
– Snapshot (in real time, available in Pro version of the plugin)

Trigger and frequency Airtable WordPress sync
  • Publish and sync

All you have to do now is publish the connection before starting it.

Once published, a Synchronize button will appear at the top right of your connection page.

The data has been successfully imported into WordPress!

In our example, we can see our articles in the list of articles.

Categories and tags that still needed to be created were created on the fly.

Check that out! The formatting entered in rich text in Airtable is fully respected.

Learn more about Air WP Sync & WP connect

To learn more about Air WP Sync and the integration of Airtable with WordPress, visit this page.

For your information, we also offer plugins to send data from your WordPress forms to Airtable:

Gravity Forms to Airtable integration
WPForms to Airtable integration
Contact Form 7 to Airtable integration

Related Posts

Black Friday Sales is ON. Get 20% OFF on all products with BFWPC coupon till Wednesday 30 of November 11:59PM (CET).
This is default text for notification bar