An automated facility management skill that routes maintenance tickets from communication logs into Excel, tracks SLA thresholds, and automates team notifications.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install workorder-dispatch
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install workorder-dispatch using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Work Order Dispatch & SLA Monitoring?
The Work Order Dispatch and SLA Monitoring skill is an enterprise-grade automation system built to manage the end-to-end lifecycle of facility maintenance requests. Configured to run on top of real-world Excel sheets, this system completely removes manual dispatch bottlenecks and automates ticket logging. By leveraging Openclaw Skills, engineering and property management teams can instantly deploy automatic work order generation, precise technician routing, and real-time status tracking without complex, expensive enterprise software installations.
The skill operates by directly mapping incoming maintenance inputs from corporate communication logs (like WeCom, email, or telephone registries) into structured spreadsheet data. It parses issue descriptions, intelligently matches the problem with specialized technicians, schedules cron-based background checks to monitor SLA compliance, and escalates delayed tickets automatically to ensure zero missed handoffs.
Work Order Dispatch & SLA Monitoring Use Cases
- Automatically ingesting and logging repair tickets directly from WeCom mentions, emails, or call registers.
- Intelligently parsing task descriptions to route specialized issues (like electrical faults or pipe leaks) to the correct technicians.
- Scheduling automated hourly audits of open tickets to identify overdue actions before they breach operational guidelines.
- Constructing direct escalation pathways to alert supervisors via enterprise WeChat notifications when SLAs are breached.
- Syncing all maintenance workflows with a centralized offline Excel ledger that operates as a lightweight, low-maintenance CMMS database.
How Work Order Dispatch & SLA Monitoring Works
- Ingestion & Classification: The agent parses inbound messages containing repair details, determining key metrics such as location, issue category, and urgency level.
- Specialized Technician Assignment: The agent evaluates descriptive keywords (e.g., 'electrical failure' or 'water leak') against pre-mapped employee skills (e.g., electrician or plumber) to identify the best assignee.
- Excel Registry Logging: The new ticket is appended directly to the designated Excel sheet with active pending flags and timestamps.
- Instant Notification Push: A beautifully formatted dispatch card is pushed to the assigned technician via WeCom integration.
- Automated SLA Scanning: A background cron job runs hourly to cross-reference open issues against defined SLA limits (1 hour for urgent tasks, 24 hours for normal requests).
- Supervisor Escalation: If a critical SLA threshold is crossed, the agent triggers an immediate alert using WeCom mentioning the maintenance supervisor.
- Completion Confirmation: When the technician completes the task, the agent updates the sheet with the resolution notes, actual repair costs, and total resolution days before sending out a completion notice.
Work Order Dispatch & SLA Monitoring Setup
Installation
Configure your skill workspace by executing the following terminal commands:
# Create the workspace directory for the dispatcher
mkdir -p ~/.openclaw/skills/workorder-dispatch
Configuration
Map your physical Excel file paths, SLA hours, enterprise messaging webhooks, and team specialties inside your active configuration file:
{
"workorder_dispatch": {
"excel_path": "/Users/mac/美兰中心C+服务.xlsx",
"sla_urgent_hours": 1,
"sla_normal_hours": 24,
"wecom_webhook": "https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=your_wecom_key",
"maintenance_staff": {
"电工": ["蔡其恩"],
"水工": ["杨杉"],
"万能工": ["蔡其恩", "杨杉"]
}
}
}
Scheduled Cron Configuration
Enable background SLA checking by configuring the automated cron schedule with Openclaw Skills:
{
"name": "Workorder SLA Monitoring",
"schedule": {
"kind": "cron",
"expr": "0 * * * *",
"tz": "Asia/Shanghai"
},
"payload": {
"kind": "agentTurn",
"message": "Evaluate SLA statuses of all open work orders and escalate breached tickets immediately."
},
"sessionTarget": "isolated"
}
Work Order Dispatch & SLA Monitoring Data Schema & Taxonomy
The skill manages all records within a Microsoft Excel tracking workbook. All data operations are performed on the worksheet named 🛠️报修情况汇总🛠️ (Repair Summary) using the following structured schema:
| Excel Column | Field Name (Chinese) | Description | Data Type | Example Value |
|---|---|---|---|---|
| 1 | 楼层/单元 | Floor/Unit Location | TEXT | T1-1009 / T1-9F Female Washroom |
| 2 | 紧急程度 | Urgency Classification | TEXT | 紧急！急需处理！(Urgent!) |
| 3 | 报修细节描述 | Problem Description | TEXT | Unit power trip, main valve cannot be reset |
| 4 | 报修相关现场照片【越好】 | Photo Attachments | TEXT | URL String (Optional) |
| 5 | 报修人员 | Reporter's Name | TEXT | Mr. Fang / Liu Rui |
| 6 | 报修时间 | Creation Date | DATE/TEXT | 2026-05-06 |
| 7 | 维修人员 | Assigned Technician | TEXT | Cai Qien / Yang Shan |
| 8 | 维修跟进状态 | Ticket Status | TEXT | 待处理 (Pending) / 已完成 (Completed) |
| 9 | 跟进状态及结果描述 | Progress & Resolution logs | TEXT | Dispatched, waiting on parts |
| 10 | 维修费用 | Repair Outlay/Cost | NUMERIC | 0 |
| 11 | 维修完成时间 | Ticket Closing Date | DATE/TEXT | 2026-05-06 |
| 12 | 维修用时天数 | Resolution Duration (Days) | NUMERIC | 0 |
| 13 | 月份 | Month Reference | DATE/TEXT | 2026-04-24 |
Work Order Dispatch & SLA Monitoring Advanced Features
- Intelligent Content Routing: Categorizes complex, unstructured descriptions to automatically map issues to specialized electricians or plumbers without manual triage.
- Multi-tiered SLA Escalations: Leverages distinct SLA rules (1h emergency response with
@allmentions, 24h standard warning, 3-day silent logging). - WeCom Webhook Alerts: Connects directly with WeCom to deliver formatted markdown alerts, including active @mentions to mobilize teams for critical emergencies.
- Isolated Cron Automation: Employs isolated task loops within Openclaw Skills to run scheduled checks without blocking active frontend processes.
- Dynamic Progress Log Appendings: Updates cell values continuously by prefixing status updates and timestamps onto existing ticket notes.
- Rating & Performance Audits: Extensible schema designed to support technician rating logs, customer feedback scores, and performance analytics.
SKILL.md
Loading
Related Openclaw Skills
Fee Collection Management Skill
An AI-powered property fee dunning and collection automation skill based on standard enterprise management procedures.
Customer Management Center
An intelligent enterprise-grade customer relationship skill that converts complex offline Excel ledgers into rich database profiles and proactive risk alerts.
Know Your Rights and Claim Them
An actionable digital companion that helps youth understand, diagnose, and claim their human rights under the UN Convention on the Rights of the Child through legal navigation and activism.
On Becoming a Person
An executable AI toolkit based on Carl Rogers' humanistic psychology framework to build deep, genuine helping relationships and facilitate authentic personal growth.
Inventory Monitor
An automated stock monitoring tool that calculates remaining item lifespan directly from Excel and dispatches custom alerts to your enterprise chat channels.
fu-mu-gong-ke (Parents' Homework) - Parenting Psychology AI Agent Skill
An advanced parenting psychology AI agent skill powered by the HeartFlow cognitive engine to deliver empathetic, structured emotional support and boundary-conscious guidance for families.
Featured*
