Generate SEO content briefs with GPT-4o, DataForSEO keyword research & SERP analysis
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: SerpApi (Google Search). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs when a chat message arrives. Along the way it connects Google Sheets, OpenAI Chat Model and SerpApi (Google Search). It also calls api.dataforseo.com and hooks.slack.com over HTTP.
How it runs
Trigger: When a chat message arrives.
- Normalize Input (Edit Fields (Set)): sets 4 fields: intent, topic, content…
- Fetch Keyword Metrics from DataForSEO (HTTP Request): calls api.dataforseo.com (POST)
- AI Agent: runs an AI agent, with model: OpenAI GPT-4o-mini Model; 2 tools (SERP Analysis Tool, Retrieve Historical Content Context); memory: Short-Term Memory; output parser: Structured JSON Output Parser
- Calculate Quality Scores (Code): runs custom JavaScript code
- Validate Brief Quality (If): checks a condition and branches into true / false
- Generate HTML Preview (Code): runs custom JavaScript code
- Send Slack Quality Alert (HTTP Request): calls hooks.slack.com (POST)
- Store Brief with Version Control (Google Sheets): append or update
Services it uses
HTTP calls to: api.dataforseo.com, hooks.slack.com
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 SERP Analysis Tool: 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) SERP Analysis Tool | No direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node |
Nodes used (12)
- Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Edit Fields (Set)
n8n-nodes-base.set - SerpApi (Google Search)
@n8n/n8n-nodes-langchain.toolSerpApi - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code
From the author
📊 Description Generate high-quality, SEO-optimized content briefs automatically using AI, real-time keyword research, SERP intelligence, and historical content context. This workflow standardizes user inputs, fetches search metrics, analyzes competitors, and…