Перейти к содержанию
НОВОЕМаркетплейс и ваша команда: продавайте то, что создали, и получайте планы и изменения, проверенные до того, как вы их увидите. Что нового

Библиотека / Отчёты, аналитика и дашборды

Отчёты, аналитика и дашборды

Записывает полевые SMS-отчёты муниципалитетов в Data Tables с помощью OpenAI

Принимает полевые отчёты в формате SMS через webhook, с помощью OpenAI извлекает данные о деятельности и инцидентах и сохраняет их в Data Table для учёта муниципалитетов.

Что делает

# 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

Шаги

  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

Всего шагов: 77.

Похожие автоматизации