Jotform Lead Validation and Enrichment with Reoon Email Verification and Apollo in Google Sheets

This n8n workflow automates the process of validating and enriching leads submitted via Jotform, then logging the results into a Google Sheet. It integrates email verification using the Reoon API and attempts to find company data using Apollo.io (though the Apollo.io step is not fully defined in the provided JSON, it's indicated by the directory name and common use cases for lead enrichment).

What it does

This workflow performs the following key steps:

1. Listens for new Jotform submissions: It acts as a webhook listener for a specified Jotform form.
2. Performs Email Verification: It takes the email address from the Jotform submission and sends it to the Reoon Email Verifier API to check its validity.
3. Conditionally Processes Valid Emails: It checks the result from Reoon.
   • If the email is valid, it proceeds to the next enrichment step.
   • If the email is invalid, it will not proceed with further enrichment (though the specific handling for invalid emails isn't explicitly defined in the provided JSON, it's implied by the If node).
4. Enriches Lead Data (Implied): Based on the directory name, the workflow is intended to use Apollo.io to enrich the lead data (e.g., finding company information based on the email domain). Note: The provided JSON does not contain an Apollo.io node, but the workflow name suggests its inclusion.
5. Logs to Google Sheets: It appends the original Jotform submission data, Reoon email verification results, and any enriched data (from Apollo.io) to a Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Account: A running instance of n8n.
• Jotform Account: A Jotform account with a form configured to send submissions to this workflow's webhook.
• Reoon Email Verifier API Key: An API key for Reoon Email Verifier.
• Google Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential for Google Sheets (OAuth 2.0 or Service Account).
• Apollo.io API Key (Implied): If you intend to use Apollo.io for enrichment, you will need an Apollo.io API key and an n8n credential for it.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Jotform Trigger:
   • Select your Jotform credential.
   • Choose the specific Jotform form you want to trigger this workflow.
   • Activate the workflow to generate the webhook URL. Copy this URL.
   • In your Jotform settings, configure a webhook to send submissions to the copied URL.
3. Configure Reoon Email Verification:
   • Open the "HTTP Request" node (likely configured for Reoon).
   • Set up a new HTTP Basic Auth or API Key credential for Reoon, using your Reoon API key.
   • Ensure the request body correctly sends the email from the Jotform trigger to the Reoon API.
4. Configure the 'If' node:
   • Review the conditions in the "If" node to ensure it correctly evaluates the result.status or similar field from the Reoon API response to determine email validity.
5. Add/Configure Apollo.io Node (if applicable):
   • If the Apollo.io step is not present, add an Apollo.io node (or another HTTP Request node) to perform the enrichment.
   • Configure it with your Apollo.io credential and the necessary parameters to search for company data using the email domain or other available lead information.
6. Configure Google Sheets Node:
   • Select your Google Sheets credential.
   • Specify the Spreadsheet ID and Sheet Name where you want to log the data.
   • Map the data fields from the Jotform submission, Reoon verification, and Apollo.io enrichment to the appropriate columns in your Google Sheet.
7. Activate the workflow: Once all credentials and nodes are configured, activate the workflow. New Jotform submissions will now automatically be processed, verified, enriched, and logged.