<aside> ⬇️

Download Free Workflow JSON and Sheet Template 👇

AI SEO Blog Writer Automation.json

Sheet Template: https://docs.google.com/spreadsheets/d/1c620GWsuUnB3jclLQTUtRRGgiDwTTEP5CG7ii4zbkCQ/copy

</aside>

<aside> ☕

Support My Work

I share all my automations, systems, and tutorials for free.

If you want to support my journey and help me create more, you can buy me a coffee:

👉 https://link.thesohailjafri.me/buymeacoffee

</aside>

TL;DR

This system automates SEO blog post generation, editing, and publishing using n8n, OpenRouter LLMs, Google Sheets, and Google Drive.

It converts raw titles + keywords into fully written, SEO-optimized blog articles with images and metadata.

System Overview

The AI SEO Blog Writer workflow automates content production from research to publication. It retrieves post ideas from Google Sheets, enriches them with keyword research, generates a full post using multiple OpenRouter AI agents, and publishes to Google Drive.

It runs in four major stages:

1. Content Research & Processing – Keyword analysis, search intent detection, and title refinement.
2. Content Creation – Outline generation, draft writing, assembly, and editing.
3. Finalization – Metadata, key takeaways, and image generation.
4. Publishing – Google Doc creation, SEO metadata insertion, and Drive sharing.

Input:

Output:

<aside> 💡

Want to Go Further? Join the School Community

If you want to go deeper, learn faster, and be part of a motivated community where we help each other grow, you can join my school community here

👉https://link.thesohailjafri.me/join-skool

Or Watch all my automation guides on Youtube

</aside>