Generate a hierarchical sitemap into Google Sheets with Firecrawl

See What's Earning in AI Automation Freelancing.
DigiNo helps new AI automation freelancers earn faster by tracking what clients actually pay for.

SEO clients need clean, structured URL audits fast — and manually building a hierarchical sitemap spreadsheet from a large site can take hours. This workflow automates the entire crawl-to-spreadsheet pipeline so you can deliver a polished audit deliverable in minutes.

What This Automation Does

Crawls any target website via Firecrawl and retrieves every available URL from its sitemap
Parses and groups URLs by domain and subdomain into a hierarchical table with up to 6 depth levels
Copies a Google Drive template file and appends the structured URL rows with clickable HYPERLINK formulas into a new Google Sheets spreadsheet
Validates the crawl response before proceeding, stopping the workflow cleanly if Firecrawl returns an error

Tools Used

n8n
Firecrawl
Google Drive
Google Sheets

Where to Get Hired for This Skill

On Contra, top freelancers across this stack have earned 112 combined verified reviews from real client projects.

Source: Contra freelancer search · refreshed 30 May 2026

Start Earning as a Freelancer on Contra

Contra is a commission-free professional network for independents. Browse live AI automation work and keep what you earn.

Join Contra Free →

How To Build It

Connect Firecrawl with a valid API key

Authenticate Firecrawl inside the workflow so it can map the target website's sitemap and return the full list of crawled URLs.

Set the Google Drive template file ID

Configure the workflow with the ID of a Google Drive spreadsheet template so a fresh copy is created for each client audit run rather than overwriting a shared file.

Validate the crawl response before processing

A conditional check confirms the Firecrawl response was successful before any data is written, so failed crawls surface a clear error message instead of producing an empty or corrupt spreadsheet.

Parse URLs into a six-level hierarchy with JavaScript

A custom JavaScript block groups the crawled URLs by domain and subdomain, structures them into depth levels from Niv 0 to Niv 5, and wraps each URL in a Google Sheets HYPERLINK formula ready for direct export.

Append structured rows to the copied Google Sheet

The fully parsed, hierarchical URL table is appended to the newly copied spreadsheet so the client receives a self-contained, labelled audit file they can act on immediately.

Pitfalls

Firecrawl API rate limits can silently truncate results on large sites — if a client's domain has thousands of URLs, the crawl may return a partial list without throwing an error, so always cross-check the output row count against the site's known page volume before delivering the audit.
Google OAuth tokens expire and the workflow will fail silently on a scheduled or repeat run — verify that both Google Drive and Google Sheets credentials are refreshed and that the connected account has write access to the destination folder before handing off to a client.
This workflow requires a self-hosted n8n instance because the Firecrawl community node is not available on n8n Cloud — confirm your hosting setup before quoting a client turnaround time, since provisioning a self-hosted environment adds lead time if you do not already have one running.

FAQ

Can I build this without coding?

Most of the workflow is visual configuration, but one step uses a custom JavaScript block to parse and structure URLs into the hierarchy. You do not need to write it from scratch, but you will need to read and adapt it if a client's URL structure is unusual.

How long does it take?

Once your self-hosted n8n environment is running and your Firecrawl and Google credentials are connected, the build typically takes two to three hours including testing across a couple of real client domains.

What can I charge?

Pricing is yours to set based on your positioning, but this deliverable fits naturally inside a technical SEO audit package or a site migration project where a structured URL inventory is a standard line item.

Which tool is required vs optional?

Firecrawl and Google Sheets are both required — Firecrawl handles the crawl and Google Sheets is the deliverable format. Google Drive is also required to copy the template file per run. There are no optional tools in this workflow; every connected service is load-bearing.

This is original DigiNo analysis. The underlying automation pattern is a community workflow template – view the original on n8n.