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

by WeblineIndia ✓ · 2 views · created 2026-09-02 · Lead Nurturing

What this workflow does

This workflow has 15 nodes and runs on a schedule (every day at 11:00). Along the way it connects Google Sheets, Hunter and Gmail. It also calls api.telegram.org over HTTP.

How it runs

Trigger: On a schedule (every day at 11:00).

1. Fetch Lead Data from Google Sheets (Google Sheets): uses Google Sheets
2. Check for Blank Email ID (If): checks a condition and branches into true / false
3. Verify Email Addresses (Hunter): email verifier
4. Validate Email - Deliverable (If): checks a condition and branches into true / false
5. Send Valid Lead Emails (Gmail): uses Gmail
6. Check Email Status for Action (If): checks a condition and branches into true / false
7. Set Email Status - sent (Edit Fields (Set)): sets or maps fields
8. Set Email Status - skipped (Edit Fields (Set)): sets 1 field: status
9. Set Email Status - invalid (Edit Fields (Set)): sets 1 field: status
10. Merge: merges the data from its input branches

…plus 3 more steps. See the full node list below.

Services it uses

Google SheetsHunterGmail

HTTP calls to: api.telegram.org

Before you upgrade to n8n 3.0

Nodes used (10)

• Google Sheetsn8n-nodes-base.googleSheets
• Huntern8n-nodes-base.hunter
• No Operation, do nothingn8n-nodes-base.noOp
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• Gmailn8n-nodes-base.gmail
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Mergen8n-nodes-base.merge
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

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 1. Runs…

View the original on n8n.io → Check your own copy