Automate SEO research & content gap analysis with GPT-4o, SerpAPI, and Gmail

📘 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 data into a structured SEO dataset, analyzes search intent and competition, identifies content gaps and high-impact opportunities, and delivers client-ready insights via email while logging results for tracking and audits.

Instead of manual keyword research, competitive scanning, and reporting, the system derives actionable SEO strategy directly from live search behavior. Outputs are structured for UI consumption, professional email delivery, and historical storage in Google Sheets. Any workflow failure triggers an automated Slack alert with diagnostic details.

This workflow replaces manual SEO research, gap analysis, reporting, and documentation with a repeatable, automated SEO intelligence pipeline.

⚙️ What This Workflow Does (Step-by-Step)

🟢 Receive SEO Keyword Analysis Request via Webhook Accepts a POST request containing the target keyword for SEO analysis.

🧹 Extract Keyword from Request Payload Cleans and isolates the keyword field for SERP processing.

🌐 Run Google SERP Search for Keyword (India) Executes a live Google search via SerpAPI with India as the target region. Fetches: • Organic search results • Related searches • Video SERP features • Result count metadata

🧩 Normalize SERP Results into SEO Dataset Transforms raw SERP output into a structured dataset containing: • Rankings, titles, snippets, and sources • Video presence and platforms • Related search intent signals