MadhaTV | UPS Command Center

UPS units monitored

4 single-phase · 1 three-phase

Active alarms

—

Power failure or low voltage

Average voltage

—

Across available UPS readings

Hosted database

MySQL · cPanel

Private server-side database

UPS fleet status

Latest reported values

Latest telemetry

Automatic device sync

System readiness

Device identity—

Cloud data link—

WhatsApp recipients—

Google Sheets forwarding—

Keep secrets private. Meta and Sheets tokens are sent over HTTPS and encrypted in the VPS database. They are never shown again after saving or stored on the ESP32. Protect the server encryption key and rotate any credentials previously shared.

WhatsApp Cloud API

Configure the Meta sender and an approved WhatsApp message template.

Meta Phone Number ID This is the Phone Number ID, not your displayed WhatsApp number. Meta access token Token is encrypted by the VPS. Blank keeps the saved token. Remove saved Meta token Approved template name Template language The approved template needs two body parameters: UPS/alarm and timestamp. Google Apps Script Web App URL Google Sheets HMAC secret Token is encrypted by the VPS. Blank keeps the saved secret. Remove saved Sheets secret

Emergency & WhatsApp recipients

Choose whether each saved person is an emergency contact, receives WhatsApp alerts, or both. Use international format with country code.

Loading contacts…

VPS connection

Device ID—

Database—

Core server secrets—

Dashboard passwordNot configured

ESP32 device tokenNot configured

Session signing secretNot configured

Meta access tokenNot configured

Google Sheets HMAC tokenNot configured

Protect this server

Set unique server secrets before starting the Node.js app. Keep the .env file outside public web folders and restrict access to the database and backups.

Dashboard loginUse a long unique password

ESP32 ingestUse a separate random token

Session signingKeep private and stable

Token encryptionBack up securely; never change casually

Google Sheets setup

Create a Google Sheet, then open Extensions → Apps Script.
Paste the project’s google-sheets/Code.gs source.
In Apps Script Project Settings → Script Properties, set SPREADSHEET_ID and GOOGLE_SHEETS_TOKEN. Use the same random token as the one entered in this dashboard.
Deploy as a Web app, execute as yourself, and allow access as required by your Google Workspace. Copy the deployment URL above.

System overview

UPS fleet status

Latest telemetry

System readiness

Historical reports

Readings

WhatsApp Cloud API

Emergency & WhatsApp recipients

VPS connection

Protect this server

Google Sheets setup