AutomationFlowsMarketing & Ads › Validate and Enrich Jotform Leads with Reoon Email Verification and Apollo…

Validate and Enrich Jotform Leads with Reoon Email Verification and Apollo…

Original n8n title: Validate and Enrich Jotform Leads with Reoon Email Verification and Apollo in Sheets

ByNaveen Choudhary @n8nstein on n8n.io

This workflow automatically validates and enriches contact form submissions from JotForm, ensuring you only store high-quality leads with complete business information.

Event trigger★★★★☆ complexity14 nodesJot Form TriggerGoogle SheetsHTTP Request
Marketing & Ads Trigger: Event Nodes: 14 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #9391 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request 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 →

Download .json
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "563f7548-f33f-4901-95bb-63906f42dbe0",
      "name": "Trigger: JotForm Submission",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        -400,
        32
      ],
      "parameters": {
        "form": "252806830916461"
      },
      "credentials": {
        "jotFormApi": {
          "name": "<your credential>"
        }
      },
      "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": {
          "name": "<your credential>"
        }
      },
      "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": {
          "name": "<your credential>"
        }
      },
      "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": {
          "name": "<your credential>"
        }
      },
      "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": {
          "name": "<your credential>"
        }
      },
      "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": {
          "name": "<your credential>"
        }
      },
      "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": "## \ud83d\udccb JotForm Contact Validation & Enrichment\n\nThis workflow automatically validates and enriches contact form submissions.\n\n**What it does:**\n\u2705 Captures JotForm submissions\n\u2705 Verifies email validity with Reoon\n\u2705 Filters out risky/invalid emails\n\u2705 Enriches safe contacts with Apollo data\n\u2705 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": "\u26a0\ufe0f **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\ud83d\udd17 **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
    }
  ],
  "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
          }
        ]
      ]
    }
  }
}

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.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow automatically validates and enriches contact form submissions from JotForm, ensuring you only store high-quality leads with complete business information.

Source: https://n8n.io/workflows/9391/ — original creator credit. Request a take-down →

More Marketing & Ads workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Marketing & Ads

This workflow automates the transition of new Jotform submissions into ActiveCampaign, using ZeroBounce for multi-layer validation (Validation + Scoring).

@Zerobounce/N8N Nodes Zerobounce, Google Sheets, Jot Form Trigger +1
Marketing & Ads

This n8n workflow automatically generates lead magnet ideas based on topics and website URLs stored in a Google Sheet. It uses the Lead Magnet Idea Generator AI API to produce relevant, value-driven i

HTTP Request, Google Sheets, Google Drive Trigger
Marketing & Ads

行銷自動化:Leads Magnet Mail List - n8n form. Uses formTrigger, googleSheets, httpRequest, gmail. Event-driven trigger; 10 nodes.

Form Trigger, Google Sheets, HTTP Request +2
Marketing & Ads

This LinkedIn automation workflow monitors post comments for specific trigger words and automatically sends direct messages with lead magnets to engaged users. The system checks connection status, han

HTTP Request, Noco Db, Form Trigger
Marketing & Ads

This workflow automates the transition of new Typeform submissions into Mautic, using ZeroBounce for multi-layer validation (Validation + Scoring).

@Zerobounce/N8N Nodes Zerobounce, Google Sheets, Typeform Trigger +1