Auto-draft WordPress posts from your Airtable calendar
When a new row lands in your Airtable content calendar, the agent researches the topic and saves a ready-to-review draft in WordPress.
Airtable
WordPressMarketingContent GenerationBuild 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.
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.
FAQs
Will it publish posts to my site automatically?
What happens if I rerun it on a row that already has a draft?
Can I control which category and tags the post lands in?
Will it stuff the target keyword into the post?
Do I need a special WordPress plan?
Related templates
Every Thursday, rank your team's upcoming flights by how likely they are to run late, and email the fixes while changes are still cheap.
When a content calendar row is approved, each network gets its own version of the copy, scheduled to the right connected social profiles.
Every weekday we find your newly published articles, write separate LinkedIn, X, Instagram, and Threads posts, and schedule them across the day.
Mark a row Approved in your content calendar and the post is scheduled on every channel you picked, at the time you picked, with no copy pasting.
Every new community post, review or job listing gets scored against your policy, labeled by topic, and only the risky ones ever reach your team.
Every weekday at 8am, get five creator posts that are outperforming their own usual numbers, with a one line reason to back each one.
Stop writing first drafts from scratch.
Connect Airtable and WordPress once, and Geni turns each new calendar row into a ready-to-review blog draft.