π£ Validate & score leads with ZeroBounce AI before sending Gmail emails
β‘ 100 views Β· π£ Lead Generation & Enrichment
Description
ZeroBounce Email Validation, A.I Scoring & Sending with Gmail
This workflow automates the process of validating, scoring, and emailing leads from a Google Sheet. It ensures you only send emails to high-quality contacts, protecting your sender reputation.
π How it Works
- Trigger: Watches a Google Sheet for new or updated rows (contacts).
- Validate: Uses ZeroBounce to check if the email address is valid.
- If Invalid: Updates the sheet with the reason and marks βEmailedβ as
false.
- If Invalid: Updates the sheet with the reason and marks βEmailedβ as
- Score: If valid, uses ZeroBounce A.I. Scoring to grade the lead quality (0-10).
- If Low/Medium Score (<9): Updates the sheet with the score and marks βEmailedβ as
false.
- If Low/Medium Score (<9): Updates the sheet with the score and marks βEmailedβ as
- Send: If the score is High (9-10), sends an email via Gmail.
- Update: Writes the final status back to the Google Sheet, preventing duplicate sends.
π Setup Requirements
- Google Sheet: A sheet with columns for
Email,Validated,Scored,Score,Emailed,Reason, etc. - ZeroBounce Account: API Key for validation and scoring.
- Gmail Account: Connected via OAuth2 to send emails.
π‘ Key Features
- Cost Efficient: Checks existing
ValidatedandScoredcolumns to avoid re-processing contacts. - Risk Protection: Filters out valid but low-quality leads (e.g., catch-alls or low scores).
- Status Tracking: Keeps your Google Sheet updated with rich data (Sub-status, Domain Age, etc.).
π Nodes Used
Google Sheets, Gmail, Google Sheets Trigger
π₯ Import
Download workflow.json and import into n8n:
Workflow menu β Import from File