Skip to main content

Hello,


I am new to Airtable but want to use it to inform my content strategy. This requires me to be able to replicate and update my WordPress website in Airtable.


I would like to:




  • List item Create a record all of the current posts, their categories and status (draft, published etc.). I gather I can just export them as XML or CSV and import them into Airtable




  • List item Update the Airtable table when the status of posts are change. E.g. if a post that has a draft status in WordPress is published, the status on the Airtable record should update to “Published”. Similarly, if the category is changed on Wordpress post, this should update and reflect on the Airtable record.




I understand that there are Zapier integrations that should be able to do this. I have tried a few but can’t get them to do what I want. I also understand that many people write content in Airtable, which then gets pushed to their website. I have a team that works on WordPress and part of the project is to train people on WordPress so I am not so keen on this approach.


Any input welcome.


Thanks,


Grant

Welcome to the community, @Grant_McNulty!

You may want to check out Air WP Sync, which claims to do all of this!

Otherwise, you can set this up yourself by using Make’s Wordpress integrations in conjunction with Make’s Airtable integrations.

You mentioned Zapier in your message above, but I would STRONGLY recommend against using Zapier.

Make is INFINITELY more powerful & customizable than Zapier, yet it is SIGNIFICANTLY CHEAPER than Zapier.

I wrote an entire post here comparing Make vs. Zapier.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

I can understand why you want a WordPress to Airtable workflow, even though I currently use a few different workflows in the opposite direction. (My custom block for creating posts in WordPress from Airtable records recently won a prize in Airtable’s custom block contest.)


I respectfully suggest that you use WordPress’s post ID to uniquely identify your posts and not the post title. Once a post is created, its post id never changes.


How often do changes happen to the WordPress website and how quickly do you need to see those changes?

I can understand why you want a WordPress to Airtable workflow, even though I currently use a few different workflows in the opposite direction. (My custom block for creating posts in WordPress from Airtable records recently won a prize in Airtable’s custom block contest.)


I respectfully suggest that you use WordPress’s post ID to uniquely identify your posts and not the post title. Once a post is created, its post id never changes.


How often do changes happen to the WordPress website and how quickly do you need to see those changes?


Hello and thanks for the tip on the post ID. Posts are published on a daily basis but it would work if the changes only reflected in Airtable every week or two as we have fortnightly content meetings.


The main thing I want to record is if a post status changes from draft/ pending to published so a workflow for that would suffice. Recording changes to categories and other things is secondary.

Thanks for the follow up.


Since you need to update the data in Airtable once a week or so, one option is to use an Airtable script. When you want to get the most recent data, click a button to run the script. The script gets the data (including post status and categories/tags) from the the WordPress API and updates the Airtable records.


However, this system requires setup on the WordPress site as well as custom code for the Airtable script. If you are interested in hiring someone to create such a script, let me know.

Thanks for the follow up.


Since you need to update the data in Airtable once a week or so, one option is to use an Airtable script. When you want to get the most recent data, click a button to run the script. The script gets the data (including post status and categories/tags) from the the WordPress API and updates the Airtable records.


However, this system requires setup on the WordPress site as well as custom code for the Airtable script. If you are interested in hiring someone to create such a script, let me know.


Congrats on the prize!! I gotta say I watched the video on your entry form and it looks solid. Just wondering, is the Post to WordPress block available already? Also, once the content has been published to WP is it possible to edit using tools like Thrive Architect?

@Jorge_Rodriguez Thank you. The Post to WordPress block as appears in the DevPost contests is freely available. You can see the link to the GitHub repository in the DevPost entry. I also have a updated version that I am working on. If you are interested in the block but do not feel up to remixing it from GitHub yourself, please feel free to direct message me.


Once the block pushes the post to WordPress, it exists just like any other post in WordPress. However, the contents of the post may or may not be editable using Thrive Architect. It all depends on the exact html that you push, and how Thrive Architect interprets it. Many WordPress page builders expect the html to be formed in a particular way, and do not play nicely with html that does not conform to their format.

Reply


Terms & Conditions