Validate and enrich JotForm leads with Reoon email verification and Apollo in sheets

Description

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

Who's it for

Marketing teams, sales professionals, and business owners who collect leads through forms and want to automatically verify email validity and enrich contact data before adding them to their CRM or database.

What it does

When someone submits a contact form on JotForm, this workflow:

• Captures the submission data (name, email, phone, message)
• Creates a new record in Google Sheets
• Verifies the email address using Reoon's email verification API
• Saves validation metrics (deliverability, spam trap detection, disposable email check)
• Filters out unsafe or invalid emails
• Enriches validated contacts with professional data from Apollo (LinkedIn URL, job title, company name)
• Updates the Google Sheet with enriched information

How it works

1. JotForm Trigger - Listens for new form submissions
2. Initial Storage - Creates a contact record in Google Sheets with basic form data
3. Email Verification - Sends email to Reoon API for comprehensive validation
4. Save Verification Results - Updates the sheet with email quality metrics
5. Safety Filter - Only passes emails marked as "safe" to enrichment
6. Contact Enrichment - Queries Apollo API to find professional information
7. Final Update - Saves enriched data (LinkedIn, title, company) back to the sheet

Requirements

Services you'll need:

• JotForm account (free plan available)
• Reoon Email Verifier API access
• Apollo.io account for contact enrichment
• Google account for Google Sheets access

Setup steps:

1. Copy this Google Sheet template (make your own copy)
2. Create a JotForm with fields: First Name, Last Name, E-mail, Phone, Message
3. Get your Reoon API key from their dashboard
4. Get your Apollo.io API key from account settings
5. Connect your Google Sheets account in n8n

How to customize

• Change verification level: Modify the "mode" parameter in the Reoon API call (options: quick, power)
• Adjust filtering criteria: Update the IF node to filter by different email quality metrics
• Add more enrichment: Apollo returns additional data fields you can map to your sheet
• Notification layer: Add a Send Email or Slack node after enrichment to notify your team of high-quality leads
• CRM integration: Replace or supplement Google Sheets with HubSpot, Salesforce, or Pipedrive nodes

This workflow provides a complete lead qualification pipeline that saves time and ensures only high-quality, validated contacts make it into your database with enriched professional information.