Airtable Database to WordPress Site

Airtable and WordPress are two of the preferred instruments utilized by companies and people for managing information and creating web sites. Now, think about having the ability to seamlessly combine the 2 for much more environment friendly and highly effective information administration. With Air WP Sync, you are able to do simply that.

Air WP Sync is a WordPress plugin that allows you to arrange information and data in Airtable, then sync all of it to WordPress. This implies you should utilize Airtable to develop customized web sites powered by WordPress with out having to depend on third-party connectors like Zapier. 

However is Air WP Sync straightforward to arrange and use? What number of Airtable databases can I sync with this device? Can it map information to WordPress customized fields? 

On this hands-on evaluate of Air WP Sync, I’ll reply these questions and present you easy methods to use the plugin to streamline your workflows/processes. 

Air WP Sync: Overview & Key Options

The USP of Air WP Sync is that you should utilize it to attach as many Airtable databases to your WordPress web site as you want. Extra particularly, it helps you to map information from Airtable to fields in WordPress—you possibly can publish the information as WordPress pages, posts, or custom post types.

Air WP Sync maps to plain WordPress fields like information, title, class, and so on. However for those who want some superior implementations, there’s assist for customized area information mapping. You too can arrange your personal customized schedules for work and determine between syncing information routinely or manually.

Different salient options of Air WP Sync embody:

• Preserves Airtable wealthy textual content formatting (e.g., headings, paragraphs, and so on.)
  Offers the choice to pick out the put up standing of imported content material (draft, non-public, revealed)
• Gives customized put up sorts for displaying any sort of Airtable document in WordPress (occasions, case research, and so on.)
• Affords completely different sync strategies (add, replace, delete)

Palms-On With Air WP Sync

On this part, I’ll show easy methods to create an Airtable WordPress integration with the assistance of Air WP Sync. 

Earlier than I start, I ought to level out that I did the testing with the premium model of the plugin.

However even for those who begin with the free model, the essential steps ought to be the identical. 

Setting Up Information in Airtable

To start, arrange your information in Airtable. In case you have achieved this already, you possibly can leap straight to the following step.

For this evaluate, I used Airtable’s pre-made Occasion Planning template. With Air WP Sync, I used to be in a position to sync the occasion actions to WordPress so that every exercise will get its personal particular person web page.

Producing Airtable Entry Token

To attach the plugin to your Airtable account, you’ll need to generate what’s referred to as an Airtable entry token.

Follow the steps here to generate one and click on the Create Token button:

Be happy to call your token for straightforward recall.

Subsequent, add every part that seems underneath the Scope heading. Then, underneath Entry, select the Airtable bases you want to hook up with WordPress. 
After you have made your alternatives, click on the Create Token button to generate your Airtable token.

Making a New Connection in WordPress

Subsequent, go to your WordPress admin space and choose Air WP Sync > Add New to create a brand new connection. Enter a reputation for it after which paste your entry token within the field. When you’ve achieved this, watch for Air WP Sync to assemble related tables and bases (you don’t must do something at this level—the plugin will fetch every part routinely).

Shifting on, select what Airtable content material to connect with by utilizing the next choices:

• Base – Choose your base connection. Solely the bases you chose whereas creating your token shall be obtainable for choice.
• Desk – From the tables obtainable within the chosen base, choose the one you need to work with.
• View – Choose a sure view throughout the desk. In case you have a number of views on your information, choose the one you need to use. Alternatively, you possibly can select the “No View” choice to usher in all information.
• Filter by method –That is an non-compulsory, superior methodology for selecting what information to import. Right here, you possibly can enter an Airtable method to set issues up. I made a decision to skip this step as a result of I didn’t understand how Airtable formulation work.

Configuring Content material Import Sorts

Subsequent, choose the way you need to import Airtable content material by scrolling all the way down to Import As… choices. Right here, you possibly can select from the next:

• Publish Sort – Choose the kind of put up you need to import. Choices embody Posts, Pages, Merchandise, and any customized put up sorts you’ve made. The plugin even features a perform to create a brand new customized content material sort straight from its settings. 
• Publish Standing – You could have the choice to right away publish the put up or import it as a special standing, resembling Scheduled, Draft, and so on. 
• Publish Creator – Select the writer for the put up from any consumer account registered in your web site

