Automated Email Verification for Google Sheets using Rapid Verifier - n8n Workflow

Email Marketers: Users needing to maintain clean mailing lists and improve deliverability rates.
Sales Teams: Professionals qualifying leads entered into a CRM or spreadsheet.
Data Engineers: Anyone looking to automate data hygiene practices within Google Sheets.
n8n Users: Individuals seeking practical n8n templates for data processing and API integration.

Maintaining high-quality contact data is crucial for successful outreach, but manual email verification is tedious and time-consuming. This specialized n8n workflow solves this by providing a hands-off, continuous email validation system. The n8n automation monitors a designated Google Sheet, identifies new, unverified entries, leverages the rapid-email-verifier API for validation, and efficiently updates the sheet with the verification status. This ensures your data is always fresh, reducing bounce rates and protecting sender reputation. This core logic flow control demonstrates advanced usage of key n8n node types, providing a robust solution ready for production use.

This n8n workflow operates on a scheduled polling mechanism to provide near real-time verification.

1. Trigger (n8n trigger): The process begins with the 'Monitor New Email Entries' Google Sheets Trigger n8n node, which polls the specified spreadsheet hourly, looking for newly added rows.


2. Filtering: The 'Filter Unverified Emails' n8n node checks if the 'Email Verified' column is empty. This crucial step prevents redundant API calls by only passing emails that have not yet been processed.


3. Batch Processing: The 'Process Emails in Batches' n8n node ensures that the subsequent API calls are handled sequentially (or in small batches), respecting API rate limits and enhancing the reliability of the overall n8n workflow.


4. API Validation: The 'Verify Email Address' HTTP Request n8n node executes a validation check against the rapid-email-verifier API, passing the email address dynamically from the spreadsheet row data.


5. Data Update: Finally, the 'Update Verification Results' Google Sheets n8n node uses the unique row ID ('SrNo') to match and update the original row, writing the validation status (e.g., 'valid', 'invalid') into the 'Email Verified' column. The flow loops back to handle the next item in the batch until all new entries are processed.

To deploy this powerful n8n workflow template, follow these steps:

1. Import: Import the provided n8n workflow JSON data into your n8n instance.


2. Google Sheet Setup: Create a Google Spreadsheet with the required columns: SrNo, Name, Email, and Email Verified.


3. Credential Setup: Connect your Google Sheets account by configuring the OAuth2 API credentials used in the 'Monitor New Email Entries' n8n trigger node and the 'Update Verification Results' n8n node.


4. Configure Nodes: Update the 'Document ID' and 'Sheet Name' parameters in both the Google Sheets Trigger and the Google Sheets Update n8n nodes to point to your newly created spreadsheet.


5. API Note: The rapid-email-verifier n8n node is configured to use an unauthenticated public endpoint (free tier limits apply). No separate API key setup is necessary.


6. Activation: Save the n8n workflow and toggle it to 'Active' to start the hourly monitoring process.

This n8n workflow leverages several specialized n8n node types to achieve continuous automation:

Monitor New Email Entries (Google Sheets Trigger n8n trigger):
Function: Starts the n8n workflow when a new row is added to the specified spreadsheet.
Key Configuration: Event: rowAdded. Poll Time: every hour.
Filter Unverified Emails (Filter n8n node):
Function: Implements smart logic to process only records where the 'Email Verified' column is currently empty.
Key Configuration: Condition checks if $json['Email Verified'] equals an empty string ("").
Process Emails in Batches (Split In Batches n8n node):
Function: Manages the flow control, ensuring items are processed sequentially to avoid API concurrency issues or rate limits.
Key Configuration: Default batch size (or sequential processing) is utilized.
Verify Email Address (HTTP Request n8n node):
Function: Contacts the external verification API (rapid-email-verifier) to determine the status of the email address.
Key Configuration: URL: https://rapid-email-verifier.fly.dev/api/validate. The email is passed via a Query Parameter using expression ={{ $json.Email }}.
Update Verification Results (Google Sheets n8n node):
Function: Writes the verification status (valid/invalid/unknown) back to the originating spreadsheet row.
* Key Configuration: Operation: appendOrUpdate. Matching Columns: SrNo. Data updated: 'Email Verified' using the expression ={{ $json.status }}.