Extract and analyze Google AI overviews with LLM for SEO recommendations
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets and OpenRouter Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Extract Webhook Data (Edit Fields (Set)): sets 4 fields: htmlContent, sources, extractedAt…
- Get URLs to Analyze (Google Sheets): uses Google Sheets
- Convert AI Overview to Markdown (Markdown): converts between Markdown and HTML
- Limit: keeps the first few items
- Save AI Overview to Sheets (Google Sheets): append or update
- myURL Exists (Filter): keeps only the items that match a condition
- Process URLs in Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Get Current URL Data (Edit Fields (Set)): sets or maps fields
- Fetch Page Content (HTTP Request): calls an HTTP API
- Convert Page Content to Markdown (Markdown): converts between Markdown and HTML
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (15)
- Webhook
n8n-nodes-base.webhook - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - HTML
n8n-nodes-base.html - Merge
n8n-nodes-base.merge - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Wait
n8n-nodes-base.wait - Limit
n8n-nodes-base.limit - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Markdown
n8n-nodes-base.markdown - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
From the author
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…