Google Sheets + Anymail Finder: fewer email bounces
Your outreach list looks fine… until the bounces start coming back. Then you’re stuck second-guessing every “good” lead, cleaning spreadsheets at the worst possible moment, and hoping your domain reputation doesn’t take a hit.
This is where email verification automation pays off fast. Marketing managers running campaigns feel it first, but agency owners and scrappy founders doing outbound from a Sheet deal with the same mess.
This workflow verifies emails directly inside Google Sheets using Anymail Finder, then writes a clear status back to each row. You’ll see how it works, what you need, and what to watch out for.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets + Anymail Finder: fewer email bounces
flowchart LR
subgraph sg0["Manual Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Manual Trigger", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "Get Leads", pos: "b", h: 48 }
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
n3@{ icon: "mdi:database", form: "rounded", label: "Update email status", pos: "b", h: 48 }
n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Check email status"]
n1 --> n2
n0 --> n1
n2 --> n4
n4 --> n3
n3 --> n2
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n1,n3 database
class n4 api
classDef customIcon fill:none,stroke:none
class n4 customIcon
The Problem: Dirty email lists quietly wreck outreach
Email bounces aren’t just annoying. They’re expensive in a slow, cumulative way: wasted send volume, wasted time chasing replies that will never come, and a deliverability reputation that gets harder to recover as you scale. And the worst part is how sneaky the work becomes. Someone exports leads, someone else “quick checks” a handful, then you still send to a list that hasn’t been validated in weeks. A simple spreadsheet turns into a fragile process you have to babysit.
It adds up fast. Here’s where it usually breaks down in real life.
- You end up copying and pasting emails into tools one-by-one because bulk uploads feel like a hassle.
- Rows get skipped when multiple people touch the same sheet, so unverified emails slip into campaigns.
- You don’t have a consistent “source of truth” column, which means your CRM import is always a gamble.
- Fixing bounces happens after a send, when you’re already paying the price in lost replies and lower deliverability.
The Solution: Verify emails inside Google Sheets with Anymail Finder
This n8n workflow turns your Google Sheet into a live validation queue. You start it manually when you’re ready to clean a list. It pulls only the rows that haven’t been checked yet (specifically, where your “VERIFY” column is blank), then loops through those leads one at a time. For each row, it sends the email address to the Anymail Finder verification endpoint and waits for the response. Finally, it writes the verification status back into the same row so your team can instantly see what’s safe to contact and what needs attention.
It begins with a quick pull from Google Sheets, then an API call to Anymail Finder for each email. Once a result comes back, the workflow updates the “VERIFY” field using the row number, so you don’t get mismatched updates or messy manual notes.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you collect 200 leads in a Google Sheet each week. Manually validating even “quickly” at about 1 minute per email is still roughly 3 hours of tedious checking, plus the inevitable skipped rows. With this workflow, you kick it off once, let it loop through the unverified rows, and come back to a filled “VERIFY” column. Your active time is closer to 10 minutes: start the run, spot-check a few results, and move on.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets to store leads and statuses.
- Anymail Finder API to verify deliverability status.
- Anymail Finder API key (get it from your Anymail Finder account settings).
Skill level: Beginner. You’ll connect Google Sheets OAuth and paste an API key into an HTTP header auth credential.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
You start the run when you’re ready. The workflow uses a manual trigger, so you can validate a batch before a campaign, a CRM import, or a handoff to a sales rep.
Google Sheets provides the “to-do list.” It reads rows from your chosen spreadsheet and filters to only leads where the “VERIFY” column is empty, which keeps reruns clean and avoids burning API calls on already-checked emails.
Anymail Finder checks each email in a loop. n8n processes leads one-by-one (Split in Batches), posts the email address to the Anymail Finder /v5.1/verify-email endpoint, and captures the status from the response.
The result lands back in the same row. The workflow updates the “VERIFY” column using the row number, so every lead gets a clear status without you touching the sheet.
You can easily modify the sheet filter to also check only a specific campaign tab or segment based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Manual Trigger
Set up the workflow entry point so you can run the verification process on demand during testing.
- Add the Manual Start Trigger node as the trigger for the workflow.
- Leave all parameters at their default values for Manual Start Trigger.
- Confirm the execution flow connects Manual Start Trigger → Retrieve Lead Records.
Step 2: Connect Google Sheets
Retrieve lead rows from your spreadsheet and prepare them for verification.
- Open Retrieve Lead Records and select the correct Google Sheet in Document using the value
[YOUR_ID]. - Set Sheet to
Foglio1(gid0). - In Filters, ensure lookupColumn is set to
VERIFYso you only process rows needing verification. - Credential Required: Connect your googleSheetsOAuth2Api credentials for Retrieve Lead Records and Update Verification Flag.
[YOUR_ID] with your actual Google Sheet ID, otherwise no data will be returned.Step 3: Set Up Batch Processing
Process lead records one batch at a time to avoid API rate limits and maintain looped processing.
- Add the Iterate Records Batch node after Retrieve Lead Records.
- Keep default settings in Iterate Records Batch unless you want to change the batch size.
- Verify the loop: Update Verification Flag outputs back to Iterate Records Batch for continued processing.
Step 4: Configure the Email Validation Request
Send each lead’s email address to the verification API and capture the status response.
- Open Validate Email Status and set URL to
https://api.anymailfinder.com/v5.1/verify-email. - Set Method to
POSTand enable Send Body. - In Body Parameters, add email with the expression
{{ $json["EMAIL "] }}. - Set Authentication to
genericCredentialTypeand Generic Auth Type tohttpHeaderAuth. - Credential Required: Connect your httpHeaderAuth credentials for Validate Email Status.
Step 5: Configure the Output Update
Write the verification result back to the correct row in your spreadsheet.
- Open Update Verification Flag and set Operation to
update. - Set Sheet to
Foglio1and Document to[YOUR_ID]. - Under Columns, map VERIFY to
{{ $json.email_status }}. - Map row_number to
{{ $('Iterate Records Batch').item.json.row_number }}and set Matching Columns torow_number.
Step 6: Test and Activate Your Workflow
Run a full test to validate data flow and then activate the workflow for ongoing use.
- Click Execute Workflow to run from Manual Start Trigger.
- Confirm Retrieve Lead Records returns rows and Validate Email Status returns an
email_statusvalue. - Verify that Update Verification Flag updates the VERIFY column in your Google Sheet.
- When results are correct, toggle the workflow to Active for production use.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the n8n credential status and your Google account access to the target spreadsheet first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 20 minutes if your Google Sheet is ready.
No. You’ll connect Google Sheets and add an Anymail Finder API key. After that, it’s mostly picking the right columns and testing one run.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Anymail Finder API costs based on how many emails you verify.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, but you’ll do it by changing how the Google Sheets “Retrieve Lead Records” step filters rows. Common tweaks include pointing to a different sheet/tab, filtering by a campaign name column, and only validating leads added “today” so you’re not reprocessing old lists.
Usually it’s an OAuth permission issue or the credential expired. Reconnect the Google Sheets account in n8n, then confirm the spreadsheet is shared with the same Google user. Also double-check the sheet ID and that your column names match exactly (this workflow expects “VERIFY” and an “EMAIL” column, sometimes with a space).
A few thousand leads per run is realistic for most teams, and the looped batch processing keeps it stable. On n8n Cloud, your monthly execution limit depends on your plan. If you self-host, there’s no platform execution cap, but you’ll still be limited by your server and the Anymail Finder API throughput.
Often, yes. This kind of workflow benefits from looping, conditional logic, and writing back to the exact row you pulled, and n8n handles that without making you split everything into fragile mini-zaps. You also get the self-hosting option, which can matter once you’re validating lots of leads weekly. Zapier or Make can still be fine for tiny lists, especially if you want a very guided UI and don’t care about costs scaling with volume. If you want help picking the right approach for your outbound stack, Talk to an automation expert.
Cleaner spreadsheets lead to cleaner sends. Set this up once, and you’ll stop treating deliverability like a last-minute fire drill.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
