Workflow n8n
Automatisation Google Sheets avec n8n : génération de leads
Ce workflow n8n a pour objectif de générer des leads à partir de Google Maps en automatisant la collecte et l'enregistrement des données dans Google Sheets. Dans un contexte où les entreprises cherchent à optimiser leur processus de génération de prospects, ce workflow permet de récupérer des informations précieuses sur des entreprises locales en utilisant l'API Google Maps. Les cas d'usage incluent la recherche de nouveaux clients potentiels, la mise à jour des informations de contact et l'analyse de marché. Le workflow commence par un déclencheur manuel ou programmé, qui active l'exécution du flux. Ensuite, il utilise des requêtes HTTP pour interroger l'API Google Maps et récupérer les données nécessaires. Les informations sont ensuite traitées pour éliminer les doublons et organisées dans un tableau Google Sheets. Des étapes de vérification et de gestion des erreurs sont intégrées pour garantir la fiabilité du processus. En fin de compte, ce workflow permet aux équipes commerciales de gagner du temps, d'améliorer leur efficacité et de se concentrer sur la conversion des leads en clients, tout en réduisant les risques d'erreurs manuelles.
Tags clés :automatisationGoogle Sheetsgénération de leadsAPIn8n
Catégorie: Scheduled | Manual · Tags: automatisation, Google Sheets, génération de leads, API, n8n❤ 0
Workflow n8n Google Sheets, génération de leads : vue d'ensemble
Schéma des nœuds et connexions de ce workflow n8n, généré à partir du JSON n8n.
Workflow n8n Google Sheets, génération de leads : détail des nœuds
Inscris-toi pour voir l'intégralité du workflow
Inscription gratuite
S'inscrire gratuitementBesoin d'aide ?{
"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": "When clicking \"Execute Workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1080,
540
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b761e882-298f-454e-8c21-f77b336ce54e",
"name": "Run workflow every hours",
"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": "Execute Workflow Trigger",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"disabled": true,
"position": [
-1080,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "10f40f60-c29f-47db-a4d1-3d0b8e8363d7",
"name": "Check Max Retries1",
"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": "Stop and Error1",
"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": "Update Status to Success",
"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": "Add rows in 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": "Set Row Number",
"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": "Set Zip",
"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": "Set 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": "Exponential Backoff",
"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": "Remove Duplicates",
"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": "Wait",
"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": "Check Max Retries",
"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": "Stop and Error",
"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": "Exponential Backoff1",
"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": "Wait1",
"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": "Settings",
"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 - Get Subcategory",
"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": "Subcategory",
"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 - Get Zip Codes",
"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": "Place Array",
"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": "Loop Zips",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-420,
280
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "33bbb601-86ad-40b2-94fc-ccb7753d690e",
"name": "Loop Subcats",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-320,
620
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "fc1f56d7-ac1c-4447-a897-5b48ab4be430",
"name": "GS - Get Status",
"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": "Check Max Retries2",
"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": "Stop and Error2",
"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": "Exponential Backoff2",
"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": "Wait2",
"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": "Limit",
"type": "n8n-nodes-base.limit",
"position": [
500,
80
],
"parameters": {
"maxItems": 3
},
"typeVersion": 1
},
{
"id": "b141c344-c011-41b2-b87d-b5a067e37c0f",
"name": "Sticky Note20",
"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": "Sticky Note8",
"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": "Sticky Note15",
"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": "Sticky Note",
"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": "Zips",
"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": "Sticky Note1",
"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": "Filter Zips",
"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": "Filter Subcategories",
"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": "If Empty",
"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": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
300,
80
],
"parameters": {
"include": "allOtherFields",
"options": {},
"fieldToSplitOut": "row_number"
},
"typeVersion": 1
},
{
"id": "2402643d-605e-40d8-b4ed-1678a144960b",
"name": "Sticky Note2",
"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": {
"Wait": {
"main": [
[
{
"node": "Check Max Retries1",
"type": "main",
"index": 0
}
]
]
},
"Zips": {
"main": [
[
{
"node": "Filter Zips",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Loop Zips",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Check Max Retries",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Check Max Retries2",
"type": "main",
"index": 0
}
]
]
},
"Set Zip": {
"main": [
[
{
"node": "GMaps API",
"type": "main",
"index": 0
}
]
]
},
"If Empty": {
"main": [
[
{
"node": "Loop Subcats",
"type": "main",
"index": 0
}
],
[
{
"node": "Place Array",
"type": "main",
"index": 0
}
]
]
},
"Settings": {
"main": [
[
{
"node": "GS - Get Zip Codes",
"type": "main",
"index": 0
}
]
]
},
"GMaps API": {
"main": [
[
{
"node": "If Empty",
"type": "main",
"index": 0
}
]
]
},
"Loop Zips": {
"main": [
[],
[
{
"node": "GS - Get Subcategory",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Filter Zips": {
"main": [
[
{
"node": "Set Row Number",
"type": "main",
"index": 0
}
]
]
},
"Place Array": {
"main": [
[
{
"node": "Set Place ID",
"type": "main",
"index": 0
}
]
]
},
"Subcategory": {
"main": [
[
{
"node": "Loop Subcats",
"type": "main",
"index": 0
}
]
]
},
"Loop Subcats": {
"main": [
[
{
"node": "Loop Zips",
"type": "main",
"index": 0
}
],
[
{
"node": "Set Zip",
"type": "main",
"index": 0
}
]
]
},
"Set Place ID": {
"main": [
[
{
"node": "Remove Duplicates",
"type": "main",
"index": 0
}
]
]
},
"Set Row Number": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"GS - Get Status": {
"main": [
[
{
"node": "Update Status to Success",
"type": "main",
"index": 0
}
],
[
{
"node": "Exponential Backoff2",
"type": "main",
"index": 0
}
]
]
},
"Check Max Retries": {
"main": [
[
{
"node": "Stop and Error",
"type": "main",
"index": 0
}
],
[
{
"node": "Update Status to Success",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicates": {
"main": [
[
{
"node": "Add rows in Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Check Max Retries1": {
"main": [
[
{
"node": "Stop and Error1",
"type": "main",
"index": 0
}
],
[
{
"node": "Add rows in Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Check Max Retries2": {
"main": [
[
{
"node": "Stop and Error2",
"type": "main",
"index": 0
}
]
]
},
"GS - Get Zip Codes": {
"main": [
[
{
"node": "Zips",
"type": "main",
"index": 0
}
]
]
},
"Exponential Backoff": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Exponential Backoff1": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Exponential Backoff2": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Filter Subcategories": {
"main": [
[
{
"node": "Subcategory",
"type": "main",
"index": 0
}
]
]
},
"GS - Get Subcategory": {
"main": [
[
{
"node": "Filter Subcategories",
"type": "main",
"index": 0
}
]
]
},
"Execute Workflow Trigger": {
"main": [
[
{
"node": "Settings",
"type": "main",
"index": 0
}
]
]
},
"Run workflow every hours": {
"main": [
[
{
"node": "Settings",
"type": "main",
"index": 0
}
]
]
},
"Update Status to Success": {
"main": [
[
{
"node": "Loop Subcats",
"type": "main",
"index": 0
}
],
[
{
"node": "Exponential Backoff1",
"type": "main",
"index": 0
}
]
]
},
"Add rows in Google Sheets": {
"main": [
[
{
"node": "GS - Get Status",
"type": "main",
"index": 0
}
],
[
{
"node": "Exponential Backoff",
"type": "main",
"index": 0
}
]
]
},
"When clicking \"Execute Workflow\"": {
"main": [
[
{
"node": "Settings",
"type": "main",
"index": 0
}
]
]
}
}
}Workflow n8n Google Sheets, génération de leads : pour qui est ce workflow ?
Ce workflow s'adresse aux équipes commerciales et marketing des PME et grandes entreprises qui cherchent à automatiser leur processus de génération de leads. Il est conçu pour des utilisateurs ayant un niveau technique intermédiaire, familiarisés avec les outils d'automatisation et les API.
Workflow n8n Google Sheets, génération de leads : problème résolu
Ce workflow résout le problème de la collecte manuelle des données de prospects, qui peut être chronophage et sujette à des erreurs. En automatisant ce processus, les utilisateurs peuvent réduire le temps passé à rechercher des informations sur des entreprises et minimiser les risques d'erreurs humaines. Le résultat est une base de données de leads actualisée et fiable, prête à être utilisée pour des campagnes de prospection.
Workflow n8n Google Sheets, génération de leads : étapes du workflow
Étape 1 : Le workflow est déclenché manuellement ou selon un calendrier défini.
- Étape 1 : Il exécute une requête HTTP vers l'API Google Maps pour récupérer des données sur des entreprises.
- Étape 2 : Les données sont traitées pour éliminer les doublons.
- Étape 3 : Les informations sont organisées et ajoutées dans Google Sheets.
- Étape 4 : Des vérifications sont effectuées pour s'assurer que le processus s'est déroulé sans erreurs, avec des étapes de gestion des erreurs intégrées.
Workflow n8n Google Sheets, génération de leads : guide de personnalisation
Pour personnaliser ce workflow, vous pouvez modifier l'URL de l'API Google Maps pour cibler des zones géographiques spécifiques ou des types d'entreprises. Il est également possible d'ajuster les paramètres d'authentification pour l'API. Dans Google Sheets, vous pouvez changer le nom de la feuille ou les colonnes pour mieux correspondre à vos besoins. Enfin, vous pouvez intégrer d'autres outils ou services en ajoutant des noeuds supplémentaires dans le workflow n8n.