P26-02-26">
n8n Email Verification Google Sheets
6 min read Automation

How to Automate Email Verification Using n8n & Apify (Step-by-Step Tutorial)

Cold email campaigns live or die by list quality. Manual verification wastes hours and still misses bad addresses. This n8n workflow automatically checks every email via Apify's API, updates your Google Sheets in real-time, and removes invalid addresses — giving you perfect list hygiene without the manual work.

The Problem With Manual Email Verification

Every cold email marketer knows the frustration: you spend hours building what looks like a perfect prospect list, only to discover half the addresses bounce when you send your campaign. Manual verification methods like sending test emails or using free online tools are slow, inconsistent, and often miss invalid addresses.

The hidden cost? Poor email deliverability that can get your domain flagged as spam. Email providers track your bounce rates, and high rates mean future emails—even to valid addresses—are more likely to land in spam folders.

Industry data shows: Lists with just 10% invalid addresses see 30% lower open rates overall. Automated verification maintains 99%+ deliverability while manual methods average 85-90% at best.

How The Automated Verification Works

This n8n workflow solves the problem by connecting Google Sheets directly to Apify's email verification API. It checks each address automatically, then updates your spreadsheet based on the results:

  • Valid emails are marked "okay" and kept in your list
  • Invalid emails are automatically removed to maintain list hygiene
  • Unknown status addresses are flagged for manual review

The entire process runs on a schedule you set (hourly/daily/weekly), requiring zero manual intervention once configured. At 3:15 in the tutorial video, you'll see how the workflow processes a test email and correctly identifies it as invalid.

Step 1: Setting Up The Schedule Trigger

The workflow begins with n8n's schedule trigger, which determines how often your email list gets verified. For most businesses, running verification weekly is sufficient, but high-volume senders may want daily checks.

Key configuration points:

  • Set the recurrence pattern (hourly/daily/weekly)
  • Choose off-peak hours to avoid API rate limits
  • Add a manual trigger option for on-demand verification

At 1:45 in the video, you'll see how to adjust these settings based on your email volume and campaign frequency.

Step 2: Connecting Google Sheets

The workflow pulls email addresses from a Google Sheet where:

  • Column A contains email addresses
  • Column B tracks verification status ("not sent", "valid", "invalid")

Critical configuration shown at 2:30 in the tutorial:

  1. Connect your Google account to n8n
  2. Select your spreadsheet and worksheet
  3. Set the filter to only process rows marked "not sent"
  4. Configure the workflow to process one row per execution

Pro Tip: Add a "last verified" date column to track when each address was checked. Email validity changes over time as people change jobs or abandon addresses.

Step 3: Configuring Apify Email Verification

The heart of the workflow is Apify's email verification API, which performs several checks:

  • Domain validity (does the domain exist?)
  • Mailbox existence (is the address active?)
  • Disposable email detection (is this a temporary address?)
  • Catch-all verification (does the domain accept all emails?)

Configuration steps demonstrated at 4:10:

  1. Connect your Apify account
  2. Select the email verifier actor
  3. Map the email field from the Google Sheet
  4. Set the workflow to wait for API results

The API typically responds within 15-30 seconds per email, making it significantly faster than manual verification methods.

Step 4: Processing The Results

The workflow uses a switch node to route emails based on their verification status:

  • Valid ("okay"): Updates status in Google Sheets
  • Invalid: Removes the row entirely
  • Unknown: Flags for manual review

At 6:45 in the video, you'll see how the:

  1. Get Dataset Item node retrieves API results
  2. Switch node routes based on verification outcome
  3. Google Sheets nodes update or delete records accordingly

Important: The workflow logs all actions, so you can audit which addresses were removed and when. This prevents accidental data loss while maintaining list hygiene.

Watch the Full Tutorial

See the complete workflow in action, including how it handles different verification outcomes (valid, invalid, and unknown statuses). At 8:20 in the video, you'll see a real example of the workflow processing an invalid email and automatically removing it from the Google Sheet.

n8n email verification automation tutorial

Key Takeaways

This n8n workflow transforms email list management from a manual, error-prone process into an automated system that maintains perfect list hygiene. By connecting Google Sheets to Apify's verification API, you ensure every email in your campaigns reaches a real inbox.

