Writes each planned topic with AI, saves it to WordPress as a draft, and records the link in your sheet.
Uses
Google Sheets
OpenAI
WordPress
Turn a content plan into WordPress drafts
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 draftLogTabErrorTry
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 emptyYes
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 loggedTopicErrorTry
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 maxNewDraftsPerRunYes
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 topicErrorTry
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 emptyYes
Skip to the next item.Skip to the next item.No
No steps
If alreadyDrafted contains topic in lowercaseIf alreadyDrafted contains topic in lowercaseYes
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 angleErrorTry
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 emptyYes
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 writingErrorTry
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 emptyYes
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 wordpressErrorTry
WordPressCreate the post topic. Save it as newPost.Create the post topic. Save it as newPost.draftHtmlOn 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 postLinkErrorTry
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 emptyYes
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.