Automated Approval Workflow System That Replaced Weeks-Long Paper Chains for a Public Utility

A municipal water utility with 85 employees was managing over 500 approval requests per month across procurement, maintenance, and policy change processes using paper forms, physical routing, and manual signature collection. Approvals that should have taken hours were taking weeks, and the utility had no reliable way to track where a request stood in the chain or whether it had been acted upon at all.

The utility needed a digital approval workflow system that could automate multi-step approval chains, enforce role-based routing, maintain a complete audit trail, and give managers the ability to review and approve requests from anywhere.

Client: A municipal water utility

Employee Size: 85 employees

Industry: Government & Public Sector

Services: - Custom Software Development - AI Automation & Workflow Design - Workflow System Development - Cloud Infrastructure

The utility's approval processes had been paper-based since its founding and had grown increasingly complex over the decades. A typical procurement request required signatures from the requesting department head, the operations manager, the finance director, and in cases exceeding $5,000, the utility's general manager. Each signature required physical routing of a paper form, often carried by hand between offices or placed in interdepartmental mail trays.

The paper-based system created chronic delays. Forms sat in inboxes for days when approvers were in the field, on leave, or simply unaware that a request was waiting. There was no visibility into where a form was in the chain. Requestors frequently resorted to walking the hallways to track down their paperwork, and follow-up calls to administrative assistants became a routine part of getting anything approved.

Lost forms were a regular occurrence. The utility estimated that approximately 8% of submitted forms were lost at some point in the process and had to be resubmitted. In several cases, procurement requests were lost entirely and only rediscovered weeks later when the requesting department escalated the issue. This resulted in delayed equipment purchases, missed maintenance windows, and in one instance, a regulatory citation for failing to complete a required infrastructure repair on time.

The lack of an audit trail created additional problems. When questions arose about past approvals, such as who authorized a specific purchase or when a policy exception was granted, there was no reliable way to retrieve the information. Paper files were stored in cabinets organized by year, but misfiling was common and retrieval could take hours.

Maintenance approvals were particularly problematic. Field managers needed to request approval for non-routine repairs while on-site at treatment facilities or pump stations. Under the paper system, this required returning to the main office, filling out a form, and waiting for it to route through the chain. Emergency repairs were sometimes completed without approval and reconciled after the fact, creating compliance and accountability gaps.

The utility needed a solution that would: - Digitize all approval request types - Automate multi-step routing based on request type and dollar thresholds - Enable mobile approvals for managers in the field - Provide real-time tracking of request status - Maintain a searchable, permanent audit trail

JSG designed and deployed a fully digital approval workflow system that replaced the utility's paper-based processes with structured, automated, and auditable digital workflows accessible from any device.

Key Components

Multi-Step Approval Orchestration N8N was used to build and orchestrate approval workflows for each request type: procurement, maintenance, policy change, and personnel actions. Each workflow defined the required approval chain based on request category, dollar amount, and department. The system automatically routed requests to the next approver upon each approval, with conditional branching for threshold-based escalations and exception handling.

Digital Request Submission & Document Attachment A web-based submission form replaced paper forms, capturing all required fields and supporting document attachments such as vendor quotes, maintenance reports, and policy drafts. Form validation ensured that requests were complete before submission, eliminating the incomplete forms that had previously caused delays and rejection loops.

Mobile Approvals for Field Managers Power Apps provided managers with a mobile interface for reviewing and approving requests from the field. Managers received push notifications when a request required their action, could review the full request and attached documents on their device, and could approve, reject, or return for revision with a single tap. This eliminated the requirement to be physically present at the main office to participate in the approval chain.

AI-Powered Priority Classification Azure OpenAI analyzed incoming requests to classify urgency and flag high-priority items. Emergency maintenance requests, safety-related procurements, and regulatory-deadline items were automatically elevated in the queue and marked with priority indicators. This ensured that time-sensitive requests were not buried behind routine approvals.

Real-Time Status Tracking & SLA Monitoring Every request was trackable in real time through a status dashboard. Requestors could see exactly where their submission stood in the chain, which approver currently held it, and how long it had been at each stage. SLA timers triggered automated reminders when a request sat with an approver for more than 24 hours, and escalation workflows activated at the 48-hour mark.

Searchable Audit Trail & Reporting Every action within the system, including submissions, approvals, rejections, comments, and modifications, was logged with timestamps and user attribution. The complete history of any request was retrievable in seconds through a search interface. Monthly reports summarized approval volumes, average cycle times, bottleneck identification, and SLA compliance by department.

## Quantifiable Impact

• Average approval cycle time reduced from 18 business days to 1.8 business days
• 100% of paper forms eliminated across all approval types
• Zero lost requests since system launch (previously ~40 lost forms per month)
• 500+ approval requests processed per month with full audit trail
• 94% of approvals completed within 24-hour SLA (up from an unmeasurable baseline)
• 35% reduction in emergency procurement spending due to fewer missed maintenance windows
• Audit trail retrieval time reduced from hours to under 30 seconds

• Frontend: Next.js
• Backend: .NET API
• Platform: TMX (request management, workflow data layer, audit logging)
• Cloud: Microsoft Azure
• Database: Azure SQL
• AI & Automation: Azure OpenAI (priority classification, urgency detection)
• Workflow Orchestration: N8N (multi-step approval chains, conditional routing, escalation triggers, SLA monitoring)
• Mobile: Power Apps (field manager approval interface, push notifications)
• Communication: Twilio (SMS approval alerts), SendGrid (email notifications and reminders)
• Reporting: Power BI (approval cycle analytics, bottleneck identification, SLA compliance dashboards)