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
The integration steps this workflow runs, in the order it first runs them.
- 1Google SheetsCreate tab
- 2Google SheetsRead rows
- 3Google SheetsAppend row
- 4OpenAIQuery model
- 5GmailSend
How it works
Everything the template sets up, and what to fill in before the first run.
Works down your content plan once a day. For every topic that has not been through review yet, AI writes the post in your house style, the full draft is emailed to your reviewer, and the workflow then waits for them to approve it. Nothing counts as done until a person has answered.
Type approve to record the topic as approved. Type anything else and it is recorded as changes requested, with what you typed kept as the note. If nobody answers, the topic is recorded as 'No answer' - the draft is already sitting in the reviewer's inbox, so it is never lost, and the topic is not drafted a second time on the next run.
Your plan tab needs a column headed Topic; each topic becomes one post. 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.
Every decision is appended to its own tab ('Draft Approvals' by default, created on the first run) with the topic, the status, the reviewer's notes and the date. That log is what stops a re-run drafting the same topic twice, so a topic is only ever written up again if you remove its row. A topic whose draft or email fails is left unlogged and picked up next time.
Fill in 'planSpreadsheetUrl', 'planTabName', 'reviewerEmail' and 'audienceAndStyle' before the first run. 'maxDraftsPerRun' caps how many topics one run may put through review, because each one waits for a person.
You May Also Be Interested In
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.
Send sentiment-aware emails with couponsEmails each customer about their purchase in your tone, reads their feedback first, and adds a coupon when the feedback is negative.
Audit one page's on-page SEO and email the fixesAudits the on-page SEO of a page you name each week and emails what to fix, in priority order.
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. No credit card required.
Free plan available · No credit card required