Skip to content

Instantly share code, notes, and snippets.

@ansh808s
Created February 6, 2026 13:42
Show Gist options
  • Select an option

  • Save ansh808s/591ad6d93c972ab282f41e75643698ad to your computer and use it in GitHub Desktop.

Select an option

Save ansh808s/591ad6d93c972ab282f41e75643698ad to your computer and use it in GitHub Desktop.
Enrich and Veryify leads
{
"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": {
"id": "GOOGLE_SHEET",
"name": "Google Sheets account"
}
}
},
{
"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": {
"id": "Google_Sheet_ID",
"name": "Google Sheets Trigger account"
}
}
},
{
"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
}
]
]
}
},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "5544243018978d8bc3747384ecd8162b71d951ca320a4b5a19d103243b3c5f6c"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment