Extraction d'e-mails commerciaux de Google Maps vers Google Sheets pour la génération de prospects
Avancé
Ceci est unLead Generation, Multimodal AIworkflow d'automatisation du domainecontenant 19 nœuds.Utilise principalement des nœuds comme Code, Wait, Filter, SplitOut, HttpRequest. Extraire les adresses e-mail professionnelles de Google Maps vers Google Sheets pour la génération de leads
Prérequis
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (19)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"meta": {
"instanceId": "95bbb5b970c767b3b6d7299c0acae6c888a5567209cf6474f05874e3c0844fea",
"templateId": "5385"
},
"nodes": [
{
"id": "47d741e7-a53f-40c7-bf7c-09a446b0d229",
"name": "Supprimer les doublons",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
1168,
544
],
"parameters": {
"options": {}
},
"typeVersion": 2
},
{
"id": "6cd049c8-425e-45e0-8d45-6a4883c2f496",
"name": "Boucler sur les éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
336,
848
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "3c3a3870-034d-4147-936a-4b0f19b7727d",
"name": "Attendre",
"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": "Attendre1",
"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": "Diviser",
"type": "n8n-nodes-base.splitOut",
"position": [
864,
800
],
"parameters": {
"options": {},
"fieldToSplitOut": "emails"
},
"typeVersion": 1
},
{
"id": "7e9c227c-2321-429a-a3f3-4c3a77bc6cf3",
"name": "Extraire les e-mails",
"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": "Extraire les 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": "Filtrer les vides",
"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": "Filtrer 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": "Supprimer les doublons (2)",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
1056,
800
],
"parameters": {
"options": {}
},
"typeVersion": 2
},
{
"id": "aa3e9285-235d-4fda-ab0e-45134cf825dd",
"name": "Ajouter à la feuille (ou autre choix !)",
"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": "Quand un message chat est reçu",
"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": "Note adhésive",
"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": "Note adhésive1",
"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": "Note adhésive2",
"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": "Note adhésive3",
"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": "Note adhésive5",
"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
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Génération de leads, IA Multimodale
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Extraction d'e-mails commerciaux à partir de listes Google Maps pour la génération de prospects
Extraire les adresses e-mail professionnelles à partir des listes Google Maps pour la génération de leads
Code
Wait
Limit
+
Code
Wait
Limit
20 NœudsJose Castillo
Génération de leads
Collecteur d'e-mails Google Maps avec requêtes HTTP et JavaScript
Système de génération de prospects : de Google Maps vers un collecteur d'e-mails, exportation vers Google Sheets
Code
Wait
Limit
+
Code
Wait
Limit
19 NœudsNick Saraev
Génération de leads
基于AIde潜在clientgénération系统（e-mail个性化etLinkedIn）
基于AIde潜在clientgénération系统：包含e-mail个性化etLinkedIn功能
If
Code
Limit
+
If
Code
Limit
51 NœudsMatthieu
Génération de leads
Créer des prospects qualifiés et des scripts de démarchage froid avec LinkedIn, OpenAI et Sales Navigator
Créer des prospects qualifiés et des scripts pour des appels à froid via LinkedIn, OpenAI et Sales Navigator
If
Code
Limit
+
If
Code
Limit
47 NœudsMatthieu
Génération de leads
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
Collecte automatisée de données de Leadfeeder et Apollo.io
Pipeline d'enrichissement de prospects : de Leadfeeder vers Apollo puis vers Google Sheets
If
Set
Code
+
If
Set
Code
23 NœudsKhairul Muhtadin
Génération de leads
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds19
Catégorie2
Types de nœuds10
Description de la difficulté
Auteur
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.
Liens externes
Voir sur n8n.io →
Partager ce workflow