Video notes & templates (free): Lead Form
Try n8n for free: AI Workflow Automation Platform - n8n
Automate repetitive email sending from Google Sheets using n8n — send personalized emails via Gmail, track replies, and even generate AI-written messages at scale.
This tutorial walks through building a complete email automation system in n8n. You set up a Google Sheet with columns for recipient email, subject, message body, and a status field. The n8n workflow reads all rows marked “To send,” dispatches each email through Gmail, and updates the status to “Sent” to prevent duplicates.
A second workflow handles response tracking — it monitors your Gmail inbox for replies and logs them back into the same Google Sheet, giving you a centralized view of who’s been contacted and who’s responded without manually checking your inbox.
The tutorial also covers AI-powered personalization using n8n’s AI Agent node with OpenAI. Instead of writing each email yourself, you add a one-sentence description of each recipient and the AI generates tailored email content at scale. This is where it gets really powerful — dozens of personalized emails from brief one-liners.
The whole setup runs on n8n, which can be 80-90% cheaper than alternatives like Zapier or Make, and you can self-host it for free with unlimited executions.
Book a Free Consultation: Book a Call - SmoothWork
