Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

Bibliothek / Berichte, Analysen & Dashboards

Berichte, Analysen & Dashboards

Kommunale SMS-Feldberichte mit OpenAI in Data Tables erfassen

Empfängt SMS-artige Feldberichte über einen Webhook, nutzt OpenAI, um Aktivitäts- und Vorfalldetails zu extrahieren, und speichert sie zur kommunalen Nachverfolgung in einer Data Table.

Was sie bewirkt

# 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

Die Schritte

  1. Webhook — Receive SMS
  2. Verify Gateway
  3. Normalize Envelope
  4. Validate Envelope
  5. Find Existing Message
  6. Check Duplicate
  7. Duplicate SMS — Placeholder
  8. Register Inbound Message
  9. Acknowledge Gateway
  10. Find Agent
  11. Check Agent Access
  12. Validate Interpretation
  13. Check Interpretation and Scope
  14. Route Intent

Insgesamt 77 Schritte.

Ähnliche Automatisierungen