Automated blog publishing with Google Trends, GPT-4, Pexels & WordPress
Ready for 3.0What this workflow does
This AI workflow has 20 nodes and runs on a schedule (every 25 minutes). Along the way it connects Google Sheets, OpenAI Chat Model and Wordpress. It also calls trends.google.it, quickchart.io and clipmint.pro over HTTP.
How it runs
Trigger: On a schedule (every 25 minutes).
- Main Config (Edit Fields (Set)): sets 1 field: min_traffic
- GoogleTrends (HTTP Request): calls trends.google.it
- XML: converts between XML and JSON
- Filter Scraped Keywords (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get row in sheet (Google Sheets): uses Google Sheets
- Append or update row in sheet (Google Sheets): append or update
- Grab one random keyword (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Update row in sheet (Google Sheets): update
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: trends.google.it, quickchart.io, clipmint.pro
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 (11)
- Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - XML
n8n-nodes-base.xml - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Wordpress
n8n-nodes-base.wordpress - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
This n8n template demonstrates how to automatically generate and publish blog posts using trending keywords, AI-generated content, and watermarked stock images. Use cases include maintaining an active blog with fresh SEO content, scaling content marketing…