Automate Your Cold Email Outreach with n8n & Google Sheets

Transform your cold email outreach from manual drudgery into an intelligent, automated system that personalizes every message, tracks responses, and follows up automatically—all powered by n8n, Google Sheets, and AI.

What this workflow does

This comprehensive cold email automation workflow streamlines your entire outreach process with precision and intelligence. Here's how it operates:

• Automatically fetches all leads marked as "Pending" from your Google Sheets database
• Processes each lead individually to respect email rate limits and avoid spam filters
• Uses OpenAI to generate personalized cold emails based on each lead's name, company, and job title
• Sends customized emails via Gmail and updates lead status to "Email 1 Sent"
• Monitors your inbox for replies after a 2-minute processing window
• Automatically updates lead status to "Replied" when responses are detected
• Generates and sends AI-powered follow-up emails for non-responders
• Includes robust error handling with Slack notifications for any workflow failures

Use cases

Perfect for sales teams conducting B2B outreach campaigns, recruiters reaching out to potential candidates, agencies prospecting new clients, or SaaS companies running lead generation campaigns. This workflow is ideal when you have a substantial lead list in Google Sheets and want to maintain personalization at scale while tracking engagement automatically.

Technical details

Built with essential n8n nodes including Gmail for email delivery, Google Sheets for lead management, OpenAI for content personalization, Slack for error notifications, plus if/code/wait/sticky note nodes for logic and flow control. Setup requires OAuth2 connections for Google Sheets, Gmail, and Slack, plus your OpenAI API key.

Your leads spreadsheet needs columns for First Name, Last Name, Company, Email, Job Title, Status, and Thread_ID. Simply set lead status to "Pending" and customize the AI prompts to match your outreach style. Complete setup takes approximately 15 minutes, then execute the workflow to process all pending leads automatically.