{"product_id":"n8n-cold-email-automation-google-sheets-gmail-gemini","title":"n8n Cold Email Automation: Google Sheets + Gmail + Gemini","description":"\u003ch3\u003eAutomate Gemini-powered cold emails from Google Sheets—plus timed follow-ups and live reply tracking in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every day to generate personalized cold emails with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, send them via \u003cstrong\u003eGmail\u003c\/strong\u003e, schedule two follow-ups based on when the first email was sent, and continuously monitor Gmail for replies to update your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including a \u003cstrong\u003eSlack\u003c\/strong\u003e alert for hot leads.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily 9AM execution\u003c\/strong\u003e: at 9AM, it launches three parallel paths—new sends, Follow-up 1 checks, and Follow-up 2 checks—using the same Google Sheets “Leads” list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNew lead processing\u003c\/strong\u003e: pulls pending leads from Google Sheets, validates required fields, then \u003cstrong\u003escrapes each company website\u003c\/strong\u003e using an \u003cstrong\u003eHTTP request\u003c\/strong\u003e and cleans the page text for prompting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini email generation\u003c\/strong\u003e: sends company details, cleaned website content, and your service to \u003cstrong\u003eGemini\u003c\/strong\u003e to produce a \u003cstrong\u003eJSON subject and personalized email body\u003c\/strong\u003e, then sanitizes the output to remove leftover placeholders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail sending + sheet updates\u003c\/strong\u003e: sends the cold email via \u003cstrong\u003eGmail\u003c\/strong\u003e and updates the matching Google Sheets row (by \u003cstrong\u003econtact_email\u003c\/strong\u003e) with status, timestamps, and follow-up tracking fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTimed follow-ups\u003c\/strong\u003e: selects leads whose \u003cstrong\u003esent_at\u003c\/strong\u003e is at least \u003cstrong\u003e3 days\u003c\/strong\u003e old (Follow-up 1) or \u003cstrong\u003e7 days\u003c\/strong\u003e old (Follow-up 2), sends prewritten follow-ups via Gmail, and marks sequence completion in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReply monitoring + Slack alerts\u003c\/strong\u003e: polls Gmail for new unread inbox messages, matches the sender against Google Sheets leads, and if not already marked replied, updates the row and posts a \u003cstrong\u003ehot-lead notification\u003c\/strong\u003e to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams running consistent cold outreach using \u003cstrong\u003en8n\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing structured follow-up sequences (3-day and 7-day) tied to lead status.\u003c\/li\u003e\n  \u003cli\u003eOperators who want \u003cstrong\u003elive reply visibility\u003c\/strong\u003e with Slack notifications and sheet-based tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGoogle Sheets (leads list + row updates via \u003cem\u003econtact_email\u003c\/em\u003e)\u003c\/li\u003e\n  \u003cli\u003eGmail (send emails + trigger\/poll unread replies)\u003c\/li\u003e\n  \u003cli\u003eGoogle Gemini (generate subject and personalized body in JSON)\u003c\/li\u003e\n  \u003cli\u003eHTTP request (scrape and clean company website text)\u003c\/li\u003e\n  \u003cli\u003eSlack (hot-lead notifications)\u003c\/li\u003e\n  \u003cli\u003eif, code, sticky note nodes for logic, data handling, and workflow documentation\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45726217076915,"sku":"N8N-17488","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/uKYFqSDA4o3B8fScHQoYm_Ii6ArZpQ.png?v=1785054834","url":"https:\/\/buyflowscripts.com\/products\/n8n-cold-email-automation-google-sheets-gmail-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}