Send validated lead emails from Google Sheets via Hunter, Gmail and Telegram

Description

Quick overview
This workflow runs on a schedule to fetch leads from Google Sheets, verify email deliverability with Hunter, send messages via Gmail, update each lead’s send status back in Google Sheets, and post a run summary to Telegram.

How it works
Runs daily at the configured hour to start the email dispatch process.
Pulls lead rows from a Google Sheets spreadsheet and ignores records with a blank Email field.
Verifies each non-empty email address with Hunter’s Email Verifier and checks that it is deliverable and not already marked as sent or skipped.
Sends an email to deliverable leads using Gmail.
Marks each lead as sent, skipped, or invalid and updates the “Email sent” column back in Google Sheets (matching by “Tool Name”).
Aggregates totals for sent, invalid, and skipped leads and sends the summary report to a Telegram chat using the Telegram Bot API.

Setup
Add Google Sheets OAuth credentials and set the correct spreadsheet and sheet for both reading leads and updating the “Email sent” status.
Add a Hunter API credential for email verification.
Add a Gmail credential and update the email subject/body to match your outreach message.
Create a Telegram bot, replace in the Telegram request URL, and set the target chat_id for where the summary should be sent.
Ensure your Google Sheet includes unique “Tool Name”, “Email”, and “Email sent” columns so updates match the correct rows and prevent re-sending.

Additional info
How To Customize Nodes

Modify Email Content
Customize the message and subject in the "Send Valid Lead Emails" node. You can add dynamic fields like the Tool Name from the Google Sheets data.

Update Email Status Logic
You can customize the "Set Email Status" node to assign different status values if your workflow requires different email states.

Add More Validation
If you want to add extra validation for emails (e.g., checking for specific domains), modify the email verification logic within the "Hunter" node.

Adjust Reporting
Customize the summary report by changing the "Generate Email Summary" node, which aggregates the results. You can include additional fields if needed.

Add‑ons (Additional features to extend the workflow usage)

Advanced Email Personalization
Integrate with other data sources like CRM systems to pull more personalized lead information for email customization.

Multiple Email Sending Services
You can add multiple email services like SendGrid or Mailgun for higher email throughput if needed.

Email Retry Mechanism
Implement a retry mechanism for failed email attempts to ensure maximum delivery.

Detailed Reporting
Extend the summary report by including detailed logs, click rates, or even A/B testing results for emails.

Use Case Examples

Lead Email Campaigns
Use this workflow to send marketing emails to a list of leads stored in Google Sheets and track the results in real-time.

CRM Email Outreach
CRM administrators can use this to send automated emails to their leads and update records in real-time.

Event Registration Confirmation
Automate the sending of event confirmation emails to participants and track responses for follow-up actions.

Affiliate Program Outreach
Use this workflow to send emails to affiliate leads, ensuring they receive the correct information and track engagement.

There can be many more use cases, including customer surveys, newsletter distribution, and more.

Troubleshooting Guide

| Issue | Possible Cause | Solution |
|----------------------------------|---------------------------------------------------|----------------------------------------------------|
| Blank Emails Not Skipped | Blank email condition not set properly | Check the condition in "Check for Blank Email ID" |
| Email Verification Fails | Invalid Hunter API key or rate limit reached | Verify the Hunter API credentials and try again |
| Emails Not Sent | Gmail/SMTP credentials missing or incorrect | Ensure Gmail/SMTP credentials are correctly set up |
| Summary Report Not Sent | Missing Telegram credentials or invalid chat ID | Double-check Telegram bot settings and chat ID |

Need Help

If you need help setting up, customizing or extending this workflow, feel free to reach out to WeblineIndia. We offer support for configuring n8n workflows, integrating additional services or building similar automated processes tailored to your needs.