Auto-draft WordPress posts from your Airtable 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.