Lead Email Verification and Validation using Hunter.io and Google Sheets - n8n Workflow

Sales operations teams needing to routinely clean CRM data.
Marketing professionals validating email lists before large campaigns.
Users looking for high-quality, practical n8n templates for data management.
Anyone needing reliable automated email verification built with a solid n8n workflow.

Poor lead data quality severely impacts email deliverability and wastes time for sales teams. This robust n8n workflow provides a solution by automating the verification process for contacts stored in Google Sheets. It leverages the specialized Hunter.io email verification service to check SMTP status, identify disposable addresses, and provide a confidence score. By implementing this specific n8n workflow, users ensure their outreach efforts target valid addresses, significantly boosting campaign effectiveness and protecting sender reputation. This powerful combination of a Google Sheets n8n node and an HTTP Request n8n node allows for seamless, hands-free data scrubbing, offering immense value compared to manual processes.

This automation begins with the Schedule n8n trigger (⏯️ Triggers Everyday), which initiates the routine verification process. First, the 📥 Fetch Emails from Source Sheet n8n node reads all existing contact data (Email, FirstName, LastName, Company) from a designated input Google Sheet. The data then passes to the 🧹 Clean & Prepare Email Data custom Code n8n node, which filters out any rows lacking a valid email structure and prepares the payload for the API call. The core of the verification lies in the 🕵️‍♂️ Hunter.io Email Verifier HTTP Request n8n node. This n8n node sends each email address to the Hunter.io verification endpoint, utilizing an API key for authentication. Once Hunter.io returns the comprehensive verification status, the 🧠 Format Hunter Response Code n8n node intelligently merges the raw verification results (score, status, SMTP check) back with the original lead data. Finally, the 📤 Write Results to Output Sheet Google Sheets n8n node executes an 'append or update' operation, writing the complete, verified dataset, including a human-readable status summary, to a specified output sheet. This entire n8n workflow is designed for efficient, batch processing of lead data.

To deploy this useful n8n workflow, follow these setup steps:

1. Import the n8n Workflow: Copy the provided JSON code and import it into your n8n instance using the 'New' -> 'Import from JSON' function.


2. Configure Credentials:

1. Update Google Sheet IDs: In both Google Sheets n8n node instances, update the documentId fields to point to your specific input and output spreadsheet IDs.


2. Activate: Enable the n8n workflow using the toggle switch and test the n8n trigger manually before scheduling.

⏯️ Triggers Everyday (Schedule n8n trigger): Sets the automation to run periodically, although it can be triggered manually for testing or on-demand batch runs.
📥 Fetch Emails from Source Sheet (Google Sheets n8n node): Connects to the designated input sheet and retrieves rows containing lead data (Email, FirstName, etc.).
🧹 Clean & Prepare Email Data (Code n8n node): A custom scripting n8n node that iterates through input items, filters out invalid email entries, and standardizes the data structure before verification.
🕵️‍♂️ Hunter.io Email Verifier (HTTP Request n8n node): The core verification step. It calls the Hunter.io API endpoint (/v2/email-verifier) for each lead, passing the email and the required API key as query parameters.
🧠 Format Hunter Response (Code n8n node): This crucial post-processing n8n node retrieves data from both the initial cleaning step and the Hunter.io API response, merging them into a single, comprehensive output structure. It calculates fields like statusSummary for easy review.
📤 Write Results to Output Sheet (Google Sheets n8n node): Takes the verified and formatted data and writes it back to a dedicated output sheet. It uses the appendOrUpdate operation, matching records based on the email address, providing a clean audit trail for this n8n workflow.