Problem
City service request routing is manual. Residents call different department numbers, staff route requests by hand, and there is no central log. Small cities and municipal agencies lack the budget for enterprise solutions but still need to handle hundreds of requests efficiently.
Solution
A webhook-triggered n8n workflow that handles resident service requests for a city government. Claude AI classifies each request by department (Public Works, Parks, Housing, Transportation) and urgency level. The workflow routes requests to the correct department, sends an auto-acknowledgment to the resident, and logs everything to Google Sheets.
Results
- Resident request to department routing in seconds
- Auto-acknowledgment sent to resident on every submission
- Google Sheets audit log for all requests
Webhook receives resident submission (request type, description, contact info). Claude AI classifies by department (Public Works, Parks, Housing, Transportation, Emergency) and urgency (immediate/standard/low). n8n routes notification to department-specific channel. Auto-acknowledgment fires to resident. Google Sheets logs full request record. Test scenarios passed: pothole report, park maintenance request, housing complaint.
Tech Stack
- n8n
- Claude AI
- Webhook
- Google Sheets API
- Email Notifications