Discover and log project URLs in bulk with Firecrawl and Google Sheets

by May Zhan ✓ · 1 views · created 2026-08-12 · Market Research

What this workflow does

This workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.firecrawl.dev over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Get Sites from Sheet (Google Sheets): uses Google Sheets
2. Keep Unprocessed Sites (Filter): keeps only the items that match a condition
3. Loop Over Sites (Loop Over Items (Split in Batches)): loops over the items in batches
4. Prepare Site Data (Edit Fields (Set)): sets 2 fields: site_name, site_url
5. Firecrawl: Map Site (HTTP Request): calls api.firecrawl.dev (POST)
6. Filter Project URLs (Code): runs custom JavaScript code
7. Log Mapping Error (Google Sheets): append
8. Save Mapped URLs (Google Sheets): append or update
9. Mark Site as Error (Google Sheets): append or update
10. Mark Site as Done (Google Sheets): append or update

…plus 2 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: api.firecrawl.dev

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

Before you upgrade to n8n 3.0

Nodes used (9)

• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Filtern8n-nodes-base.filter
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• No Operation, do nothingn8n-nodes-base.noOp
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Waitn8n-nodes-base.wait

From the author

Quick Overview This workflow manually runs through a list of websites in Google Sheets, maps each site with the Firecrawl Map API to discover project/content URLs, and writes the filtered results back to Google Sheets while marking each source site as Done or…

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