Draft blog posts and email them for approval
Drafts each planned blog topic with AI, emails it to your reviewer, and records their decision in your sheet.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsCreate tabCreates the 'Draft Approvals' tab in your plan spreadsheet on the first run, or carries on with the existing one.
- 2Google SheetsRead rowsReads the approval log to find topics already reviewed or waiting, then reads your plan tab for the topics still to draft.
If
approvalLog.headersis empty- 3Google SheetsAppend rowAppends the log's header row when it is empty, then each topic as awaiting review and again with its status, reviewer notes and date.
- 3
For each
plannedTopic- 4OpenAIQuery modelAsks the AI to write the full post for one topic in your house style, following any angle on the row.
- 5Google SheetsRead columnReads the log's Topic column again just before each review request, so a topic another run has taken on is skipped.
- 6Google SheetsAppend row
- 4
How it works
What happens on each run, in plain English.
Once a day, the topics on your content plan that have not been through review yet are written up as blog posts by AI in your house style, and each full draft is emailed to your reviewer to approve or reject, from the email itself. The run waits for their answer, so nothing counts as done until a person has looked at it.
Each topic ends up as a draft in the reviewer's inbox and a row in a 'Draft Approvals' tab in the same spreadsheet: the topic, whether it was approved or changes were requested, the reviewer's notes and the date. Each topic is logged as awaiting review before the reviewer is asked and that log is checked again before each request, so a topic is never drafted twice, and a topic nobody answers is recorded as 'No answer' rather than resent. Your plan tab is only ever read, a topic whose draft fails is picked up next time, and nothing is published anywhere.
You need a plan tab with a 'Topic' column, optionally an 'Angle' column for extra direction, the reviewer's email address and a short description of your audience and house style.
You may also be interested in
Fill a spreadsheet with a ChatGPT-written list every hourEvery hour, has ChatGPT write a fresh batch of the list you describe and adds each item as a row in your Google Sheet.
Write blog posts from your content plan, with your sign-offTurns your content plan into blog posts: you approve the outline, then the finished post, before anything is published on WordPress.
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.
Get a weekly email of Reddit posts about your productEvery Monday, emails you the Reddit posts that mention your product, checked by AI so namesakes are filtered out, with links.Start from a workflow that already works.
Add "Draft blog posts and email them for approval" to your workspace, connect its apps, and make it yours.
Free plan, no credit card