Send School Fee Reminders with Payment Links via Email & WhatsApp — n8n 工作流
概览
📚 Automated School Fee Reminder Workflow with Payment Link
Automatically sends fee reminders (via email and WhatsApp) to parents with secure payment links, 3 days before the due date.
🔧 Main Components
Daily Fee Check – 8 AM** Scheduled trigger that starts the workflow daily at 8 AM.
Read Pending Fees** Fetches student fee records from an Excel sheet (using getAll method).
Process Fee Reminders** Filters records to find pending fees due within the next 3 days.
Prepare Email Reminder*
使用的节点
Send EmailMicrosoft Excel 365WhatsApp Business CloudCode
工作流预览
⚡
D
Daily Fee Check - 8 AM
Read Pending Fees
Process Fee Reminders
Prepare Email Reminder
Prepare WhatsApp Reminder
Send Email Reminder
Update Reminder Status
W
Wait For Prepare Reminder
W
Wait For Prepare Reminde…
Send message
10 nodes10 edges
工作原理
- 1
触发器
工作流由 定时 触发器启动,按预定计划运行。
- 2
处理
数据流经 10 个节点, connecting code, emailsend, microsoftexcel。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (10)
SE#1
Send Email
emailSend
MI#2
Microsoft Excel 365
microsoftExcel
WHwhatsApp
#3
WhatsApp Business Cloud
CO#4
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
send-school-fee-reminders-with-payment-links-via-email-whatsapp文件并点击导入。 - 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
- 5点击 测试工作流 验证一切正常,然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴:
{ "name": "Send School Fee Reminders with Payment Links via Email & WhatsApp", "nodes": [...], ...}
集成
codeemailsendmicrosoftexcelscheduletriggerwaitwhatsapp
创建者
Oneclick AI Squad
@oneclick-ai
标签
codeemailsendmicrosoftexcelscheduletriggerwaitwhatsapp