İçeriğe geç
YENİPazar yeri ve ekibin: geliştirdiğini sat; planlar ve değişiklikler sen görmeden önce test edilsin. Yeniliklere bak

Kütüphane / Raporlar, Analitik ve Panolar

Raporlar, Analitik ve Panolar

Belediye SMS saha raporlarını OpenAI ile Data Tables'a kaydet

Webhook üzerinden SMS formatındaki saha raporlarını alır, OpenAI ile faaliyet ve olay ayrıntılarını çıkarır ve belediye takibi için bir Data Table'a kaydeder.

Ne yapar

# 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

Adımlar

  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

Toplam 77 adım.

Benzer otomasyonlar