mustaphatb1975/energy-sector-morocco-automation

Automated pump monitoring & data pipeline — WhatsApp → Excel, real-time alerts, zero manual entry | n8n · OpenAI · Google Sheets # 💧 Water & Energy Pump Automation — Morocco 🇲🇦 **Production automation system monitoring 7 industrial pumps in Morocco's energy sector.** Manual hours → **Zero** · Human errors → **Near-Zero** · Monitoring → **Real-Time** --- ## 📋 Overview This n8n workflow automates the full data lifecycle for 7 industrial water and energy pumps — from daily index collection to anomaly detection and instant supervisor alerts via WhatsApp. The system was built for an energy sector facility in Morocco 🇲🇦 and replaced a fully manual reporting process, eliminating transcription errors and enabling real-time operational visibility. > *"This system completely transformed how we track pump performance. What used to take hours of manual work now happens automatically every day."* > — **Operations Supervisor**, Energy Sector — Morocco 🇲🇦 --- ## 🏗️ System Architecture ``` ┌──────────────────────────────────────────────────────────────────┐ │ TRIGGER LAYER │ │ ┌─────────────────────┐ ┌──────────────────────────────┐ │ │ │ Schedule Trigger │ │ WhatsApp Webhook (POST) │ │ │ │ Daily @ 09:50 AM │ │ Receives daily pump indexes │ │ │ └────────┬────────────┘ └──────────────┬───────────────┘ │ │ │ │ │ │ ▼ ▼ │ │ ┌─────────────────────┐ ┌──────────────────────────────┐ │ │ │ Morning Reminder │ │ Month Router (Switch) │ │ │ │ via WhatsApp API │ │ Jan / Feb / Mar / Apr… │ │ │ └─────────────────────┘ └──────────────┬───────────────┘ │ └─────────────────────────────────────────────┼────────────────────┘ │ ┌─────────────────────────────────────────────▼────────────────────┐ │ PROCESSING LAYER │ │ │ │ ┌────── …