Templates / Generate a hierarchical sitemap from a URL into Google Sheets using Firecrawl

Generate a hierarchical sitemap from a URL into Google Sheets using Firecrawl

Unknown

by Allan Vaccarizi ✓ · 1,080 views · created 2025-08-14 · Market Research, Multimodal AI

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 7 nodes and runs when a chat message arrives. Along the way it connects Google Drive, Google Sheets and Firecrawl (community).

How it runs

Trigger: When a chat message arrives.

  1. Crawl Website and Get URLs (Firecrawl): map
  2. If: checks a condition and branches into true / false
  3. Copy Report Template in Drive (Google Drive): copy
  4. Stop on Firecrawl Failure (Stop and Error): stops the run with an error
  5. Organize URLs into Table Format (Code): runs custom JavaScript code
  6. Append URL Data to Sheets (Google Sheets): append

Services it uses

Google DriveGoogle SheetsFirecrawl (community)

Uses Firecrawl. New users get 10% off with our link.

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

  • Check that @mendable/n8n-nodes-firecrawl is verified or supports 3.0 (used in Crawl Website and Get URLs).

Nodes used (7)

From the author

📺 Full walkthrough video: https://youtu.be/yjeKYfZP0kU > ⚠️ Self-hosted only — This template uses a community node (@mendable/n8n-nodes-firecrawl) and cannot run on n8n Cloud. Who it's for This workflow is for SEO consultants, web agencies, and technical…

Excerpt from Allan Vaccarizi's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.