In summary: Automated email verification saves hours of manual work, improves deliverability by 30%+, and prevents wasted effort on invalid addresses — all while running unattended on your schedule.

Frequently Asked Questions

Common questions about email verification automation

Manual email verification is time-consuming and error-prone. Automated verification through n8n and Apify can process hundreds of emails per hour with perfect accuracy, while manual verification might take days.

The automation also eliminates human errors like missed invalid addresses or incorrect status updates in your spreadsheet. At scale, manual verification simply isn't practical for lists with more than a few hundred addresses.

  • Saves 5-10 hours per 1,000 email verifications
  • Reduces bounce rates by 60-80% compared to manual methods
  • Provides consistent, auditable results

Apify's email verification API provides enterprise-grade accuracy, typically identifying 98-99% of invalid email addresses correctly. It checks multiple factors including domain validity, mailbox existence, and disposable email detection.

The API categorizes results as valid (okay), invalid (bounce risk), or unknown (needs manual review). Unknown results typically represent less than 1% of verifications and usually indicate temporary mail server issues rather than actual invalid addresses.

  • 98.7% accuracy for invalid address detection
  • Real-time verification against active mail servers
  • Identifies disposable/temporary email addresses

Yes, the workflow is designed to process email lists of any size efficiently. It processes one email at a time by default to avoid API rate limits, but can be modified to batch process 5-10 emails per run.

For lists over 10,000 emails, we recommend adding a delay between batches to stay within API usage limits. The workflow can run continuously over several days to complete very large verifications without manual intervention.

  • Processes 500-1,000 emails per day safely
  • Scales to 50,000+ emails with batch processing
  • Automatically resumes where it left off

The workflow automatically removes invalid emails from your Google Sheet to maintain list hygiene. This prevents wasted effort on undeliverable addresses and improves your overall email deliverability rates.

The system logs all actions so you can track which addresses were removed and when. If needed, you can modify the workflow to move invalid addresses to a separate "bounced" sheet instead of deleting them entirely.

  • Invalid addresses are immediately removed
  • Action is logged for auditing purposes
  • Option to archive rather than delete

For most cold email campaigns, running verification weekly is sufficient. The workflow in this tutorial is set to run hourly by default, but you can adjust the schedule trigger based on your needs.

New lists should be verified immediately before sending, while established lists benefit from periodic re-verification. Email addresses become invalid over time as people change jobs or abandon accounts.

  • New lists: verify immediately before sending
  • Active lists: weekly verification
  • Dormant lists: monthly verification

Absolutely. While this tutorial uses Google Sheets, n8n has connectors for Airtable, Excel Online, and many other data sources. The workflow logic remains the same - you would just replace the Google Sheets nodes with nodes for your preferred spreadsheet platform.

The API verification and status updating steps work identically regardless of your data source. Many businesses connect this workflow directly to their CRM systems for even tighter integration.

  • Works with Airtable, Excel Online, Smartsheet
  • Can connect directly to CRMs like HubSpot
  • Same verification logic applies

The Apify email verification API costs approximately $0.002 per verification (200 verifications for $1). n8n is free for the open-source version, or starts at $20/month for the cloud version.

Compared to manual verification (which costs $15-$25/hour in labor), this automation typically pays for itself within the first 5,000 email verifications. The time savings alone justify the minimal API costs for most businesses.

  • ~$1 per 500 email verifications
  • n8n free or $20+/month
  • Saves $75+ per 1,000 emails vs manual

GrowwStacks specializes in building custom email verification automations tailored to your specific needs. We can implement this exact workflow for you, customize it for your CRM or marketing tools, or build a more advanced version with additional features.

Our team handles everything from API integration to ongoing maintenance. We'll configure the workflow to your exact specifications, train your team on using it, and provide support for any modifications needed as your business grows.

  • Full implementation in 2-3 business days
  • Customized for your tech stack
  • Ongoing support and optimization

Stop Wasting Time on Manual Email Verification

Every bounced email hurts your sender reputation and wastes your outreach effort. Let GrowwStacks build this automated verification system for you — typically deployed and running in under 48 hours.