Générer des prospects à l'aide de Google Maps - AlexK1919
Avancé
Ceci est unSales, Marketingworkflow d'automatisation du domainecontenant 42 nœuds.Utilise principalement des nœuds comme If, Set, Code, Wait, Limit. Générer des prospects avec Google Maps
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 (42)
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": "cQAILffOajE9n2cf",
"meta": {
"instanceId": "a14364f050ddf078652622522c15b502c09f9ef0c34946b703b7489667faedef",
"templateCredsSetupCompleted": true
},
"name": "Generate Leads with Google Maps - AlexK1919",
"tags": [
{
"id": "yS42KACueZegnCTR",
"name": "AlexK1919",
"createdAt": "2024-06-04T02:58:48.480Z",
"updatedAt": "2024-06-04T02:58:48.480Z"
}
],
"nodes": [
{
"id": "edc9d8f5-e1f4-48e2-b7f7-36e53674d5b3",
"name": "Au clic sur \"Exécuter le workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1080,
540
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b761e882-298f-454e-8c21-f77b336ce54e",
"name": "Exécuter le workflow toutes les heures",
"type": "n8n-nodes-base.scheduleTrigger",
"disabled": true,
"position": [
-1080,
360
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes",
"minutesInterval": 15
}
]
}
},
"typeVersion": 1.1
},
{
"id": "63d30ea8-1e31-47d2-8f3a-6757f438ab8a",
"name": "Déclencheur d'exécution du workflow",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"disabled": true,
"position": [
-1080,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "10f40f60-c29f-47db-a4d1-3d0b8e8363d7",
"name": "Vérifier les tentatives max1",
"type": "n8n-nodes-base.if",
"position": [
1680,
740
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "51e191cb-af20-423b-9303-8523caa4ae0d",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $('Exponential Backoff').item.json[\"retryCount\"] }}",
"rightValue": 10
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6665de66-8e00-4a45-b26a-93be044e9b8d",
"name": "Arrêter et erreur1",
"type": "n8n-nodes-base.stopAndError",
"position": [
1880,
740
],
"parameters": {
"errorMessage": "Google Sheets API Limit has been triggered and the workflow has stopped"
},
"typeVersion": 1
},
{
"id": "f0b15937-3734-4cdf-9256-ae36e39a2046",
"name": "GMaps API",
"type": "n8n-nodes-base.httpRequest",
"position": [
80,
680
],
"parameters": {
"url": "https://places.googleapis.com/v1/places:searchText",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendBody": true,
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "textQuery",
"value": "={{ $('Subcategory').item.json.Subcategory }} {{ $json.zip }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-Goog-FieldMask",
"value": "places.id,places.displayName,places.addressComponents,places.formattedAddress,places.primaryType,places.primaryTypeDisplayName,places.types,places.location,places.nationalPhoneNumber,places.rating,places.userRatingCount,places.websiteUri,places.editorialSummary,places.reviews,places.attributions,places.userRatingCount"
}
]
},
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"googleOAuth2Api": {
"id": "mfmC5Vkz0fz2YJ77",
"name": "KBB Google OAuth"
}
},
"typeVersion": 4.2
},
{
"id": "539bb125-173a-45b8-a6fc-0b755a013525",
"name": "Mettre à jour le statut en Succès",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
1520,
1160
],
"parameters": {
"columns": {
"value": {
"zip": "={{ $('Set Zip').first().json.zip }}",
"status": "scraped",
"subcat": "={{ $('Subcategory').first().json.Subcategory }}"
},
"schema": [
{
"id": "zip",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subcat",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subcat",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"zip"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Settings').first().json.sheet }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Settings').first().json.gs_url }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OnIKN60kSWkHVPHx",
"name": "Google Sheets - KBB"
}
},
"executeOnce": true,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "848b71e5-7ff5-4fb5-aad3-33b630ee42c8",
"name": "Ajouter des lignes dans Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
1080,
740
],
"parameters": {
"columns": {
"value": {
"type": "={{ $('Subcategory').item.json.Subcategory }}",
"phone": "={{ $json.place.nationalPhoneNumber }}",
"title": "={{ $json.place.displayName.text }}",
"types": "={{ $json.place.types }}",
"rating": "={{ $json.place.rating }}",
"address": "={{ $json.place.formattedAddress }}",
"reviews": "={{ $json.place.reviews }}",
"website": "={{ $json.place.websiteUri }}",
"place_id": "={{ $json.place.id }}",
"gps_coordinates": "={\"latitude\":{{ $json.place.location.latitude }},\"longitude\":{{ $json.place.location.longitude }}}"
},
"schema": [
{
"id": "ACTION",
"type": "string",
"display": true,
"required": false,
"displayName": "ACTION",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "STATUS",
"type": "string",
"display": true,
"required": false,
"displayName": "STATUS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "firstname",
"type": "string",
"display": true,
"required": false,
"displayName": "firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lastname",
"type": "string",
"display": true,
"required": false,
"displayName": "lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "clean url",
"type": "string",
"display": true,
"required": false,
"displayName": "clean url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website",
"type": "string",
"display": true,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "WP API",
"type": "string",
"display": true,
"required": false,
"displayName": "WP API",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "WP",
"type": "string",
"display": true,
"required": false,
"displayName": "WP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook",
"type": "string",
"display": true,
"required": false,
"displayName": "facebook",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "youtube",
"type": "string",
"display": true,
"required": false,
"displayName": "youtube",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tiktok",
"type": "string",
"display": true,
"required": false,
"displayName": "tiktok",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitter",
"type": "string",
"display": true,
"required": false,
"displayName": "twitter",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pinterest",
"type": "string",
"display": true,
"required": false,
"displayName": "pinterest",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reddit",
"type": "string",
"display": true,
"required": false,
"displayName": "reddit",
"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": "type",
"type": "string",
"display": true,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "price",
"type": "string",
"display": true,
"required": false,
"displayName": "price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "place_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "place_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "string",
"display": true,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "data_id",
"type": "string",
"display": true,
"required": false,
"displayName": "data_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "data_cid",
"type": "string",
"display": true,
"required": false,
"displayName": "data_cid",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_link",
"type": "string",
"display": true,
"required": false,
"displayName": "reviews_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "photos_link",
"type": "string",
"display": true,
"required": false,
"displayName": "photos_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "gps_coordinates",
"type": "string",
"display": true,
"required": false,
"displayName": "gps_coordinates",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "place_id_search",
"type": "string",
"display": true,
"required": false,
"displayName": "place_id_search",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "provider_id",
"type": "string",
"display": true,
"required": false,
"displayName": "provider_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "types",
"type": "string",
"display": true,
"required": false,
"displayName": "types",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "open_state",
"type": "string",
"display": true,
"required": false,
"displayName": "open_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hours",
"type": "string",
"display": true,
"required": false,
"displayName": "hours",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "operating_hours",
"type": "string",
"display": true,
"required": false,
"displayName": "operating_hours",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "service_options",
"type": "string",
"display": true,
"required": false,
"displayName": "service_options",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "order_online",
"type": "string",
"display": true,
"required": false,
"displayName": "order_online",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "thumbnail",
"type": "string",
"display": true,
"required": false,
"displayName": "thumbnail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "editorial_reviews",
"type": "string",
"display": true,
"required": false,
"displayName": "editorial_reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "unclaimed_listing",
"type": "string",
"display": true,
"required": false,
"displayName": "unclaimed_listing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reserve_a_table",
"type": "string",
"display": true,
"required": false,
"displayName": "reserve_a_table",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "user_review",
"type": "string",
"display": true,
"required": false,
"displayName": "user_review",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "amenities",
"type": "string",
"display": true,
"required": false,
"displayName": "amenities",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "book_online",
"type": "string",
"display": true,
"required": false,
"displayName": "book_online",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"place_id"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "=Results"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Settings').item.json.gs_url }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OnIKN60kSWkHVPHx",
"name": "Google Sheets - KBB"
}
},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "4e1e9438-8091-4cf6-8a99-179960a35eae",
"name": "Définir le numéro de ligne",
"type": "n8n-nodes-base.set",
"position": [
80,
80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4c5ad6be-28aa-455f-8ee2-edce1ab1bdbb",
"name": "row_number",
"type": "number",
"value": "={{ $json.row_number }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "a1939e46-7a56-4e41-9f12-86e784acd044",
"name": "Définir le code postal",
"type": "n8n-nodes-base.set",
"position": [
-120,
680
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7b1629c5-cbfe-4769-8286-66b46c51cd7e",
"name": "zip",
"type": "number",
"value": "={{ $('Loop Zips').first().json.zip }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "062d2c9f-f957-43ee-9fc2-2a8600828b58",
"name": "Définir le Place ID",
"type": "n8n-nodes-base.set",
"position": [
680,
740
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "758ff896-7cd8-4f72-bfbb-e64583c5937c",
"name": "places.id",
"type": "string",
"value": "={{ $json.place.id }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "0e3f4e19-0067-4233-afa8-1b9dd0a6bf30",
"name": "Backoff exponentiel",
"type": "n8n-nodes-base.code",
"position": [
1280,
740
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Define the retry count (coming from a previous node or set manually)\nconst retryCount = $json[\"retryCount\"] || 0; // If not present, default to 0\nconst maxRetries = 5; // Define the maximum number of retries\nconst initialDelay = 1; // Initial delay in seconds (1 second)\n\n// If the retry count is less than the max retries, calculate the delay\nif (retryCount < maxRetries) {\n const currentDelayInSeconds = initialDelay * Math.pow(2, retryCount); // Exponential backoff delay in seconds\n \n // Log the delay time for debugging\n console.log(`Waiting for ${currentDelayInSeconds} seconds before retry...`);\n \n return {\n json: {\n retryCount: retryCount + 1, // Increment retry count\n waitTimeInSeconds: currentDelayInSeconds, // Pass the delay time in seconds\n status: 'retrying',\n }\n };\n} else {\n // If max retries are exceeded, return a failure response\n return {\n json: {\n error: 'Max retries exceeded',\n retryCount: retryCount,\n status: 'failed'\n }\n };\n}\n"
},
"typeVersion": 2
},
{
"id": "68e13297-e299-4218-a02e-354c4bdd61db",
"name": "Supprimer les doublons",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
880,
740
],
"parameters": {
"compare": "selectedFields",
"options": {},
"fieldsToCompare": "place.id,places.id"
},
"typeVersion": 1.1
},
{
"id": "ee71fd03-8e15-4c38-b10a-8ff5853da476",
"name": "Pause",
"type": "n8n-nodes-base.wait",
"position": [
1480,
740
],
"webhookId": "e0cf8da3-e4ab-490e-abcd-0c0c55b90846",
"parameters": {
"amount": "={{ $json[\"waitTime\"] }}"
},
"typeVersion": 1.1
},
{
"id": "761d8d0e-c185-41a5-9a75-53e51ab67add",
"name": "Vérifier les tentatives max",
"type": "n8n-nodes-base.if",
"position": [
2120,
1160
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "51e191cb-af20-423b-9303-8523caa4ae0d",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $('Exponential Backoff1').item.json[\"retryCount\"] }}",
"rightValue": 10
}
]
}
},
"typeVersion": 2.2
},
{
"id": "d8fa857a-e195-405c-ae15-44fecd3fea3e",
"name": "Arrêter et erreur",
"type": "n8n-nodes-base.stopAndError",
"position": [
2320,
1160
],
"parameters": {
"errorMessage": "Google Sheets API Limit has been triggered and the workflow has stopped"
},
"typeVersion": 1
},
{
"id": "127dc44e-dd79-4735-b818-b95ec00184f2",
"name": "Backoff exponentiel1",
"type": "n8n-nodes-base.code",
"position": [
1720,
1160
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Define the retry count (coming from a previous node or set manually)\nconst retryCount = $json[\"retryCount\"] || 0; // If not present, default to 0\nconst maxRetries = 5; // Define the maximum number of retries\nconst initialDelay = 1; // Initial delay in seconds (1 second)\n\n// If the retry count is less than the max retries, calculate the delay\nif (retryCount < maxRetries) {\n const currentDelayInSeconds = initialDelay * Math.pow(2, retryCount); // Exponential backoff delay in seconds\n \n // Log the delay time for debugging\n console.log(`Waiting for ${currentDelayInSeconds} seconds before retry...`);\n \n return {\n json: {\n retryCount: retryCount + 1, // Increment retry count\n waitTimeInSeconds: currentDelayInSeconds, // Pass the delay time in seconds\n status: 'retrying',\n }\n };\n} else {\n // If max retries are exceeded, return a failure response\n return {\n json: {\n error: 'Max retries exceeded',\n retryCount: retryCount,\n status: 'failed'\n }\n };\n}\n"
},
"typeVersion": 2
},
{
"id": "fb7e37c4-f0b3-4a19-a4cc-29fd0c158f9d",
"name": "Pause1",
"type": "n8n-nodes-base.wait",
"position": [
1920,
1160
],
"webhookId": "670750d4-0c4d-4fff-b139-1d60be1eac68",
"parameters": {
"amount": "={{ $json[\"waitTime\"] }}"
},
"typeVersion": 1.1
},
{
"id": "520c9d50-bf23-402f-abf2-cb107341da4d",
"name": "Paramètres",
"type": "n8n-nodes-base.set",
"position": [
-800,
360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "fa469a25-eb00-4011-a626-87fae7fb8bbd",
"name": "gs_url",
"type": "string",
"value": "https://docs.google.com/spreadsheets/d/11bzNIQDE4GB2NWkyGv2IfEsTggSIBCKe2z39Ecp2Z4g/edit?gid=853393043#gid=853393043"
},
{
"id": "df0a7a51-0ec6-47d2-9f73-bc8268385305",
"name": "catSheet",
"type": "string",
"value": "Google Maps Categories"
},
{
"id": "a1ff9a58-9ae6-4000-9fcd-6c11de23bd48",
"name": "sheet",
"type": "string",
"value": "AZ Zips"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "1e9c68db-5ccd-4db7-a469-47aabb38dca1",
"name": "GS - Obtenir la sous-catégorie",
"type": "n8n-nodes-base.googleSheets",
"position": [
-220,
340
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Settings').item.json.catSheet }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Settings').item.json.gs_url }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OnIKN60kSWkHVPHx",
"name": "Google Sheets - KBB"
}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "e822be8c-ac7e-472e-a6e6-8835a1001323",
"name": "Sous-catégorie",
"type": "n8n-nodes-base.set",
"position": [
180,
340
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d3470f6f-c66e-4223-bbf5-81e45201d45d",
"name": "Subcategory",
"type": "string",
"value": "={{ $json.Subcategory }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "003af494-cb09-441b-87c7-43d7d98682e6",
"name": "GS - Obtenir les codes postaux",
"type": "n8n-nodes-base.googleSheets",
"position": [
-520,
80
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Settings').item.json.sheet }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Settings').item.json.gs_url }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OnIKN60kSWkHVPHx",
"name": "Google Sheets - KBB"
}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "cccc740e-55e5-4a64-b7f1-b1ca3fbb236e",
"name": "Tableau de lieux",
"type": "n8n-nodes-base.code",
"position": [
480,
740
],
"parameters": {
"jsCode": "// Get the places array from the input data\nconst places = items[0]?.json?.body?.places || [];\n\n// Create an output array to hold each place as a separate item\nlet output = [];\n\nif (places.length > 0) {\n for (let i = 0; i < places.length; i++) {\n // For each place, push a new item into the output array\n output.push({\n json: {\n place: places[i], // The individual place object\n otherData: items[0].json.otherData || null // Include other data or default to null\n }\n });\n }\n} else {\n // Log an error or handle the case where places array is empty or undefined\n console.log('Places array is empty or undefined.');\n}\n\n// Return the output array, so each place becomes its own item\nreturn output;\n"
},
"typeVersion": 2
},
{
"id": "4cd6a14a-084f-4389-90c5-f4d5921fc80d",
"name": "Boucle sur les codes postaux",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-420,
280
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "33bbb601-86ad-40b2-94fc-ccb7753d690e",
"name": "Boucle sur les sous-catégories",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-320,
620
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "fc1f56d7-ac1c-4447-a897-5b48ab4be430",
"name": "GS - Obtenir le statut",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
1280,
960
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Settings').first().json.sheet }}"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Settings').first().json.gs_url }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OnIKN60kSWkHVPHx",
"name": "Google Sheets - KBB"
}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "04e698d9-2455-4884-8f95-e2a9dbc16d57",
"name": "Vérifier les tentatives max2",
"type": "n8n-nodes-base.if",
"position": [
1880,
960
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "51e191cb-af20-423b-9303-8523caa4ae0d",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $('Exponential Backoff2').item.json[\"retryCount\"] }}",
"rightValue": 10
}
]
}
},
"typeVersion": 2.2
},
{
"id": "be784eb9-1d18-4ddc-a91a-1a78355eabed",
"name": "Arrêter et erreur2",
"type": "n8n-nodes-base.stopAndError",
"position": [
2080,
960
],
"parameters": {
"errorMessage": "Google Sheets API Limit has been triggered and the workflow has stopped"
},
"typeVersion": 1
},
{
"id": "3226891f-2e03-442e-9be3-7bc41d067d23",
"name": "Backoff exponentiel2",
"type": "n8n-nodes-base.code",
"position": [
1480,
960
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Define the retry count (coming from a previous node or set manually)\nconst retryCount = $json[\"retryCount\"] || 0; // If not present, default to 0\nconst maxRetries = 5; // Define the maximum number of retries\nconst initialDelay = 1; // Initial delay in seconds (1 second)\n\n// If the retry count is less than the max retries, calculate the delay\nif (retryCount < maxRetries) {\n const currentDelayInSeconds = initialDelay * Math.pow(2, retryCount); // Exponential backoff delay in seconds\n \n // Log the delay time for debugging\n console.log(`Waiting for ${currentDelayInSeconds} seconds before retry...`);\n \n return {\n json: {\n retryCount: retryCount + 1, // Increment retry count\n waitTimeInSeconds: currentDelayInSeconds, // Pass the delay time in seconds\n status: 'retrying',\n }\n };\n} else {\n // If max retries are exceeded, return a failure response\n return {\n json: {\n error: 'Max retries exceeded',\n retryCount: retryCount,\n status: 'failed'\n }\n };\n}\n"
},
"typeVersion": 2
},
{
"id": "04435aaa-0ba7-45f9-80a7-248fbd47ff0e",
"name": "Pause2",
"type": "n8n-nodes-base.wait",
"position": [
1680,
960
],
"webhookId": "d9b32a26-861f-46d5-a8d7-0ede2ea37fe6",
"parameters": {
"amount": "={{ $json[\"waitTime\"] }}"
},
"typeVersion": 1.1
},
{
"id": "4c246eb7-5ec2-4c89-b0c0-c851cb318c34",
"name": "Limite",
"type": "n8n-nodes-base.limit",
"position": [
500,
80
],
"parameters": {
"maxItems": 3
},
"typeVersion": 1
},
{
"id": "b141c344-c011-41b2-b87d-b5a067e37c0f",
"name": "Note adhésive20",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1420,
0
],
"parameters": {
"color": 6,
"width": 250,
"height": 1390,
"content": "# AlexK1919 \n\n\n#### I’m Alex Kim, an AI-Native Workflow Automation Architect Building Solutions to Optimize your Personal and Professional Life.\n\n\n### About Me\nhttps://beacons.ai/alexk1919\n\n\n### Products Used \n[Google Maps API via Google Cloud Account](https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/?utm_source=n8n_app&utm_medium=credential_settings&utm_campaign=create_new_credentials_modal)\n"
},
"typeVersion": 1
},
{
"id": "3fd43827-bc14-4337-89d3-2e48fc010e9f",
"name": "Note adhésive8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-860,
0
],
"parameters": {
"color": 3,
"width": 247,
"height": 1391,
"content": "# Settings"
},
"typeVersion": 1
},
{
"id": "c4ddef39-75e4-4a04-808c-2057ed59eddf",
"name": "Note adhésive15",
"type": "n8n-nodes-base.stickyNote",
"position": [
-860,
80
],
"parameters": {
"color": 7,
"width": 219,
"height": 220,
"content": "In the Google Sheets document, set the subcategories you'd like to search for\n\nSet the URL of your Google Sheets document\n\nSet the Zip Code sheet name"
},
"typeVersion": 1
},
{
"id": "b02c6a3a-3939-469a-bb50-0417cf2bc3c5",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1140,
0
],
"parameters": {
"color": 7,
"width": 247,
"height": 1391,
"content": "# Triggers"
},
"typeVersion": 1
},
{
"id": "0aeeaed1-e0dd-4837-ba69-31e0205ea824",
"name": "Codes postaux",
"type": "n8n-nodes-base.set",
"position": [
-320,
80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3d16d922-0ed3-4a0f-9707-43797438970d",
"name": "zip",
"type": "number",
"value": "={{ $json.zip }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "e186129c-202b-409a-8028-e7434ab70093",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-580,
520
],
"parameters": {
"color": 5,
"width": 3060,
"height": 880,
"content": "# Google Maps API"
},
"typeVersion": 1
},
{
"id": "6e142b17-55e7-4a2f-ae2a-829edd330aad",
"name": "Filtrer les codes postaux",
"type": "n8n-nodes-base.filter",
"position": [
-120,
80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "9f5a5e37-faae-45db-8a22-ad7d5786ecfe",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.status }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "077dc67e-eab4-413a-8f17-a17b298bf3f4",
"name": "Filtrer les sous-catégories",
"type": "n8n-nodes-base.filter",
"position": [
-20,
340
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b64333b6-67ce-47c4-a2cc-07303278d178",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json.STATUS }}",
"rightValue": "Ignore"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2d5f5e14-4958-4b60-9ae3-b66a7ad095e9",
"name": "Si vide",
"type": "n8n-nodes-base.if",
"position": [
280,
680
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7424452f-e208-4e7e-8144-d0c6278bc0f0",
"operator": {
"type": "object",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.body }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "594eee9f-35d2-4b7f-8926-47010891298b",
"name": "Diviser",
"type": "n8n-nodes-base.splitOut",
"position": [
300,
80
],
"parameters": {
"include": "allOtherFields",
"options": {},
"fieldToSplitOut": "row_number"
},
"typeVersion": 1
},
{
"id": "2402643d-605e-40d8-b4ed-1678a144960b",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-580,
0
],
"parameters": {
"color": 4,
"width": 3060,
"height": 500,
"content": "# Data Prep"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "5b91dfd7-b915-46b5-a195-c6cfa0d90dc6",
"connections": {
"ee71fd03-8e15-4c38-b10a-8ff5853da476": {
"main": [
[
{
"node": "10f40f60-c29f-47db-a4d1-3d0b8e8363d7",
"type": "main",
"index": 0
}
]
]
},
"0aeeaed1-e0dd-4837-ba69-31e0205ea824": {
"main": [
[
{
"node": "6e142b17-55e7-4a2f-ae2a-829edd330aad",
"type": "main",
"index": 0
}
]
]
},
"4c246eb7-5ec2-4c89-b0c0-c851cb318c34": {
"main": [
[
{
"node": "4cd6a14a-084f-4389-90c5-f4d5921fc80d",
"type": "main",
"index": 0
}
]
]
},
"fb7e37c4-f0b3-4a19-a4cc-29fd0c158f9d": {
"main": [
[
{
"node": "761d8d0e-c185-41a5-9a75-53e51ab67add",
"type": "main",
"index": 0
}
]
]
},
"04435aaa-0ba7-45f9-80a7-248fbd47ff0e": {
"main": [
[
{
"node": "04e698d9-2455-4884-8f95-e2a9dbc16d57",
"type": "main",
"index": 0
}
]
]
},
"a1939e46-7a56-4e41-9f12-86e784acd044": {
"main": [
[
{
"node": "f0b15937-3734-4cdf-9256-ae36e39a2046",
"type": "main",
"index": 0
}
]
]
},
"2d5f5e14-4958-4b60-9ae3-b66a7ad095e9": {
"main": [
[
{
"node": "33bbb601-86ad-40b2-94fc-ccb7753d690e",
"type": "main",
"index": 0
}
],
[
{
"node": "cccc740e-55e5-4a64-b7f1-b1ca3fbb236e",
"type": "main",
"index": 0
}
]
]
},
"520c9d50-bf23-402f-abf2-cb107341da4d": {
"main": [
[
{
"node": "003af494-cb09-441b-87c7-43d7d98682e6",
"type": "main",
"index": 0
}
]
]
},
"f0b15937-3734-4cdf-9256-ae36e39a2046": {
"main": [
[
{
"node": "2d5f5e14-4958-4b60-9ae3-b66a7ad095e9",
"type": "main",
"index": 0
}
]
]
},
"4cd6a14a-084f-4389-90c5-f4d5921fc80d": {
"main": [
[],
[
{
"node": "1e9c68db-5ccd-4db7-a469-47aabb38dca1",
"type": "main",
"index": 0
}
]
]
},
"594eee9f-35d2-4b7f-8926-47010891298b": {
"main": [
[
{
"node": "4c246eb7-5ec2-4c89-b0c0-c851cb318c34",
"type": "main",
"index": 0
}
]
]
},
"6e142b17-55e7-4a2f-ae2a-829edd330aad": {
"main": [
[
{
"node": "4e1e9438-8091-4cf6-8a99-179960a35eae",
"type": "main",
"index": 0
}
]
]
},
"cccc740e-55e5-4a64-b7f1-b1ca3fbb236e": {
"main": [
[
{
"node": "062d2c9f-f957-43ee-9fc2-2a8600828b58",
"type": "main",
"index": 0
}
]
]
},
"e822be8c-ac7e-472e-a6e6-8835a1001323": {
"main": [
[
{
"node": "33bbb601-86ad-40b2-94fc-ccb7753d690e",
"type": "main",
"index": 0
}
]
]
},
"33bbb601-86ad-40b2-94fc-ccb7753d690e": {
"main": [
[
{
"node": "4cd6a14a-084f-4389-90c5-f4d5921fc80d",
"type": "main",
"index": 0
}
],
[
{
"node": "a1939e46-7a56-4e41-9f12-86e784acd044",
"type": "main",
"index": 0
}
]
]
},
"062d2c9f-f957-43ee-9fc2-2a8600828b58": {
"main": [
[
{
"node": "68e13297-e299-4218-a02e-354c4bdd61db",
"type": "main",
"index": 0
}
]
]
},
"4e1e9438-8091-4cf6-8a99-179960a35eae": {
"main": [
[
{
"node": "594eee9f-35d2-4b7f-8926-47010891298b",
"type": "main",
"index": 0
}
]
]
},
"fc1f56d7-ac1c-4447-a897-5b48ab4be430": {
"main": [
[
{
"node": "539bb125-173a-45b8-a6fc-0b755a013525",
"type": "main",
"index": 0
}
],
[
{
"node": "3226891f-2e03-442e-9be3-7bc41d067d23",
"type": "main",
"index": 0
}
]
]
},
"761d8d0e-c185-41a5-9a75-53e51ab67add": {
"main": [
[
{
"node": "d8fa857a-e195-405c-ae15-44fecd3fea3e",
"type": "main",
"index": 0
}
],
[
{
"node": "539bb125-173a-45b8-a6fc-0b755a013525",
"type": "main",
"index": 0
}
]
]
},
"68e13297-e299-4218-a02e-354c4bdd61db": {
"main": [
[
{
"node": "848b71e5-7ff5-4fb5-aad3-33b630ee42c8",
"type": "main",
"index": 0
}
]
]
},
"10f40f60-c29f-47db-a4d1-3d0b8e8363d7": {
"main": [
[
{
"node": "6665de66-8e00-4a45-b26a-93be044e9b8d",
"type": "main",
"index": 0
}
],
[
{
"node": "848b71e5-7ff5-4fb5-aad3-33b630ee42c8",
"type": "main",
"index": 0
}
]
]
},
"04e698d9-2455-4884-8f95-e2a9dbc16d57": {
"main": [
[
{
"node": "be784eb9-1d18-4ddc-a91a-1a78355eabed",
"type": "main",
"index": 0
}
]
]
},
"003af494-cb09-441b-87c7-43d7d98682e6": {
"main": [
[
{
"node": "0aeeaed1-e0dd-4837-ba69-31e0205ea824",
"type": "main",
"index": 0
}
]
]
},
"0e3f4e19-0067-4233-afa8-1b9dd0a6bf30": {
"main": [
[
{
"node": "ee71fd03-8e15-4c38-b10a-8ff5853da476",
"type": "main",
"index": 0
}
]
]
},
"127dc44e-dd79-4735-b818-b95ec00184f2": {
"main": [
[
{
"node": "fb7e37c4-f0b3-4a19-a4cc-29fd0c158f9d",
"type": "main",
"index": 0
}
]
]
},
"3226891f-2e03-442e-9be3-7bc41d067d23": {
"main": [
[
{
"node": "04435aaa-0ba7-45f9-80a7-248fbd47ff0e",
"type": "main",
"index": 0
}
]
]
},
"077dc67e-eab4-413a-8f17-a17b298bf3f4": {
"main": [
[
{
"node": "e822be8c-ac7e-472e-a6e6-8835a1001323",
"type": "main",
"index": 0
}
]
]
},
"1e9c68db-5ccd-4db7-a469-47aabb38dca1": {
"main": [
[
{
"node": "077dc67e-eab4-413a-8f17-a17b298bf3f4",
"type": "main",
"index": 0
}
]
]
},
"63d30ea8-1e31-47d2-8f3a-6757f438ab8a": {
"main": [
[
{
"node": "520c9d50-bf23-402f-abf2-cb107341da4d",
"type": "main",
"index": 0
}
]
]
},
"b761e882-298f-454e-8c21-f77b336ce54e": {
"main": [
[
{
"node": "520c9d50-bf23-402f-abf2-cb107341da4d",
"type": "main",
"index": 0
}
]
]
},
"539bb125-173a-45b8-a6fc-0b755a013525": {
"main": [
[
{
"node": "33bbb601-86ad-40b2-94fc-ccb7753d690e",
"type": "main",
"index": 0
}
],
[
{
"node": "127dc44e-dd79-4735-b818-b95ec00184f2",
"type": "main",
"index": 0
}
]
]
},
"848b71e5-7ff5-4fb5-aad3-33b630ee42c8": {
"main": [
[
{
"node": "fc1f56d7-ac1c-4447-a897-5b48ab4be430",
"type": "main",
"index": 0
}
],
[
{
"node": "0e3f4e19-0067-4233-afa8-1b9dd0a6bf30",
"type": "main",
"index": 0
}
]
]
},
"edc9d8f5-e1f4-48e2-b7f7-36e53674d5b3": {
"main": [
[
{
"node": "520c9d50-bf23-402f-abf2-cb107341da4d",
"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é - Ventes, Marketing
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
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
Système de génération de prospects Overpass
Utiliser les données OpenStreetMap pour générer des prospects commerciaux et les sauvegarder dans Google Sheets
If
Set
Code
+
If
Set
Code
27 NœudsAkram Kadri
Ventes
Automatisation des demandes LinkedIn et des messages d'ouverture avec Browserflow et Google Sheets
Utiliser Browserflow et Google Sheets pour automatiser les demandes LinkedIn et les messages d'ouverture
If
Set
Sort
+
If
Set
Sort
44 NœudsPollupAI
Ventes
Générateur d'images de format 9:16 à partir de contenu v1
Générer des images au format 9:16 en fonction du contenu et des directives de marque
Set
Wait
Limit
+
Set
Wait
Limit
39 NœudsAlex Kim
Intelligence Artificielle
[Modèle] AI Pet Shop v8
🐶 Assistant de magasin de pets IA - Intégration de GPT-4o, Google Calendar et WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 NœudsAmanda Benks
Ventes
marketinge-mailAI个性化多produit
基于SMTP轮换deAI个性化多produite-mailmarketing（GPT-4o/o3-mini）
If
Code
Wait
+
If
Code
Wait
41 NœudsBadr
Ventes
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds42
Catégorie2
Types de nœuds16
Description de la difficulté
Auteur
Liens externes
Voir sur n8n.io →
Partager ce workflow