Bulk Email Verification Automation

What This Agent Does

This powerful email validation workflow automates the process of verifying email addresses stored in Google Sheets, helping you maintain a clean and deliverable email list. The agent reads email addresses from your spreadsheet, validates each one through ZeroBounce's industry-leading verification service, and scores them based on deliverability quality—all without manual intervention.

Key benefits include:

• Save hours of manual work: Automatically process hundreds or thousands of email addresses in minutes instead of validating them one by one
• Improve email deliverability: Identify invalid, risky, or disposable email addresses before sending campaigns, protecting your sender reputation
• Reduce bounce rates: Remove bad emails proactively, ensuring your messages reach real inboxes and improving your overall email marketing ROI
• Data-driven decisions: Get detailed scoring and validation data to segment your email list based on quality

Perfect use cases:

• Cleaning imported contact lists before launching email campaigns
• Validating lead magnets and form submissions in real-time
• Maintaining database hygiene for CRM and marketing automation platforms
• Verifying customer email addresses before important transactional communications

Who Is It For

This workflow is ideal for:

• Marketing teams who need to maintain clean email lists and maximize campaign deliverability rates
• Sales professionals who want to verify prospect contact information before outreach
• E-commerce businesses looking to validate customer email addresses and reduce failed order notifications
• Data analysts responsible for maintaining data quality across customer databases
• Small business owners who manage their own email marketing and need cost-effective list hygiene
• Agencies managing multiple client email lists and needing scalable validation processes

Whether you're processing 50 emails or 50,000, this automation scales to meet your needs while maintaining accuracy and speed.

Required Integrations

Google Sheets

Why it's needed: Google Sheets serves as your data source, storing the email addresses you want to validate. The workflow reads directly from your spreadsheet, making it easy to manage and update your email lists without technical complexity.

Setup steps:

1. Create or access your Google account at https://accounts.google.com if you don't already have one
2. Navigate to TaskAGI integrations by clicking on "Integrations" in the left sidebar
3. Find Google Sheets in the integration marketplace and click "Connect"
4. Authorize access by clicking "Allow" when prompted to grant TaskAGI permission to read and manage your spreadsheets
5. Confirm connection by verifying that the Google Sheets integration shows as "Connected" with a green status indicator

Obtaining credentials: Google Sheets uses OAuth authentication, so you won't need to manually create API keys. Simply sign in with your Google account and authorize TaskAGI to access your sheets.

Configuration in TaskAGI: Once connected, you'll be able to paste any Google Sheets URL directly into the workflow. Ensure your spreadsheet has at least one column containing email addresses with a clear header row (e.g., "Email" or "Email Address").

ZeroBounce

Why it's needed: ZeroBounce is a professional email validation service that checks email addresses for validity, deliverability, and quality. It identifies invalid emails, catch-all domains, disposable addresses, and potential spam traps—critical information for maintaining list health.

Setup steps:

1. Create a ZeroBounce account at https://www.zerobounce.net/members/register/
2. Choose a plan that fits your validation volume needs (they offer free credits for testing)
3. Access your API key by logging into your ZeroBounce dashboard and navigating to "API" in the top menu
4. Copy your API key from the API documentation page (it will look like a long alphanumeric string)
5. Add to TaskAGI by going to Integrations → ZeroBounce → "Add Credentials"
6. Paste your API key into the credential field and click "Save"
7. Test the connection to ensure TaskAGI can communicate with ZeroBounce successfully

Obtaining credentials: Your ZeroBounce API key is available immediately upon account creation. Navigate to the API section of your dashboard, and you'll find it clearly labeled as "API Key" with a copy button for convenience.

Configuration in TaskAGI: After adding your API credentials, select them in both the "Validate Email" and "Score Email" nodes within your workflow. The integration will automatically handle authentication for all API calls.

Configuration Steps

Step 1: Set Up the Manual Trigger

The Manual Trigger node allows you to start the workflow on-demand whenever you're ready to validate emails. No configuration is required—this node is ready to use out of the box. Simply click the "Run" button when you want to process your email list.

Step 2: Configure Get Emails from Sheet

The Get Emails from Sheet node connects to your Google Sheets document and retrieves your email list.

Configuration:

