Turn a content plan into WordPress drafts
Writes each planned topic with AI, saves it to WordPress as a draft, and records the link in your sheet.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
The integration steps this workflow runs, in the order it first runs them.
- 1Google SheetsCreate tab
- 2Google SheetsRead rows
- 3Google SheetsAppend row
- 4OpenAIQuery model
- 5WordPressCreate post
How it works
Everything the template sets up, and what to fill in before the first run.
Works down a spreadsheet of planned topics once a day. For each topic that has not been written yet, AI drafts the post body in your house style, the post is created in WordPress, and the topic, post ID and post link are recorded on a second tab of the same spreadsheet so the plan stays current.
Posts are created with the status 'draft', never published. Nothing written by AI goes live on your site until you have opened it in WordPress and pressed publish yourself.
Your plan tab needs a column headed Topic; each topic becomes the post title. An optional column headed Angle is passed to the writer as extra direction. Every other column is left alone - this workflow never writes to your plan tab.
The record of what has been drafted is what stops a re-run drafting the same topic twice, so it lives on its own tab ('Drafted Posts' by default, created on the first run) and is only ever appended to. A topic whose draft or WordPress call fails is left unrecorded and picked up on the next run.
Fill in 'planSpreadsheetUrl', 'planTabName' and 'audienceAndStyle' before the first run. 'maxNewDraftsPerRun' caps how many posts one run may write, so a long plan is worked through a few topics at a time.
You May Also Be Interested In
Approve the outline, then the post, then publishTakes the next topic off your content plan, asks you to approve the outline, writes the post to it, and publishes only if you say so.
Read a whole site into spreadsheet rowsFinds the pages on a site from its sitemap or front page, reads each one, and adds a row per page to your sheet.
Weekly Reddit mentions digestFinds posts about your product in the subreddits you watch, filters out the coincidences and emails a weekly digest.Find the problems your market keeps raisingReads the subreddits your customers use, groups the complaints that keep coming back, and emails the ones with real evidence.
Start from a workflow that already works.
Add "Turn a content plan into WordPress drafts" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required