Create SEO WordPress blog drafts from a Google Sheets queue with Gemini
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 30 nodes and runs on a schedule (every 7 days at 06:00). Along the way it connects Google Sheets, Gmail, Google Gemini Chat Model and Google Gemini and 1 more.
How it runs
Trigger: On a schedule (every 7 days at 06:00).
- Read Blog Queue from Sheets (Google Sheets): read (sheet)
- Select First Blog for Draft (Code): runs custom JavaScript code
- Set Blog Input Fields (Edit Fields (Set)): sets 15 fields: rowKey, STATUS, TOPIC…
- Fetch WordPress Post by Slug (HTTP Request): calls an HTTP API (GET)
- Check if Post Exists (If): checks a condition and branches into true / false
- Update Sheets for Existing Post (Google Sheets): update (sheet)
- Check Row Processing Status (If): checks a condition and branches into true / false
- Notify Existing Draft Reconciled (Gmail): send (message)
- Mark Row as Processing in Sheets (Google Sheets): update (sheet)
- Fetch WP Category by Slug (HTTP Request): calls an HTTP API (GET)
…plus 15 more steps. See the full node list below.
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 (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Split Out
n8n-nodes-base.splitOut - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Edit Image
n8n-nodes-base.editImage - Wordpress
n8n-nodes-base.wordpress
From the author
Quick overview This workflow runs weekly to turn a picked topic from Google Sheets into a validated SEO blog draft in WordPress using Google Gemini for article and image generation, then writes the draft metadata and image URLs back to the sheet and sends a…