Create and publish SEO blog posts using Google Sheets, Gemini/OpenAI, Ideogram, and WordPress
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 41 nodes and runs on a schedule (every day at 06:00). Along the way it connects Google Gemini Chat Model, DeepSeek Chat Model, Discord and OpenAI Chat Model and 1 more. It also calls script.google.com and api.ideogram.ai over HTTP.
How it runs
Trigger: On a schedule (every day at 06:00).
- Get_Post_Data (Google Sheets): uses Google Sheets
- Post_Loop (Loop Over Items (Split in Batches)): loops over the items in batches
- get_client_status (Google Sheets): uses Google Sheets
- client_active_check (If): checks a condition and branches into true / false
- PBN_Website_Access (HTTP Request): calls script.google.com (POST)
- Do the Research on the Topic (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- sitemap_crawl( internal_linking ) (HTTP Request): calls an HTTP API
- write_content (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- extract_title_body (Code): runs custom JavaScript code
- classify_category (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
…plus 22 more steps. See the full node list below.
Services it uses
HTTP calls to: script.google.com, api.ideogram.ai
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (15)
- Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - DeepSeek Chat Model
@n8n/n8n-nodes-langchain.lmChatDeepSeek - AI Agent
@n8n/n8n-nodes-langchain.agent - Aggregate
n8n-nodes-base.aggregate - HTTP Request
n8n-nodes-base.httpRequest - Discord
n8n-nodes-base.discord - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge
From the author
This workflow automates the complete blog publishing process. It removes manual work from content creation, image generation, category management, and WordPress publishing by using AI and n8n. It helps agencies, SEO teams, and content creators manage blogs at…