Effortlessly extract business data from Google Maps using the Google Sheets API and store it directly into Google Sheets. This automation is perfect for data management professionals looking to streamline lead generation. Requires 1 account: Google Sheets OAuth. Save hours of manual entry and generate 100+ targeted leads weekly with this seamless integration.
Categories
APIs
Credentials
Copy or download to import into your n8n instance
{
"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, Founder @ WotAI.\n\n\n### About Me\nhttps://wotai.co/community\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
}
]
]
}
}
}This workflow utilizes the Google Sheets API to automatically scrape email addresses from Google Maps, filtering and batching the results for efficient data management. Ideal for professionals in data management, it requires just 1 account: Google Sheets OAuth. Save hours of manual data entry and generate targeted email lists quickly, driving your marketing efforts with precision.
This workflow utilizes the OpenAI API and Google Sheets API to extract HTML data, analyze it with OpenAI GPT, and seamlessly merge it into Google Sheets for easy access. Ideal for data management professionals, this automation simplifies complex data processing. Requires 2 accounts: OpenAI API Key and Google Sheets OAuth. Save hours of manual data entry and streamline your reporting process, generating actionable insights in minutes.
Streamline data management by automating the parsing and enrichment of information using the Google Sheets API and OpenAI GPT. This workflow is tailored for data management professionals who need accurate and enriched data insights. Requires 3 accounts: OpenAI API, Serp API, and Google Sheets OAuth. Save hours of manual data entry and enhance your reporting capabilities with structured outputs, increasing productivity and accuracy in your data processes.
Automate the integration of OpenAI GPT with Supabase to efficiently parse structured outputs and store them in your database. This workflow is perfect for AI-powered automation users looking to enhance their data handling capabilities. Requires 2 accounts: OpenAI API and Supabase API. Experience faster data retrieval and improved decision-making with minimal manual effort, saving you hours each week.
Configure credentials and update service-specific settings before executing the workflow. Review required credentials in the Technical Details section above.