Automated School Fee & Payment Link Distribution - n8n Workflow

School/University administrators needing to automate billing reminders.
Financial departments looking to integrate Microsoft Excel data with communication platforms.
Users seeking comprehensive n8n templates for scheduled data processing and multichannel communication.
Developers needing examples of custom scripting within an n8n node for complex data transformation.

This comprehensive automation solution solves the tedious task of manually tracking school fee payments and sending reminders. By leveraging a scheduled n8n trigger, the n8n workflow connects directly to your Microsoft Excel fee records. It intelligently filters for fees due within a critical 3-day window, dynamically generates unique payment links, and ensures high deliverability by sending personalized messages through both standard email and WhatsApp. This powerful n8n workflow dramatically reduces administrative overhead, improves cash flow, and offers a prime example of sophisticated data handling within an n8n environment. Utilizing these n8n templates ensures consistent and timely parent communication.

1. Scheduled Start: The entire process begins with a Schedule n8n trigger, Daily Fee Check - 8 AM, set to run precisely at 8 AM every morning.


2. Data Retrieval: The n8n workflow uses the Microsoft Excel n8n node (Read Pending Fees) to fetch all records marked as "Pending" from the specified fee ledger workbook.


3. Core Logic Processing: A crucial Code n8n node (Process Fee Reminders) analyzes the fetched data. It calculates a reminder date (3 days out), filters for records where the dueDate falls within that window, and dynamically generates a simulated paymentLink. This stage showcases complex data manipulation achievable within an n8n node.


4. Parallel Preparation: The flow branches into two parallel paths. Separate Code n8n nodes (Prepare Email Reminder and Prepare WhatsApp Reminder) structure the reminder details, subject lines, and conversational text, ensuring optimal messaging for both platforms.


5. Flow Control (Wait): The workflow uses Wait n8n nodes to manage the data flow before proceeding to the send operations.


6. Multi-Channel Delivery: The flow executes the actual delivery using the Email Send n8n node and the dedicated WhatsApp n8n node, sending personalized reminders and payment links directly to the parents.


7. Status Update: Finally, the Microsoft Excel n8n node (Update Reminder Status) updates the source sheet. This ensures that the n8n workflow logs the successful reminder submission, preventing re-sending in subsequent runs and maintaining data integrity.

1. Import the n8n template: Copy the provided JSON code and import it directly into your n8n instance.


2. Set up Credentials: You will need to configure three sets of credentials:

1. Configure Data Nodes: Edit the Read Pending Fees and Update Reminder Status n8n nodes to ensure they point to the correct Workbook ID and Worksheet ID for your fee records.


2. Activate: Ensure the workflow is active. The Schedule n8n trigger will start the process daily at the configured time.

Daily Fee Check - 8 AM (Schedule n8n trigger): The entry point of this sophisticated n8n workflow, guaranteeing it runs consistently every day at 8:00 AM.
Read Pending Fees (Microsoft Excel n8n node): Connects to the fee database. Key Configuration: Filters records where the Status column is equal to "Pending."
Process Fee Reminders (Code n8n node): Crucial logic component. Function: Filters fees due within a 3-day window and generates dynamic fields like paymentLink and daysRemaining. This custom code n8n node is the backbone of the reminder logic.
Prepare Email Reminder / Prepare WhatsApp Reminder (Code n8n nodes): These nodes handle data transformation, dynamically composing the subject and text body for each channel using incoming data fields.
Wait For Prepare Reminder (Wait n8n node): Ensures sequential execution before delivery is attempted.
Send Email Reminder (Email Send n8n node): Dispatches the personalized fee reminder email using the configured SMTP credentials.
Send message (WhatsApp n8n node): Sends the reminder via the WhatsApp API, leveraging the formatted message created in the previous n8n node.
Update Reminder Status (Microsoft Excel n8n node): The final step in this n8n workflow. Function: Updates the status column in Excel, marking the record as processed to prevent redundant reminders.