Extract and Analyze Google AI Overviews with LLM for SEO Recommendations

Description

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

Open n8n and navigate to Workflows
Click "Add workflow" → "Import from JSON"
Upload the AI_OVERVIES_EXTRACTOR_TEMPLATE.json file
Save the workflow

Step 2: Configure Google Sheets

Create Google Sheets Document

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=0#gid=0


Copy the Google Sheets URL (you'll need it for the workflow)

Set up Google Sheets Credentials

In n8n, go to Settings → Credentials
Click "Add credential" → "Google Sheets OAuth2 API"
Follow the OAuth setup to authorize n8n access to Google Sheets
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:
Set documentId to your Google Sheets URL
Set sheetName to your Google Sheets URL
Select your Google Sheets credential

Step 3: Configure AI Provider (OpenRouter)

Get OpenRouter API Key

Sign up at https://openrouter.ai/
Generate API key in your account settings
Add credits to your account

Set up OpenRouter Credentials

In n8n, go to Settings → Credentials
Click "Add credential" → "OpenRouter API"
Enter your API key
Name the credential (e.g., "OpenRouter AI Overview")

Configure OpenRouter Node

Select the Gemini 2.5 Pro Model node
Choose your credential from the dropdown
Verify the model (default: google/gemini-2.5-pro-preview)

Step 4: Install Browser Extension

Install in Chrome

Official Extension (Recommended)
Visit: https://chromewebstore.google.com/detail/ai-overview-extractor/cbkdfibgmhicgnmmdanlhnebbgonhjje
Click "Add to Chrome"

Install in Firefox

Official Add-on
Visit: https://addons.mozilla.org/en-US/firefox/addon/ai-overview-extractor/
Click "Add to Firefox"

Step 5: Configure Webhook Connection

Get Webhook URL

In n8n workflow, click on the Webhook node
Copy the webhook URL (should be like: http://localhost:5678/webhook/ai-overview-extractor-template-123456789)

Configure Extension

Go to Google Search and perform any search with AI Overview
Click the browser extension button (AI Overview Extractor)
In webhook configuration section, paste your webhook URL
Click "Test" - should show ✅ Test successful
Click "Save" to store the configuration

Step 6: Activate and Test

Activate Workflow

In n8n, toggle the workflow to "Active" (top right switch)
Verify all nodes are properly configured

Test End-to-End

Go to Google Search
Search for something that shows AI Overview
Use the extension to extract AI Overview
Send via webhook - check your Google Sheets for the data
Verify the markdown conversion worked correctly

Optional: Batch Analysis Setup

For SEO Analysis Features

In your Google Sheets, add URLs in the myURL column
Set task column to "create guidelines"
Run the workflow manually or wait for the 15-minute scheduler
Check guidelines column for AI-generated SEO recommendations

Troubleshooting

Webhook Issues
Ensure n8n is running on port 5678
Check if workflow is activated
Verify webhook URL format

Google Sheets Errors
Confirm OAuth credentials are working
Check sheet URL format
Verify column names match exactly
Ensure nodes Get URLs to Analyze, Save AI Overview to Sheets, and Save SEO Guidelines to Sheets are properly configured

OpenRouter Issues
Check API key validity
Ensure sufficient account credits
Try different models if Gemini 2.5 Pro fails
Verify the Gemini 2.5 Pro Model node is properly connected

Extension Problems
Check browser console for errors
Verify extension is properly installed
Ensure you're on google.com/search pages
Confirm webhook URL is correctly configured in extension

Next Steps

Customize AI prompts** in the Generate SEO Recommendations node for your specific needs
Adjust scheduler frequency** (default: 15 minutes)
Add more URL analysis** by populating Google Sheets
Monitor usage** and API costs

Support

GitHub Issues**: https://github.com/romek-rozen/ai-overview-extractor/issues
n8n Community**: https://community.n8n.io/
Template Documentation**: Check the included README files