Générateur automatisé de prospects commerciaux locaux basé sur l'IA, les médias sociaux et les liens WhatsApp
Avancé
Ceci est unLead Generation, Multimodal AIworkflow d'automatisation du domainecontenant 29 nœuds.Utilise principalement des nœuds comme If, Code, Limit, SplitOut, Telegram. Génération automatique de prospects commerciaux locaux avec IA, médias sociaux et liens WhatsApp
Prérequis
- •Token Bot Telegram
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (29)
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
{
"id": "4Gt0UvB5ArkeE7Hi",
"meta": {
"instanceId": "0d045f8fe3802ff2be0bb9a9ea445ee6c9ed61973377effe00767e483681e2f4",
"templateCredsSetupCompleted": true
},
"name": "Automated Local Business Lead Generator with AI, Social Media & WhatsApp Links",
"tags": [],
"nodes": [
{
"id": "e1e728f2-c48b-493b-8d73-0f72993083cd",
"name": "Requête HTTP",
"type": "n8n-nodes-base.httpRequest",
"position": [
420,
0
],
"parameters": {
"url": "https://serpapi.com/search",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "api_key",
"value": "YOUR_SERPAPI_KEY"
},
{
"name": "engine",
"value": "google_maps"
},
{
"name": "type",
"value": "search"
},
{
"name": "google_domain",
"value": "google.com"
},
{
"name": "q",
"value": "={{ $json.keyword }} {{ $json['city or specific location'] }}"
},
{
"name": "gl",
"value": "={{ $json['country code'] }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "efd6137c-6c9a-482c-92e4-e4691361be26",
"name": "Chaîne LLM de base",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1720,
-100
],
"parameters": {
"text": "=Business Information:\n\nName: {{ $json.title }}\nAddress: {{ $json.address }}\nRating: {{ $json.rating }} (based on {{ $json.reviews }} reviews)\nTypes: {{ $json.types }}\nPhone: {{ $json.phone }}\nWebsite: {{ $json.website }}\nReviews Link: {{ $json.reviews_link }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=You are a digital business consultant. Based on the business information below, write a professional message directly addressed to the business owner.\nThe message should include:\n\nA brief summary of how the business is currently positioned (based on business type and typical customers)\nWhat customers likely appreciate most about the business\nAreas that could be improved for better visibility, engagement, or conversions\nOne actionable suggestion or opportunity for growth\nA short, persuasive closing line or CTA inviting them to improve their online presence or marketing strategy\nUse a helpful and respectful tone as if offering a free evaluation. Write in the language corresponding to the country code: {{ $('Get row(s) in sheet').item.json['country code'] }}."
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "933599b0-9cd8-4719-8c58-d3c6bae7c720",
"name": "Ajouter ou mettre à jour une ligne dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
860,
0
],
"parameters": {
"columns": {
"value": {
"phone": "={{ \"https://wa.me/\" + $json.phone.replace(/\\D/g, \"\") }}",
"title": "={{ $json.title }}",
"types": "={{ $json.types }}",
"rating": "={{ $json.rating }}",
"address": "={{ $json.address }}",
"data_id": "={{ $json.data_id }}",
"reviews": "={{ $json.reviews }}",
"website": "={{ $json.website }}",
"reviews_link": "={{ $json.reviews_link }}"
},
"schema": [
{
"id": "data_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "data_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews",
"type": "string",
"display": true,
"required": false,
"displayName": "reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_link",
"type": "string",
"display": true,
"required": false,
"displayName": "reviews_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "types",
"type": "string",
"display": true,
"required": false,
"displayName": "types",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website",
"type": "string",
"display": true,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "review_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_1_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_1_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tiktok",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "tiktok",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "web_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "web_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_2_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_2_status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"data_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1321933612,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=1321933612",
"cachedResultName": "results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Automated Local Business Lead Generator using AI, Gmail & Telegram"
}
},
"typeVersion": 4.6
},
{
"id": "9eb71830-c068-4121-98fb-2fea45840451",
"name": "Envoyer un SMS",
"type": "n8n-nodes-base.telegram",
"position": [
2540,
160
],
"webhookId": "73212779-f86d-4e82-bdd2-605adac6069f",
"parameters": {
"text": "=----\n\nLatest Data for Follow Up\n\nBusiness Name: {{ $('Limit').item.json.title }}\nBusiness Types : {{ $('Limit').item.json.types }}\nLocation: {{ $('Limit').item.json.address }}\n\nWhatsapp Link: \n{{ $('Limit').item.json.phone }}\n\n----",
"chatId": "YOUR_TELEGRAM_CHAT_ID",
"additionalFields": {
"appendAttribution": false
}
},
"typeVersion": 1.2
},
{
"id": "692059f0-ee24-409e-8f0c-1169404e4831",
"name": "Déclencheur programmé",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
20,
0
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "bfbc2bdb-f14a-4788-8775-2459caae979d",
"name": "Obtenir une ou plusieurs lignes de la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
220,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Automated Local Business Lead Generator using AI, Gmail & Telegram"
}
},
"typeVersion": 4.6
},
{
"id": "0ece857b-9e1e-4dc2-b368-71226683bd70",
"name": "Modèle de chat OpenRouter",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1720,
80
],
"parameters": {
"model": "google/gemini-2.0-flash-exp:free",
"options": {}
},
"typeVersion": 1
},
{
"id": "71fea344-66b3-4042-aa2b-424b6d50bfb5",
"name": "Si possède un site web",
"type": "n8n-nodes-base.if",
"position": [
2260,
-100
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6a19bdfe-33c6-4786-897a-1d292f647db6",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Limit').item.json.website }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0a4385ce-7460-43eb-99ba-2552e90f2b7f",
"name": "Ajouter ou mettre à jour une ligne dans la feuille1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2960,
-680
],
"parameters": {
"columns": {
"value": {
"tiktok": "={{ $json.tiktok }}",
"data_id": "={{ $('Limit').item.json.data_id }}",
"instagram": "={{ $json.instagram }}"
},
"schema": [
{
"id": "data_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "data_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reviews_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "types",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "types",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "review_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_1_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_1_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tiktok",
"type": "string",
"display": true,
"required": false,
"displayName": "tiktok",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "web_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "web_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_2_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_2_status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"data_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1321933612,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=1321933612",
"cachedResultName": "results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Automated Local Business Lead Generator using AI, Gmail & Telegram"
}
},
"typeVersion": 4.6
},
{
"id": "ff892256-4826-4d6b-a467-c25ac1feed85",
"name": "Chaîne LLM de base1",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
2960,
-220
],
"parameters": {
"text": "=Business name: {{ $('Limit').item.json.title }}\nWebsite URL: {{ $('Limit').item.json.website }}\nWebsite content: {{ $('HTTP Request1').item.json.data }}\n",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=Please help create a professional message to the business owner based on the following website content. Focus on a brief analysis and improvement suggestions, and conclude with an invitation to discuss with our digital agency.\n\nFormat the message like this:\n---\n\nWe visited [business name]'s website and found that [...].\n[Paragraph 2: Suggested technical/UX/SEO improvements in a polite and professional manner.]\n[Paragraph 3: Suggestion from the agency, including name and CTA.]\n\nUse a polite, clear, and concise style. Use emoji to make more interactive. Write in country code {{ $('Get row(s) in sheet').item.json['country code'] }} language."
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "d721c358-0fa8-4b76-ad68-81871439f497",
"name": "Ajouter ou mettre à ligne dans la feuille2",
"type": "n8n-nodes-base.googleSheets",
"position": [
3300,
-220
],
"parameters": {
"columns": {
"value": {
"data_id": "={{ $('Limit').item.json.data_id }}",
"web_summary": "={{ $json.text }}"
},
"schema": [
{
"id": "data_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "data_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reviews_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "types",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "types",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "review_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_1_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_1_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tiktok",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "tiktok",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "web_summary",
"type": "string",
"display": true,
"required": false,
"displayName": "web_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_2_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_2_status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"data_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1321933612,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=1321933612",
"cachedResultName": "results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Automated Local Business Lead Generator using AI, Gmail & Telegram"
}
},
"typeVersion": 4.6
},
{
"id": "da07d108-1e9a-4165-a00c-46a34ab0ef98",
"name": "Envoyer un SMS1",
"type": "n8n-nodes-base.telegram",
"position": [
3520,
-220
],
"webhookId": "6f77a0b9-23cb-4a4b-8f23-c47f816e4fde",
"parameters": {
"text": "=----\n\nLatest Data for Follow Up\n\nBusiness Name: {{ $('Limit').item.json.title }}\nBusiness Types : {{ $('Limit').item.json.types }}\nLocation: {{ $('Limit').item.json.address }}\n\nWhatsapp Link: \n{{ $('Limit').item.json.phone }}\n\n----",
"chatId": "=YOUR_TELEGRAM_CHAT_ID",
"additionalFields": {
"appendAttribution": false
}
},
"typeVersion": 1.2
},
{
"id": "ed94c401-a892-44a4-ae30-7e15a23acfcc",
"name": "Diviser",
"type": "n8n-nodes-base.splitOut",
"position": [
640,
0
],
"parameters": {
"options": {},
"fieldToSplitOut": "local_results"
},
"executeOnce": true,
"typeVersion": 1
},
{
"id": "f9817682-0399-4635-82ba-9f9e9f8c1ddd",
"name": "Obtenir une ou plusieurs lignes de la feuille1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1080,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1321933612,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=1321933612",
"cachedResultName": "results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Automated Local Business Lead Generator using AI, Gmail & Telegram"
}
},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "dcbf3521-62f1-4ece-b590-d018fa18fc56",
"name": "Condition Si",
"type": "n8n-nodes-base.if",
"position": [
1300,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "febcf30b-1a4b-4ac3-971a-dcb5f471dee0",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.review_summary }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "373f6a6f-4bf1-4403-8ba2-01d7cd3bebd5",
"name": "Limite",
"type": "n8n-nodes-base.limit",
"position": [
1520,
-100
],
"parameters": {
"maxItems": 5
},
"typeVersion": 1
},
{
"id": "e2a8be2e-1476-491c-97c2-48a80d65006c",
"name": "Ajouter ou mettre à jour une ligne dans la feuille3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2060,
-100
],
"parameters": {
"columns": {
"value": {
"data_id": "={{ $('Limit').item.json.data_id }}",
"review_summary": "={{ $json.text }}"
},
"schema": [
{
"id": "data_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "data_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reviews_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "types",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "types",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_1_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_1_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tiktok",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "tiktok",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "web_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "web_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_link_2_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "whatsapp_link_2_status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"data_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1321933612,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=1321933612",
"cachedResultName": "results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Automated Local Business Lead Generator using AI, Gmail & Telegram"
}
},
"typeVersion": 4.6
},
{
"id": "65bea1ea-2295-4e6d-8c63-4fbde97d1d1e",
"name": "Requête HTTP1",
"type": "n8n-nodes-base.httpRequest",
"position": [
2540,
-220
],
"parameters": {
"url": "={{ $('Limit').item.json.website }}",
"options": {}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "b9c345c3-f9ca-4620-85e5-fea50f92192e",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
2740,
-680
],
"parameters": {
"jsCode": "const html = $json[\"data\"];\nconst ig = html.match(/https?:\\/\\/(www\\.)?instagram\\.com\\/[^\\s\"']+/i);\nconst tiktok = html.match(/https?:\\/\\/(www\\.)?tiktok\\.com\\/[^\\s\"']+/i);\n\nreturn [{\n json: {\n instagram: ig ? ig[0] : null,\n tiktok: tiktok ? tiktok[0] : null\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "f2d95980-fb2c-4d47-ac8a-cbd7d81e09cb",
"name": "Modèle de chat OpenRouter1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
2960,
-40
],
"parameters": {
"model": "google/gemini-2.0-flash-exp:free",
"options": {}
},
"typeVersion": 1
},
{
"id": "e540d2bc-d534-44ac-9367-7c3c847fdc86",
"name": "Aucune opération",
"type": "n8n-nodes-base.noOp",
"position": [
1520,
280
],
"parameters": {},
"typeVersion": 1
},
{
"id": "27a67c3f-249b-44c5-b500-e77812bf3369",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
2740,
-220
],
"parameters": {
"jsCode": "const html = $json[\"data\"] || \"\";\n\n// Fungsi bantu untuk ekstrak teks antar tag\nfunction extractTag(tag, html) {\n const regex = new RegExp(`<${tag}[^>]*>(.*?)<\\\\/${tag}>`, 'gis');\n const matches = [];\n let match;\n while ((match = regex.exec(html)) !== null) {\n const clean = match[1].replace(/<[^>]*>/g, '').trim();\n if (clean.length > 5) matches.push(clean);\n }\n return matches;\n}\n\n// Fungsi untuk ambil meta tag\nfunction extractMeta(name, html) {\n const regex = new RegExp(`<meta[^>]+name=[\"']${name}[\"'][^>]+content=[\"']([^\"']+)[\"']`, 'i');\n const match = regex.exec(html);\n return match ? match[1].trim() : '';\n}\n\n// Ambil bagian penting\nconst title = extractTag('title', html)[0] || '';\nconst description = extractMeta('description', html);\nconst keywords = extractMeta('keywords', html);\nconst headings = extractTag('h1', html).concat(extractTag('h2', html), extractTag('h3', html), extractTag('h4', html));\nconst paragraphs = extractTag('p', html).filter(p => p.length > 30 && p.length < 300);\nconst buttons = extractTag('button', html).concat(extractTag('a', html)).filter(t => /order|buy|join|shop|sign|book|start|contact|subscribe/i.test(t));\n\n// Hasil akhir\nconst summary = [\n `🔹 Title:\\n${title}`,\n `🔹 Description:\\n${description}`,\n `🔹 Keywords:\\n${keywords}`,\n `🔹 Headings:\\n${headings.slice(0, 5).join('\\n') || '(Tidak ditemukan)'}`,\n `🔹 Paragraf Penting:\\n${paragraphs.slice(0, 3).join('\\n\\n') || '(Tidak ditemukan)'}`,\n `🔹 CTA / Tombol:\\n${buttons.slice(0, 5).join('\\n') || '(Tidak ditemukan)'}`\n].join('\\n\\n');\n\nreturn [{ json: { simplified_summary: summary } }];\n"
},
"typeVersion": 2
},
{
"id": "f2af7012-3463-4e49-aa21-7c18625026c5",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-600,
-540
],
"parameters": {
"width": 540,
"height": 1240,
"content": "# Automated Local Business Lead Generator with AI, Social Media & WhatsApp Links\n\nThis workflow automates the process of generating and managing local business leads by scraping Google Maps data, analyzing business information with AI, and creating personalized outreach messages. The system searches for local businesses based on keywords and locations, extracts their contact information and reviews, then generates professional outreach messages tailored to each business. Results are stored in Google Sheets and notifications are sent via Telegram.\n\n\n📊 **Google Sheets Template**\nUse this template: [Local Business Lead Generator](https://docs.google.com/spreadsheets/d/1s1N_cAFoKtCsolQh4v3QZpqr8KmVzi7agKHr5MdBEBs/edit?usp=sharing)\n\n\n## 🔑 Key Features\n- 🔍 Searches Google Maps for local businesses using SerpAPI based on keywords and location parameters \n- 📋 Collects comprehensive business information including name, address, rating, reviews, phone numbers, and websites \n- 🤖 Uses OpenRouter's LLM to analyze business data and generate personalized outreach messages \n- 🌐 Analyzes business websites to provide targeted improvement suggestions \n- 📱 Automatically detects Instagram and TikTok profiles from business websites \n- 🗣️ Generates messages in the local language based on country code settings \n- 📊 Organizes and stores all collected data in Google Sheets with proper categorization \n- 🚀 Sends real-time updates and lead summaries via Telegram bot \n- 💬 Automatically creates WhatsApp links for easy business communication \n\n---\n\n## 🔧 Requirements\n- ✅ **SerpAPI Account + API Key** – For Google Maps business data extraction \n- ✅ **OpenRouter Account + API Key** – For AI-powered message generation and analysis \n- ✅ **Telegram Bot + API Token** – For notifications and bot interactions \n- ✅ **Google Sheets** – Connected to n8n for data storage \n- ✅ **Google Sheets Template** – Pre-configured with proper column structure \n\n---\n\n## 🎁 Benefits\n- Fully automated lead generation and outreach system \n- Saves time and increases efficiency for local business marketing \n- High personalization improves engagement and response rate \n- Scalable for any niche or location \n"
},
"typeVersion": 1
},
{
"id": "ee7d5e30-8c35-4278-96f9-97a31a3b3204",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
-200
],
"parameters": {
"color": 2,
"width": 580,
"height": 380,
"content": "- Run workflows automatically based on a specified schedule.\n- Fetch data from a Google Sheet containing a list of keywords and search locations.\n- Send requests to SerpAPI to retrieve business data from Google Maps based on input from the Sheet."
},
"typeVersion": 1
},
{
"id": "cfacf4f1-b561-4e48-8306-63567d337f30",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
620,
-200
],
"parameters": {
"color": 4,
"width": 800,
"height": 380,
"content": "- Break the local results array from the SerpAPI JSON output into individual items for individual processing.\n- Save each business result to a Google Sheet (results tab), using the ID data as the matching column.\n- Retrieve data from the results sheet for further analysis or processing.\n- Filter unsummarized data for further processing."
},
"typeVersion": 1
},
{
"id": "82526c8d-2ff1-42b9-9de7-b3c56d49d96e",
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1480,
-340
],
"parameters": {
"color": 5,
"width": 920,
"height": 560,
"content": "- Limit the number of items submitted to LLM for efficiency (e.g., only 5 businesses per batch)\n- Generate a review summary using a business information-based prompt.\n- The AI model used by the LLM Chain node above.\n- Save the review_summary results to Google Sheets (results tab), matching based on ID data.\n- Check if the business has a website for further processing."
},
"typeVersion": 1
},
{
"id": "3ed718a5-eab3-4bee-a114-14248fcb3f99",
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2720,
-400
],
"parameters": {
"color": 6,
"width": 500,
"height": 500,
"content": "- Fetch HTML content from a business website.\n- Extract important elements from the HTML using Regex, then organize them into a ready to use summary.\n- Provide an AI model for generating summaries."
},
"typeVersion": 1
},
{
"id": "4a093569-46b8-4066-ba07-b751f2003419",
"name": "Note adhésive5",
"type": "n8n-nodes-base.stickyNote",
"position": [
3260,
-400
],
"parameters": {
"color": 7,
"width": 500,
"height": 500,
"content": "- Save analysis results to Google Sheets.\n- Send automatic notifications to Telegram once data is processed and saved."
},
"typeVersion": 1
},
{
"id": "b138f46b-a0bd-43e0-89b6-b51e76178082",
"name": "Note adhésive6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2720,
-840
],
"parameters": {
"color": 7,
"width": 500,
"height": 400,
"content": "- Find Instagram and TikTok account links from business website pages.\n- Save Instagram and TikTok extraction results to Google Sheets."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "d17193ca-d795-492a-985a-4183538f81ab",
"connections": {
"dcbf3521-62f1-4ece-b590-d018fa18fc56": {
"main": [
[
{
"node": "373f6a6f-4bf1-4403-8ba2-01d7cd3bebd5",
"type": "main",
"index": 0
}
],
[
{
"node": "e540d2bc-d534-44ac-9367-7c3c847fdc86",
"type": "main",
"index": 0
}
]
]
},
"b9c345c3-f9ca-4620-85e5-fea50f92192e": {
"main": [
[
{
"node": "0a4385ce-7460-43eb-99ba-2552e90f2b7f",
"type": "main",
"index": 0
}
]
]
},
"27a67c3f-249b-44c5-b500-e77812bf3369": {
"main": [
[
{
"node": "ff892256-4826-4d6b-a467-c25ac1feed85",
"type": "main",
"index": 0
}
]
]
},
"373f6a6f-4bf1-4403-8ba2-01d7cd3bebd5": {
"main": [
[
{
"node": "efd6137c-6c9a-482c-92e4-e4691361be26",
"type": "main",
"index": 0
}
]
]
},
"ed94c401-a892-44a4-ae30-7e15a23acfcc": {
"main": [
[
{
"node": "933599b0-9cd8-4719-8c58-d3c6bae7c720",
"type": "main",
"index": 0
}
]
]
},
"e1e728f2-c48b-493b-8d73-0f72993083cd": {
"main": [
[
{
"node": "ed94c401-a892-44a4-ae30-7e15a23acfcc",
"type": "main",
"index": 0
}
]
]
},
"71fea344-66b3-4042-aa2b-424b6d50bfb5": {
"main": [
[
{
"node": "65bea1ea-2295-4e6d-8c63-4fbde97d1d1e",
"type": "main",
"index": 0
}
],
[
{
"node": "9eb71830-c068-4121-98fb-2fea45840451",
"type": "main",
"index": 0
}
]
]
},
"65bea1ea-2295-4e6d-8c63-4fbde97d1d1e": {
"main": [
[
{
"node": "27a67c3f-249b-44c5-b500-e77812bf3369",
"type": "main",
"index": 0
},
{
"node": "b9c345c3-f9ca-4620-85e5-fea50f92192e",
"type": "main",
"index": 0
}
]
]
},
"efd6137c-6c9a-482c-92e4-e4691361be26": {
"main": [
[
{
"node": "e2a8be2e-1476-491c-97c2-48a80d65006c",
"type": "main",
"index": 0
}
]
]
},
"ff892256-4826-4d6b-a467-c25ac1feed85": {
"main": [
[
{
"node": "d721c358-0fa8-4b76-ad68-81871439f497",
"type": "main",
"index": 0
}
]
]
},
"692059f0-ee24-409e-8f0c-1169404e4831": {
"main": [
[
{
"node": "bfbc2bdb-f14a-4788-8775-2459caae979d",
"type": "main",
"index": 0
}
]
]
},
"bfbc2bdb-f14a-4788-8775-2459caae979d": {
"main": [
[
{
"node": "e1e728f2-c48b-493b-8d73-0f72993083cd",
"type": "main",
"index": 0
}
]
]
},
"f9817682-0399-4635-82ba-9f9e9f8c1ddd": {
"main": [
[
{
"node": "dcbf3521-62f1-4ece-b590-d018fa18fc56",
"type": "main",
"index": 0
}
]
]
},
"0ece857b-9e1e-4dc2-b368-71226683bd70": {
"ai_languageModel": [
[
{
"node": "efd6137c-6c9a-482c-92e4-e4691361be26",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"f2d95980-fb2c-4d47-ac8a-cbd7d81e09cb": {
"ai_languageModel": [
[
{
"node": "ff892256-4826-4d6b-a467-c25ac1feed85",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"933599b0-9cd8-4719-8c58-d3c6bae7c720": {
"main": [
[
{
"node": "f9817682-0399-4635-82ba-9f9e9f8c1ddd",
"type": "main",
"index": 0
}
]
]
},
"d721c358-0fa8-4b76-ad68-81871439f497": {
"main": [
[
{
"node": "da07d108-1e9a-4165-a00c-46a34ab0ef98",
"type": "main",
"index": 0
}
]
]
},
"e2a8be2e-1476-491c-97c2-48a80d65006c": {
"main": [
[
{
"node": "71fea344-66b3-4042-aa2b-424b6d50bfb5",
"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
Extracteur de sentiments et de mots-clés des commentaires YouTube
Utiliser Gemini AI pour analyser le sentiment et les mots-clés des commentaires YouTube et les signaler via Telegram
Set
Code
Telegram
+
Set
Code
Telegram
20 NœudsBudi SJ
Étude de marché
Analyse intelligente quotidienne des groupes WhatsApp : Analyse GPT-4.1 et transcription des messages vocaux
Analyse intelligente des groupes WhatsApp quotidiens : analyse GPT-4.1 et transcription des messages vocaux
If
Set
Code
+
If
Set
Code
52 NœudsDaniel Lianes
Divers
基于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
Enrichissement des données Apollo par ID d'entreprise
Enrichissement des contacts d'approvisionnement à partir de l'ID d'entreprise en utilisant Apollo, Google Sheets et Telegram
If
Set
Code
+
If
Set
Code
27 NœudsKhaisa Studio
Génération de leads
Collecte et extraction automatisées de données de factures via Vision API et LLM
Extraire et structurer les données des factures avec Google Vision OCR, Gemini LLM et Google Sheets
Set
Code
Telegram
+
Set
Code
Telegram
17 NœudsBudi SJ
Traitement des factures
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds29
Catégorie2
Types de nœuds12
Description de la difficulté
Auteur
Budi SJ
@budisjI’m a Product Designer who also works as an Automation Developer. With a background in product design and systems thinking, I build user-centered workflows. My focus is on helping teams and businesses work more productively through impactful automation systems.
Liens externes
Voir sur n8n.io →
Partager ce workflow