{"id":315,"date":"2022-10-22T14:23:02","date_gmt":"2022-10-22T14:23:02","guid":{"rendered":"https:\/\/jonathan-wright.com\/?p=315"},"modified":"2022-10-22T14:23:06","modified_gmt":"2022-10-22T14:23:06","slug":"wordpress-to-airtable","status":"publish","type":"post","link":"https:\/\/jonathan-wright.com\/wordpress-to-airtable\/","title":{"rendered":"How to Automatically Send Post & Page Data from WordPress to Airtable"},"content":{"rendered":"\n

Automatically getting post and page data such as; author, title, word count, category etc. sent from WordPress to Airtable can prove incredibly useful as part of a content workflow process. So let me show you how to do just that.<\/p>\n\n\n\n

WordPress to Airtable Summary<\/h2>\n\n\n\n

What we are going to do is use my free plugin for WordPress called Post Webhook<\/a> to automatically send data to Airtable when we publish or delete a post or page. I’ll show you how to handle the data once it’s in Airtable and some examples of the powerful things you can do with the information.<\/p>\n\n\n\n

The data we are going to receive is; Author (display name), Post ID, Post Title, Post Date, Post Modified Date, Post GUID, Post Slug, Permalink, Post Type, Post Status, Post Categories, Post Tags and Post Word Count.<\/p>\n\n\n\n

You don’t need to use all of these data items, just ignore the ones you don’t want.<\/p>\n\n\n\n\n\n

Airtable Plan Limits & Screwed Up Pricing Model<\/h2>\n\n\n\n

Before we get into this article, if you are new to Airtable, I just want to mention how Airtables plan limits and pricing works because if you have a large team of writers you want to share your ‘Base’ with it may not be the solution for you.<\/p>\n\n\n\n

On the Free plan there is a limit of 5 users, 1,200 records (rows in your tables) per Base and 100 automation runs per month per Workspace. So in the context of this article, that’s 1200 posts in total and 100 Webhook ‘events’ per month. This will be OK for a lot of people and the 1st tier in the paid plan is only $10 per month and gives you 5,000 records and 5,000 automation runs per month.<\/p>\n\n\n\n

All good so far but here’s where the Airtable pricing model can be problematic (and insane if you ask me, because I’d imagine a lot of valuable mid-large customers leave Airtable because of it).<\/p>\n\n\n\n

If you have a team of writers and you want them to have more than just read only access, then be aware that if you need a paid plan because you need more than 1,200 records or 100 automation runs p\/m then you will have to pay for each user. So if you have 5 writers + 1 VA + You, that will run you a minimum of $70 per month, even though those writers will probably only have access to one view and do nothing more than change the status of an article they are writing.<\/p>\n\n\n\n

Anyway, now you are aware of the weird pricing model and you can make an informed choice about whether Airtable is right for you, let’s carry on with what we came here for.<\/p>\n\n\n\n

Step 1 – Create a Table in Airtable<\/h2>\n\n\n\n

If you don’t already have an Airtable account, go and open one. Everything we are about to do can be done in the free plan (but be mindful of what I mentioned above).<\/p>\n\n\n\n