Bulk Lead Email Validation with Google Sheets & Anymail Finder - n8n Workflow

• Sales and Marketing Operations teams who need to clean extensive lead lists.


• Data Analysts requiring automated data validation workflows.


• Users looking for a practical n8n workflow example for looping and API integration.


• Any organization focused on improving email deliverability and reducing bounce rates using this sophisticated n8n template.

Maintaining clean and accurate customer data is critical for successful outreach campaigns. This reliable n8n workflow provides an automated solution for validating email addresses retrieved directly from Google Sheets using the powerful Anymail Finder API. Instead of manual verification or external scripts, you can deploy this ready-to-use n8n template to process thousands of records efficiently.

By leveraging the Google Sheets n8n node for both reading and writing, and the HTTP Request n8n node for integration with Anymail Finder, this workflow ensures that your lead data is validated on a per-row basis, updating the verification status in real-time. This specific n8n workflow is engineered for reliability, handling errors gracefully while significantly speeding up your data preparation pipeline.

This automation begins with a manual intervention and follows a structured looping pattern:

1. Initiate (n8n trigger): The process starts when the user executes the Manual Trigger n8n trigger.


2. Retrieve Data: The Google Sheets n8n node named 'Get Leads' reads all rows from the specified sheet (filtered potentially by rows that need verification, indicated by the 'VERIFY' column being empty or flagged).


3. Process Iteration: The 'Loop Over Items' n8n node (Split In Batches) takes the incoming list of leads and processes them one by one, ensuring manageable data handling for the external API.


4. API Call: The 'Check email status' n8n node (HTTP Request) sends the email address of the current lead item to the Anymail Finder API using secure HTTP Header Authentication. This n8n node is configured to continue the process even if an individual API request fails.


5. Update Record: The result of the verification (the email status) is captured. The 'Update email status' Google Sheets n8n node then writes this result back to the original spreadsheet. Crucially, it uses the extracted row_number to accurately identify and update the correct row.


6. Loop Continuation: After updating the spreadsheet, the n8n workflow returns control to the 'Loop Over Items' n8n node to fetch and process the next lead, continuing until all retrieved items have been validated.

To deploy this n8n workflow effectively, follow these steps:

1. Import: Copy the provided JSON data and import it into your n8n instance via the Workflows section ('New' -> 'Import from JSON'). This provides you with the base n8n template.


2. Google Sheets Credential: Configure the Google Sheets n8n node credentials. You will need an OAuth2 credential set up for Google Sheets to grant read/write access to your lead spreadsheet. Ensure the sheet structure matches the expected columns (EMAIL, VERIFY, etc.).


3. Anymail Finder API Key: Locate the 'Check email status' n8n node. This node requires an HTTP Header Auth credential named 'Anymail Finder'. The header Name must be set to Authorization, and the Value must contain your Anymail Finder API key (e.g., YOURAPIKEY).


4. Workflow Configuration: Update the 'Get Leads' and 'Update email status' n8n nodes to point to the correct Document ID and Sheet Name of your specific Google Sheet where the leads are stored.


5. Execution: Once credentials are set and the sheet path is correct, activate the n8n workflow and execute it using the Manual Trigger n8n trigger.

• Manual Trigger (n8n trigger): The starting point for the n8n workflow. Used to initiate the bulk validation job manually.


• Google Sheets (Get Leads): This crucial n8n node performs the Read operation. It fetches lead data from the target spreadsheet. Key configuration includes filtering rows based on the contents of the VERIFY column, ensuring only unverified or target rows are processed.


• Split In Batches (Loop Over Items): This n8n node manages the flow control. It splits the incoming list of leads into individual items, allowing the subsequent validation step to run sequentially for each email address.


• HTTP Request (Check email status): This core n8n node handles the third-party integration. It uses the POST method to query the Anymail Finder API URL, passing the EMAIL value from the current item. It utilizes HTTP Header Auth credentials for authentication.


• Google Sheets (Update email status): This n8n node performs the Update operation. It uses the rownumber received from the initial read operation as the matching column to accurately update the VERIFY status with the validation result ({{ $json.emailstatus }}), completing the cycle within this powerful n8n workflow.