Generate SEO landing page content with GPT-4, Reddit, YouTube and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, SerpApi (Google Search), Reddit and YouTube and 2 more.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Workflow Configuration (Edit Fields (Set)): sets 10 fields: serviceType, targetAudience, industry…
- Fetch Reddit Discussions (Reddit): search
- Fetch YouTube Videos (YouTube): work with video
- Fetch Industry News API (HTTP Request): calls an HTTP API
- Combine Research Data (Merge): merges the data from its input branches
- Aggregate Insights (Code): runs custom JavaScript code
- SEO Content Generator Agent (AI Agent): runs an AI agent, with model: OpenAI GPT-; 2 tools (Wikipedia, Google Search for SEO Research); output parser: Structured Content Output
- Convert to HTML (Markdown): converts between Markdown and HTML
- Save to Google Sheets (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- SerpApi (Google Search) in Google Search for SEO Research: no direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node.
| Removed in 3.0 | Replace with |
|---|---|
| SerpApi (Google Search) Google Search for SEO Research | No direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node |
Nodes used (14)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - SerpApi (Google Search)
@n8n/n8n-nodes-langchain.toolSerpApi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Markdown
n8n-nodes-base.markdown - Reddit
n8n-nodes-base.reddit - YouTube
n8n-nodes-base.youTube - HTTP Request
n8n-nodes-base.httpRequest - Wikipedia
@n8n/n8n-nodes-langchain.toolWikipedia - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
How It Works This workflow automates SEO content creation by aggregating multi-source research and generating optimized articles. Designed for content marketers, SEO specialists, and digital agencies, it solves the time-consuming challenge of researching…