Word that I imported the content material as a normal put up for this tutorial.

Subsequent, you possibly can arrange area mapping to hyperlink the information out of your Airtable base to fields in WordPress.

This characteristic helps core WordPress fields resembling put up title, put up content material, classes, and so on., in addition to customized fields. Advanced Custom Fields assist can also be obtainable (ACF) in a Professional+ Model.

To get began, merely click on the Add Discipline button.

Now, undergo the next elements:

1. Airtable Discipline – Choose a column out of your Airtable base.
2. Import As – Choose the corresponding WordPress area to which you need to add the information from that column. You too can create new customized put up sort and customized fields at this stage. The plugin may routinely detect fields created with ACF or CPT UI or any CPT included in your theme.

For example, to set the occasion exercise because the title of the put up, map it like this:

You may then map extra information by repeating the method. With Air WP Sync, there’s no restrict to the variety of mapping guidelines you possibly can arrange.

Nonetheless, the mapping guidelines may differ primarily based on the Airtable area you join. For example, when selecting a column with photographs, you possibly can map the pictures to the featured picture in WordPress.

Configuring Sync Settings

Sync settings setup is subsequent. Doing this allows you to outline when and easy methods to sync information from Airtable bases to your WordPress website.

Right here, you possibly can decide from three strategies for easy methods to sync:

• Add, Replace & Delete – This alternative gives a complete synchronization. New content material shall be added as wanted, current content material shall be up to date if any adjustments happen within the base, and any WordPress content material that corresponds to a deleted Airtable document shall be eliminated. 
• Add & Replace – This feature will add new content material and replace any current content material that has been altered in Airtable. Nonetheless, current content material won’t be deleted, even whether it is now not current in your Airtable base. 
• Add – Solely new content material shall be added, and no adjustments shall be made to any current WordPress content material, even when it has been altered in Airtable or is now not in your Airtable base.

After that, you get to select from three choices on your sync set off:

• Handbook solely – Syncs content material solely if you provoke it. 
• Recurring – Routinely syncs content material primarily based in your set schedule , which may vary from as soon as each 15 days to each 5 minutes. 
• Instantaneous – units up real-time syncing by configuring an automation in Airtable to set off a webhook URL. This lets you routinely sync everytime you make adjustments in Airtable.

Publishing your connections

When you’re glad together with your connections’ settings, click on Publish to go stay. Air WP Sync additionally helps you to manually sync the connection from the interface after publishing it.

After the sync ends, you need to be capable to see every part that you just’ve imported, like I did:

As you possibly can see, I used to be in a position to import the entire occasion actions as posts on my website.

If you wish to handle your connections, head over to Air WP Sync > All Connections. You are able to do this after you’ve revealed them. 

Air WP Sync Pricing

Air WP Sync is a strong plugin that’s obtainable in two variations: a free model at WordPress.org and a premium model with added options.

Should you go for the free model, it is possible for you to to make the most of the core performance of the plugin, together with constructing connections between your WordPress fields and Airtable information, and synchronizing your information manually or routinely. 

Nonetheless, the Professional model takes issues to the following stage. With it, it is possible for you to to:

• Set your personal customized replace frequency for automated information synchronization
• Publish limitless connections from Airtable to WordPress (the free model limits you to just one lively connection at a time)
• Publish Airtable information to customized put up sorts moderately than solely the default Publish and Web page put up sorts
• Construct customized fields and sync Airtable information to WP customized fields

Pricing for Air WP Sync Professional begins at $129 per 12 months for a single web site license. If you wish to use the plugin on extra web sites, you’ll need to get a higher-tier plan. Listed below are all the worth plans:

The developer additionally provides ACF (Superior Customized Fields) due to Air WP Sync Pro+.

Last Verdict

Total, utilizing Air WP Sync is an effective way to construct customized web sites and handle your WordPress content material higher.

I believe it does an awesome job at letting customers sync and map information, in addition to hyperlink Airtable columns to WordPress fields.

And with the premium model of this plugin, you get the power to work with customized fields and customized put up sorts. 

Arrange an Airtable WordPress integration right this moment to save lots of time and enhance your work effectivity.

Get Air WP Sync