Lead Validation and Enrichment Pipeline - n8n Workflow

• Marketing Managers who rely on form submissions for lead generation.


• Sales Operations professionals needing validated, high-quality contact data.


• Users looking for advanced examples of conditional logic within an n8n workflow.


• Anyone seeking robust n8n templates for CRM and data pipeline automation.

Maintaining a clean and highly detailed contact database is crucial for effective sales and marketing outreach. This sophisticated n8n workflow template solves the problem of dealing with spam, invalid, or low-quality form submissions by implementing an immediate validation and enrichment layer.

Starting with a JotForm submission, the data is instantly recorded in Google Sheets. Crucially, the n8n workflow then passes the email through Reoon for deep verification. Only emails deemed 'safe' are allowed to proceed to the expensive enrichment step, where Apollo.io is used to pull in professional data like job titles and company names. This ensures you save money on enrichment APIs and improve deliverability by only focusing on verified, valid leads. This entire process is orchestrated automatically using n8n nodes, providing a resilient and efficient lead processing pipeline. If you need robust n8n templates for lead management, this is a prime example.

This n8n workflow begins execution immediately upon a new form submission, functioning as a real-time lead processing system.

1. Lead Capture (JotForm Trigger): The n8n trigger starts when a user completes and submits the specified JotForm.


2. Initial Storage: The initial contact data (Name, Email, Phone) is instantly appended as a new row in Google Sheets, ensuring no data is lost.


3. Email Verification (Reoon): The email address is passed to the Reoon API via an HTTP Request n8n node to perform detailed checks (syntax, deliverability, spam trap, catch-all status).


4. Update Verification Status: The results from Reoon (overall score, status, deliverability flags) are updated in the corresponding Google Sheet row.


5. Conditional Filtering: An IF n8n node checks if the status returned by Reoon is 'safe'. Only items meeting this condition continue down the enrichment path.


6. Contact Enrichment (Apollo): For safe emails, an HTTP Request n8n node calls the Apollo.io contact match API to retrieve professional data (job title, LinkedIn URL, organization name).


7. Final Update: The enriched data from Apollo is used to update the same contact record in Google Sheets, completing the lead profile. This seamless integration showcases the power of this n8n workflow template.

To deploy this powerful n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and paste it into your n8n instance using the 'New' menu and selecting 'Import from JSON'.


2. Google Sheets Setup: Copy the provided Google Sheet template (link provided in the Sticky Note) and update the Document ID and Sheet Name in the three Google Sheets n8n node instances.


3. JotForm Setup: Configure the 'Trigger: JotForm Submission' n8n trigger node by selecting your JotForm credential and ensuring the correct Form ID is entered.


4. Credential Configuration: You must set up API credentials within your n8n instance for the external services:

1. Activation: Once all credentials and IDs are updated in every n8n node, activate the n8n workflow to begin automated processing.

This n8n workflow utilizes several key n8n node types to achieve its complex logic:

JotForm Trigger:
Function: Acts as the n8n trigger, initiating the entire process upon a new form submission.
Key Configuration: Configured to watch a specific JotForm ID (252806830916461).
Google Sheets (Sheets: Create Contact Record & Sheets: Save Verification Status & Sheets: Save Enriched Data):
Function: Used repeatedly throughout the flow—first to append the initial record, then twice to update the row with verification and enrichment data.
Key Configuration: All Sheet nodes use the 'update' or 'append' operation, matching records based on the submitted email column.
HTTP Request (API: Email Verification (Reoon)):
Function: Calls the external Reoon API to validate the email address.
Key Configuration: Uses HTTP Query Authentication and sends the email address via a query parameter email={{ $json.email }}.
If (Filter: Safe Emails Only):
Function: Implements core flow control logic. It gates the expensive enrichment step, ensuring only verified, 'safe' emails proceed.
Key Configuration: Checks if {{ $json.status }} equals safe.
HTTP Request (API: Contact Enrichment (Apollo)):
Function: Executes API call to Apollo.io to retrieve professional data.
* Key Configuration: Uses HTTP Header Authentication and sends the email via a query parameter to the /people/match endpoint. This n8n node is crucial for deep data retrieval.