Send deduplicated partner outreach emails from Google Sheets via Zoho ZeptoMail
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs on a schedule (every day). Along the way it connects Google Sheets and Zohozeptomail (community).
How it runs
Trigger: On a schedule (every day).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Remove Duplicate Emails (Remove Duplicates): removes duplicate items
- Validate Email and Name (Filter): keeps only the items that match a condition
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Read Tracking Sheet (Google Sheets): uses Google Sheets
- Skip If Already In Sequence (Code): runs custom JavaScript code
- Route by Partner Type (Switch): routes items into 3 branches
- College Email (Edit Fields (Set)): sets 5 fields: recipientEmail, recipientName, partnerType…
- Influencer Email (Edit Fields (Set)): sets 5 fields: recipientEmail, recipientName, partnerType…
- Brand Email (Edit Fields (Set)): sets 5 fields: recipientEmail, recipientName, partnerType…
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-zohozeptomail is verified or supports 3.0 (used in Initial Email).
Nodes used (10)
- Remove Duplicates
n8n-nodes-base.removeDuplicates - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Zoho Zeptomail
n8n-nodes-zohozeptomail.zohoZeptomail
From the author
Send personalized cold outreach emails to partners without ever contacting the same person twice. This workflow reads a lead list from Google Sheets, validates and deduplicates entries, checks a tracking sheet to skip anyone already in sequence, then routes…