n8n Cold Email Automation: Gemini + Sheets + Gmail Sequences

Turn a Lead List Into Hand-Written Cold Emails (With Gemini, Sheets, and Gmail Sequences)

This n8n Cold Email Automation workflow reads leads from Google Sheets, uses Gemini to write a first email and follow-up from your offer brief, runs a spam-safety quality check, and sends (or drafts) messages via Gmail—while tracking everything back to each lead row.

What this workflow does

• Starts from a manual run or an n8n Form submission that adds a lead, or via an CSV/XLSX upload.
• Appends leads to Google Sheets, then reads the full sheet and pulls your offer brief from Google Docs.
• Automatically detects required columns (email, name, company, website, role—whatever they’re called) and selects the next leads to email or follow up based on outreach status and timing.
• For new leads: fetches the lead’s website content (when available) and generates a first email plus a follow-up using only the facts in your offer brief and a proven 4-part structure.
• Validates the copy against fixed rules; if it fails, the workflow rewrites once before deciding it’s safe to proceed.
• For follow-ups: searches Gmail to confirm the original email was sent and to detect replies before sending the next message.
• Sends via Gmail or creates a Gmail draft (based on send mode), then updates the matching Google Sheets row with email content, dates, and outreach status.

Use cases

• SaaS operators generating repeatable cold outreach sequences from CRM exports.
• Automation engineers deploying an n8n workflow for lead status tracking, timing logic, and reply-aware follow-ups.
• Teams running campaigns where copy must stay consistent with an offer brief in Google Docs.

Technical details

• n8n nodes/logic: if, set, code, switch, gmail
• Integrations: Google Sheets (leads + status), Google Docs (offer brief), Gmail (send/draft + reply detection)
• AI-based steps for lead-aware email generation and spam-safety quality checks before Gmail output.