Automated tour payment reminders via WhatsApp & email with payment links
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 12 nodes and runs on a schedule (every day at 07:00) (plus 1 other trigger). Along the way it connects Microsoft Excel 365 and WhatsApp Business Cloud.
How it runs
Trigger: On a schedule (every day at 07:00) (plus 1 other trigger).
- Read Pending Travel Payment (Microsoft Excel 365): work with worksheet
- Check Pending Payment (Microsoft Excel 365): work with worksheet
- Process Payment Reminders (Code): runs custom JavaScript code
- Create Payment Reminders (Code): runs custom JavaScript code
- Prepare WhatsApp Reminder (Code): runs custom JavaScript code
- Make Reminder For Email (Code): runs custom JavaScript code
- Send Message (WhatsApp Business Cloud): send
- Send Email: sends an email over SMTP
- Update Reminder Status (Microsoft Excel 365): update (worksheet)
- Update Status Of Reminder (Microsoft Excel 365): update (worksheet)
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Code
n8n-nodes-base.code - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Send Email
n8n-nodes-base.emailSend - WhatsApp Business Cloud
n8n-nodes-base.whatsApp
From the author
This workflow automatically notifies travelers about their pending trip payments and provides secure payment links through Email and WhatsApp. It runs twice daily (at 7 AM and 7 PM) to ensure timely reminders before the due date. Designed for travel agencies,…