# Student Fee Reminders with Stripe Payment Links

**Category:** Education  
**Tools:** n8n, Google Sheets, Google Drive  
**Nodes:** 27  
**Built by:** Forgent Systems

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.

![Workflow](preview.webp)

## How it works

1. On schedule, pending fees are fetched and a reminder stage is chosen.
2. A Stripe payment link is created, or the existing one is reused.
3. A WhatsApp reminder is sent and the fee record is updated.
4. The Stripe payment webhook marks the fee as paid.
5. A receipt PDF is created, stored in Drive and sent on WhatsApp.

## Use cases

- Schools and colleges
- Coaching institutes
- Activity and sports academies

## Data setup

**Google Sheets** (tab: columns)

- **Daily FEE Reminder → Fees Sheet**: `Status`, `StudentID`, `LastReminderSent`, `StripePaymentLink`, `ReminderSentAt`, `Month`, `DueAmount`, `ReceiptLink`, `PaymentReceiveAt`
- **Daily FEE Reminder → Students**: `StudentID`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Drive account
   - Google Sheets account
   - Stripe account
   - Twilio account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Schedule Trigger** — `n8n-nodes-base.scheduleTrigger`
- **Fetch Pending Fees** — `n8n-nodes-base.googleSheets`
- **Determine Reminder Stage (R1 / R2 / R3 / FINAL)** — `n8n-nodes-base.code`
- **Process Each Student Fee Record** — `n8n-nodes-base.splitInBatches`
- **Get Student & Parent Details** — `n8n-nodes-base.googleSheets`
- **Check If Stripe Payment Link Exists** — `n8n-nodes-base.if`
- **Create Stripe Payment Link** — `n8n-nodes-base.httpRequest`
- **Send WhatsApp Fee Reminder (New Link)** — `n8n-nodes-base.twilio`
- **Update Fee Record After Reminder(New Link)** — `n8n-nodes-base.googleSheets`
- **Send WhatsApp Fee Reminder (Existing Link)** — `n8n-nodes-base.twilio`
- **Update Fee Record After Reminder (Existing Link)** — `n8n-nodes-base.googleSheets`
- **Payment Success Trigger** — `n8n-nodes-base.stripeTrigger`
- **Extract Payment & Student Details** — `n8n-nodes-base.set`
- **Generate Receipt HTML (Styled)** — `n8n-nodes-base.code`
- **Convert Receipt HTML to PDF** — `n8n-nodes-base.httpRequest`
- **Find “Fee Receipts” Folder in Drive** — `n8n-nodes-base.googleDrive`
- **Check If Receipt Folder Exists** — `n8n-nodes-base.if`
- **Create “Fee Receipts” Folder** — `n8n-nodes-base.googleDrive`
- **Upload Receipt PDF (Existing Folder)** — `n8n-nodes-base.googleDrive`
- **Upload Receipt PDF (New Folder)** — `n8n-nodes-base.googleDrive`
- **Generate Public Receipt Link** — `n8n-nodes-base.set`
- **Send Payment Confirmation on WhatsApp** — `n8n-nodes-base.twilio`
- **Update Fee Status & Receipt Link** — `n8n-nodes-base.googleSheets`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Sticky Note1** — `n8n-nodes-base.stickyNote`
- **Sticky Note2** — `n8n-nodes-base.stickyNote`
- **Share Receipt** — `n8n-nodes-base.googleDrive`
