Automate school notice distribution via WhatsApp, email and Excel
Ready for 3.0What this workflow does
This workflow has 9 nodes and runs on a schedule (every day at 09:00). Along the way it connects Microsoft Excel 365. It also calls graph.facebook.com over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00).
- Read Notices (Microsoft Excel 365): work with worksheet
- Validate Notice Data (If): checks a condition and branches into true / false
- Process Notice Distribution (Code): runs custom JavaScript code
- Prepare Email Content (Code): runs custom JavaScript code
- Prepare WhatsApp Content (Code): runs custom JavaScript code
- Send Email: sends an email over SMTP
- Send WhatsApp Notice (HTTP Request): calls graph.facebook.com
- Update Notice Status (Microsoft Excel 365): update (worksheet)
Services it uses
HTTP calls to: graph.facebook.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend - HTTP Request
n8n-nodes-base.httpRequest - Microsoft Excel 365
n8n-nodes-base.microsoftExcel
From the author
This automated n8n workflow distributes school notices to stakeholders (students, parents, and staff) via WhatsApp, email, and other channels. It streamlines the process of scheduling, validating, and sending notices while updating distribution status. System…