Student Fee Reminders with Stripe Payment Links
Sends staged WhatsApp fee reminders to parents with a Stripe payment link. When payment is made, the record is updated, a receipt PDF is generated and the receipt is shared.

On this page
How it works
- On schedule, pending fees are fetched and a reminder stage is chosen.
- A Stripe payment link is created, or the existing one is reused.
- A WhatsApp reminder is sent and the fee record is updated.
- The Stripe payment webhook marks the fee as paid.
- A receipt PDF is created, stored in Drive and sent on WhatsApp.
Use cases
- Schools and colleges
- Coaching institutes
- Activity and sports academies
What you need
This workflow connects to these apps.
- n8n
- Google Sheets
- Google Drive
You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.
- Google Drive account
- Google Sheets account
- Stripe account
- Twilio account
Data setup
Create these tables with these exact column names before the first run.
| Table | Columns |
|---|---|
| Daily FEE Reminder → Fees SheetGoogle Sheets | StatusStudentIDLastReminderSentStripePaymentLinkReminderSentAtMonthDueAmountReceiptLinkPaymentReceiveAt |
| Daily FEE Reminder → StudentsGoogle Sheets | StudentID |
Setup
- Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.
Nodes
| Node | Type |
|---|---|
| Schedule Trigger | scheduleTrigger |
| Fetch Pending Fees | googleSheets |
| Determine Reminder Stage (R1 / R2 / R3 / FINAL) | code |
| Process Each Student Fee Record | splitInBatches |
| Get Student & Parent Details | googleSheets |
| Check If Stripe Payment Link Exists | if |
| Create Stripe Payment Link | httpRequest |
| Send WhatsApp Fee Reminder (New Link) | twilio |
| Update Fee Record After Reminder(New Link) | googleSheets |
| Send WhatsApp Fee Reminder (Existing Link) | twilio |
| Update Fee Record After Reminder (Existing Link) | googleSheets |
| Payment Success Trigger | stripeTrigger |
| Extract Payment & Student Details | set |
| Generate Receipt HTML (Styled) | code |
| Convert Receipt HTML to PDF | httpRequest |
| Find “Fee Receipts” Folder in Drive | googleDrive |
| Check If Receipt Folder Exists | if |
| Create “Fee Receipts” Folder | googleDrive |
| Upload Receipt PDF (Existing Folder) | googleDrive |
| Upload Receipt PDF (New Folder) | googleDrive |
| Generate Public Receipt Link | set |
| Send Payment Confirmation on WhatsApp | twilio |
| Update Fee Status & Receipt Link | googleSheets |
| Share Receipt | googleDrive |
Frequently asked questions
Sends staged WhatsApp fee reminders to parents with a Stripe payment link. When payment is made, the record is updated, a receipt PDF is generated and the receipt is shared. It's a 27-node n8n workflow.
An n8n instance, on n8n Cloud or self-hosted, and credentials for Google Drive, Google Sheets, Stripe, and Twilio. It uses only nodes that ship with n8n, so there's nothing else to install.
It works with 2 tables in Google Sheets. Create them with the column names listed under Data setup on this page before the first run.
Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.
Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.



