Extract and analyze Google AI overviews with LLM for SEO recommendations

How it works • Extract AI Overviews from Google Search - Receives data from browser extension via webhook • Convert HTML to Markdown - Automatically processes and cleans AI Overview content • Store in Google Sheets - Archives all extracted AI Overviews with metadata and sources • Generate SEO Guidelines - AI analyzes page content vs AI Overview to suggest improvements • Automate Analysis - Batch process multiple URLs and schedule regular checks Set up steps • Import workflow - Load the JSON template into your n8n instance (2 minutes) • Configure Google Sheets - Set up OAuth connection and create spreadsheet with required columns (5 minutes) • Set up AI provider - Add OpenRouter API credentials for Gemini 2.5 Pro (3 minutes) • Install browser extension - Deploy the companion Chrome/Firefox extension for data extraction (5 minutes) • Test webhook endpoint - Verify the connection between extension and n8n workflow (2 minutes) Total setup time: ~15 minutes What you'll need: - Google account for Sheets integration - Google Sheet template with required columns - OpenRouter API key for Gemini 2.5 Pro model access - Browser extension: Chrome Extension or Firefox Add-on - n8n instance (local or cloud) Use cases: - SEO agencies - Monitor AI Overview presence for client keywords - Content marketers - Analyze what content gets featured in AI Overviews - E-commerce - Track AI Overview coverage for product-related searches - Research - Build datasets of AI Overview content across different topics The workflow comes with a free browser extension (Chrome | Firefox) that automatically extracts AI Overview content from Google Search and sends it via webhook to your n8n workflow for processing and analysis. GitHub Repository: https://github.com/romek-rozen/ai-overview-extractor/ Detailed Setup Instructions - AI Overview Extractor Prerequisites - n8n instance (local or cloud) - version 1.95.3+ - Google account for Sheets integration - OpenRouter API account for Gemini 2.5 Pro access - Browser (Chrome/Firefox) for the extension Step 1: Import the Workflow 1. Open n8n and navigate to Workflows 2. Click "Add workflow" → "Import from JSON" 3. Upload the AIOVERVIESEXTRACTORTEMPLATE.json file 4. Save the workflow Step 2: Configure Google Sheets Create Google Sheets Document 1. Create new Google Sheet with these columns: extractedAt | searchQuery | sources | markdown | myURL | task | guidelines | key Here is public google sheet template: https://docs.google.com/spreadsheets/d/15xqZ2dTiLMoyICYnnnRV-HPvXfdgVeXowr8a7kU4uHk/edit?gid=0gid=0 2. Copy the Google Sheets URL (you'll need it for the workflow) Set up Google Sheets Credentials 1. In n8n, go to Settings → Credentials 2. Click "Add credential" → "Google Sheets OAuth2 API" 3. Follow the OAuth setup to authorize n8n access to Google Sheets 4. Name the credential (e.g., "Google Sheets AI Overview") Configure Google Sheets Nodes Update these nodes with your Google Sheets URL: - Get URLs to Analyze - Save AI Overview to Sheets - Save SEO Guidelines to Sheets In each node: 1. Set documentId to your Google Sheets URL 2. Set sheetName to your Google Sheets URL 3. Select your Google Sheets credential Step 3: Configure AI Provider (OpenRouter) Get OpenRouter API Key 1. Sign up at https://openrouter.ai/ 2. Generate API key in your account settings 3. Add credits to your account Set up OpenRouter Credentials 1. In n8n, go to Settings → Credentials 2. Click "Add credential" → "OpenRouter API" 3. Enter your API key 4. Name the credential (e.g., "OpenRouter AI Overview") Configure OpenRouter Node 1. Select the Gemini 2.5 Pro Model node 2. Choose your credential from the dropdown 3. Verify the model (default: google/gemini-2.5-pro-preview) Step 4: Install Browser Extension Install in Chrome Official Extension (Recommended) 1. Visit: https://chromewebstore.google.com/detail/ai-overview-extractor/cbkdfibgmhicgnmmdanlhnebbgonhjje 2. Click "Add to Chrome" Install in Firefox Official Add-on 1. Visit: https://addons.mozill