Send multi-stage customer project emails from Google Sheets with Zoho ZeptoMail
UnknownWhat this workflow does
This workflow has 24 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets and Zohozeptomail (community).
How it runs
Trigger: On a schedule (every day at 09:00).
- Read All Customer Rows (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Calculate Date Variables (Edit Fields (Set)): sets 7 fields: today, t3_target_date, t3_window_date…
- Is T+3 Email Due? (If): checks a condition and branches into true / false
- Is T+5 Email Due? (If): checks a condition and branches into true / false
- Is Feedback Email Due? (If): checks a condition and branches into true / false
- Is Upsell Email Due? (If): checks a condition and branches into true / false
- Loop T+3 (1 at a time) (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop T+5 (1 at a time) (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop Feedback (1 at a time) (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 13 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 Send T+3 Update Email, Send T+5 Update Email, Send Feedback Request Email).
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Zoho Zeptomail
n8n-nodes-zohozeptomail.zohoZeptomail
From the author
Keep your clients informed at every stage of their project without lifting a finger. This workflow runs daily from Google Sheets and automatically sends four timed emails a Day 3 progress update, a Day 5 near-completion nudge, a feedback request on project…