Library / Reports, Analytics & Dashboards
Reports, Analytics & Dashboards
Log municipal SMS field reports to Data Tables with OpenAI
Receives SMS-style field reports through a webhook, uses OpenAI to extract activity and incident details, and stores them in a Data Table for municipal tracking.
What it does
# SMS Territorial Operations Hub A demonstration workflow designed for local governments and municipal departments to collect field reports, track public service activities, and record incidents through SMS-style messages. Inspired by the operational challenges faced by local administrations in rural Africa, the workflow can be adapted to similar reporting needs in municipalities and communities worldwide. In many local government settings, field officers work across different areas, often with limited internet access. Reporting progress on road maintenance, water supply, sanitation, or urgent incidents can be difficult when information is scattered across phone calls and paper records. This workflow offers a simple way for authorized field officers to report activities, flag incidents, and consult their own recent records. Local government teams can use the recorded information to support follow-up and coordination across departments. The system is a demonstration prototype. It does not provide a municipality-wide dashboard, automatically notify departments, or send real SMS messages. ## How it works 1. An agent submits an SMS-style message through a webhook. 2. n8n checks the message and identifies the reporting agent. 3. The workflow interprets the request and retrieves or records the relevant information. 4. A simulated SMS response is prepared. Four commands are supported: - UPDATE — Record progress on an activity. - ALERT — Report an incident. - STATUS — Consult recent records. - BRIEF — Obtain a short activity summary. OpenAI is used only where message interpretation is necessary. Record retrieval and operational rules use deterministic processing. ## Requirements - An n8n instance with Data Tables. - An OpenAI credential. - The Main and Send SMS workflows. - Five Data Tables: AGENTS, UPDATES, INCIDENTS, ROUTING_RULES and MESSAGES. The companion SETUP.md contains the required table structure and demonstration data. ## Before testing - [ ] Create the five Data Tables. - [ ] Connect all Data Table nodes. - [ ] Connect the four Send SMS calls to the companion workflow. - [ ] Configure the OpenAI credential. - [ ] Add the fictional test agent and routing rule. - [ ] Keep both workflows inactive. ## Local test Open Webhook — Receive SMS and select Listen for Test Event. Replace the placeholder below with the webhook's Test URL: bash curl -X POST "PASTE_TES
The steps
- Webhook — Receive SMS
- Verify Gateway
- Normalize Envelope
- Validate Envelope
- Find Existing Message
- Check Duplicate
- Duplicate SMS — Placeholder
- Register Inbound Message
- Acknowledge Gateway
- Find Agent
- Check Agent Access
- Validate Interpretation
- Check Interpretation and Scope
- Route Intent
77 steps in total.
Similar automations
Content Writing & GenerationPost weekly research briefs to Slack with EmpirioLabs AI and data tables14 stepsForms & SurveysCheck and fix Japanese PR TIMES press releases with rule tables and OpenAI14 stepsData Sync & ETLSync Mastodon bookmarks to Wallabag with Data Tables and duplicate checks15 stepsEmail AutomationMonitor autism and urban mobility literature with OpenAlex and Data Tables15 steps