This workflow follows the Google Sheets → Googlesheetstrigger recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "limadata_api_key",
"value": "",
"type": "string"
},
{
"id": "id-2",
"name": "zerobounce_api_key",
"value": "",
"type": "string"
},
{
"id": "id-4",
"name": "batch_size",
"value": 50,
"type": "number"
},
{
"id": "id-5",
"name": "note",
"value": "CONFIG: Stores API keys and workflow settings",
"type": "string"
}
]
},
"includeOtherFields": true,
"options": {}
},
"id": "a68dcd2b-9f83-431c-8120-3aae1c27fe91",
"name": "Workflow Configuration",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-12672,
192
]
},
{
"parameters": {
"options": {}
},
"id": "f248957e-d113-4137-b698-7b31587de73e",
"name": "Remove Duplicate Prospects",
"type": "n8n-nodes-base.removeDuplicates",
"typeVersion": 2,
"position": [
-12448,
192
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 3
},
"conditions": [
{
"id": "id-1",
"leftValue": "={{ $json.email }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
}
},
{
"id": "id-2",
"leftValue": "={{ $json.name }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
}
},
{
"id": "id-3",
"leftValue": "={{ $json.company }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
}
},
{
"id": "id-4",
"leftValue": "={{ $json.linkedin_url }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
}
}
],
"combinator": "or"
},
"options": {}
},
"id": "5ed4bb6c-8109-48c6-bb16-0df45bcc69ee",
"name": "Filter Valid Prospects",
"type": "n8n-nodes-base.filter",
"typeVersion": 2.3,
"position": [
-12224,
192
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "name",
"value": "={{ $json.name }}",
"type": "string"
},
{
"id": "id-2",
"name": "title",
"value": "={{ $json.title || '' }}",
"type": "string"
},
{
"id": "id-3",
"name": "company",
"value": "={{ $json.company }}",
"type": "string"
},
{
"id": "id-4",
"name": "company_url",
"value": "={{ $json.company_url || '' }}",
"type": "string"
},
{
"id": "id-5",
"name": "linkedin_url",
"value": "={{ $json.linkedin_url || '' }}",
"type": "string"
},
{
"id": "id-6",
"name": "email",
"value": "={{ $json.email || '' }}",
"type": "string"
}
]
},
"options": {}
},
"id": "c7e7495b-4d2d-4441-986f-b7a4bcef123f",
"name": "Prepare for Enrichment",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-12000,
192
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-2",
"name": "first_name",
"value": "={{ $json.person?.first_name || '' }}",
"type": "string"
},
{
"id": "id-3",
"name": "last_name",
"value": "={{ $json.person?.last_name || '' }}",
"type": "string"
},
{
"id": "id-4",
"name": "title",
"value": "={{ $json.person?.employment?.title || $('Prepare for Enrichment').item.json.title || '' }}",
"type": "string"
},
{
"id": "id-5",
"name": "headline",
"value": "={{ $json.person?.headline || '' }}",
"type": "string"
},
{
"id": "id-6",
"name": "company",
"value": "={{ $json.person?.employment?.company_name || $('Prepare for Enrichment').item.json.company || '' }}",
"type": "string"
},
{
"id": "id-7",
"name": "company_domain",
"value": "={{ $json.person?.employment?.company_domain || $json.company?.domain || '' }}",
"type": "string"
},
{
"id": "id-8",
"name": "email",
"value": "={{ $json.person?.email || '' }}",
"type": "string"
},
{
"id": "id-9",
"name": "phone",
"value": "={{ $json.company?.phones?.[0] || '' }}",
"type": "string"
},
{
"id": "id-10",
"name": "linkedin_url",
"value": "={{ $json.person?.linkedin?.url || $('Prepare for Enrichment').item.json.linkedin_url || '' }}",
"type": "string"
},
{
"id": "id-11",
"name": "company_url",
"value": "={{ $json.company?.website || $('Prepare for Enrichment').item.json.company_url || '' }}",
"type": "string"
},
{
"id": "id-12",
"name": "location_city",
"value": "={{ $json.person?.location?.city || '' }}",
"type": "string"
},
{
"id": "id-13",
"name": "location_state",
"value": "={{ $json.person?.location?.state || '' }}",
"type": "string"
},
{
"id": "id-14",
"name": "location_country",
"value": "={{ $json.person?.location?.country || '' }}",
"type": "string"
},
{
"id": "id-15",
"name": "company_employee_count",
"value": "={{ $json.company?.employees?.employee_count || '' }}",
"type": "string"
},
{
"id": "id-16",
"name": "company_industry",
"value": "={{ $json.company?.categories?.industry || '' }}",
"type": "string"
},
{
"id": "id-17",
"name": "company_founded_year",
"value": "={{ $json.company?.founded_year || '' }}",
"type": "string"
}
]
},
"options": {}
},
"id": "b3c6939c-9986-428b-a858-6c5ae80d84c0",
"name": "Map Enriched Data",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-10880,
192
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 3
},
"conditions": [
{
"id": "id-1",
"leftValue": "={{ $json.email }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
}
},
{
"id": "id-2",
"leftValue": "={{ $json.email }}",
"rightValue": "@",
"operator": {
"type": "string",
"operation": "contains"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "5ee4830d-18ec-4b71-ace9-9539811ebf93",
"name": "Filter Enriched Records",
"type": "n8n-nodes-base.filter",
"typeVersion": 2.3,
"position": [
-9312,
96
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "email_to_verify",
"value": "={{ $json.email }}",
"type": "string"
},
{
"id": "id-2",
"name": "name",
"value": "={{ $json.name }}",
"type": "string"
},
{
"id": "id-3",
"name": "first_name",
"value": "={{ $json.first_name }}",
"type": "string"
},
{
"id": "id-4",
"name": "last_name",
"value": "={{ $json.last_name }}",
"type": "string"
},
{
"id": "id-5",
"name": "title",
"value": "={{ $json.title }}",
"type": "string"
},
{
"id": "id-6",
"name": "headline",
"value": "={{ $json.headline }}",
"type": "string"
},
{
"id": "id-7",
"name": "company",
"value": "={{ $json.company }}",
"type": "string"
},
{
"id": "id-8",
"name": "company_domain",
"value": "={{ $json.company_domain }}",
"type": "string"
},
{
"id": "id-9",
"name": "phone",
"value": "={{ $json.phone }}",
"type": "string"
},
{
"id": "id-10",
"name": "linkedin_url",
"value": "={{ $json.linkedin_url }}",
"type": "string"
},
{
"id": "id-11",
"name": "company_url",
"value": "={{ $json.company_url }}",
"type": "string"
},
{
"id": "id-12",
"name": "location_city",
"value": "={{ $json.location_city }}",
"type": "string"
},
{
"id": "id-13",
"name": "location_state",
"value": "={{ $json.location_state }}",
"type": "string"
},
{
"id": "id-14",
"name": "location_country",
"value": "={{ $json.location_country }}",
"type": "string"
},
{
"id": "id-15",
"name": "company_employee_count",
"value": "={{ $json.company_employee_count }}",
"type": "string"
},
{
"id": "id-16",
"name": "company_industry",
"value": "={{ $json.company_industry }}",
"type": "string"
},
{
"id": "id-17",
"name": "company_founded_year",
"value": "={{ $json.company_founded_year }}",
"type": "string"
},
{
"id": "id-18",
"name": "enrichment_source",
"value": "={{ $json.enrichment_source }}",
"type": "string"
}
]
},
"options": {}
},
"id": "73bf7d8d-82f2-4465-b50b-745635eccffb",
"name": "Prepare for Verification",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-9088,
96
]
},
{
"parameters": {
"url": "https://api.zerobounce.net/v2/validate",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "api_key",
"value": "={{ $('Workflow Configuration').item.json.zerobounce_api_key }}"
},
{
"name": "email",
"value": "={{ $json.email_to_verify }}"
}
]
},
"options": {
"response": {
"response": {
"neverError": true
}
}
},
"infoMessage": "VERIFICATION: Validates email addresses using ZeroBounce API"
},
"id": "05097982-cca9-4597-9686-b7e7ffec879e",
"name": "Zerobounce Email Verification",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.3,
"position": [
-8864,
96
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": false,
"leftValue": "",
"typeValidation": "loose"
},
"conditions": [
{
"id": "id-1",
"leftValue": "={{ $('Zerobounce Email Verification').item.json.status }}",
"rightValue": "valid",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "5161a64a-78e5-41bf-a56f-d330a9c7ca3c",
"name": "Check Email Validity",
"type": "n8n-nodes-base.if",
"typeVersion": 2.3,
"position": [
-8640,
96
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "name",
"value": "={{ $('Prepare for Verification').item.json.name }}",
"type": "string"
},
{
"id": "id-2",
"name": "first_name",
"value": "={{ $('Prepare for Verification').item.json.first_name }}",
"type": "string"
},
{
"id": "id-3",
"name": "last_name",
"value": "={{ $('Prepare for Verification').item.json.last_name }}",
"type": "string"
},
{
"id": "id-4",
"name": "title",
"value": "={{ $('Prepare for Verification').item.json.title }}",
"type": "string"
},
{
"id": "id-5",
"name": "headline",
"value": "={{ $('Prepare for Verification').item.json.headline }}",
"type": "string"
},
{
"id": "id-6",
"name": "company",
"value": "={{ $('Prepare for Verification').item.json.company }}",
"type": "string"
},
{
"id": "id-7",
"name": "company_domain",
"value": "={{ $('Prepare for Verification').item.json.company_domain }}",
"type": "string"
},
{
"id": "id-8",
"name": "email",
"value": "={{ $('Prepare for Verification').item.json.email_to_verify }}",
"type": "string"
},
{
"id": "id-9",
"name": "phone",
"value": "={{ $('Prepare for Verification').item.json.phone }}",
"type": "string"
},
{
"id": "id-10",
"name": "linkedin_url",
"value": "={{ $('Prepare for Verification').item.json.linkedin_url }}",
"type": "string"
},
{
"id": "id-11",
"name": "company_url",
"value": "={{ $('Prepare for Verification').item.json.company_url }}",
"type": "string"
},
{
"id": "id-12",
"name": "location_city",
"value": "={{ $('Prepare for Verification').item.json.location_city }}",
"type": "string"
},
{
"id": "id-13",
"name": "location_state",
"value": "={{ $('Prepare for Verification').item.json.location_state }}",
"type": "string"
},
{
"id": "id-14",
"name": "location_country",
"value": "={{ $('Prepare for Verification').item.json.location_country }}",
"type": "string"
},
{
"id": "id-15",
"name": "company_employee_count",
"value": "={{ $('Prepare for Verification').item.json.company_employee_count }}",
"type": "string"
},
{
"id": "id-16",
"name": "company_industry",
"value": "={{ $('Prepare for Verification').item.json.company_industry }}",
"type": "string"
},
{
"id": "id-17",
"name": "company_founded_year",
"value": "={{ $('Prepare for Verification').item.json.company_founded_year }}",
"type": "string"
},
{
"id": "id-18",
"name": "enrichment_source",
"value": "={{ $('Prepare for Verification').item.json.enrichment_source }}",
"type": "string"
},
{
"id": "id-19",
"name": "email_status",
"value": "verified",
"type": "string"
}
]
},
"options": {}
},
"id": "5b98ee94-5a1f-4968-a732-e33f8e3fa43d",
"name": "Mark as Verified",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-8416,
0
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "name",
"value": "={{ $('Prepare for Verification').item.json.name }}",
"type": "string"
},
{
"id": "id-2",
"name": "first_name",
"value": "={{ $('Prepare for Verification').item.json.first_name }}",
"type": "string"
},
{
"id": "id-3",
"name": "last_name",
"value": "={{ $('Prepare for Verification').item.json.last_name }}",
"type": "string"
},
{
"id": "id-4",
"name": "title",
"value": "={{ $('Prepare for Verification').item.json.title }}",
"type": "string"
},
{
"id": "id-5",
"name": "headline",
"value": "={{ $('Prepare for Verification').item.json.headline }}",
"type": "string"
},
{
"id": "id-6",
"name": "company",
"value": "={{ $('Prepare for Verification').item.json.company }}",
"type": "string"
},
{
"id": "id-7",
"name": "company_domain",
"value": "={{ $('Prepare for Verification').item.json.company_domain }}",
"type": "string"
},
{
"id": "id-8",
"name": "email",
"value": "={{ $('Prepare for Verification').item.json.email_to_verify }}",
"type": "string"
},
{
"id": "id-9",
"name": "phone",
"value": "={{ $('Prepare for Verification').item.json.phone }}",
"type": "string"
},
{
"id": "id-10",
"name": "linkedin_url",
"value": "={{ $('Prepare for Verification').item.json.linkedin_url }}",
"type": "string"
},
{
"id": "id-11",
"name": "company_url",
"value": "={{ $('Prepare for Verification').item.json.company_url }}",
"type": "string"
},
{
"id": "id-12",
"name": "location_city",
"value": "={{ $('Prepare for Verification').item.json.location_city }}",
"type": "string"
},
{
"id": "id-13",
"name": "location_state",
"value": "={{ $('Prepare for Verification').item.json.location_state }}",
"type": "string"
},
{
"id": "id-14",
"name": "location_country",
"value": "={{ $('Prepare for Verification').item.json.location_country }}",
"type": "string"
},
{
"id": "id-15",
"name": "company_employee_count",
"value": "={{ $('Prepare for Verification').item.json.company_employee_count }}",
"type": "string"
},
{
"id": "id-16",
"name": "company_industry",
"value": "={{ $('Prepare for Verification').item.json.company_industry }}",
"type": "string"
},
{
"id": "id-17",
"name": "company_founded_year",
"value": "={{ $('Prepare for Verification').item.json.company_founded_year }}",
"type": "string"
},
{
"id": "id-18",
"name": "enrichment_source",
"value": "={{ $('Prepare for Verification').item.json.enrichment_source }}",
"type": "string"
},
{
"id": "id-19",
"name": "email_status",
"value": "invalid",
"type": "string"
},
{
"id": "id-20",
"name": "email_quality_score",
"value": "N/A",
"type": "string"
},
{
"id": "id-21",
"name": "verification_date",
"value": "={{ new Date().toISOString() }}",
"type": "string"
}
]
},
"options": {}
},
"id": "458b623e-92a8-44dc-a582-512be216771b",
"name": "Mark as Invalid",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-8416,
192
]
},
{
"parameters": {},
"id": "374de3c4-d85a-4af3-a099-dabcf339bbeb",
"name": "Combine Verification Results",
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
-8192,
96
]
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"value": "",
"mode": "list",
"cachedResultName": "",
"cachedResultUrl": ""
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "",
"cachedResultUrl": ""
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"id": "99610fa6-b65e-42d4-957d-12c5215fa662",
"name": "Save to Enriched Data Sheet",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
-7744,
192
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"pollTimes": {
"item": [
{
"hour": 9
}
]
},
"documentId": {
"__rl": true,
"value": "id",
"mode": "list",
"cachedResultName": "",
"cachedResultUrl": ""
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "",
"cachedResultUrl": ""
},
"event": "rowAdded",
"options": {}
},
"id": "916d631e-f57e-4a9a-8d16-53326e6cf086",
"name": "When Row Added to Prospect List",
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 1,
"position": [
-12896,
192
],
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 3
},
"conditions": [
{
"leftValue": "={{ $json.linkedin_url }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
},
"id": "4281b82c-121e-45bf-921e-580418baceea"
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "LinkedIn URL"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 3
},
"conditions": [
{
"leftValue": "={{ $json.email }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
},
"id": "1f1ba1b7-b7d9-493c-bd89-37537975f7c4"
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "Email"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 3
},
"conditions": [
{
"leftValue": "={{ $json.name }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
},
"id": "6bc07ff2-a8ae-405c-afa9-cd13bc0921ba"
},
{
"leftValue": "={{ $json.company }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty"
},
"id": "e621e833-045a-4d3f-be46-a7edcba4c1a7"
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "Name + Company"
}
]
},
"options": {
"fallbackOutput": "extra",
"renameFallbackOutput": "No Valid Data"
}
},
"id": "23aea473-778b-4f78-bd18-6fd4fa61cd6b",
"name": "Route by Available Data",
"type": "n8n-nodes-base.switch",
"typeVersion": 3.4,
"position": [
-11776,
160
]
},
{
"parameters": {
"method": "POST",
"url": "https://api.limadata.com/api/v1/enrich/person",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-api-key",
"value": "={{ $('Workflow Configuration').item.json.limadata_api_key }}"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={{ { \"linkedin_url\": $json.linkedin_url } }}",
"options": {
"response": {
"response": {
"neverError": true
}
}
}
},
"id": "51403f36-1f03-4f33-b573-7194868e8a47",
"name": "Enrich by LinkedIn URL",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.3,
"position": [
-11552,
0
]
},
{
"parameters": {
"method": "POST",
"url": "https://api.limadata.com/api/v1/enrich/person",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-api-key",
"value": "={{ $('Workflow Configuration').item.json.limadata_api_key }}"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={{ { \"email\": $json.email, \"name\": $json.name || null } }}",
"options": {
"response": {
"response": {
"neverError": true
}
}
}
},
"id": "5eb339c5-49b4-473f-b12f-a893b0279fc8",
"name": "Enrich by Email",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.3,
"position": [
-11552,
192
]
},
{
"parameters": {
"method": "POST",
"url": "https://api.limadata.com/api/v1/enrich/person",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-api-key",
"value": "={{ $('Workflow Configuration').item.json.limadata_api_key }}"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={{ { \"name\": $json.name, \"company_name\": $json.company || null, \"company_domain\": $json.company_domain || null } }}",
"options": {
"response": {
"response": {
"neverError": true
}
}
}
},
"id": "237b95f5-1451-43e4-bd6d-15f8c20a7d7c",
"name": "Enrich by Name + Company",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.3,
"position": [
-11552,
384
]
},
{
"parameters": {
"numberInputs": 3
},
"id": "c2c95603-c7bc-4c9e-bb0a-5b05e68724b9",
"name": "Merge Enrichment Results",
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
-11328,
176
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 3
},
"conditions": [
{
"id": "id-1",
"leftValue": "={{ $json.data }}",
"rightValue": null,
"operator": {
"type": "string",
"operation": "notExists",
"singleValue": true
}
}
],
"combinator": "or"
},
"options": {}
},
"id": "63e3b919-70ce-4d7e-ba26-8e946b9d9874",
"name": "Check Enrichment Success",
"type": "n8n-nodes-base.if",
"typeVersion": 2.3,
"position": [
-11104,
192
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": false,
"leftValue": "",
"typeValidation": "loose"
},
"conditions": [
{
"id": "id-1",
"leftValue": "={{ $json.email }}",
"operator": {
"type": "string",
"operation": "empty"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "d2275775-5bbc-45cb-9bf6-f669745e4d6d",
"name": "Check if Email Missing",
"type": "n8n-nodes-base.if",
"typeVersion": 2.3,
"position": [
-10656,
192
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "full_name",
"value": "={{ (($json.first_name || '') + ' ' + ($json.last_name || '')).trim() }}",
"type": "string"
},
{
"id": "id-2",
"name": "company_domain",
"value": "={{ $json.company_domain }}",
"type": "string"
},
{
"id": "id-4",
"name": "first_name",
"value": "={{ $json.first_name }}",
"type": "string"
},
{
"id": "id-5",
"name": "last_name",
"value": "={{ $json.last_name }}",
"type": "string"
},
{
"id": "id-6",
"name": "title",
"value": "={{ $json.title }}",
"type": "string"
},
{
"id": "id-7",
"name": "headline",
"value": "={{ $json.headline }}",
"type": "string"
},
{
"id": "id-8",
"name": "company",
"value": "={{ $json.company }}",
"type": "string"
},
{
"id": "id-9",
"name": "phone",
"value": "={{ $json.phone }}",
"type": "string"
},
{
"id": "id-10",
"name": "linkedin_url",
"value": "={{ $json.linkedin_url }}",
"type": "string"
},
{
"id": "id-11",
"name": "company_url",
"value": "={{ $json.company_url }}",
"type": "string"
},
{
"id": "id-12",
"name": "location_city",
"value": "={{ $json.location_city }}",
"type": "string"
},
{
"id": "id-13",
"name": "location_state",
"value": "={{ $json.location_state }}",
"type": "string"
},
{
"id": "id-14",
"name": "location_country",
"value": "={{ $json.location_country }}",
"type": "string"
},
{
"id": "id-15",
"name": "company_employee_count",
"value": "={{ $json.company_employee_count }}",
"type": "string"
},
{
"id": "id-16",
"name": "company_industry",
"value": "={{ $json.company_industry }}",
"type": "string"
},
{
"id": "id-17",
"name": "company_founded_year",
"value": "={{ $json.company_founded_year }}",
"type": "string"
}
]
},
"options": {}
},
"id": "e8a3f5e9-0898-4d81-aae1-722f0d05928a",
"name": "Prepare Work Email Request",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-10432,
288
]
},
{
"parameters": {
"method": "POST",
"url": "https://api.limadata.com/api/v1/find/email_work",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-api-key",
"value": "={{ $('Workflow Configuration').item.json.limadata_api_key }}"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={{ { \"full_name\": $json.full_name, \"company_domain\": $json.company_domain } }}",
"options": {
"response": {
"response": {
"neverError": true
}
}
}
},
"id": "e31e5660-7f4c-4dc0-a6a4-14a46eea399f",
"name": "Find Work Email via Limadata",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.3,
"position": [
-10208,
288
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 3
},
"conditions": [
{
"id": "id-1",
"leftValue": "={{ $json.email }}",
"operator": {
"type": "string",
"operation": "notEmpty"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "1643e9fa-5bc2-4aa8-9026-519110fb40de",
"name": "Check Work Email Found",
"type": "n8n-nodes-base.if",
"typeVersion": 2.3,
"position": [
-9984,
288
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "email",
"value": "={{ $json.email }}",
"type": "string"
},
{
"id": "id-2",
"name": "name",
"value": "={{ $('Prepare Work Email Request').item.json.name }}",
"type": "string"
},
{
"id": "id-3",
"name": "first_name",
"value": "={{ $('Prepare Work Email Request').item.json.first_name }}",
"type": "string"
},
{
"id": "id-4",
"name": "last_name",
"value": "={{ $('Prepare Work Email Request').item.json.last_name }}",
"type": "string"
},
{
"id": "id-5",
"name": "title",
"value": "={{ $('Prepare Work Email Request').item.json.title }}",
"type": "string"
},
{
"id": "id-6",
"name": "headline",
"value": "={{ $('Prepare Work Email Request').item.json.headline }}",
"type": "string"
},
{
"id": "id-7",
"name": "company",
"value": "={{ $('Prepare Work Email Request').item.json.company }}",
"type": "string"
},
{
"id": "id-8",
"name": "company_domain",
"value": "={{ $('Prepare Work Email Request').item.json.company_domain }}",
"type": "string"
},
{
"id": "id-9",
"name": "phone",
"value": "={{ $('Prepare Work Email Request').item.json.phone }}",
"type": "string"
},
{
"id": "id-10",
"name": "linkedin_url",
"value": "={{ $('Prepare Work Email Request').item.json.linkedin_url }}",
"type": "string"
},
{
"id": "id-11",
"name": "company_url",
"value": "={{ $('Prepare Work Email Request').item.json.company_url }}",
"type": "string"
},
{
"id": "id-12",
"name": "location_city",
"value": "={{ $('Prepare Work Email Request').item.json.location_city }}",
"type": "string"
},
{
"id": "id-13",
"name": "location_state",
"value": "={{ $('Prepare Work Email Request').item.json.location_state }}",
"type": "string"
},
{
"id": "id-14",
"name": "location_country",
"value": "={{ $('Prepare Work Email Request').item.json.location_country }}",
"type": "string"
},
{
"id": "id-15",
"name": "company_employee_count",
"value": "={{ $('Prepare Work Email Request').item.json.company_employee_count }}",
"type": "string"
},
{
"id": "id-16",
"name": "company_industry",
"value": "={{ $('Prepare Work Email Request').item.json.company_industry }}",
"type": "string"
},
{
"id": "id-17",
"name": "company_founded_year",
"value": "={{ $('Prepare Work Email Request').item.json.company_founded_year }}",
"type": "string"
}
]
},
"options": {}
},
"id": "e3636170-0df8-409c-8c3a-2c7b2e3c1030",
"name": "Add Work Email to Data",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-9760,
192
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-2",
"name": "first_name",
"value": "={{ $('Prepare Work Email Request').item.json.first_name }}",
"type": "string"
},
{
"id": "id-3",
"name": "last_name",
"value": "={{ $('Prepare Work Email Request').item.json.last_name }}",
"type": "string"
},
{
"id": "id-4",
"name": "title",
"value": "={{ $('Prepare Work Email Request').item.json.title }}",
"type": "string"
},
{
"id": "id-5",
"name": "headline",
"value": "={{ $('Prepare Work Email Request').item.json.headline }}",
"type": "string"
},
{
"id": "id-6",
"name": "company",
"value": "={{ $('Prepare Work Email Request').item.json.company }}",
"type": "string"
},
{
"id": "id-7",
"name": "company_domain",
"value": "={{ $('Prepare Work Email Request').item.json.company_domain }}",
"type": "string"
},
{
"id": "id-8",
"name": "email",
"value": "",
"type": "string"
},
{
"id": "id-9",
"name": "phone",
"value": "={{ $('Prepare Work Email Request').item.json.phone }}",
"type": "string"
},
{
"id": "id-10",
"name": "linkedin_url",
"value": "={{ $('Prepare Work Email Request').item.json.linkedin_url }}",
"type": "string"
},
{
"id": "id-11",
"name": "company_url",
"value": "={{ $('Prepare Work Email Request').item.json.company_url }}",
"type": "string"
},
{
"id": "id-12",
"name": "location_city",
"value": "={{ $('Prepare Work Email Request').item.json.location_city }}",
"type": "string"
},
{
"id": "id-13",
"name": "location_state",
"value": "={{ $('Prepare Work Email Request').item.json.location_state }}",
"type": "string"
},
{
"id": "id-14",
"name": "location_country",
"value": "={{ $('Prepare Work Email Request').item.json.location_country }}",
"type": "string"
},
{
"id": "id-15",
"name": "company_employee_count",
"value": "={{ $('Prepare Work Email Request').item.json.company_employee_count }}",
"type": "string"
},
{
"id": "id-16",
"name": "company_industry",
"value": "={{ $('Prepare Work Email Request').item.json.company_industry }}",
"type": "string"
},
{
"id": "id-17",
"name": "company_founded_year",
"value": "={{ $('Prepare Work Email Request').item.json.company_founded_year }}",
"type": "string"
},
{
"id": "528baffa-50f5-47b4-a1c8-fa422aaba510",
"name": "email_status",
"value": "={{ $('Check Work Email Found') == true ? 'verified': 'not verified'}}",
"type": "string"
}
]
},
"options": {}
},
"id": "dbe60351-8cd4-4e73-9506-d3c7d8f90c4f",
"name": "Mark for Direct Save",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-8192,
368
]
},
{
"parameters": {},
"id": "6fd1f6e4-b31e-4947-93a6-3e2b925ff449",
"name": "Merge Email Paths",
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
-9536,
96
]
},
{
"parameters": {},
"id": "c13c2f07-256f-4b63-be2d-b1d19d9ed8bc",
"name": "Merge All Data Paths",
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
-7968,
192
]
},
{
"parameters": {
"content": "# Data Preparation Layer\n\n- Load Prospects from Google Sheet, with all the available data\n- Apply Deduplication and prepare for enrichment",
"height": 592,
"width": 1072
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-12944,
-32
],
"id": "28381b54-1498-4b92-959a-326135cb368b",
"name": "Sticky Note"
},
{
"parameters": {
"content": "# Enrichment Layer \n- Route enrichment based on data available with Limadata\n- Merge and map enriched data ",
"height": 800,
"width": 1056,
"color": 2
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-11808,
-192
],
"id": "948d4380-e524-4545-9aee-715d512f47d4",
"name": "Sticky Note1"
},
{
"parameters": {
"content": "# Email layer\n- Add email for prospects with missing email data",
"height": 848,
"width": 1712,
"color": 5
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-10688,
-192
],
"id": "230daaee-a835-4713-a5c5-e3e7a9fa1372",
"name": "Sticky Note2"
},
{
"parameters": {
"content": "# Email Verification and Storing Enriched Data\n- Validate email and store enriched prospect leads with Zerobounce",
"height": 896,
"width": 1344,
"color": 7
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-8880,
-224
],
"id": "2e3b9ebb-1940-4d14-a20e-077e2db59d4d",
"name": "Sticky Note3"
}
],
"connections": {
"Workflow Configuration": {
"main": [
[
{
"node": "Remove Duplicate Prospects",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicate Prospects": {
"main": [
[
{
"node": "Filter Valid Prospects",
"type": "main",
"index": 0
}
]
]
},
"Filter Valid Prospects": {
"main": [
[
{
"node": "Prepare for Enrichment",
"type": "main",
"index": 0
}
]
]
},
"Prepare for Enrichment": {
"main": [
[
{
"node": "Route by Available Data",
"type": "main",
"index": 0
}
]
]
},
"Map Enriched Data": {
"main": [
[
{
"node": "Check if Email Missing",
"type": "main",
"index": 0
}
]
]
},
"Filter Enriched Records": {
"main": [
[
{
"node": "Prepare for Verification",
"type": "main",
"index": 0
}
]
]
},
"Prepare for Verification": {
"main": [
[
{
"node": "Zerobounce Email Verification",
"type": "main",
"index": 0
}
]
]
},
"Zerobounce Email Verification": {
"main": [
[
{
"node": "Check Email Validity",
"type": "main",
"index": 0
}
]
]
},
"Check Email Validity": {
"main": [
[
{
"node": "Mark as Verified",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark as Invalid",
"type": "main",
"index": 0
}
]
]
},
"Mark as Verified": {
"main": [
[
{
"node": "Combine Verification Results",
"type": "main",
"index": 0
}
]
]
},
"Mark as Invalid": {
"main": [
[
{
"node": "Combine Verification Results",
"type": "main",
"index": 1
}
]
]
},
"Combine Verification Results": {
"main": [
[
{
"node": "Merge All Data Paths",
"type": "main",
"index": 0
}
]
]
},
"When Row Added to Prospect List": {
"main": [
[
{
"node": "Workflow Configuration",
"type": "main",
"index": 0
}
]
]
},
"Route by Available Data": {
"main": [
[
{
"node": "Enrich by LinkedIn URL",
"type": "main",
"index": 0
}
],
[
{
"node": "Enrich by Email",
"type": "main",
"index": 0
}
],
[
{
"node": "Enrich by Name + Company",
"type": "main",
"index": 0
}
]
]
},
"Enrich by LinkedIn URL": {
"main": [
[
{
"node": "Merge Enrichment Results",
"type": "main",
"index": 0
}
]
]
},
"Enrich by Email": {
"main": [
[
{
"node": "Merge Enrichment Results",
"type": "main",
"index": 1
}
]
]
},
"Enrich by Name + Company": {
"main": [
[
{
"node": "Merge Enrichment Results",
"type": "main",
"index": 2
}
]
]
},
"Merge Enrichment Results": {
"main": [
[
{
"node": "Check Enrichment Success",
"type": "main",
"index": 0
}
]
]
},
"Check Enrichment Success": {
"main": [
[
{
"node": "Map Enriched Data",
"type": "main",
"index": 0
}
]
]
},
"Check if Email Missing": {
"main": [
[
{
"node": "Prepare Work Email Request",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge Email Paths",
"type": "main",
"index": 1
}
]
]
},
"Prepare Work Email Request": {
"main": [
[
{
"node": "Find Work Email via Limadata",
"type": "main",
"index": 0
}
]
]
},
"Find Work Email via Limadata": {
"main": [
[
{
"node": "Check Work Email Found",
"type": "main",
"index": 0
}
]
]
},
"Check Work Email Found": {
"main": [
[
{
"node": "Add Work Email to Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark for Direct Save",
"type": "main",
"index": 0
}
]
]
},
"Add Work Email to Data": {
"main": [
[
{
"node": "Merge Email Paths",
"type": "main",
"index": 0
}
]
]
},
"Mark for Direct Save": {
"main": [
[
{
"node": "Merge All Data Paths",
"type": "main",
"index": 1
}
]
]
},
"Merge Email Paths": {
"main": [
[
{
"node": "Filter Enriched Records",
"type": "main",
"index": 0
}
]
]
},
"Merge All Data Paths": {
"main": [
[
{
"node": "Save to Enriched Data Sheet",
"type": "main",
"index": 0
}
]
]
}
},
"meta": {
"templateCredsSetupCompleted": true
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApigoogleSheetsTriggerOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Enrich And Veryify Leads. Uses httpRequest, googleSheets, googleSheetsTrigger. Event-driven trigger; 32 nodes.
Source: https://gist.github.com/ansh808s/591ad6d93c972ab282f41e75643698ad — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This template finds businesses on Google Maps → writes to Google Sheets → enriches + verifies email contact so your outreach stays clean and deliverable. It includes Sticky Notes** to explain the flow
HTTP Request, Google Sheets, @Verificaremails/N8N Nodes Verificaremails +1
Description:
Google Sheets Trigger, Google Sheets, HTTP Request
Description:
Google Sheets Trigger, Google Sheets, HTTP Request
This automated n8n workflow qualifies B2B leads via voice calls using the VAPI API and integrates the collected data into Google Sheets. It triggers when a new lead’s phone number is added, streamlini
Google Sheets Trigger, HTTP Request, Google Sheets
Transform your lead generation process with this powerful n8n workflow that automatically captures form submissions from Google Forms and creates organized lead cards in Trello.
Google Sheets Trigger, Trello, HTTP Request