Drafts each planned blog topic with AI, emails it to your reviewer, and records their decision in your sheet.
Uses
Google Sheets
OpenAI
Draft blog posts and email them for approval
Run every day.Run every day.
Set planSpreadsheetUrl to blank.Set planSpreadsheetUrl to blank.Set planTabName to blank.Set planTabName to blank.Set reviewerEmail to blank.Set reviewerEmail to blank.Set audienceAndStyle to blank.Set audienceAndStyle to blank.Set approvalLogTabName to Draft Approvals.Set approvalLogTabName to Draft Approvals.Set maxDraftsPerRun to 3.Set maxDraftsPerRun to 3.
If a step below fails, save the error as logTabErrorIf a step below fails, save the error as logTabErrorTry
Google SheetsCreate the tab approvalLogTabName in planSpreadsheetUrl.Create the tab approvalLogTabName in planSpreadsheetUrl.On error
Show in the output: Using the existing '@approvalLogTabName' tab: logTabError as text.Show in the output: Using the existing '@approvalLogTabName' tab: logTabError as text.Google SheetsRead the rows of planSpreadsheetUrl. Save it as approvalLog.Read the rows of planSpreadsheetUrl. Save it as approvalLog.
If approvalLog.headers is emptyIf approvalLog.headers is emptyYes
Google SheetsAdd a row to approvalLogTabName in planSpreadsheetUrl.Add a row to approvalLogTabName in planSpreadsheetUrl.No
No steps
Start an empty list and save it as reviewedTopics.Start an empty list and save it as reviewedTopics.
For each loggedTopic in approvalLog.rows:For each loggedTopic in approvalLog.rows:If a step below fails, save the error as loggedTopicErrorIf a step below fails, save the error as loggedTopicErrorTry
Add loggedTopic.Topic in lowercase to the end of reviewedTopics and save it as reviewedTopics.Add loggedTopic.Topic in lowercase to the end of reviewedTopics and save it as reviewedTopics.On error
Show in the output: Ignoring a row in '@approvalLogTabName' that has no Topic.Show in the output: Ignoring a row in '@approvalLogTabName' that has no Topic.Google SheetsRead the rows of planSpreadsheetUrl. Save it as plan.Read the rows of planSpreadsheetUrl. Save it as plan.Set draftsThisRun to 0.Set draftsThisRun to 0.For each plannedTopic in plan.rows:For each plannedTopic in plan.rows:If draftsThisRun is greater than or equal to maxDraftsPerRunIf draftsThisRun is greater than or equal to maxDraftsPerRunYes
Show in the output: Reached this run's limit of drafts. The rest of the plan is picked up on the next run..Show in the output: Reached this run's limit of 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 plannedTopic.Topic and save it as topic.Trim plannedTopic.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 reviewedTopics contains topic in lowercaseIf reviewedTopics contains topic in lowercaseYes
Show in the output: Already sent for approval, skipping: topic.Show in the output: Already sent for approval, 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 plannedTopic.Angle and save it as angle.Trim plannedTopic.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 as plain text an editor can read in an email. Open with a short introduction, put each section heading on its own line, and close with a brief conclusion. Aim for 600-900 words, use concrete examples, and do not invent statistics, quotes, customer names or links. Return only the post itself - no title line and no commentary before or after it.Set draft to blank.Set draft 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 draft.Trim the response text from the OpenAI “Ask OpenAI” step and save it as draft.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 draft is emptyIf draft 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 loggedNow to nothing.Set loggedNow to nothing.If a step below fails, save the error as logReadErrorIf a step below fails, save the error as logReadErrorTry
Google SheetsRead column 'A' of approvalLogTabName in planSpreadsheetUrl. Save it as loggedNow.Read column 'A' of approvalLogTabName in planSpreadsheetUrl. Save it as loggedNow.On error
Show in the output: Could not read the '@approvalLogTabName' tab, so '@topic' stays on the plan for the next run: logReadError as text.Show in the output: Could not read the '@approvalLogTabName' tab, so '@topic' stays on the plan for the next run: logReadError as text.Skip to the next item.Skip to the next item.If loggedNow.values contains topicIf loggedNow.values contains topicYes
Show in the output: Already waiting on another run's review, skipping: topic.Show in the output: Already waiting on another run's review, skipping: topic.Skip to the next item.Skip to the next item.No
No steps
If a step below fails, save the error as claimErrorIf a step below fails, save the error as claimErrorTry
Google SheetsAdd a row to approvalLogTabName in planSpreadsheetUrl.Add a row to approvalLogTabName in planSpreadsheetUrl.On error
Show in the output: Could not log '@topic' as awaiting review, so it stays on the plan for the next run: claimError as text.Show in the output: Could not log '@topic' as awaiting review, so it stays on the plan for the next run: claimError as text.Skip to the next item.Skip to the next item.Set approvalStatus to No answer.Set approvalStatus to No answer.Set reviewerNotes to blank.Set reviewerNotes to blank.If a step below fails, save the error as approvalErrorIf a step below fails, save the error as approvalErrorTry
Request approval: Approve the draft for @topic? Save it as review.Request approval: Approve the draft for @topic? Save it as review.
Who to ask: reviewerEmailApprove to record the draft as approved. Reject it, with a comment saying what you want changed, and it is recorded as changes requested. Nothing is published either way.
draftIf review.approved is yesIf review.approved is yesYes
Change approvalStatus to Approved.Change approvalStatus to Approved.Else if @review.timed_out is no
Change approvalStatus to Changes requested.Change approvalStatus to Changes requested.Otherwise
No steps
Trim review.comment and save it as reviewerNotes.Trim review.comment and save it as reviewerNotes.On error
Show in the output: The review of '@topic' could not be sent to reviewerEmail: approvalError as text.Show in the output: The review of '@topic' could not be sent to reviewerEmail: approvalError as text.Change approvalStatus to Not sent for review.Change approvalStatus to Not sent for review.Change reviewerNotes to approvalError.message.Change reviewerNotes to approvalError.message.If a step below fails, save the error as logErrorIf a step below fails, save the error as logErrorTry
Google SheetsAdd a row to approvalLogTabName in planSpreadsheetUrl.Add a row to approvalLogTabName in planSpreadsheetUrl.On error
Show in the output: Could not record the outcome for '@topic': logError as text.Show in the output: Could not record the outcome for '@topic': logError as text.If approvalStatus is Not sent for reviewIf approvalStatus is Not sent for reviewYes
Stop and report a problem: The review of '@topic' could not be sent to reviewerEmail, so the run stopped rather than use up more topics. Check 'reviewerEmail', then delete '@topic' from the '@approvalLogTabName' tab to have it drafted again.Stop and report a problem: The review of '@topic' could not be sent to reviewerEmail, so the run stopped rather than use up more topics. Check 'reviewerEmail', then delete '@topic' from the '@approvalLogTabName' tab to have it drafted again.No
No steps
Add 1 to draftsThisRun.Add 1 to draftsThisRun.