Send deduplicated partner outreach emails from Google Sheets via Zoho ZeptoMail

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 each lead to a tailored email template based on their partner type all sent via Zoho ZeptoMail with status logged back automatically.

Who it's for

Startups, agencies, or creator platforms running partnership outreach across multiple lead categories (colleges, influencers, brands) who want personalized messaging at scale without a dedicated CRM.

How it works

A Schedule Trigger fires and reads all rows from your leads Google Sheet Duplicate emails are removed and rows missing a name or email are filtered out Each lead is looped one at a time and checked against a Tracking Sheet anyone with a status of sent, followup_1, completed, replied, or unsubscribed is skipped entirely Qualifying leads are routed through a Switch node based on Partner Type: College — campus partnership pitch, addressed to the institution Influencer — collab-focused email, first-name personalized Brand — brand partnership proposal with company name Other — generic but warm outreach for uncategorized leads The correct email template is assembled in a Set node with a dynamic subject and HTML body Email is sent via Zoho ZeptoMail The lead is appended to the Tracking Sheet with status sent — preventing any re-contact on future runs

Setup

Connect your Google Sheets and Zoho ZeptoMail credentials in n8n Set your leads sheet and tracking sheet Resource IDs in all Google Sheets nodes Replace all [YOUR COMPANY] placeholders inside the four email Set nodes Update the sender address in the ZeptoMail send node Add your mail agent ID from ZeptoMail into the send node Ensure your leads sheet has columns: Name, Email, Company, Partner Type Ensure your tracking sheet has columns: Email, Status

Partner type values (in your sheet)

College · Influencer · Brand · anything else → routed to the Other template

Requirements

Self-hosted n8n instance (community node required) Community node: n8n-nodes-zohozeptomail Active Zoho ZeptoMail account with a configured mail agent