workflows.fit
Back to n8n workflows
n8n templateFreeBy Oneclick AI Squad

Automated tour payment reminders via WhatsApp & email with payment links

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 t...

CommunicationHITLCore NodesData & StorageProductivityDevelopmentCodeMicrosoft Excel
Loading interactive preview...

Template notes

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, it simplifies payment tracking, reduces manual follow-up, and ensures every traveler receives personalized reminders with real-time payment status updates.

🔧 Main Components Daily Payment Check – 7 AM & 7 PM Scheduled triggers that start the workflow daily at 7 AM and 7 PM.

Read Pending Travel Payment Fetches traveler payment records from an Excel sheet (using getAll method).

Process Payment Reminders Filters records to find pending payments due within the next 3 days.

Create Payment Reminders Generates personalized payment reminders.

Make Reminder For Email Prepares email-friendly messages with payment links.

Send Email Reminder Sends the payment reminder email with a secure payment link to the traveler.

Prepare WhatsApp Reminder Generates WhatsApp-friendly messages with payment and payment details.