Automated Email Verification and Google Sheet Deliverability Update - n8n Workflow

Sales Development Representatives (SDRs): Who need clean lead lists before initiating outreach campaigns.
Marketing Professionals: Managing email subscription lists and needing to reduce bounce rates.
Data Engineers and Analysts: Focused on maintaining high data quality within CRM inputs or spreadsheets.
n8n Users: Seeking ready-to-use n8n templates for integrating Sheets with external validation services.

Maintaining accurate and deliverable email lists is crucial for successful marketing and sales operations. Manually validating hundreds of emails is time-consuming and error-prone. This n8n workflow solves this by providing a seamless, automated process. Every time a new row is added to your specified Google Sheet, the dedicated n8n trigger instantly starts the process. The email address is sent to a verification API (EmailValidation.io in this case), and the resulting deliverability status is written back directly into the Google Sheet. This n8n automation ensures your data is clean and actionable without requiring manual intervention, saving significant operational time.

The automated process begins with the designated n8n trigger, the Google Sheets Trigger node. This n8n trigger is configured to constantly monitor a specified document ('Email Validation') for the addition of new rows.

1. Trigger and Filter: When a new row is detected, the workflow proceeds. The data is first passed through the 'Filter Empty Cells' n8n node to ensure that only rows containing a valid email address are processed, preventing unnecessary API calls.


2. Data Preparation: The 'Take Email Only' set n8n node isolates the email field, standardizing the data format before contacting the external service.


3. API Validation: The core validation is handled by the 'Email Validation API' node (configured as an HTTP Request). It uses the provided email address to query the EmailValidation.io API and retrieve the deliverability status.


4. Status Extraction: The 'Take Email and Validation Status' set n8n node parses the API response, extracting the specific email and the validation state (e.g., 'deliverable', 'undeliverable').


5. Google Sheets Update: Finally, the 'Update the Sheets with Validation Status' Google Sheets n8n node writes this status back to the original spreadsheet. It uses the email address as the matching key to locate the row and updates the 'Deliverability' column with the verified status, completing the efficient n8n workflow.

To deploy this comprehensive n8n workflow, follow these steps:

1. Import: Copy the provided JSON data and paste it into your n8n canvas to import this n8n template.


2. Google Sheets Credentials: Click on the 'Google Sheets Trigger' n8n node and the 'Update the Sheets with Validation Status' n8n node. Connect or create new Google Sheets OAuth2 API credentials, granting n8n access to your specified spreadsheet.


3. Spreadsheet Configuration: Ensure the sheet ID and sheet name configured in both Google Sheets nodes match your target spreadsheet. Verify that you have columns named 'Email' and 'Deliverability'.


4. API Key Setup: In the 'Email Validation API' HTTP Request n8n node, you must replace {{api_key}} in the URL with your actual API key for EmailValidation.io (or set up a corresponding environment variable).


5. Activate: Save the n8n workflow and activate it to start monitoring your Google Sheet for new email inputs automatically.

Google Sheets Trigger: This is the primary n8n trigger. It monitors the designated Google Sheet ('Email Validation') and fires the n8n workflow whenever a new row is added, ensuring real-time processing.
Filter Empty Cells (Filter n8n node): Ensures that the Email column field is not empty before allowing the data item to proceed to the API call, optimizing resource usage.
Take Email Only (Set n8n node): Prepares the data by isolating the necessary Email field, ensuring the subsequent HTTP request node receives clean input.
Email Validation API (HTTP Request n8n node): Performs the heavy lifting by calling the EmailValidation.io API using a dynamic URL that includes the email address and your API key. Note: An alternative 'Hunter' n8n node is included but disconnected.
Take Email and Validation Status (Set n8n node): Maps the critical output from the API response (state and email) into standardized fields (status, email) for easier use in the final update step.
Update the Sheets with Validation Status (Google Sheets n8n node): The final action. It uses the validated email address to locate the corresponding row in the Google Sheet and updates the 'Deliverability ' column with the status retrieved from the API.