Airtable to WordPress: auto-draft blog posts from your content calendar

Build an agent workflow that turns my Airtable content calendar into ready-to-review WordPress drafts.

Trigger: poll Airtable for a new record (event type new_record) in my Content Calendar table. Each row carries a working title, a target keyword, a target audience, and a desired word count. There are also optional columns for categories and tags that should be passed through if present, and a Draft URL column the workflow will fill in.

When a new row appears, the agent should do the following:

1. Skip the row entirely if its Draft URL column is already populated, so reruns and backfills are safe.

2. Research the topic using the working title, the target keyword, and the target audience as context.

3. Draft a full SEO-friendly blog post. It should include a compelling final title, a meta description, an intro, a clear H2 and H3 outline, the body, and a conclusion. Aim for the desired word count on the row. Treat the target keyword as a soft constraint, not a stuffing requirement. Write naturally and weave it in where it fits.

4. Call the WordPress Create a Post action with status set to draft. Populate the title, the HTML content, the excerpt or meta description, and any categories and tags pulled from the Airtable row. Never publish directly. A human reviews every post in WordPress before it goes live.

5. Use the Airtable Update Record action to write the new draft URL back to the source row and set its status to Draft Ready, so the calendar always reflects what is queued for review.

Integrations: Airtable (poll trigger plus Update Record) and WordPress (Create a Post). Keep WordPress categories and tags configurable via columns on the same Airtable row, and assume the user wants drafts only, not auto-publishing.

Additional information

What does this prompt do?

Watches your Airtable content calendar for new rows with a working title, target keyword, audience, and word count.
Researches the topic and writes a full SEO-friendly blog post with a compelling title, meta description, intro, H2 and H3 structure, body, and conclusion.
Saves the post as a draft in WordPress so a human can review and publish on their own schedule.
Writes the draft link and a Draft Ready status back to the same Airtable row, and skips rows that already have a draft.

What do I need to use this?

An Airtable base with a Content Calendar table
A WordPress site you can log into as an admin
Columns on the calendar for working title, target keyword, audience, and word count (categories and tags are optional)

How can I customize it?

Point it at a different table or rename the columns that feed the brief.
Add Categories and Tags columns to the row and the agent will file each post for you.
Tune the voice, tone, and word count target row by row.
Switch the WordPress status from draft to publish if you want it to ship without review.

Frequently asked questions

Will it publish posts to my site automatically?

No. By default every post is saved as a draft in WordPress so you can review and edit before it goes live. You can change that behavior if you want.

What happens if I rerun it on a row that already has a draft?

It skips any row that already has a draft URL filled in, so you can safely add new rows without worrying about duplicate posts.

Can I control which category and tags the post lands in?

Yes. Add Categories and Tags columns to your Airtable row and the agent will pass those values straight into the WordPress draft.

Will it stuff the target keyword into the post?

No. The keyword is used as a soft SEO guide, not a stuffing requirement. The agent writes naturally and weaves the keyword in where it fits.

Do I need a special WordPress plan?

Any self-hosted WordPress site that supports Application Passwords will work. You just need an admin login and your site URL.