{"product_id":"n8n-lead-email-automation-google-sheets-hunter-gmail-telegram","title":"n8n Lead Email Automation: Google Sheets + Hunter + Gmail + Telegram","description":"\u003ch3\u003eAutomate lead outreach end-to-end with n8n: Google Sheets → Hunter → Gmail → Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls leads from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, verifies each email’s deliverability with \u003cstrong\u003eHunter\u003c\/strong\u003e, sends outreach via \u003cstrong\u003eGmail\u003c\/strong\u003e, updates results back into your sheet, and posts a run summary to \u003cstrong\u003eTelegram\u003c\/strong\u003e—all on a daily schedule.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e at the configured hour to start the dispatch process.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads lead rows\u003c\/strong\u003e from a specified Google Sheets spreadsheet\/worksheet and \u003cstrong\u003eignores records with a blank “Email” field\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies deliverability\u003c\/strong\u003e for each non-empty email using \u003cstrong\u003eHunter Email Verifier\u003c\/strong\u003e, checking that the email is deliverable and not already marked as “sent” or “skipped”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends emails with Gmail\u003c\/strong\u003e to leads confirmed as deliverable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e by writing the result to the “Email sent” column—marking each lead as \u003cem\u003esent\u003c\/em\u003e, \u003cem\u003eskipped\u003c\/em\u003e, or \u003cem\u003einvalid\u003c\/em\u003e (matched by the unique “Tool Name” column).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a summary to Telegram\u003c\/strong\u003e via the Telegram Bot API with totals for sent, invalid, and skipped leads.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily outreach for SaaS or agency leads maintained in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eCold email campaigns that need deliverability checks to reduce wasted sends.\u003c\/li\u003e\n  \u003cli\u003eTeams that want automated status tracking in Google Sheets and visible reporting in Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e for reading leads and updating the “Email sent” column (by “Tool Name”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHunter API\u003c\/strong\u003e to verify deliverability with Hunter’s Email Verifier.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e to send the outreach email (subject\/body configurable in the workflow).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram Bot API\u003c\/strong\u003e to send a run report to your chat_id (using your bot token).\u003c\/li\u003e\n  \u003cli\u003en8n logic implemented with nodes including: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and \u003cstrong\u003emerge\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003ePrerequisites:\u003c\/strong\u003e your Google Sheet must include unique \u003cstrong\u003e“Tool Name”\u003c\/strong\u003e, \u003cstrong\u003e“Email”\u003c\/strong\u003e, and \u003cstrong\u003e“Email sent”\u003c\/strong\u003e columns to ensure correct matching and prevent re-sending.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938180194483,"sku":"N8N-19043","price":54.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TQ12R3TLN68nhPGAjZJv5_FwaEDI93.png?v=1788339970","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-email-automation-google-sheets-hunter-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}