Extracción de correos electrónicos comerciales de Google Maps a Google Sheets para generación de clientes potenciales
Avanzado
Este es unLead Generation, Multimodal AIflujo de automatización del dominio deautomatización que contiene 19 nodos.Utiliza principalmente nodos como Code, Wait, Filter, SplitOut, HttpRequest. Extraer direcciones de correo electrónico de negocios de Google Maps a Google Sheets para generación de leads
Requisitos previos
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
Nodos utilizados (19)
Categoría
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"meta": {
"instanceId": "95bbb5b970c767b3b6d7299c0acae6c888a5567209cf6474f05874e3c0844fea",
"templateId": "5385"
},
"nodes": [
{
"id": "47d741e7-a53f-40c7-bf7c-09a446b0d229",
"name": "Eliminar duplicados",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
1168,
544
],
"parameters": {
"options": {}
},
"typeVersion": 2
},
{
"id": "6cd049c8-425e-45e0-8d45-6a4883c2f496",
"name": "Iterar sobre elementos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
336,
848
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "3c3a3870-034d-4147-936a-4b0f19b7727d",
"name": "Esperar",
"type": "n8n-nodes-base.wait",
"position": [
512,
1056
],
"webhookId": "19cc6ed4-4fe7-485b-b879-c679e4b3374d",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "5f4ae91a-29c7-4fb3-b535-34bc5194b183",
"name": "Esperar1",
"type": "n8n-nodes-base.wait",
"position": [
496,
800
],
"webhookId": "0fe34756-6e43-4603-8891-5747a9a6500a",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "645bf31c-4b3c-4f4c-b90b-610fc2d6007c",
"name": "Separar",
"type": "n8n-nodes-base.splitOut",
"position": [
864,
800
],
"parameters": {
"options": {},
"fieldToSplitOut": "emails"
},
"typeVersion": 1
},
{
"id": "7e9c227c-2321-429a-a3f3-4c3a77bc6cf3",
"name": "Extraer correos electrónicos",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
688,
1056
],
"parameters": {
"jsCode": "const input = $input.first().json.data\nconst regex = /[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.(?!jpeg|jpg|png|gif|webp|svg)[a-zA-Z]{2,}/g\nconst emails = input.match(regex)\nreturn {json: {emails:emails}}"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "fb76c70c-385d-4e7f-93cd-43023690076a",
"name": "Extraer URLs",
"type": "n8n-nodes-base.code",
"position": [
832,
544
],
"parameters": {
"jsCode": "const input = $input.first().json.data\nconst regex = /https?:\\/\\/[^\\/\\s\"'>]+/g\nconst websites = input.match(regex)\nreturn websites.map(website => ({json:{website}}))"
},
"typeVersion": 2
},
{
"id": "b10c0ed6-5a94-4272-b65c-bd19bd674fa0",
"name": "Scrape Google Maps",
"type": "n8n-nodes-base.httpRequest",
"position": [
576,
544
],
"parameters": {
"url": "=https://www.google.com/maps/search/{{ $json.chatInput }}",
"options": {
"response": {
"response": {
"fullResponse": true
}
},
"allowUnauthorizedCerts": true
}
},
"typeVersion": 4.2
},
{
"id": "58a0d85d-f6eb-47d1-ba9c-3af69ddd30fb",
"name": "Scrape Site",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
336,
1056
],
"parameters": {
"url": "={{ $json.website }}",
"options": {
"redirect": {
"redirect": {}
}
}
},
"typeVersion": 4.2
},
{
"id": "4618e775-d14d-4355-b3a2-cd6a6bbc70e8",
"name": "Filtrar vacíos",
"type": "n8n-nodes-base.filter",
"position": [
672,
800
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "a6786c58-424a-409a-b87f-8a7592cb7944",
"operator": {
"type": "array",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.emails }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "74513e7e-a7dc-4b19-b23e-01efd82c9d6d",
"name": "Filtrar Google URLs",
"type": "n8n-nodes-base.filter",
"position": [
992,
544
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bf0a5053-9660-457c-9581-964793bb6d7d",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "schema"
},
{
"id": "9110b9e0-12aa-45cc-bde0-9eda8c10970e",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "google"
},
{
"id": "fb9b6ed6-96a5-4560-ab10-b8a4b9a61a2b",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "gg"
},
{
"id": "10500c0b-cdbd-4816-aba3-df60d69845dc",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.website }}",
"rightValue": "gstatic"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "035fbbe8-7758-4c7b-be8e-c1cba8fc48bc",
"name": "Eliminar duplicados (2)",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
1056,
800
],
"parameters": {
"options": {}
},
"typeVersion": 2
},
{
"id": "aa3e9285-235d-4fda-ab0e-45134cf825dd",
"name": "Agregar a Sheet (o como desees!)",
"type": "n8n-nodes-base.googleSheets",
"position": [
1264,
800
],
"parameters": {
"columns": {
"value": {
"emails": "={{ $json.emails }}"
},
"schema": [
{
"id": "emails",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "emails",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"emails"
]
},
"options": {
"useAppend": true
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fcijyZM1oU73i2xUbXYJ4j6RshmVEduOkCJji2SJP68/edit#gid=0",
"cachedResultName": "emails"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "10V7ikaGWmC-U73Z0sWOv1hfwbyMDvYNMS0lxlvA6C8c",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/10V7ikaGWmC-U73Z0sWOv1hfwbyMDvYNMS0lxlvA6C8c/edit?usp=drivesdk",
"cachedResultName": "GMaps Scrapers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "KGpn9qYCYQQErxFL",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "5ae34016-6347-474d-a95f-d8e2396fa5d0",
"name": "Cuando se recibe mensaje de chat",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
400,
544
],
"webhookId": "f24b6138-da02-4d9a-802f-bce12176a1e5",
"parameters": {
"options": {}
},
"typeVersion": 1.3
},
{
"id": "794a397c-b98f-4ac7-a149-efd94672f9a0",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
480
],
"parameters": {
"width": 466,
"height": 220,
"content": "## 🔎 Step 1: Google Maps Data Scraper"
},
"typeVersion": 1
},
{
"id": "221aae1d-3546-42a1-bb2b-f743e02a300f",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
816,
480
],
"parameters": {
"width": 544,
"height": 196,
"content": "## 🔗 Step 2: URL Filtering & Processing"
},
"typeVersion": 1
},
{
"id": "d914e291-db43-4c45-908d-7d20890294cc",
"name": "Nota adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
976
],
"parameters": {
"width": 528,
"height": 248,
"content": "## 🔄 Step 3: Smart Website Scraper"
},
"typeVersion": 1
},
{
"id": "a6a902be-648e-41cd-a4fe-00f50cabe78c",
"name": "Nota adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
720
],
"parameters": {
"width": 916,
"height": 248,
"content": "## 📧 Step 4: Email Extraction & Data Export\n\n\n"
},
"typeVersion": 1
},
{
"id": "ac1ba88f-3538-40e9-ad89-84a73da7d239",
"name": "Nota adhesiva5",
"type": "n8n-nodes-base.stickyNote",
"position": [
864,
976
],
"parameters": {
"width": 528,
"height": 240,
"content": "## 🚀 Get More Resources & Advanced Workflows\n\nFor additional resources, advanced automation tutorials, and business strategies that help you **generate more leads and grow your agency**, check out my website:\n\n## 👉 [Noman Mohammad](https://nomanmohammad.com)"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"3c3a3870-034d-4147-936a-4b0f19b7727d": {
"main": [
[
{
"node": "7e9c227c-2321-429a-a3f3-4c3a77bc6cf3",
"type": "main",
"index": 0
}
]
]
},
"5f4ae91a-29c7-4fb3-b535-34bc5194b183": {
"main": [
[
{
"node": "4618e775-d14d-4355-b3a2-cd6a6bbc70e8",
"type": "main",
"index": 0
}
]
]
},
"645bf31c-4b3c-4f4c-b90b-610fc2d6007c": {
"main": [
[
{
"node": "035fbbe8-7758-4c7b-be8e-c1cba8fc48bc",
"type": "main",
"index": 0
}
]
]
},
"58a0d85d-f6eb-47d1-ba9c-3af69ddd30fb": {
"main": [
[
{
"node": "3c3a3870-034d-4147-936a-4b0f19b7727d",
"type": "main",
"index": 0
}
]
]
},
"fb76c70c-385d-4e7f-93cd-43023690076a": {
"main": [
[
{
"node": "74513e7e-a7dc-4b19-b23e-01efd82c9d6d",
"type": "main",
"index": 0
}
]
]
},
"7e9c227c-2321-429a-a3f3-4c3a77bc6cf3": {
"main": [
[
{
"node": "6cd049c8-425e-45e0-8d45-6a4883c2f496",
"type": "main",
"index": 0
}
]
]
},
"6cd049c8-425e-45e0-8d45-6a4883c2f496": {
"main": [
[
{
"node": "5f4ae91a-29c7-4fb3-b535-34bc5194b183",
"type": "main",
"index": 0
}
],
[
{
"node": "58a0d85d-f6eb-47d1-ba9c-3af69ddd30fb",
"type": "main",
"index": 0
}
]
]
},
"47d741e7-a53f-40c7-bf7c-09a446b0d229": {
"main": [
[
{
"node": "6cd049c8-425e-45e0-8d45-6a4883c2f496",
"type": "main",
"index": 0
}
]
]
},
"74513e7e-a7dc-4b19-b23e-01efd82c9d6d": {
"main": [
[
{
"node": "47d741e7-a53f-40c7-bf7c-09a446b0d229",
"type": "main",
"index": 0
}
]
]
},
"4618e775-d14d-4355-b3a2-cd6a6bbc70e8": {
"main": [
[
{
"node": "645bf31c-4b3c-4f4c-b90b-610fc2d6007c",
"type": "main",
"index": 0
}
]
]
},
"b10c0ed6-5a94-4272-b65c-bd19bd674fa0": {
"main": [
[
{
"node": "fb76c70c-385d-4e7f-93cd-43023690076a",
"type": "main",
"index": 0
}
]
]
},
"035fbbe8-7758-4c7b-be8e-c1cba8fc48bc": {
"main": [
[
{
"node": "aa3e9285-235d-4fda-ab0e-45134cf825dd",
"type": "main",
"index": 0
}
]
]
},
"5ae34016-6347-474d-a95f-d8e2396fa5d0": {
"main": [
[
{
"node": "b10c0ed6-5a94-4272-b65c-bd19bd674fa0",
"type": "main",
"index": 0
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Generación de leads, IA Multimodal
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Extracción de correos electrónicos comerciales de listas de Google Maps para generación de clientes potenciales
Extraer direcciones de correo electrónico de negocios de listas de Google Maps para generación de leads
Code
Wait
Limit
+
Code
Wait
Limit
20 NodosJose Castillo
Generación de leads
Recolector de correos electrónicos de Google Maps mediante solicitudes HTTP y JavaScript
Sistema de generación de prospectos: de Google Maps a extractor de correos, exportando a Hojas de Google
Code
Wait
Limit
+
Code
Wait
Limit
19 NodosNick Saraev
Generación de leads
基于AIde潜在clientegeneración系统（correo electrónico个性化yLinkedIn）
基于AIde潜在clientegeneración系统：包含correo electrónico个性化yLinkedIn功能
If
Code
Limit
+
If
Code
Limit
51 NodosMatthieu
Generación de leads
Crear prospectos calificados y guiones de llamadas en frío usando LinkedIn, OpenAI y Sales Navigator
Crear leads cualificados y guiones para llamadas frías usando LinkedIn, OpenAI y Sales Navigator
If
Code
Limit
+
If
Code
Limit
47 NodosMatthieu
Generación de leads
Explorar nodos de n8n en la biblioteca de referencias visuales
Explorar nodos de n8n en la base de referencia visual
If
Ftp
Set
+
If
Ftp
Set
113 NodosI versus AI
Otros
Recopilación automatizada de datos de Leadfeeder y Apollo.io
Pipeline de enriquecimiento de prospectos: de Leadfeeder a Apollo y luego a Hojas de Google
If
Set
Code
+
If
Set
Code
23 NodosKhairul Muhtadin
Generación de leads
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos19
Categoría2
Tipos de nodos10
Descripción de la dificultad
Autor
Noman Mohammad
@nomanmohammadHi 👋 I'm Noman Mohammad. I do a lot of things, and AI is part of that work. If you have any questions about my templates or my n8n builds, feel free to ask, and I'll gladly reply in the comments. Thank you for reading.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo