Keep your clients informed at every stage of their project without lifting a finger. This workflow runs daily from Goog…
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 completion, and a post-delivery upsell all via Zoho ZeptoMail. Each email is logged back to the sheet so no message ever sends twice. Who it's for Service businesses (resume writing, LinkedIn optimization, design, freelance agencies) that manage client orders in a Google Sheet and want structured follow-up without a CRM. How it works A Schedule Trigger fires daily at 9 AM and reads all rows from your Google Sheet Blank rows are filtered out; date variables are calculated dynamically Four parallel branches check independently whether each email type is due: T+3 — progress update sent 3 days after the order date T+5 — near-completion update sent at day 5 (only after T+3 is confirmed sent) Feedback — sent once the project status is marked Completed Upsell — sent ~3 days after feedback, offering premium add-ons Each qualifying row is looped one at a time, the email is sent via ZeptoMail, and the sheet is updated to prevent re-sends After the upsell sends, the row status is set to All Done — permanently stopping all further checks for that customer Setup Connect your Google Sheets and Zoho ZeptoMail credentials in n8n Replace all YOUR_RESOURCE_ID_HERE placeholders in the Google Sheets nodes with your actual spreadsheet and sheet IDs Set your sender address in all four email nodes (YOUR_EMAIL_HERE) Update the feedback form link and booking link in the Feedback and Upsell email templates Ensure your sheet has these columns: Customer Name, Email, Project Type, Date Added, Status, T3_Email_Sent, T5_Email_Sent, Feedback_Email_Sent, Feedback_Email_Date, Upsell_Email_Sent, original_subject Requirements Self-hosted n8n instance (community node required) Community node: n8n-nodes-zohozeptomail Active Zoho ZeptoMail account with a configured mail agent. An n8n automation workflow template by Panth1823.
Panth1823
web
free
Others in the same category, ranked by how often they are opened.
