{"product_id":"automate-cold-emails-n8n-with-google-sheets-gmail-drafts","title":"Automate Cold Emails: n8n with Google Sheets \u0026 Gmail Drafts","description":"\u003cp\u003eTransform your B2B cold email outreach from manual copy-paste drudgery into an intelligent, automated system that creates personalized Gmail drafts using AI. This n8n workflow template seamlessly connects Google Sheets lead management with Google Gemini AI writing and Gmail draft creation, giving you complete control over your outreach while eliminating repetitive tasks.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThe automation runs on a scheduled basis (defaulting to weekday mornings) and intelligently processes your Google Sheets lead database. It validates email addresses, caps daily send volumes, and smartly skips already-contacted leads to prevent duplicate outreach. Using Google Gemini AI, the workflow generates personalized subject lines and email bodies by pulling data from your sheet columns like pain points, plus points, location, and specialty information.\u003c\/p\u003e\n\n\u003cp\u003eRather than sending emails blindly, the system creates Gmail drafts for your review—ensuring you maintain quality control over tone, facts, and compliance. Once you approve and send drafts manually, the workflow automatically logs the \"Email Sent\" status and timestamp back to your Google Sheets, creating a complete audit trail.\u003c\/p\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eDigital agencies prospecting new clients with personalized outreach campaigns\u003c\/li\u003e\n\u003cli\u003eB2B consultants systematically reaching out to potential customers\u003c\/li\u003e\n\u003cli\u003eSaaS founders conducting targeted cold email sequences for user acquisition\u003c\/li\u003e\n\u003cli\u003eSales teams managing high-volume prospect communications with personalization at scale\u003c\/li\u003e\n\u003cli\u003eService providers automating initial contact while maintaining message quality\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow utilizes Google Sheets nodes for lead data management, Google Gemini integration for AI-powered content generation, and Gmail nodes for draft creation. The automation includes code nodes for custom logic, wait nodes for API throttling, split in batches functionality for processing control, and sticky note nodes for workflow documentation.\u003c\/p\u003e\n\n\u003cp\u003eSimply import the \u003ccode\u003eoutreach_cold_mail_agent.json\u003c\/code\u003e file, configure your Google Sheets IDs and OAuth credentials, and launch your first automated cold email draft generation within minutes.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45484908871859,"sku":"N8N-15425","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vtmfc2vxvEJmcnA5KQ-LJ_79755389fad94b099f122de822969ebe.jpg?v=1777656356","url":"https:\/\/buyflowscripts.com\/products\/automate-cold-emails-n8n-with-google-sheets-gmail-drafts","provider":"N8N Commerce","version":"1.0","type":"link"}