⚙️ Pipeline Parameters & Search Filter
Presets:
n8n Execution Canvas — Live Topology (9 Nodes)
IDLE · READY
1 item
When clicking 'Execute workflow'
manualTrigger
1 item
Set Variables1
set
1 item
Geocoding API (Coordinates)1
httpRequest
3 items
HTTP Request
POST places.google...
60 items
Code in JavaScript
dedupe & normalize
split
If
hasWebsite == true
true
42 items
Append row in sheet1
append: with-web
false
18 items
Wait
2s pacing buffer
18 items
Append row in sheet2
append: no-web
Geocoded Coordinates
30.2672°, -97.7431°
Austin, TX · Resolved via Google Geocoding
Total Places Ingested
60 leads
3 Paginated Batches · 20 per Page
Duplicates Filtered
0 purged
Deduped by Google Place ID (100% Unique)
High-Intent Web Prospects
18 leads (30%)
Zero Website Found · Prime Outreach Targets
Website Availability Partitioning (Conditional Routing Output)
● 42 With Website (70%) |
● 18 Without Website (30%)
| Place ID | Business Name | Address | Phone Number | Website | Rating | Status | Latitude | Longitude |
|---|
⚡ Automated Pipeline Diagnostics (8-Point Acceptance Suite)
ALL TESTS PASS (8/8)
1. User Search Parameters: businessType, location, radius, maxResults properly defined
PASS
2. Geocoding API: converts textual location into valid latitude & longitude
PASS
3. Google Places API (New): sends X-Goog-FieldMask with all 9 required attributes
PASS
4. Multi-Page Pagination: loops through 3 pages and aggregates raw place items
PASS
5. Place ID Deduplication: ensures 100% unique records with zero duplicate entries
PASS
6. Website Presence Classifier: accurately evaluates and assigns boolean hasWebsite flag
PASS
7. Conditional Two-Way Router: routes website leads to sheet1 and no-website leads to sheet2
PASS
8. Schema Parity & Rate Limit Buffer: identical 9-column headers across sheets with 2s wait
PASS