n8n Lead Email Automation: Google Sheets + Hunter + Gmail + Telegram

Automate lead outreach end-to-end with n8n: Google Sheets → Hunter → Gmail → Telegram

This n8n workflow pulls leads from Google Sheets, verifies each email’s deliverability with Hunter, sends outreach via Gmail, updates results back into your sheet, and posts a run summary to Telegram—all on a daily schedule.

What this workflow does

• Runs daily at the configured hour to start the dispatch process.
• Reads lead rows from a specified Google Sheets spreadsheet/worksheet and ignores records with a blank “Email” field.
• Verifies deliverability for each non-empty email using Hunter Email Verifier, checking that the email is deliverable and not already marked as “sent” or “skipped”.
• Sends emails with Gmail to leads confirmed as deliverable.
• Updates Google Sheets by writing the result to the “Email sent” column—marking each lead as sent, skipped, or invalid (matched by the unique “Tool Name” column).
• Posts a summary to Telegram via the Telegram Bot API with totals for sent, invalid, and skipped leads.

Use cases

• Daily outreach for SaaS or agency leads maintained in Google Sheets.
• Cold email campaigns that need deliverability checks to reduce wasted sends.
• Teams that want automated status tracking in Google Sheets and visible reporting in Telegram.

Technical details

• Google Sheets OAuth for reading leads and updating the “Email sent” column (by “Tool Name”).
• Hunter API to verify deliverability with Hunter’s Email Verifier.
• Gmail to send the outreach email (subject/body configurable in the workflow).
• Telegram Bot API to send a run report to your chat_id (using your bot token).
• n8n logic implemented with nodes including: if, set, code, no op, gmail, and merge.

Prerequisites: your Google Sheet must include unique “Tool Name”, “Email”, and “Email sent” columns to ensure correct matching and prevent re-sending.