Automate Cold Emails: n8n with Google Sheets & Gmail Drafts

Transform 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.

What this workflow does

The 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.

Rather 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.

Use cases

• Digital agencies prospecting new clients with personalized outreach campaigns
• B2B consultants systematically reaching out to potential customers
• SaaS founders conducting targeted cold email sequences for user acquisition
• Sales teams managing high-volume prospect communications with personalization at scale
• Service providers automating initial contact while maintaining message quality

Technical details

This 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.

Simply import the outreach_cold_mail_agent.json file, configure your Google Sheets IDs and OAuth credentials, and launch your first automated cold email draft generation within minutes.