WordPress blog automation: AI SEO content, images, scheduling & email alerts
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs on a schedule (every day at 04:00). Along the way it connects Wordpress, Google Sheets, OpenAI and Gmail. It also calls res.cloudinary.com over HTTP.
How it runs
Trigger: On a schedule (every day at 04:00).
- Get post information from Spreadsheet (Google Sheets): uses Google Sheets
- Compare date of spreadsheet and todays (If): checks a condition and branches into true / false
- Edit Fields (Edit Fields (Set)): sets 18 fields: Date to be published, Primary keyword, Secondary keyword…
- GET information from sitemap (HTTP Request): calls an HTTP API
- XML: converts between XML and JSON
- Split Out: splits a list into separate items
- Aggregate: combines items into one
- Generate all the necessary information of post (OpenAI): uses OpenAI
- Code: runs custom JavaScript code
- Send to Wordpress (Wordpress): uses Wordpress
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: res.cloudinary.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 (14)
- Aggregate
n8n-nodes-base.aggregate - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Split Out
n8n-nodes-base.splitOut - XML
n8n-nodes-base.xml - Code
n8n-nodes-base.code - Wordpress
n8n-nodes-base.wordpress - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - Edit Image
n8n-nodes-base.editImage - HTML
n8n-nodes-base.html - Gmail
n8n-nodes-base.gmail
From the author
Description: This workflow fully automates your blog publishing process using n8n, AI, and WordPress. It pulls blog data from Google Sheets, generates SEO-optimized content with AI, creates feature images, sets meta titles & descriptions, uploads everything…