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.