Track municipal SMS field reports with OpenAI and Data Tables
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 77 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects OpenAI Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Verify Gateway (If): checks a condition and branches into true / false
- Validate and Format SMS (Edit Fields (Set)): sets 1 field: sms_payload
- Normalize Envelope (Edit Fields (Set)): sets 12 fields: phone_from, phone_to, text…
- Split SMS into Segments (Code): runs custom JavaScript code
- Validate Envelope (If): checks a condition and branches into true / false
- Check Existing Outbound (Data table): get
- Return SMS Preparation Error (Code): runs custom JavaScript code
- Find Existing Message (Data table): get
- Restore SMS Segment Context (Code): runs custom JavaScript code
- Return SMS Dedup Lookup Error (Code): runs custom JavaScript code
…plus 58 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Data table
n8n-nodes-base.dataTable - No Operation, do nothing
n8n-nodes-base.noOp - Respond to Webhook
n8n-nodes-base.respondToWebhook - Switch
n8n-nodes-base.switch - Code
n8n-nodes-base.code - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Merge
n8n-nodes-base.merge - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger
From the author
Quick overview Designed for municipal teams, this demonstration records field updates and incidents from SMS-style messages and lets agents check their recent activity. Inspired by rural African administrations, it can be adapted elsewhere. n8n Data Tables…