Automate SEO-Optimized WordPress posts with AI & Google Sheets
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 15 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenAI, Wordpress and OpenRouter Chat Model. It also calls url over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get context (Google Sheets): uses Google Sheets
- Set context (Edit Fields (Set)): sets 1 field: prompt
- Generate article (OpenAI): uses OpenAI
- Generate title (OpenAI): uses OpenAI
- Add draft to WP (Wordpress): uses Wordpress
- Generate image (OpenAI): work with image
- Upload image (HTTP Request): calls url (POST)
- Set image (HTTP Request): calls an HTTP API (POST)
- Update Sheet (Google Sheets): update
- SEO Expert (Basic LLM Chain): sends a prompt to an LLM, with model: OpenRouter Chat Model; output parser: Structured Output Parser
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: url
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 (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Wordpress
n8n-nodes-base.wordpress - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
From the author
This workflow automates the process of creating a complete SEO-optimized blog post, including generating content, titles, images, and meta tags, and publishing it on WordPress. It leverages AI models (like DeepSeek and OpenRouter) for content generation and…