AI Workflow · Marketing

AI Blog Writer — A Content Pipeline That Never Misses a Week

Drop topic ideas into a spreadsheet; this workflow turns them into complete, structured blog posts — researched, written and filed ready to publish.

Trigger: Schedule 14 nodes

This is the real workflow. Click to pan and zoom the canvas.

Content marketing works when it is consistent, and consistency is exactly what this pipeline delivers. You keep a simple Google Sheet of topics; on schedule, the workflow picks the next one, has an AI agent research and write a full structured article, and saves the finished draft back ready for review and publishing. It is a complete editorial assembly line: ideas go in one end, publish-ready drafts come out the other — every week, without anyone having to find writing time.

What it connects

OpenRouter (AI models)GmailSchedulerGoogle SheetsAI AgentConversation Memory

KEY FEATURES

  • Topic queue managed in a simple Google Sheet
  • AI agent researches and writes complete structured articles
  • Runs on schedule — your content calendar fills itself
  • Drafts saved for human review before anything goes live
  • Extensible: add SEO scoring, images or auto-publishing

Want this running in your business?

Every Awesomate hosting plan comes with your own private n8n instance. Deploy this workflow from our template library in one click — or have our team build it for you.

Get your automation hub →