Priority follow-up
Status Breakdown
Safe · Unsafe · Need Assistance · Pending
Status by Campaign
Campaign Breakdown
| Campaign | Site | Sent | Safe | Unsafe | Assist | Pending | Replied |
|---|
Employee Directory
| Emp ID | Name | Mobile | Location | Campaign | Department | Shift | Manager | Type | Last Response | Status |
|---|
Edit the lists used in the employee form. Each manager belongs to a campaign, so the Manager list only shows managers of the chosen campaign. Renaming an entry also updates the employees that use it.
Text Blast · m360 short code 6783
Message Template Library
Broadcast Log
| When | Sender ID | Location | Campaign | Template | Message | Recipients | Sent / Failed | By |
|---|
Users & Roles
| Name | Role | Campaigns | Active |
|---|
Super Admin: everything, and the only role that can create or change Super Admin accounts · HR Admin: directory, users, lists, text blasts, templates · IT Admin: directory, users, lists, event log, settings (no blasting) · Manager: view-only, and only for the campaign(s) assigned to them.
Bulk import roster
Columns recognised: Employee ID, Name, Mobile, Location, Campaign, Department, Shift, Manager, Employment Type. Existing Employee IDs are updated; new ones are added.
The sheet must be shared with the Google account that deployed this script.
Campaign Google Sheets
Google Sheets cannot hide rows from someone who can open the file, so each campaign or department gets its own view-only spreadsheet holding only its employees (phone numbers masked) and their replies. Share it with that team's Google accounts. Your main sheet stays private.
| Name | Type | Viewers (Google accounts) | Last sync |
|---|
m360 Event Log
| Time | Type | Number | Keyword | Result | Raw payload |
|---|
m360 & Integration Settings
Leave a field empty to keep its current value. Stored in Script Properties, never sent back to the browser.
Test an inbound reply (no m360 needed)
Simulates an SMS to 6783 from an employee's number and updates their status. It is recorded as MO_TEST in the Event Log.
MO receiver (m360_mo_receiver)
Set this as the inbound callback URL for short code 6783 in m360 (use the same webhook key you saved above):
Advanced (optional): push a roster from another Google Sheet
Only needed if you keep a master roster in a different Google Sheet. Add this to that sheet's Apps Script and run it. m360 does not use or need this.