A powerful, easy to use combination of tools that allow you to automatically (or manually) generate WordPress posts with custom metadata.
Create WordPress posts from your Airtable data.
Install the WordPress Plugin
The WordPress Connector has two parts, a WordPress plugin that pulls your Airtable data into wordpress, and an API tool to connect with airtable here.
To connect to wordpress, use the Aeropage Sync for Airtable plugin. You can find it in the WordPress directory by searching for “Aeropage“.
Add a Custom Post Type
Once the plugin is installed, just open it from the sidebar and “Add Post”.
After clicking “Add a Post” you will be shown a form.
The title of the custom post type will usually be the same name as the table you”re importing data from in Airtable.
The dynamic url can be “SEO” friendly by using the name eg “shure-headphones” or it can be easier to manage potential duplicate names by using the unique id of each record.
Continue to the next steps to create a token to use with the api connector.
Will check for changes every 10 minutes and automatically import them to WordPress.
When submitted this will create a custom post type and automatically add a new post for every record in your connected Airtable
To complete the form you will need an API token (below)…
Create API Connector & Token
The api connector stores your connection info and prepares the data in the response to be used in WordPress.
Connect to Airtable
After clicking new and creating your project, copy and paste the url to the airtable data you want to connect. To find out more details on this step, click on the instructions button.
Post Data & Fields (MetaData)
you can create dynamic values for your posts when they appear in “loops” on your WordPress archive pages, query and loop templates
If you want to make a custom title, instead of using the default name of the records.
The image will be automatically downloaded to your wordpress media library.
A short description of the post content.
By default, every field in your airtable record will be created as post metadata. If you want to prevent some data from being synced, click the field settings and toggle off the ones you want to exclude.
Replaces temporary links in your attachment fields with permanent urls.
ðŸ’¡ After making changes, you need to refresh the data to see the result.
You can see a preview of how your posts would look in a WordPress loop by click on the “posts” view. This can be used to confirm the Post Title, Image and Excerpt are correct before you syncronize with WordPress.
Syncronizing with Airtable
Once your data is setup in Aeropageâ€¦
- Open the settings.
- Click on the “token” field to copy it.
- Go back to Wordrpress plugin, “create post” page.
- Paste your token into the API Token field.
ðŸ’¡ Auto sync can be toggled on to check for new and changed data every 10 minutes.
After a few seconds, you should see your data appear in the right – and a Success message.
You are now ready to save the post, which will syncronize you posts for the first time. After syncronizing your custom post will appear in the WordPress menu, and a post will have been added for each record in your Airtable data.
ðŸ’¡ The first time you sync it can take longer as it”s downloading your featured images.
You should also see the featured images for each post in your media library.
You can now use your custom post to make queries and templates â†’ also use custom post meta data, for any of the fields in your Airtable data when making Single Post templates. The custom posts and metadata should work with all your favorite builders.
- Create loops using the “Query Loop” Block
- Make templates for your single posts.
- Create loops using the “Loop Template” widget.
- Make templates for your single posts.
- Refer to documentation for how to make loops with custom posts and metadata.
Update your Data
To manually resync your data, make changes or delete – just click the icons below.
Make changes to the configuration
Resyncronize your data manually.
If you have auto sync toggled on, your posts will be updated automatically every 10 minutes.
- Upload the plugin folder to your /wp-content/plugins/ folder.
- Go to the Plugins page and activate the plugin.
- Create an API connector for Airtable on tools.aeropage.io.
- Setup your custom post type, and sync your Airtable data to WordPress.
以下人員參與了開源軟體〈Aeropage Sync for Airtable〉的開發相關工作。參與者
* Fixed the links for the tools website.
* Added View Record menu item in the admin bar
* UI changes and i mprovements
* Fixed the plugin import issue
* fixed issues reported for syncing and image upload to wordpress
* Fixed the image upload issue
* Fixed sync issues
* Fixed the links
* Added resyncing data in the admin bar
* Added a post status option in the Add/Edit Pages
* Added support for opening the Airtable URL of an Aeropage in a separate tab
* UI Improvements
* Added support for feature image downloading from airtable
* UI fixed and improvements
* Sync fixes and UI improvements
* UI improvements to the admin bar
* General bug fixes
* Plugin released.