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.