Turn a content plan into WordPress drafts

Once a day, the topics on your content plan spreadsheet are worked through a few at a time. For each topic not yet written, AI drafts the post body for the audience and house style you describe, taking any angle noted on the row, and the post is created in WordPress with the topic as its title.

You end up with drafts waiting in WordPress and a 'Drafted Posts' tab in the same spreadsheet recording each topic, its post id, its link and the date. Nothing is ever published: every post is saved as a draft for you to open, check and publish yourself. Your plan tab is only read, never written to, and the record tab is only ever appended to, so a later run never drafts the same topic twice. A topic whose draft or WordPress call fails is left unrecorded and picked up on the next run.

Your plan tab needs a column headed 'Topic', and can carry an optional 'Angle' column with extra direction for each post.

Run every day.Run every day.

Set planSpreadsheetUrl to blank.Set planSpreadsheetUrl to blank.

Set planTabName to blank.Set planTabName to blank.

Set audienceAndStyle to blank.Set audienceAndStyle to blank.

Set draftLogTabName to Drafted Posts.Set draftLogTabName to Drafted Posts.

Set maxNewDraftsPerRun to 5.Set maxNewDraftsPerRun to 5.

If a step below fails, save the error as draftLogTabErrorIf a step below fails, save the error as draftLogTabError

Try

Google SheetsCreate the tab draftLogTabName in planSpreadsheetUrl.Create the tab draftLogTabName in planSpreadsheetUrl.

On error

Show in the output: Did not create the '@draftLogTabName' tab, which is expected once it exists: draftLogTabError as text.Show in the output: Did not create the '@draftLogTabName' tab, which is expected once it exists: draftLogTabError as text.

Google SheetsRead the rows of planSpreadsheetUrl. Save it as draftLog.Read the rows of planSpreadsheetUrl. Save it as draftLog.

If draftLog.headers is emptyIf draftLog.headers is empty

Yes

Google SheetsAdd a row to draftLogTabName in planSpreadsheetUrl.Add a row to draftLogTabName in planSpreadsheetUrl.

No

No steps

Start an empty list and save it as alreadyDrafted.Start an empty list and save it as alreadyDrafted.

For each loggedPost in draftLog.rows:For each loggedPost in draftLog.rows:

If a step below fails, save the error as loggedTopicErrorIf a step below fails, save the error as loggedTopicError

Try

Add loggedPost.Topic in lowercase to the end of alreadyDrafted and save it as alreadyDrafted.Add loggedPost.Topic in lowercase to the end of alreadyDrafted and save it as alreadyDrafted.

On error

Show in the output: Ignoring a row in '@draftLogTabName' that has no Topic.Show in the output: Ignoring a row in '@draftLogTabName' that has no Topic.

Google SheetsRead the rows of planSpreadsheetUrl. Save it as plan.Read the rows of planSpreadsheetUrl. Save it as plan.

Set newDrafts to 0.Set newDrafts to 0.

For each plannedPost in plan.rows:For each plannedPost in plan.rows:

If newDrafts is greater than or equal to maxNewDraftsPerRunIf newDrafts is greater than or equal to maxNewDraftsPerRun

Yes

Show in the output: Reached this run's limit of new drafts. The rest of the plan is picked up on the next run..Show in the output: Reached this run's limit of new drafts. The rest of the plan is picked up on the next run..

Stop repeating.Stop repeating.

No

No steps

Set topic to blank.Set topic to blank.

If a step below fails, save the error as topicErrorIf a step below fails, save the error as topicError

Try

Trim plannedPost.Topic and save it as topic.Trim plannedPost.Topic and save it as topic.

On error

Show in the output: Skipping a row in '@planTabName' that has no Topic.Show in the output: Skipping a row in '@planTabName' that has no Topic.

If topic is emptyIf topic is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

If alreadyDrafted contains topic in lowercaseIf alreadyDrafted contains topic in lowercase

Yes

Show in the output: Already drafted, skipping: topic.Show in the output: Already drafted, skipping: topic.

Skip to the next item.Skip to the next item.

No

No steps

Set angle to blank.Set angle to blank.

If a step below fails, save the error as angleErrorIf a step below fails, save the error as angleError

Try

Trim plannedPost.Angle and save it as angle.Trim plannedPost.Angle and save it as angle.

On error

Change angle to blank.Change angle to blank.

Set brief to Topic: topic.Set brief to Topic: topic.

If angle isn't emptyIf angle isn't empty

Yes

Change brief to briefChange brief to brief Angle to take: angle.

No

No steps

Set prompt to You are writing one post for a company blog.Set prompt to You are writing one post for a company blog. Audience and house style: audienceAndStyle brief Write the finished post body. Return ONLY the body HTML - <h2>, <h3>, <p>, <ul> and <li> tags. Do not include an <h1>, a title line, a code fence, or any commentary before or after the HTML. Aim for 600-900 words, use concrete examples, and do not invent statistics, quotes, customer names, or links.

Set draftHtml to blank.Set draftHtml to blank.

If a step below fails, save the error as writingErrorIf a step below fails, save the error as writingError

Try

Trim the response text from the OpenAI “Ask OpenAI” step and save it as draftHtml.Trim the response text from the OpenAI “Ask OpenAI” step and save it as draftHtml.

On error

Show in the output: Could not draft '@topic': writingError as text.Show in the output: Could not draft '@topic': writingError as text.

If draftHtml is emptyIf draftHtml is empty

Yes

Show in the output: No draft text came back for '@topic'. It stays on the plan for the next run.Show in the output: No draft text came back for '@topic'. It stays on the plan for the next run.

Skip to the next item.Skip to the next item.

No

No steps

Set newPost to nothing.Set newPost to nothing.

If a step below fails, save the error as wordpressErrorIf a step below fails, save the error as wordpressError

Try

WordPressCreate the post topic. Save it as newPost.Create the post topic. Save it as newPost.draftHtml

On error

Show in the output: Could not create the WordPress draft for '@topic': wordpressError as text.Show in the output: Could not create the WordPress draft for '@topic': wordpressError as text.

Set postUrl to blank.Set postUrl to blank.

If a step below fails, save the error as postLinkErrorIf a step below fails, save the error as postLinkError

Try

Trim newPost.link and save it as postUrl.Trim newPost.link and save it as postUrl.

On error

Change postUrl to blank.Change postUrl to blank.

If postUrl is emptyIf postUrl is empty

Yes

Show in the output: No WordPress draft was created for '@topic'. It stays on the plan for the next run.Show in the output: No WordPress draft was created for '@topic'. It stays on the plan for the next run.

Skip to the next item.Skip to the next item.

No

No steps

Google SheetsAdd a row to draftLogTabName in planSpreadsheetUrl.Add a row to draftLogTabName in planSpreadsheetUrl.

Add topic in lowercase to the end of alreadyDrafted and save it as alreadyDrafted.Add topic in lowercase to the end of alreadyDrafted and save it as alreadyDrafted.

Add 1 to newDrafts.Add 1 to newDrafts.