{"product_id":"groq-cold-email-n8n-google-sheets-to-gmail-telegram-alerts","title":"Groq Cold Email n8n: Google Sheets to Gmail + Telegram Alerts","description":"\u003ch3\u003eTurn Google Sheets prospects into Groq cold emails—and approve reply drafts in Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e “Prospects” tab for new leads, uses \u003cstrong\u003eGroq\u003c\/strong\u003e to write personalized cold emails, sends or drafts them in \u003cstrong\u003eGmail\u003c\/strong\u003e, then monitors for replies and routes reply drafts to \u003cstrong\u003eTelegram\u003c\/strong\u003e for your approval before anything is sent.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on new prospects:\u003c\/strong\u003e When a new row is added to the \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e Prospects tab, the workflow validates required prospect fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq-written cold email:\u003c\/strong\u003e It generates a personalized email subject and body using \u003cstrong\u003eGroq\u003c\/strong\u003e, then writes the content back to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend or draft logic:\u003c\/strong\u003e If the row’s \u003cem\u003eAuto Send\u003c\/em\u003e field is \u003cstrong\u003etrue\u003c\/strong\u003e, it sends the email via \u003cstrong\u003eGmail\u003c\/strong\u003e. Otherwise, it creates a Gmail \u003cstrong\u003edraft\u003c\/strong\u003e and updates the prospect’s status and timestamps in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReply detection every 2 minutes:\u003c\/strong\u003e Every 2 minutes, it reads rows marked \u003cem\u003eSent - Awaiting Reply\u003c\/em\u003e from Google Sheets and searches \u003cstrong\u003eGmail\u003c\/strong\u003e inbox replies tied to the prospect using the subject tag format \u003cstrong\u003eREF-\u0026lt;Prospect ID\u0026gt;\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq classifies replies:\u003c\/strong\u003e On a new reply, Groq classifies it (e.g., interested, question, declined, unclear) and drafts an appropriate response when appropriate, recording reply details in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram approval gate:\u003c\/strong\u003e The workflow creates a Gmail draft reply in the original thread, stores the draft ID in Google Sheets, then posts the draft text to \u003cstrong\u003eTelegram\u003c\/strong\u003e with an inline \u003cstrong\u003e“Send reviewed draft”\u003c\/strong\u003e approval button.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApproved send:\u003c\/strong\u003e When you press the approval button, it verifies the latest reply, sends the exact saved Gmail draft via the Gmail API, updates Google Sheets, and confirms in Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams running Google Sheets–driven outbound and wanting Groq-assisted personalization.\u003c\/li\u003e\n  \u003cli\u003eOperators who want \u003cstrong\u003econtrolled\u003c\/strong\u003e reply handling with Telegram-based human approval.\u003c\/li\u003e\n  \u003cli\u003en8n engineers building a complete “prospect → outreach → reply → approval → send” cold email system using Gmail.\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\u003c\/strong\u003e trigger and updates (prospects, statuses, timestamps, draft IDs).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e for sending emails, searching replies, and creating\/sending draft replies via Gmail API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e notifications and inline approval button before replies are sent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq\u003c\/strong\u003e for generating cold emails and classifying\/drafting reply responses.\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/tools mentioned: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123200577715,"sku":"N8N-20100","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/F3WyUO105EEuifHNwz5_q_bj8bmQyq.png?v=1790673430","url":"https:\/\/buyflowscripts.com\/products\/groq-cold-email-n8n-google-sheets-to-gmail-telegram-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}