PICKED FROM N8N.IO · MARKETING & REVIEWS
Each run picks a Pending topic from a Google Sheet, and an OpenAI-powered agent writes a blog post of roughly 800 to 1200 words. The draft is emailed for approval. If the reviewer asks for changes, a second agent revises it. Approved content is saved to a second sheet and the topic is marked done.
Template by Billy Christi · 25.4k views on n8n.io · listed there as “Automate blog content creation with OpenAI, Google Sheets & email approval flow”
- DIFFICULTY
- Intermediate
- NODES
- 12
- USES AI
- Yes
- PUBLISHED
- May 2025
001 / WHAT HAPPENS
- 01
A schedule trigger runs and reads the next Pending topic from the Topic List sheet.
- 02
A copywriter AI agent writes the blog draft with a structured output format.
- 03
Gmail emails the draft to a reviewer with an approval form.
- 04
A switch routes the answer: approve, ask for revisions or cancel.
- 05
A revision agent rewrites the draft using the reviewer's feedback.
- 06
Approved content is added to the Generated Content sheet and the topic status is updated.
WHO IT SUITS
Suits a small business that wants regular blog drafts but has one person to review them, not a full content team.
CONNECTS
- Google Sheets
- OpenAI
- Gmail
002 / BEFORE YOU USE IT HERE
- !Topic text goes to OpenAI in the US. Keep customer names and personal details out of topics, or mention overseas AI providers in your privacy policy under APP 8.
- !The sheet needs the exact tabs and columns the template expects (Topic List with Topic and Status, and Generated Content), so copy the author's template first.
- !AI drafts need a human edit for local facts, spelling and claims before publishing. Keep the approval email going to a real person.
LOCAL SWAP
Swap Gmail for the Microsoft Outlook node if you use Microsoft 365.
Need n8n and the AI hosted in Australia? →003 / MORE FOR MARKETING & REVIEWS
- 13 NODESAI
MARKETING & REVIEWS
Draft LinkedIn posts from a Google Sheet with email approval
Google SheetsOpenAIGmailLinkedInIntermediateby Aryan Shinde46.7k views - 6 NODESAI
MARKETING & REVIEWS
Post to Instagram from Google Drive with AI-written captions
Google DriveGoogle SheetsOpenAIInstagramIntermediateby Sagar11.2k views - 4 NODESAI
MARKETING & REVIEWS
Classify customer feedback sentiment with OpenAI and Google Sheets
OpenAIGoogle Sheetsn8n FormBeginnerby MilanWR10.3k views
004 / QUESTIONS
Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.
Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.
We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.
Book a free call→