Validate and Enrich JotForm Leads with Reoon Email Verification and Apollo in Sheets
ęčæ°
åē±»
āļø Automation
ä½æēØēčē¹
n8n-nodes-base.ifn8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.httpRequestn8n-nodes-base.httpRequest
ä»·ę ¼å
č“¹
ęµč§é0
ęåę“ę°11/28/2025
workflow.json
{
"meta": {
"instanceId": "8d41476c63702cd0f2be55363b48153c5d4820bb18197ca147e7be50ef236112",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "563f7548-f33f-4901-95bb-63906f42dbe0",
"name": "Trigger: JotForm Submission",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
-400,
32
],
"webhookId": "f32145a7-f0e6-4574-b420-4aa42b8fac01",
"parameters": {
"form": "252806830916461"
},
"credentials": {
"jotFormApi": {
"id": "ZQzE9kLfYcfbpT81",
"name": "[Naveen]JotForm account"
}
},
"typeVersion": 1
},
{
"id": "b20bd2fb-f973-43b5-aec7-f64dfc96224a",
"name": "Sheets: Create Contact Record",
"type": "n8n-nodes-base.googleSheets",
"position": [
-192,
32
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json['E-mail'] }}",
"phone": "={{ $json.Phone }}",
"message": "={{ $json.Message }}",
"last_name": "={{ $json['Last Name'] }}",
"first_name": "={{ $json['First Name'] }}"
},
"schema": [
{
"id": "first_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "overall_score",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "overall_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_deliverable",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_deliverable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_free_email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_free_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_catch_all",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_catch_all",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_disposable",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_disposable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_role_account",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_role_account",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_safe_to_send",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_safe_to_send",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_spamtrap",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_spamtrap",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_valid_syntax",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_valid_syntax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_firstname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_lastname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_organization_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_organization_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed_at",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "processed_at",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit#gid=0",
"cachedResultName": "Contact Form"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit?usp=drivesdk",
"cachedResultName": "JotForm Contact Validation & Enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "V4NHfo08zBK4IW4e",
"name": "[Naveen]Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "368f029f-630b-4860-9e26-e8e36c3a8115",
"name": "API: Email Verification (Reoon)",
"type": "n8n-nodes-base.httpRequest",
"position": [
32,
32
],
"parameters": {
"url": "https://emailverifier.reoon.com/api/v1/verify",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "email",
"value": "={{ $json.email }}"
},
{
"name": "mode",
"value": "power"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"id": "gLP6fzinBZjfgHu0",
"name": "[Reoon/Sean]Query Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "5f3fd91f-914e-4ceb-970b-9f266f17eae3",
"name": "Sheets: Save Verification Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
240,
32
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json.email }}",
"domain": "={{ $json.domain }}",
"status": "={{ $json.status }}",
"is_spamtrap": "={{ $json.is_spamtrap }}",
"is_catch_all": "={{ $json.is_catch_all }}",
"processed_at": "=",
"is_disposable": "={{ $json.is_disposable }}",
"is_free_email": "={{ $json.is_free_email }}",
"overall_score": "={{ $json.overall_score }}",
"is_deliverable": "={{ $json.is_deliverable }}",
"is_role_account": "={{ $json.is_role_account }}",
"is_safe_to_send": "={{ $json.is_safe_to_send }}",
"is_valid_syntax": "={{ $json.is_valid_syntax }}"
},
"schema": [
{
"id": "first_name",
"type": "string",
"display": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "overall_score",
"type": "string",
"display": true,
"required": false,
"displayName": "overall_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_deliverable",
"type": "string",
"display": true,
"required": false,
"displayName": "is_deliverable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_free_email",
"type": "string",
"display": true,
"required": false,
"displayName": "is_free_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_catch_all",
"type": "string",
"display": true,
"required": false,
"displayName": "is_catch_all",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_disposable",
"type": "string",
"display": true,
"required": false,
"displayName": "is_disposable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_role_account",
"type": "string",
"display": true,
"required": false,
"displayName": "is_role_account",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_safe_to_send",
"type": "string",
"display": true,
"required": false,
"displayName": "is_safe_to_send",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_spamtrap",
"type": "string",
"display": true,
"required": false,
"displayName": "is_spamtrap",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_valid_syntax",
"type": "string",
"display": true,
"required": false,
"displayName": "is_valid_syntax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_firstname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_lastname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_organization_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_organization_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed_at",
"type": "string",
"display": true,
"required": false,
"displayName": "processed_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit#gid=0",
"cachedResultName": "Contact Form"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit?usp=drivesdk",
"cachedResultName": "JotForm Contact Validation & Enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "V4NHfo08zBK4IW4e",
"name": "[Naveen]Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "94a9dbf1-120f-4203-a7e6-1e4055a2acc3",
"name": "Filter: Safe Emails Only",
"type": "n8n-nodes-base.if",
"position": [
448,
32
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "1a2bc2ad-ac91-4474-be1b-4e687a9e34b7",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "safe"
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "e63a1b68-d28b-4ff6-a0fa-440741587541",
"name": "API: Contact Enrichment (Apollo)",
"type": "n8n-nodes-base.httpRequest",
"position": [
720,
-48
],
"parameters": {
"url": "https://api.apollo.io/api/v1/people/match",
"method": "POST",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "email",
"value": "={{ $json.email }}"
},
{
"name": "reveal_personal_emails",
"value": "false"
},
{
"name": "reveal_phone_number",
"value": "false"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Cache-Control",
"value": "no-cache"
},
{
"name": "accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "XwELyyFjq7zjLcVP",
"name": "[Apollo/Sean]Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "7555fc87-fbf2-43a0-a873-3a72776e64fa",
"name": "Sheets: Save Enriched Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
928,
-48
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json.person.email }}",
"processed_at": "={{ $now.toFormat('yyyy-MM-dd') }}",
"enriched_title": "={{ $json.person.title }}",
"enriched_lastname": "={{ $json.person.last_name }}",
"enriched_firstname": "={{ $json.person.first_name }}",
"enriched_linkedin_url": "={{ $json.person.linkedin_url }}",
"enriched_organization_name": "={{ $json.person.organization.name }}"
},
"schema": [
{
"id": "first_name",
"type": "string",
"display": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "overall_score",
"type": "string",
"display": true,
"required": false,
"displayName": "overall_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_deliverable",
"type": "string",
"display": true,
"required": false,
"displayName": "is_deliverable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_free_email",
"type": "string",
"display": true,
"required": false,
"displayName": "is_free_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_catch_all",
"type": "string",
"display": true,
"required": false,
"displayName": "is_catch_all",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_disposable",
"type": "string",
"display": true,
"required": false,
"displayName": "is_disposable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_role_account",
"type": "string",
"display": true,
"required": false,
"displayName": "is_role_account",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_safe_to_send",
"type": "string",
"display": true,
"required": false,
"displayName": "is_safe_to_send",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_spamtrap",
"type": "string",
"display": true,
"required": false,
"displayName": "is_spamtrap",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_valid_syntax",
"type": "string",
"display": true,
"required": false,
"displayName": "is_valid_syntax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_firstname",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_lastname",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_linkedin_url",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_title",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_organization_name",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_organization_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed_at",
"type": "string",
"display": true,
"required": false,
"displayName": "processed_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit#gid=0",
"cachedResultName": "Contact Form"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit?usp=drivesdk",
"cachedResultName": "JotForm Contact Validation & Enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "V4NHfo08zBK4IW4e",
"name": "[Naveen]Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "6f6293ca-42e9-42f3-892c-5c35237dc959",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1088,
-128
],
"parameters": {
"width": 560,
"height": 480,
"content": "## š JotForm Contact Validation & Enrichment\n\nThis workflow automatically validates and enriches contact form submissions.\n\n**What it does:**\nā
Captures JotForm submissions\nā
Verifies email validity with Reoon\nā
Filters out risky/invalid emails\nā
Enriches safe contacts with Apollo data\nā
Stores everything in Google Sheets\n\n**Setup Required:**\n1. Copy the [Google Sheet template](https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/copy)\n2. Sign up for services:\n - [JotForm](https://www.jotform.com/pricing/?partner=naveenchoudhary)\n - [Reoon](https://emailverifier.reoon.com/)\n - [Apollo](https://www.apollo.io/)\n3. Update the Google Sheet ID in all Sheet nodes\n4. Configure your API credentials\n5. Update JotForm ID in the trigger node"
},
"typeVersion": 1
},
{
"id": "1bb22245-1a9e-403b-8369-5739573588a2",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-144
],
"parameters": {
"color": 7,
"width": 256,
"height": 144,
"content": "**Step 1: Form Submission**\n\nTriggers when someone submits your JotForm contact form. Make sure to update the form ID with your own JotForm ID."
},
"typeVersion": 1
},
{
"id": "c7aff216-b33a-4bc2-a1e2-eba6b8739003",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
32,
432
],
"parameters": {
"color": 3,
"width": 608,
"height": 272,
"content": "ā ļø **IMPORTANT - Update These Settings:**\n\n1. **Google Sheet ID**: Replace in ALL Google Sheets nodes with your copied sheet ID\n2. **JotForm ID**: Update in the trigger node\n3. **API Credentials**: Configure Reoon and Apollo credentials in n8n\n4. **Form Fields**: Ensure your JotForm has matching field names\n\nš **Quick Links:**\n- Copy [Google Sheet](https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/copy)\n- Reoon API: https://emailverifier.reoon.com/\n- Apollo API: https://www.apollo.io/"
},
"typeVersion": 1
},
{
"id": "fc5f1647-efbb-43d8-8b3c-7a1fb21b7dda",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-288,
240
],
"parameters": {
"color": 7,
"width": 272,
"height": 144,
"content": "**Step 2: Initial Storage**\n\nCreates a new row in Google Sheets with the basic form data. This ensures we capture all submissions before validation."
},
"typeVersion": 1
},
{
"id": "2708f469-4f86-41cb-b017-d5df61c9fcd9",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
-144
],
"parameters": {
"color": 7,
"width": 256,
"height": 144,
"content": "**Step 3: Email Verification**\n\nSends email to Reoon API for comprehensive validation. Checks for deliverability, spam traps, disposable emails, and more."
},
"typeVersion": 1
},
{
"id": "eb3af6ad-a6f1-48f3-b0ad-8073aef0c8dc",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
224
],
"parameters": {
"color": 7,
"width": 288,
"height": 144,
"content": "**Step 4: Safety Filter**\n\nOnly emails marked as \"safe\" proceed to enrichment. This protects your sender reputation and ensures data quality."
},
"typeVersion": 1
},
{
"id": "21b92677-1283-497e-8723-f59ec2e2535b",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
608,
-208
],
"parameters": {
"color": 7,
"width": 304,
"height": 128,
"content": "**Step 5: Contact Enrichment**\n\nQueries Apollo.io to find professional information including LinkedIn profile, job title, and company name."
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Filter: Safe Emails Only": {
"main": [
[
{
"node": "API: Contact Enrichment (Apollo)",
"type": "main",
"index": 0
}
]
]
},
"Trigger: JotForm Submission": {
"main": [
[
{
"node": "Sheets: Create Contact Record",
"type": "main",
"index": 0
}
]
]
},
"Sheets: Create Contact Record": {
"main": [
[
{
"node": "API: Email Verification (Reoon)",
"type": "main",
"index": 0
}
]
]
},
"API: Email Verification (Reoon)": {
"main": [
[
{
"node": "Sheets: Save Verification Status",
"type": "main",
"index": 0
}
]
]
},
"API: Contact Enrichment (Apollo)": {
"main": [
[
{
"node": "Sheets: Save Enriched Data",
"type": "main",
"index": 0
}
]
]
},
"Sheets: Save Verification Status": {
"main": [
[
{
"node": "Filter: Safe Emails Only",
"type": "main",
"index": 0
}
]
]
}
}
}