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”

THE WORKFLOW12 NODES
◷Schedule Trigger✦Copywriter AIAgent◆OpenAI Chat Model◐Simple Memory✦CopywriterRevision Agent≡Set Data{}Structured OutputParser▦Add GeneratedContent to Googl…▦Update TopicStatus on Google…▦Get Topic fromGoogle Sheets@Send Content forApproval⑂Approval Result
DIFFICULTY
Intermediate
NODES
12
USES AI
Yes
PUBLISHED
May 2025

001 / WHAT HAPPENS

  1. 01

    A schedule trigger runs and reads the next Pending topic from the Topic List sheet.

  2. 02

    A copywriter AI agent writes the blog draft with a structured output format.

  3. 03

    Gmail emails the draft to a reviewer with an approval form.

  4. 04

    A switch routes the answer: approve, ask for revisions or cancel.

  5. 05

    A revision agent rewrites the draft using the reviewer's feedback.

  6. 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? →

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→