Generate SEO blog drafts from Google Sheets to WordPress with OpenAI
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 45 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets, Gmail, OpenAI Chat Model and Wordpress. It also calls api.pexels.com over HTTP.
How it runs
Trigger: On a schedule (every day at 08:00).
- Get All Info Required from Sheets (Google Sheets): uses Google Sheets
- Check Rows Found (If): checks a condition and branches into true / false
- Loop for Each Row (Loop Over Items (Split in Batches)): loops over the items in batches
- Nothing to Process (Edit Fields (Set)): sets or maps fields
- Send Completion Email (Gmail): uses Gmail
- Current Row Context (Edit Fields (Set)): sets or maps fields
- Log Empty Run (Google Sheets): append
- Set Complete (Edit Fields (Set)): sets or maps fields
- SEO Blog AI Agent (AI Agent): runs an AI agent, with model: Blog Model, Fallback Blog Model; output parser: Blog JSON Output Parser
- Log Complete (Google Sheets): append
…plus 28 more steps. See the full node list below.
Services it uses
HTTP calls to: api.pexels.com
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 (13)
- Switch
n8n-nodes-base.switch - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Wordpress
n8n-nodes-base.wordpress
From the author
Description Generate SEO-friendly WordPress blog drafts from a Google Sheets queue using OpenAI. This workflow writes full HTML blog content, selects a relevant Pexels featured image with a second AI Agent, uploads the image to WordPress, creates the post as…