Extract website intelligence & classify ecommerce URLs with Gemini & Firecrawl to Google Sheets

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.