n8n Cold Email Automation: Gmail SMTP + Google Sheets

Automate Personalized Cold Email Sequences (Gmail SMTP + Google Sheets) in n8n

This n8n workflow automatically sends personalized cold email follow-ups to your leads: it pulls un-contacted prospects from your Google Sheet, validates email addresses, sends emails on a schedule, and then updates your sheet with delivery status—so your outreach stays consistent and measurable.

What this workflow does

• Runs on a schedule: A scheduled trigger (via the Set Timer node) starts the workflow automatically at your chosen interval (e.g., every 6 hours).
• Fetches unsent leads: The Get Emails node checks your Google Sheet and selects prospects where the "Email Sent" status for the current step is "No".
• Validates email addresses: The workflow validates leads’ email addresses before attempting delivery, helping prevent sending to invalid entries.
• Sends tailored emails: Emails are dispatched according to a predefined sequence and schedule, using your email content logic.
• Controls send volume: A Limit node can cap how many emails are sent per batch to avoid overwhelming your campaign pace.
• Tracks results in your CRM: After sending, the workflow updates your Google Sheet with the status for each outreach step so you can monitor what was sent and when.

Use cases

• Sales teams: Automate multi-stage cold outreach at scale with reliable follow-up tracking.
• Business development: Nurture prospects over time using a scheduled email sequence.
• Recruiters: Send introductory emails to candidate leads from a maintained Google Sheet.
• Marketers: Distribute personalized outreach for content, events, or product launches.
• Anyone doing cold outreach: Reduce manual work and track email performance in a lightweight CRM.

Technical details (n8n nodes & integrations)

• Scheduled Trigger / Set Timer (interval-based execution)
• Get Emails (reads from Google Sheets)
• if (conditional logic)
• wait (timing between steps when needed)
• gmail / email send (dispatch emails via Gmail SMTP)
• limit (batch size control)
• Sticky note (workflow documentation)