Create SEO-optimized WordPress posts from Google Sheets with OpenAI GPT-4o and DALL·E 3
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 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Wordpress, OpenAI, Google Sheets and OpenAI Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Rows from Sheets (Google Sheets): uses Google Sheets
- Batch Process Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Set SEO Parameters (Edit Fields (Set)): sets 4 fields: prompt, category, Primary Keywords…
- Content Generator Agent (AI Agent): runs an AI agent, with model: OpenAI GPT-4 Chat Model; output parser: Parse Structured Data
- OpenAI: uses OpenAI
- OpenAI: work with image
- Upload to wordpress media (HTTP Request): calls an HTTP API (POST)
- Draft Post in WordPress (Wordpress): uses Wordpress
- Update Google Sheets Row (Google Sheets): append or update
- Wait: waits 1 minutes
Services it uses
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 (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - Wordpress
n8n-nodes-base.wordpress - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI
@n8n/n8n-nodes-langchain.openAi - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Wait
n8n-nodes-base.wait - Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview Automatically generates SEO-optimized 'SEO-Writing.ai' Style 'Health and lifestyle' category WordPress blog drafts from a Google Sheet queue using Open AI (GPT-4o) for content and DALL·E 3 for featured images. How it works 1. Runs manually when…