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
- 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
Toplam 77 adım.
Benzer otomasyonlar
Veri Senkronizasyonu ve ETLSync Mastodon bookmarks to Wallabag with Data Tables and duplicate checks15 adımİçerik Yazımı ve ÜretimiPost weekly research briefs to Slack with EmpirioLabs AI and data tables14 adımE-posta OtomasyonuMonitor autism and urban mobility literature with OpenAlex and Data Tables15 adımWeb Kazıma ve AraştırmaApify ve Data Tables ile Greenhouse iş ilanı panosu değişikliklerini takip et8 adım