Send personalized cold email follow-ups from Google Sheets with ZeptoMail

Automated Cold Email Follow-up Sequence with Google Sheets & ZeptoMail

Stop losing leads to manual follow-up fatigue. This workflow runs daily, checks your Google Sheets lead tracker, and automatically sends the right follow-up email at the right time — personalized by partner type (College, Influencer, or Brand) — then updates the sheet status so nothing slips through the cracks.

Who is this for?

Founders, sales reps, and growth teams who manage outreach to multiple partner types and need a reliable, hands-off follow-up engine without a full CRM.

What this workflow does

1. Triggers daily via Schedule node
2. Reads your Google Sheet to fetch all leads
3. Filters active leads — skips anyone marked completed, replied, or unsubscribed
4. Checks follow-up date — only processes leads due today or earlier
5. Routes each lead by their current stage (sent → followup_1 → followup_2 → completed)
6. Builds a personalized HTML email based on partner type (College/University, Influencer, Brand, or generic)
7. Sends via ZeptoMail with threading headers to keep replies in the same email thread
8. Updates the Google Sheet with the new status and next follow-up date

Prerequisites

• A self-hosted n8n instance (community nodes required)
• A Google Sheets account with OAuth connected
• A Zoho ZeptoMail account with API access
• The community node installed: n8n-nodes-zohozeptomail

Google Sheet structure

Your tracking sheet should have (at minimum) these columns:

Setup steps

1. Install the community node n8n-nodes-zohozeptomail in your n8n instance
2. Connect Google Sheets — add your OAuth credentials in n8n
3. Connect ZeptoMail — add your API key credentials
4. Update the Google Sheet ID and sheet name in the Read Tracking Sheet node
5. Replace placeholder values in the Code nodes:

• [YOUR COMPANY], [YOUR NAME], [YOUR EMAIL]
• https://calendly.com/REPLACE_WITH_CALENDAR_LINK

1. Set the workflow to Active — it will run automatically every day

Customization

• Add new partner types by extending the getTemplate() function in the Build Email Code nodes
• Adjust follow-up timing by changing the date written back to the sheet in the Update Status nodes
• Add more stages beyond followup_2 by extending the Switch node and duplicating the email builder pattern

⚠️ Important notes

• This workflow requires a self-hosted n8n instance — it will not run on n8n Cloud due to the community node dependency
• Leads are skipped (not deleted) if their status is completed, replied, or unsubscribed — safe to keep all history in one sheet
• ZeptoMail threading headers (In-Reply-To, References) are set automatically if message_id is present in the sheet