1. Sheet URL: Paste your complete Google Sheets URL (e.g., https://docs.google.com/spreadsheets/d/1abc123xyz/edit)
2. Sheet Name (optional): If your spreadsheet has multiple tabs, specify which one contains your emails (defaults to the first sheet)
3. Range (optional): Define a specific cell range like A2:A100 if you only want to process certain rows

Important: Ensure your spreadsheet has a header row with column names. The workflow will return all rows as structured data, making it easy to reference specific columns in later steps.

Step 3: Set Up Loop Through Emails

The Loop Through Emails node iterates through each row returned from your spreadsheet, processing one email at a time.

Configuration:

1. Items to loop: Connect this to the rows output from the previous Google Sheets node
2. Loop variable name: Keep the default item or customize it to something like email_row for clarity

This node will automatically repeat the subsequent validation steps for every email in your list, ensuring comprehensive coverage.

Step 4: Configure Validate Email

The Validate Email node sends each email address to ZeroBounce for validation checking.

Configuration:

1. Email address: Map this to the email column from your sheet using {{item.Email}} (replace "Email" with your actual column header)
2. IP address (optional): Leave blank unless you're validating emails in context of a specific IP address
3. ZeroBounce credentials: Select the credentials you configured earlier

What it checks: This node verifies if the email exists, checks for syntax errors, identifies catch-all domains, detects disposable email services, and flags potential spam traps.

Step 5: Set Up the Is Valid? Condition

The Is Valid? condition node creates two paths based on validation results—one for valid emails and another for invalid ones.

Configuration:

1. Condition: Set to check if {{validate_email.status}} equals "valid"
2. True path: Connects to the Score Email node for further analysis
3. False path: Connects to the Invalid Email node for tracking

This branching logic ensures you only spend API credits scoring emails that have already passed basic validation.

Step 6: Configure Score Email

The Score Email node provides a quality score for valid emails, helping you prioritize high-quality contacts.

Configuration:

1. Email address: Use the same reference as before: {{item.Email}}
2. ZeroBounce credentials: Select your configured credentials

Understanding scores: ZeroBounce returns a score from 0-10, where higher numbers indicate better email quality based on historical engagement data and deliverability factors.

Step 7: Valid & Scored and Invalid Email Nodes

These No Operation nodes serve as endpoints for your workflow branches, helping you visualize the flow and potentially add future actions like:

• Writing results back to your spreadsheet
• Sending notifications for invalid emails
• Triggering follow-up workflows based on email scores

No configuration is needed for these nodes currently—they're placeholders for future enhancements.

Testing Your Agent

Running Your First Test

1. Prepare a test spreadsheet with 5-10 email addresses including a mix of valid and intentionally invalid emails (like test@invalid-domain-xyz.com)
2. Click the "Run" button on the Manual Trigger node to start execution
3. Watch the execution panel on the right side of the screen to see real-time progress through each node

Verification Checklist

After the Get Emails from Sheet node:

• ✅ Verify that the correct number of rows was retrieved
• ✅ Check that email addresses are properly displayed in the output
• ✅ Confirm column headers match your spreadsheet

After the Validate Email node:

• ✅ Look for a status field in the output (should show "valid", "invalid", "catch-all", etc.)
• ✅ Check for additional data like sub_status, free_email, and did_you_mean suggestions
• ✅ Verify that the API credit count decreased in your ZeroBounce dashboard

After the Is Valid? condition:

• ✅ Confirm that valid emails flow to the Score Email branch
• ✅ Verify that invalid emails route to the Invalid Email branch
• ✅ Check that the branching logic correctly identifies email status

After the Score Email node:

• ✅ Verify that a numerical score (0-10) appears in the output
• ✅ Check for additional scoring metadata provided by ZeroBounce

Expected Results

A successful execution should show:

• Green checkmarks on all executed nodes
• Execution time typically under 2-3 seconds per email
• Detailed output data at each step visible in the execution panel
• No error messages in red text

Troubleshooting

"Failed to fetch spreadsheet" Error

Cause: TaskAGI doesn't have permission to access your Google Sheet, or the URL is incorrect.

Solutions:

• Verify the spreadsheet URL is complete and correct
• Ensure the sheet is not set to private/restricted access
• Reconnect your Google Sheets integration in TaskAGI
• Check that the sheet name (if specified) matches exactly, including capitalization

"Invalid API Key" from ZeroBounce

Cause: The ZeroBounce credentials are incorrect or expired.

Solutions:

• Copy your API key again from the ZeroBounce dashboard
• Create new credentials in TaskAGI and select them in both validation nodes
• Verify your ZeroBounce account is active and has available credits
• Check for extra spaces when pasting the API key

"Cannot read property 'Email' of undefined"

Cause: The column reference doesn't match your spreadsheet's header.

Solutions:

• Check the exact spelling and capitalization of your email column header
• Update the reference to match (e.g., {{item.email}} vs {{item.Email}})
• Ensure your spreadsheet has a header row
• Verify the sheet isn't empty

Loop Not Processing All Emails

Cause: The loop configuration may be incorrect or the sheet data isn't properly structured.

Solutions:

• Verify the loop is connected to {{get_emails.rows}}
• Check that your spreadsheet doesn't have empty rows interrupting the data
• Ensure all email cells contain text (not formulas that might return empty values)
• Review the execution log to see where the loop stopped

ZeroBounce Rate Limiting

Cause: You're sending too many requests too quickly.

Solutions:

• Add a small delay in your loop (if available in your TaskAGI version)
• Process emails in smaller batches
• Upgrade your ZeroBounce plan for higher rate limits
• Contact ZeroBounce support to verify your account's rate limit

Next Steps

After Successful Setup

Immediate actions:

1. Process your full email list by updating the spreadsheet URL to your production data
2. Monitor your ZeroBounce credit usage to ensure you have sufficient credits for your list size
3. Document the results by noting how many emails were validated and what percentage were invalid

Optimization Suggestions

Enhance your workflow with these additions:

• Write results back to Google Sheets: Add a node after validation to update your spreadsheet with validation status and scores in new columns
• Send notifications: Configure email or Slack alerts when validation completes or when a high percentage of invalid emails is detected
• Filter by score threshold: Add additional conditions to segment emails by score (e.g., only keep emails scoring 7 or higher)
• Schedule regular validation: Convert the manual trigger to a scheduled trigger to automatically revalidate your list monthly
• Create separate lists: Route valid and invalid emails to different spreadsheet tabs for easy management

Advanced Usage Tips

Take your email validation to the next level:

• Integrate with your CRM: Connect this workflow to automatically validate new leads as they enter your system
• Build a scoring dashboard: Export validation data to a BI tool to track list quality trends over time
• Implement progressive validation: Validate high-priority segments first, then process the remainder during off-hours
• Combine with enrichment: Add data enrichment nodes to append additional information to validated emails
• Create feedback loops: Use validation results to improve your lead capture forms and identify problematic sources

Pro tip: Keep a backup of your original email list before making any deletions based on validation results. Occasionally, valid emails may be flagged incorrectly, and having the original data allows you to review edge cases manually.

Your email validation workflow is now ready to help you maintain a pristine email list, improve deliverability, and maximize the ROI of your email marketing efforts! 🚀