Automated cold email campaign with Google Sheets, email verification & SMTP
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 13 nodes and runs on a schedule (every day at 09:00) (plus 1 other trigger). Along the way it connects Google Sheets and Hunter.
How it runs
Trigger: On a schedule (every day at 09:00) (plus 1 other trigger).
- Lead Sheet - Get Rows from the sheet (Google Sheets): uses Google Sheets
- Checker - If Already "Sent" or not (If): checks a condition and branches into true / false
- Checker - If Lead's "Email" Field is empty? (If): checks a condition and branches into true / false
- Email verification using Hunter (Hunter): email verifier
- Checker - If emails are verified or no? (If): checks a condition and branches into true / false
- Send Email: sends an email over SMTP
- Creating Field for Updating "Sent" in G Sheet (Edit Fields (Set)): sets 1 field: accepted[0]
- Updating GSheet if Email Is "Sent" (Google Sheets): update
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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - No Operation, do nothing
n8n-nodes-base.noOp - Hunter
n8n-nodes-base.hunter - Send Email
n8n-nodes-base.emailSend
From the author
Use this template if you’re collecting leads in Google Sheets manually or automatically and need to send them emails daily using any personal or professional email provider. It’s simple yet effective. I’ve kept it easy so that anyone without technical or…