Extract website intelligence & classify ecommerce URLs with Gemini & Firecrawl to Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: HTML Extract. 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| HTML Extract Extract HTML | HTML node, 'Extract HTML Content' operation |
Community nodes
These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
@mendable/n8n-nodes-firecrawl(Map a website and get urls)
Nodes used (8)
- Firecrawl
@mendable/n8n-nodes-firecrawl.firecrawl - n8n Form Trigger
n8n-nodes-base.formTrigger - HTTP Request
n8n-nodes-base.httpRequest - HTML Extract
n8n-nodes-base.htmlExtract - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini
What it does
Description This n8n template automates website analysis and ecommerce URL classification using AI. It scrapes a website, extracts business intelligence, maps all internal pages, and categorises them into products, categories, or non-commerce pages. All outputs are saved in Google Sheets for easy access. --- Use cases - Lead enrichment for sales and marketing teams - Ecommerce product & category discovery - Competitor website analysis - Website audits and content mapping - Market and industry research --- How it works 1. A user submits a website URL via an n8n form. 2. The homepage is scraped and cleaned. 3. AI extracts company insights (value proposition, industry, audience, B2B/B2C). 4. Firecrawl maps all internal URLs. 5. URLs are enriched with metadata. 6. AI classifies each URL as product, category, or other. 7. Results are written into structured Google Sheets tabs. --- How to use 1. Import the workflow into n8n. 2. Connect Google Sheets, Firecrawl, and AI credentials. 3. Update the Google Sheets document links. 4. Open the form URL and submit a website. 5. Let the workflow run and review the results in Sheets. --- Requirements - n8n (self-hosted or cloud) - Firecrawl API key - Google Gemini or compatible LLM credentials - Google Sheets account --- Customising this workflow - Change AI prompts to match your niche (SaaS, ecommerce, services). - Add filters to exclude unwanted URLs (blogs, legal pages, etc.). - Extend Sheets with scoring, tagging, or lead qualification logic. - Replace the LLM with another supported model if needed. --- What this template demonstrates - End-to-end website intelligence extraction - Safe, rule-based AI classification (no hallucinations) - Scalable URL processing with batching - Clean data pipelines into Google Sheets - Practical AI usage for real business workflows This template is designed to work out-of-the-box for website intelligence, ecommerce mapping, and lead research. Feel free to reach out for custom implementation or enhancements: 📧 Email: @dinakars2003@gmail.com