Escalate unresolved maintenance requests with GPT-4o, Google Sheets and Slack — n8n Workflow

High complexity🔗 Webhook17 nodes🏷️ Project Management👁 5 viewsby Hyrum Hurst

Overview

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

Nodes used

Send EmailGoogle SheetsSlackOpenAI

Workflow Preview

⚡
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

How it Works

  1. 1

    Trigger

    The workflow starts with a webhook trigger.

  2. 2

    Process

    Data flows through 17 nodes, connecting aggregate, emailsend, googlesheets.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (17)

SE

Send Email

emailSend

#1
GO

Google Sheets

googleSheets

#2
SL

Slack

slack

#3
OP

OpenAI

n8n-nodes-langchain.openAi

#4

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded escalate-unresolved-maintenance-requests-with-gpt-4o-google-sheets-and-slack file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Escalate unresolved maintenance requests with GPT-4o, Google Sheets and Slack", "nodes": [...], ...}

Integrations

aggregateemailsendgooglesheetsopenaischeduletriggersetslackswitchwaitwebhook

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes17
Complexityhigh
Triggerwebhook
Views5
CategoryProject Management

Created by

Hyrum Hurst

Hyrum Hurst

@hyrum-hurst

Tags

aggregateemailsendgooglesheetsopenaischeduletriggersetslackswitchwaitwebhook
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →