Generate SEO blog content with GPT-4, Perplexity & WordPress auto-publishing
Ready for 3.0What this workflow does
This AI workflow has 20 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI, Google Sheets and Wordpress.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Edit Fields (Edit Fields (Set)): sets 4 fields: keyword, search intent, related keyword…
- Research (Perplexity): uses Perplexity
- research data (Code): runs custom JavaScript code
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- structure (OpenAI): uses OpenAI
- Code: runs custom JavaScript code
- Set KWs and Insights fields (Edit Fields (Set)): sets 12 fields: search_intent, hidden_insight, target_audience…
- blog tittle (OpenAI): uses OpenAI
- genrate key takeaways (OpenAI): uses OpenAI
…plus 9 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 (7)
- Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Perplexity
n8n-nodes-base.perplexity - Wordpress
n8n-nodes-base.wordpress
From the author
This n8n workflow automates the creation of high-quality, SEO-optimized blog posts using AI. It pulls keyword data from Google Sheets, conducts research via Perplexity AI, generates structured content (title, introduction, key takeaways, body, conclusion, and…