Google Sheets + Rapid Email Verifier: cleaner lists
You add “just a few” new leads to a sheet, export them, send a campaign… and then the bounce report punches you in the gut. It’s not one bad address. It’s the fact you didn’t catch it before it touched your domain reputation.
Google Sheets verification hits hardest when you’re moving fast: a Marketing Manager prepping a newsletter, a Sales lead handing lists to SDRs, or a small business owner doing outreach between meetings. You want a simple way to know which emails are safe to send, without turning list hygiene into a weekly project.
This n8n workflow checks new rows every hour, verifies each email using Rapid Email Verifier, then writes the status back into the same sheet. You’ll see where the risk is, how it runs, and what you need to set it up.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets + Rapid Email Verifier: cleaner lists
flowchart LR
subgraph sg0["Watch New Email Rows Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Watch New Email Rows", pos: "b", h: 48 }
n1@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter Unchecked Emails", pos: "b", h: 48 }
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Batch Email Processor", pos: "b", h: 48 }
n3["<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/>Validate Email Address"]
n4@{ icon: "mdi:database", form: "rounded", label: "Update Verification Status", pos: "b", h: 48 }
n3 --> n4
n1 --> n2
n0 --> n1
n2 --> n3
n4 --> 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 decision
class n4 database
class n3 api
classDef customIcon fill:none,stroke:none
class n3 customIcon
The Problem: dirty email lists quietly break deliverability
Email verification is the kind of task people skip because it feels “optional” until it isn’t. Someone pastes leads into Google Sheets, you assume the form or scraper did its job, and then you blast a campaign to addresses that are invalid, disposable, or simply risky. The fallout is annoying at first (bounces, wasted sends). Then it becomes expensive: lower inbox placement, more spam folder drama, and a team that starts distrusting the list. Honestly, the worst part is the mental load. You never feel sure the sheet is ready.
It adds up fast. Here’s where it breaks down in real teams.
- Manual spot-checking misses patterns, so bad addresses slip into “approved” segments.
- You end up verifying the same emails twice because there’s no clear “already checked” marker.
- Campaign prep turns into copy-paste work that steals about 1-2 hours right when deadlines are tight.
- A single outreach push to an unverified list can lead to bounce spikes that take weeks to recover from.
The Solution: auto-verify new Google Sheets leads every hour
This workflow turns your Google Sheet into a self-cleaning lead list. Every hour, n8n checks for new rows in your spreadsheet, then looks for entries where the “Email Verified” column is still empty. Only those rows move forward, which means you’re not paying (or waiting) to re-check old leads. Next, the workflow processes emails one at a time to stay polite with rate limits, sends each address to the Rapid Email Verifier API, and captures the response. Finally, it writes a clear verification status back into the original sheet by matching the row using your Serial Number (SrNo). Your list gets safer automatically, and your team gets a single source of truth.
The flow starts with a Google Sheets trigger that runs hourly. Verified-yet-empty rows are filtered, then each email is checked through an HTTP request to Rapid Email Verifier. The sheet is updated immediately with valid, invalid, or unknown (plus any extra fields you choose to store).
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you collect about 50 new leads a day into Google Sheets. Manually verifying them is usually 2 minutes per lead once you include copying, pasting into a verifier, and updating the sheet, which is roughly 100 minutes a day. With this workflow, you add rows normally, then n8n runs hourly and checks only the new entries. The “work” becomes close to zero: maybe 5 minutes total to review any invalid or unknown results before you send.
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 verification status.
- Rapid Email Verifier API to validate each email address.
- Google Sheets credentials (connect in n8n’s Google Sheets nodes).
Skill level: Beginner. You’ll connect Google Sheets, paste the API endpoint, and map a few fields.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
An hourly Google Sheets check. The workflow trigger runs every hour and watches your chosen spreadsheet for new rows that contain an email address.
Only “unchecked” rows move forward. A filter looks at the “Email Verified” column and ignores anything already marked, so the automation stays cheap and fast as the sheet grows.
One-by-one verification through Rapid Email Verifier. n8n processes items in a controlled loop (split in batches), sends each email to the verification API, then reads the returned status such as valid, invalid, or unknown.
The original sheet gets updated. Using SrNo as the match key, the workflow writes the result back into the correct row, which means your team always sees the latest verification state in the same place they manage leads.
You can easily modify the schedule (hourly to real-time) and the stored fields (status only vs. more details) based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Google Sheets Trigger
This workflow starts when a new row is added in your email verification spreadsheet.
- Add the Watch New Email Rows node to your workflow.
- Set Event to
rowAdded. - Set Document to
Your Email Verification Spreadsheet. - Set Sheet Name to
Sheet1. - Set the polling interval to
everyHourunder Poll Times.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
⚠️ Common Pitfall: The trigger will not run without Google Sheets credentials, even though none are preconfigured in the workflow.
Step 2: Connect Google Sheets
Configure the node that writes verification results back to the spreadsheet.
- Open Update Verification Status and set Operation to
appendOrUpdate. - Set Document to
Your Email Verification Spreadsheet. - Set Sheet Name to
Sheet1. - Map SrNo to
{{ $('Filter Unchecked Emails').item.json.SrNo }}. - Map Email Verified to
{{ $json.status }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
Step 3: Set Up Processing Logic
Filter out already-verified rows and process emails in batches.
- In Filter Unchecked Emails, add a condition where Left Value is
{{ $json['Email Verified'] }}, Operator isequals, and Right Value is left empty. - Connect Watch New Email Rows to Filter Unchecked Emails.
- Connect Filter Unchecked Emails to Batch Email Processor.
- Leave Batch Email Processor options as default unless you want to control batch size.
Tip: The execution flow loops Update Verification Status back into Batch Email Processor so each batch item is processed sequentially.
Step 4: Configure the Email Verification API
Send each email to the external verification service.
- Open Validate Email Address.
- Set URL to
https://rapid-email-verifier.fly.dev/api/validate. - Enable Send Query.
- Add a query parameter named email with value
{{ $json.Email }}. - Connect Batch Email Processor to Validate Email Address, then connect Validate Email Address to Update Verification Status.
Step 5: Test and Activate Your Workflow
Verify the workflow end-to-end before turning it on.
- Click Execute Workflow to run a manual test with sample rows.
- Confirm that Validate Email Address returns a
statusfield and that Update Verification Status writes to the Email Verified column. - Check that only rows where Email Verified is empty are processed.
- Toggle the workflow to Active to enable live polling.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials screen and the Google account access to that 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 30 minutes if your sheet is ready.
No. You’ll connect accounts and map a few fields in n8n.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. Rapid Email Verifier is free for up to 1,000 verifications per month, so many small lists cost nothing to validate.
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 more control and can be cheaper at scale, but you’ll need to handle updates and basic monitoring yourself.
Yes, but you’ll change the trigger. Replace the hourly Google Sheets trigger with a webhook trigger, then keep the same filter, batch processing, HTTP verification call, and “update row” step to write the result back into Google Sheets.
Usually it’s a Google permission issue or expired credentials in n8n. Reconnect the Google Sheets credential and confirm the same Google account can access that exact spreadsheet. Also check that the sheet still has the expected columns (SrNo, Name, Email, Email Verified), because renamed headers often break field mapping. If it fails only on updates, the SrNo match key is often blank or duplicated.
Practically, a lot. Rapid Email Verifier’s free tier covers 1,000 checks per month, and each verification is typically under a second, so even a few thousand rows a week is realistic if your plan and rate limits allow it.
Often, yes. n8n makes it easier to filter “only unchecked rows,” loop through items one-by-one, and write back to the same sheet without paying extra for multi-step logic. You also get the option to self-host, which matters once you’re verifying a lot of leads. Zapier or Make can still be fine for a very small list, especially if you want the quickest setup and don’t need batching control. If you’re unsure, Talk to an automation expert and you’ll get a straight recommendation.
Once this is running, your sheet stops being a “maybe.” It becomes a live, constantly-checked list you can actually trust before you hit send.
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.
