Escalate unresolved maintenance requests with GPT-4o, Google Sheets and Slack — n8n 工作流
概览
Who’s it for Property managers and operations teams who want better visibility into unresolved maintenance requests.
What this workflow does This workflow logs incoming maintenance requests, classifies urgency using AI, and tracks whether issues are resolved within a defined SLA. If requests remain unresolved, it escalates them automatically based on priority and sends daily summary reports.
How it works Maintenance requests are received via a form or webhook and logged in Google Sheets. After
使用的节点
Send EmailGoogle SheetsSlackOpenAI
工作流预览
⚡
M
Maintenance Request Webh…
W
Workflow Configuration
N
Normalize Request Fields
Classify Urgency with AI
Log Request to Sheets
W
Wait for SLA Window
Check Request Status
C
Check if Resolved
R
Route by Urgency
Send Slack Alert (High)
Email Manager (High)
Send Slack Alert (Medium)
L
Log Low Priority (No Ale…
⚡
D
Daily Summary Schedule
Get Unresolved Requests
A
Aggregate Unresolved Req…
Send Daily Summary Email
17 nodes15 edges
工作原理
- 1
触发器
工作流由 webhook 触发器启动。
- 2
处理
数据流经 17 个节点, connecting aggregate, emailsend, googlesheets。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (17)
SE#1
Send Email
emailSend
GO#2
Google Sheets
googleSheets
SL#3
Slack
slack
OP#4
OpenAI
n8n-nodes-langchain.openAi
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
escalate-unresolved-maintenance-requests-with-gpt-4o-google-sheets-and-slack文件并点击导入。 - 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
- 5点击 测试工作流 验证一切正常，然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴：
{ "name": "Escalate unresolved maintenance requests with GPT-4o, Google Sheets and Slack", "nodes": [...], ...}
集成
aggregateemailsendgooglesheetsopenaischeduletriggersetslackswitchwaitwebhook
创建者
Hyrum Hurst
@hyrum-hurst
标签
aggregateemailsendgooglesheetsopenaischeduletriggersetslackswitchwaitwebhook