Automate SEO research & content gap analysis with GPT-4o, SerpAPI, and Gmail
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Slack, Gmail and Google Sheets and 1 more.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Extract Keyword from Request Payload (Edit Fields (Set)): sets 1 field: body.keyword
- Slack: uses Slack
- Run Google SERP Search for Keyword (India) (Serp Api): uses Serp Api
- Normalize SERP Results into SEO Dataset (Code): runs custom JavaScript code
- Analyze Keyword SEO Opportunities (AI) (AI Agent): runs an AI agent, with model: LLM Engine for Market Intelligence Analysis; output parser: Parse Market Analysis Output JSON
- Flatten AI Output for Downstream Use (Code): runs custom JavaScript code
- Map SEO Fields for UI & Reporting (Code): runs custom JavaScript code
- Generate Client-Ready SEO Insights Email (AI) (AI Agent): runs an AI agent, with model: LLM Engine for Insight Formatting
- Log SEO Analysis Result to Google Sheets (Google Sheets): append
- Send SEO Opportunity Report via Email (Gmail): work with message
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-serpapi is verified or supports 3.0 (used in Run Google SERP Search for Keyword (India)).
Nodes used (11)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack - Edit Fields (Set)
n8n-nodes-base.set - Serp Api
n8n-nodes-serpapi.serpApi - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Webhook
n8n-nodes-base.webhook - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets
From the author
📘 Description This workflow automates keyword-level SEO research and content opportunity discovery using live Google SERP data and AI-driven analysis. It takes a single keyword request, pulls real-time search results for the India market, converts raw SERP…