How gutierrezrileyg/sms-notification-system works
This repository is a collection of SMS-notification implementations and experiments, not one unified application. The clearest documented-by-code workflow is the Main Files continuous notifier: it fetches resident and GPS-status records, groups them by barangay, formats recipient numbers, dispatches SMS through a Node module, and can sync statuses to a Google Sheet. Other folders contain alternate spreadsheet/database and webhook-based status-writing implementations. Relationships for those unsampled variants are omitted; the README itself describes no further product capabilities.
Main entry points: Main Files/run_pipeline.py Continuous notifier · Fully Working_Notif System/run_pipeline.py Barangay SMS pipeline · Working_UniSMS API/run_pipeline.py UniSMS pipeline · data_retrieve.py Web app fetcher
Components 18
Notification orchestration
- Continuous notifier
Main Files/run_pipeline.py - Barangay SMS pipeline
Fully Working_Notif System/run_pipeline.py - UniSMS pipeline
Working_UniSMS API/run_pipeline.py
Recipient data
- Web app fetcher
Main Files/data_retrieve.py - Phone formatter
Main Files/data_retrieve.py - Excel resident loader
Fully Working_Notif System/data_retrieve.py - Resident database
Fully Working_Notif System/data_retrieve.py - Spreadsheet data tools
Working_UniSMS API/data_retrieve.py
SMS delivery
- SMS sender
Main Files/sms_sending.js
Status tracking
- Sheet status sync
Main Files/sms_status.py - Excel status writer
Fully Working_Notif System/data_retrieve.py - Webhook status writer
Testing/PhilSMS/sms_status_writer.py
Other components
- Operator
- Web app data
- SMS gateway
- Google Sheets
- Status workbook
- SMS provider webhook
Connections 19
- Operator → Continuous notifier: starts
Main Files/run_pipeline.py - Continuous notifier → Web app fetcher: fetches records
Main Files/run_pipeline.py - Web app fetcher → Web app data: requests data
Main Files/data_retrieve.py - Continuous notifier → Phone formatter: formats numbers
Main Files/run_pipeline.py - Continuous notifier → SMS sender: dispatches SMS
Main Files/run_pipeline.py - SMS sender → SMS gateway: sends SMS
- Continuous notifier → Sheet status sync: updates status
Main Files/run_pipeline.py - Sheet status sync → Google Sheets: posts updates
Main Files/sms_status.py - Operator → Barangay SMS pipeline: starts
Fully Working_Notif System/run_pipeline.py - Barangay SMS pipeline → Excel resident loader: loads profiles
Fully Working_Notif System/run_pipeline.py - Excel resident loader → Resident database: stores profiles
Fully Working_Notif System/data_retrieve.py - Barangay SMS pipeline → Resident database: queries residents
Fully Working_Notif System/run_pipeline.py - Barangay SMS pipeline → SMS gateway: sends SMS
Fully Working_Notif System/run_pipeline.py - Barangay SMS pipeline → Excel status writer: updates statuses
- Operator → UniSMS pipeline: starts
Working_UniSMS API/run_pipeline.py - UniSMS pipeline → Spreadsheet data tools: loads profiles
Working_UniSMS API/run_pipeline.py - UniSMS pipeline → SMS gateway: sends SMS
Working_UniSMS API/run_pipeline.py - SMS provider webhook → Webhook status writer: posts status
Testing/PhilSMS/sms_status_writer.py - Webhook status writer → Status workbook: writes statuses
Testing/PhilSMS/sms_status_writer.py