I send 200 personalized cold emails in 10 minutes. Here's the exact n8n workflow.
Hi all I've been struggling with sending personalized cold emails at scale, and I know a lot of you have too. You have a list of 200 leads in a spreadsheet. You open the first row, write a personalized email, send it, go to the next row, repeat. By email number 10 you're exhausted. By email number 20 you're copy pasting the same thing to everyone. That's not personalization that's spam. I spent some time last week building a simple automation for this, and it now sends 200 personalized cold emails automatically for less than $10/m: 1. Add your leads to Google Sheets Just 5 columns: First Name, Company, Service, Email, Status. That's your entire lead list. No fancy tools needed. 2. n8n reads every row automatically A Google Sheets node in n8n loops through every single lead one by one. Each lead becomes its own workflow run. 3. n8n checks if this lead was already emailed An IF node checks the Status column. If it already says "sent" it skips that lead completely. No duplicate emails ever. 4. GPT-4 writes a unique email for every lead An OpenAI node takes the lead's name, company and service and writes a completely personalized cold email. Every email is different. Every email sounds human. 5. Gmail sends the email automatically The personalized email lands in the lead's inbox with their real name and company mentioned. Looks 100% manual. It's not. 6. Google Sheets updates the status automatically The Status column updates to "sent" the moment the email goes out. Your sheet is always up to date. No lead ever gets emailed twice. Total cost: Google Sheets (free) + n8n cloud (~$8/m) + OpenAI API (~$1 per 200 emails) Set it up once. Run it whenever you have a new lead list. I used to spend 3 hours sending 50 emails manually. Now I send 200 personalized emails in 10 minutes β and I only touch the spreadsheet. If anything is unclear drop a comment, happy to help π