Generate SEO blog posts from Google Trends to WordPress with GPT & Perplexity AI
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every day). Along the way it connects OpenAI, Google Sheets and Wordpress. It also calls serpapi.com and api.perplexity.ai over HTTP.
How it runs
Trigger: On a schedule (every day).
- Get Google Trends (HTTP Request): calls serpapi.com
- Extract Top 2 Trends (Edit Fields (Set)): sets or maps fields
- Filter High Volume Keywords (Code): runs custom JavaScript code
- Select Best SEO Topic (OpenAI): uses OpenAI
- Research Reliable Sources (HTTP Request): calls api.perplexity.ai (POST)
- Convert Research Format (Edit Fields (Set)): sets 1 field: research
- Draft Blog Content (OpenAI): uses OpenAI
- Find Previous Posts (Google Sheets): uses Google Sheets
- Prepare Internal Link Dataset (Aggregate): combines items into one
- Insert Internal SEO Links (OpenAI): uses OpenAI
…plus 8 more steps. See the full node list below.
Services it uses
HTTP calls to: serpapi.com, api.perplexity.ai
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 (8)
- HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Aggregate
n8n-nodes-base.aggregate - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Wordpress
n8n-nodes-base.wordpress
From the author
Auto-generate SEO blog posts from Google Trends to WordPress This workflow provides complete blog automation from trend detection to publication. It eliminates manual content research, writing, and publishing by using AI agents, Google Trends analysis, and…