All projects · Automation & Data Pipelines
Lead Finder — Google Places Location-Driven Pipeline & Website Routing (n8n)
An automated B2B lead generation pipeline in n8n that queries Google Places API (New) within a location-defined radius, handles multi-page…
An automated B2B lead generation pipeline in n8n that queries Google Places API (New) within a location-defined radius, handles multi-page pagination (3 batches of 20 places), normalizes raw places into a 9-column schema, deduplicates by Google Place ID, detects website presence, and partitions results into dual Google Sheets outputs with rate-limit pacing.
- Location-driven data pipeline: geocodes search location into coordinates to control circular Places search
- Multi-page pagination engine assembling 3 pages (60 raw places) into a unified data stream
- Deterministic Place ID deduplication ensuring 100% unique records in output spreadsheets
- Accurate website availability classification separating active websites from prime outreach targets
- Two-branch routing: direct append to Sheet 1 (with website) and 2-second rate-limited append to Sheet 2 (without website)
- Embedded zero-key pinned data (pinData) across all 9 nodes for instant offline testing and inspection
Built with: n8n, Google Places API (New), Google Geocoding API, Google Sheets API, JavaScript (Code Nodes), Pagination Engine, Data Deduplication