Do you need to arrange an Airtable WordPress integration to sync data from Airtable to your WordPress website?
Air WP Sync is a freemium WordPress plugin that permits you to sync Airtable to WordPress with out needing middleman providers like Zapier.
You possibly can arrange knowledge and data in Airtable after which sync all of that to WordPress to create the frontend of your website. This allows you to use Airtable to create customized web sites powered by WordPress.
In our Air WP Sync evaluation, we’ll take a hands-on have a look at what this plugin gives and present you easy methods to arrange an Airtable WordPress integration.
Let’s dig in!
Air WP Sync Evaluate: A Detailed Have a look at Its Options
At a excessive degree, the core worth of Air WP Sync is that it permits you to join limitless Airtable databases to your WordPress website and publish knowledge from Airtable as WordPress posts, pages, or customized put up sorts.
To do that successfully, you’re capable of map knowledge from Airtable to fields in your WordPress website.
Along with mapping to core WordPress fields akin to title, date, class, and so forth, this additionally consists of help for mapping knowledge to WordPress customized fields, which helps you to arrange some extra superior implementations if wanted.
The plugin can even protect Airtable wealthy textual content formatting when bringing over your knowledge, akin to paragraphs, headings, and so forth.
To maintain every part up to date, you too can sync your Airtable knowledge with WordPress going ahead. You possibly can sync knowledge manually or robotically, together with organising your individual customized schedules.
You may also select from totally different sync strategies:
Extra on how these totally different sync strategies work just a little later within the put up!
Find out how to Sync Airtable to WordPress With Air WP Sync
Now that you already know extra about what WP Air Sync does, let’s dig into easy methods to arrange an Airtable WordPress integration utilizing the plugin.
For this a part of our WP Air Sync evaluation, I’m utilizing the premium model of the plugin. Nevertheless, the fundamental ideas additionally apply to the free model.
Within the subsequent part, you’ll study extra about pricing and free vs Professional options.
1. Set Up Your Information in Airtable
To get began, you’ll need to arrange your knowledge in Airtable, in the event you haven’t executed so already.
If you have already got every part in Airtable, you possibly can skip forward to the following step.
For this tutorial, I used Airtable’s premade Restaurant Subject Information template. Then, I’ll sync these eating places to my WordPress website so that every restaurant will get its personal separate web page on my website.
2. Generate Your Airtable Entry Token
Subsequent, it is advisable generate your Airtable entry token, which is what permits the plugin to hook up with your Airtable account.
You possibly can create an Airtable entry token by going right here and clicking the Create Token button:
Give your token a reputation that will help you keep in mind it.
Beneath Scope, I enabled every part, although I’m unsure if that’s wanted. It will be good to have some documentation right here on easy methods to optimally configure the token. Nevertheless, as a result of this token solely has entry to particular bases that you simply select, there shouldn’t be any concern with enabling every part.
Then, beneath Entry, you need to choose the Airtable base(s) that you simply need to connect with WordPress.
Once you’re completed, click on the Create token button to generate your Airtable token:
It is best to then see a popup that comprises your token. Hold this useful since you’ll want it in a second and Airtable will solely present you this worth as soon as:
Don’t fear – in the event you by chance misplace it, you possibly can simply regenerate the token to create a brand new key.
3. Create a New Connection in WordPress
Now, open your WordPress dashboard and go to Air WP Sync → Add New to create a brand new connection.
Give it a reputation after which enter your entry token within the field.
When you paste within the entry token, WP Air Sync ought to robotically fetch the related bases and tables.
You possibly can then use the choices to decide on what Airtable content material to hook up with:
- Base – select the precise base to hook up with. You’ll solely have the ability to select from the bases that you simply chosen when creating your token within the earlier step.
- Desk – select a selected desk from all of the tables within the base that you simply chosen.
- View – select a selected view inside that desk, which is useful in the event you’ve arrange a number of views to slice and cube your knowledge. Alternatively, you should use the default No View possibility, which is able to allow you to pull in all information.
- Filter By Method – that is an elective and extra superior approach to decide on what knowledge to import. You possibly can set this up by getting into an Airtable formulation – in the event you’re unsure what Airtable formulation are, it is best to most likely simply skip it.
4. Set Up Content material Import Kind and Map Fields
Subsequent, you possibly can scroll right down to the Import As… choices to decide on the way you need to import Airtable content material to WordPress:
- Publish Kind – select the put up kind to which you need to import content material. You possibly can select Posts, Pages, and any customized put up sorts that you simply’ve created. The plugin additionally features a function to allow you to create a brand new customized put up kind immediately from the plugin’s settings.
- Publish Standing – you possibly can publish the put up instantly or import it as different statuses akin to Draft, Scheduled, and many others.
- Publish Writer – you possibly can select the writer for imported content material from any registered person account in your website.
For this instance, I’m simply going to import them as a daily put up. Nevertheless, the customized put up kind possibility can be actually useful in the event you’re seeking to create extra customized apps.
Beneath that, you possibly can arrange subject mapping, which helps you to map the info out of your Airtable base to fields in WordPress.
This consists of help for core WordPress fields – e.g. put up title, put up content material, classes, and many others. It additionally consists of help for customized fields, together with plans so as to add an Superior Customized Fields integration (ACF).
To get began, you possibly can click on the Add Subject button.
Then, there are solely two elements:
- Airtable Subject – select a column out of your Airtable base.
- Import As – select which WordPress subject to which you need to add the info from that column. You may also create new customized fields as a part of this. Nevertheless, the plugin can’t at the moment auto-detect fields that I created with ACF. However once more, that function is on the roadmap, so it may be right here by the point you’re studying.
For instance, to set the restaurant title because the title of the put up, you’d map it like so:
You possibly can then repeat the method to map further knowledge, organising as many mapping guidelines as wanted on your scenario.
The mapping guidelines may change primarily based on the Airtable subject that you choose. For instance, choosing an Airtable column with photographs opens the flexibility to map these photographs to the featured picture in WordPress.
Once you’re completed, you may need one thing that appears like this:
5. Configure Your Sync Settings
Subsequent, you possibly can arrange your sync settings, which helps you to management how and when to sync the info out of your Airtable base along with your WordPress website.
First, you possibly can select from three totally different “methods” for easy methods to sync:
- Add, Replace & Delete – this can be a full sync. It would add new content material if wanted, replace any present content material if the info in your base has modified, and delete any WordPress content material the place the corresponding Airtable file has been deleted.
- Add & Replace – will add new content material and replace present content material if the info in Airtable has modified. Nevertheless, it is not going to delete any present content material even when that content material is not in your Airtable base.
- Add – will solely add new content material – it is not going to edit or delete any present content material on WordPress, even when that content material has modified in Airtable or is not in your Airtable base.
Beneath that, you possibly can select your sync set off. You may have three choices:
- Guide solely – solely sync content material if you manually provoke it.
- Recurring – robotically sync content material on a selected schedule that you simply set – wherever from as soon as per week to each 5 minutes.
- On the spot – you possibly can arrange instantaneous syncing by configuring an Airtable automation to name a webhook URL. For instance, you might robotically sync everytime you replace something in Airtable.
6. Publish and Go Reside
When you’re glad along with your connection’s settings, you possibly can click on the Publish button to make it reside.
You may also manually sync your connection from the interface after publishing it:
After the sync finishes, you possibly can see that I used to be capable of efficiently import the entire eating places as posts on my website and in accordance with my subject mapping:
If you wish to add one other connection, you possibly can repeat the identical steps from above.
You may also handle your connections by going to Air WP Sync → All Connections:
Air WP Sync Pricing
Air WP Sync is available in each a free model at WordPress.org in addition to a premium model with extra options.
With the free model, you get entry to the core performance of the plugin, together with letting you arrange connections between your Airtable knowledge and WordPress fields and sync your knowledge manually or robotically.
Nevertheless, the Professional model unlocks some added performance that could possibly be essential for critical use circumstances:
- Set your individual customized replace frequency for the way typically to robotically sync knowledge. The free model simply permits you to use the default day by day or weekly schedule.
- Publish limitless connections from Airtable to WordPress. Whereas the free model permits you to arrange limitless connections you possibly can solely have one lively connection at a time.
- Publish Airtable knowledge to customized put up sorts. The free model solely helps the default Publish and Web page put up sorts.
- Create customized fields and sync Airtable knowledge to WordPress customized fields. The developer additionally plans so as to add an Superior Customized Fields (ACF) integration, however that function wasn’t obtainable on the time of our evaluation. The free model solely permits you to publish to the core WordPress fields.
Right here’s a visible have a look at Air WP Sync free vs Professional:
If you would like the premium options, there are three totally different pricing plans. All the plans embrace entry to the entire options – the one distinction is the variety of websites upon which you should use the plugin.
Plans begin at $129 to be used on a single website (or $99 if the plugin is on sale, because it was after we took the screenshot beneath):
Last Ideas on Air WP Sync
Total, I discovered Air WP Sync to ship on its guarantees in a really polished approach.
I believe it’s executed a very good job of providing you with a number of flexibility and letting you map and sync knowledge in the best way that works greatest on your website.
So if you wish to arrange an Airtable WordPress integration, I’d positively give this one a glance.
If the plugin can push out the Superior Customized Fields integration quickly, I believe that will make it even higher for extra customized purposes as a result of it might be simpler to work with and show customized knowledge.
In the event you’re considering attempting it out, you can begin with the free model at WordPress.org, which ought to work for fundamental use circumstances.
Nevertheless, if you wish to construct actually customized internet apps, I positively advocate upgrading to the premium model to entry the flexibility to work with customized put up sorts and customized fields, together with extra versatile syncing.
You should utilize the buttons beneath to get began:
