Discover and enrich B2B leads with Google Places and Google Sheets

by Felipe Villamil · 0 views · created 2026-08-03 · Lead Generation

What this workflow does

This workflow has 18 nodes and runs when someone submits an n8n form (“Descubridor y enriquecedor B2B”). Along the way it connects Google Sheets. It also calls places.googleapis.com and customsearch.googleapis.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Descubridor y enriquecedor B2B”).

1. Procesar Formulario (Code): runs custom JavaScript code
2. Google Places - Text Search (HTTP Request): calls places.googleapis.com (POST)
3. Preparar negocios (Code): runs custom JavaScript code
4. Loop Over Items - Negocios (Loop Over Items (Split in Batches)): loops over the items in batches
5. Resumen final (Code): runs custom JavaScript code
6. ¿Tiene web oficial? (If): checks a condition and branches into true / false
7. Descargar web oficial (HTTP Request): calls an HTTP API
8. ¿Falta NIT? (If): checks a condition and branches into true / false
9. Extraer datos web (Code): runs custom JavaScript code
10. Buscar NIT en Google API (HTTP Request): calls customsearch.googleapis.com

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

Services it uses

Google Sheets

HTTP calls to: places.googleapis.com, customsearch.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (7)

• n8n Form Triggern8n-nodes-base.formTrigger
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets
• Waitn8n-nodes-base.wait

From the author

Quick overview This workflow collects B2B prospects by searching Google Places for a niche and location, then safely enriches each business by scraping its website (optionally respecting robots.txt) to extract contact details and social links, and upserts…

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