G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

Blog Automation Pipeline

End-to-end AI content pipeline. Runs SEO research via subworkflow, generates TOC and sections with Gemini AI agents, edits content, creates images, outputs to Sheets.

View on GitHub
workflowContent & SEOAI-PoweredContentSEO
Original
4by Roheel Jain
Nodes

32

Triggers

1

Platform

n8n

Tech Stack
Google Gemini AI
Google Gemini AI
SEO Subworkflow
Image Generation
Google Sheets
Google Sheets
Google Gemini
Google Gemini
Workflow

Table of Contents

agent

Generate the Content

agent

Merge

merge

Aggregate1

aggregate

Content Editor

agent

Google Gemini Chat Model

lmChatGoogleGemini

Google Gemini Chat Model1

lmChatGoogleGemini

Code in JavaScript

code

Google Gemini Chat Model2

lmChatGoogleGemini

Generate an image

googleGemini

Title Maker

googleGemini

Create the Sections

googleGemini

Article Description

googleGemini

Image Prompt

googleGemini

Alt_Text Maker

googleGemini

Message a model1

googleGemini

Message a model

googleGemini

Call 'XLRATE CORE | SEO RESEARCH'

executeWorkflow

Code in JavaScript1

code

Append row in sheet

googleSheets

Blog Request Form1

formTrigger

When Executed by Another Workflow

executeWorkflowTrigger

From list - Search Volume Trend

googleSheets

From list - PAA

googleSheets

From list - Organic Results

googleSheets

From list - Related Keywords

googleSheets

From list - Suggestions

googleSheets

From list - Keyword Ideas

googleSheets

Merge1

merge

Code in JavaScript2

code

Get row(s) in sheet

googleSheets

Slug

code

Mini Map
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
How It Works

Publishes SEO-optimized blog posts 10x faster. Give it a topic and it handles everything — keyword research, writing, image creation, and delivery to your Google Sheet for review.

1

You provide a topic

Enter a blog topic or keyword. The automation kicks off from there — no writing required on your end.

2

SEO research runs automatically

A dedicated sub-workflow analyzes search intent, finds related keywords, and builds an outline optimized for ranking.

3

AI writes the full draft

Google Gemini generates a complete blog post with proper headings, sections, and your brand voice baked in.

4

Content gets reviewed and refined

A second AI pass edits for clarity, fixes formatting, and ensures the content matches your tone guidelines.

5
Attached Files
workflow.json

Featured image is created

An AI image generator creates a relevant featured image for the post — no design tools needed.

6

Everything lands in your Google Sheet

The finished draft, image, SEO metadata, and suggested tags are delivered to a Google Sheet. Review and publish when ready.

What You'll Need

Google SheetsGoogle Gemini AI
  • Google account with Sheets access
  • Google Gemini API key (free tier works)
  • n8n Cloud account or self-hosted n8n instance

Optional integrations:

Image Generation

Estimated Cost per Run

USD 0.02 – 0.08 (Gemini API tokens + image generation per post)

This automation has 5 configurable settings you'll customize during setup.