Automated cold email campaigns with random templates & Google Sheets tracking
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Google Sheets: uses Google Sheets
- If: checks a condition and branches into true / false
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Google Sheets: uses Google Sheets
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Edit Fields (Edit Fields (Set)): sets 2 fields: subject, body
- Merge: merges the data from its input branches
- Send Email: sends an email over SMTP
- Google Sheets: append or update
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - Manual Trigger
n8n-nodes-base.manualTrigger - Send Email
n8n-nodes-base.emailSend
From the author
📊 Google Sheets Leads → 🎲 Random Templates → ✉️ Personalized Emails → 📝 Status Tracking What this workflow does - 📊 Reads leads list from Google Sheets (Name, Email, Send Status) - 🔍 Filters out already-contacted leads (skips "SENT" status) - 🎲 Randomly…