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

📺 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 teams who need to quickly audit or document a website's URL structure and export it into a clean, hierarchical spreadsheet.

How it works

1. A chat message is received containing the target website URL. 2. Firecrawl maps the website via its sitemap and retrieves all available URLs. 3. An IF node checks whether the Firecrawl response was successful; if not, the workflow stops with an error. 4. On success, a Google Drive template file is copied to serve as the destination spreadsheet. 5. A custom JavaScript node parses the crawled URLs, groups them by domain/subdomain, and structures them into a hierarchical table (up to 6 depth levels: Niv 0 to Niv 5) with HYPERLINK formulas. 6. The structured rows are appended to the copied Google Sheet.

How to set up

- [ ] Connect your Firecrawl credentials with a valid API key - [ ] Set the Google Drive template file ID to copy for each run - [ ] Connect your Google Sheets credentials and verify the target sheet name (FR) - [ ] Review the Organize URLs into Table Format code node if you need to adjust the depth logic or output columns