Templates / Automate school notice distribution via WhatsApp, email and Excel

Automate school notice distribution via WhatsApp, email and Excel

Ready for 3.0

by Oneclick AI Squad ✓ · 1,289 views · created 2025-08-06 · Social Media

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Read Notices (Microsoft Excel 365): work with worksheet
  2. Validate Notice Data (If): checks a condition and branches into true / false
  3. Process Notice Distribution (Code): runs custom JavaScript code
  4. Prepare Email Content (Code): runs custom JavaScript code
  5. Prepare WhatsApp Content (Code): runs custom JavaScript code
  6. Send Email: sends an email over SMTP
  7. Send WhatsApp Notice (HTTP Request): calls graph.facebook.com
  8. Update Notice Status (Microsoft Excel 365): update (worksheet)

Services it uses

Microsoft Excel 365

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)

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…

Excerpt from Oneclick AI Squad's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.