Hyrum Hurst This workflow corresponds to n8n.io template #12687 — we link there as the canonical source.
This workflow follows the Emailsend → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "rtrmjYTV4NV5gIzt",
"name": "Property Maintenance Request Tracking and Escalation System",
"tags": [],
"nodes": [
{
"id": "2c84f6a8-75e3-4d55-b519-6495956a102e",
"name": "Maintenance Request Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
5040,
784
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "25d01b33-d950-4535-829f-a087ba380f5e",
"name": "Workflow Configuration",
"type": "n8n-nodes-base.set",
"position": [
5264,
784
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "700c99d6-8828-4ceb-8643-ff8147c72438",
"name": "Normalize Request Fields",
"type": "n8n-nodes-base.set",
"position": [
5488,
784
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "67650de5-f39f-4d79-b7b2-d01867726199",
"name": "Classify Urgency with AI",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
5760,
800
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3f032976-fb18-4ea1-af59-1a9575cac950",
"name": "Log Request to Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
6064,
784
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "031c1e22-a13e-486c-b0fb-b26281d2afa2",
"name": "Wait for SLA Window",
"type": "n8n-nodes-base.wait",
"position": [
6288,
784
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "69ffa4f9-0857-4c85-8e57-fdc5a3dd63f9",
"name": "Check Request Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
6512,
784
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "31aec070-cd15-44f2-a2e0-8bf8649d82c4",
"name": "Check if Resolved",
"type": "n8n-nodes-base.switch",
"position": [
6736,
784
],
"parameters": {},
"typeVersion": 3.3
},
{
"id": "8e046dd9-dcea-4b00-a6b6-190c37114333",
"name": "Route by Urgency",
"type": "n8n-nodes-base.switch",
"position": [
6960,
768
],
"parameters": {},
"typeVersion": 3.3
},
{
"id": "e0f27b19-f02a-4e0f-971f-eb0dad139fb1",
"name": "Send Slack Alert (High)",
"type": "n8n-nodes-base.slack",
"position": [
7184,
976
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "d17de422-90df-425b-99f0-331d427283de",
"name": "Email Manager (High)",
"type": "n8n-nodes-base.emailSend",
"position": [
7408,
976
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "b6ecc26f-2bdf-4ea0-9392-49d04dbb1f1a",
"name": "Send Slack Alert (Medium)",
"type": "n8n-nodes-base.slack",
"position": [
7184,
592
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "d2c40f69-b8a7-438b-b1a4-7b2390fd40b0",
"name": "Log Low Priority (No Alert)",
"type": "n8n-nodes-base.set",
"position": [
7184,
784
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "35a1be34-000c-4358-811d-e3ed0f32ae21",
"name": "Daily Summary Schedule",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
5040,
1200
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "38ab9c82-a235-43e3-9542-629a28c19cd3",
"name": "Get Unresolved Requests",
"type": "n8n-nodes-base.googleSheets",
"position": [
5264,
1200
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "08664562-123f-482f-a2c0-622a12ad1261",
"name": "Aggregate Unresolved Requests",
"type": "n8n-nodes-base.aggregate",
"position": [
5488,
1200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e01dd018-0c83-48dd-800f-ebe23f9632af",
"name": "Send Daily Summary Email",
"type": "n8n-nodes-base.emailSend",
"position": [
5712,
1200
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "11244459-198d-4acd-81d6-c3923b5e00c1",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
4320,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d838bc88-e49b-440e-a338-76d7f2d0f749",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
4992,
592
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "716d5462-9215-4816-8ee7-2b8e03dcb6b0",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
5728,
576
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b9e4c1de-7d29-4335-8dea-88104b44d3be",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
7104,
464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f4c2a758-838a-4834-92c1-b146013d36d2",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
5008,
1136
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "3f0102c8-d96d-485b-9f37-c6a48f709997",
"connections": {
"Route by Urgency": {
"main": [
[
{
"node": "Send Slack Alert (High)",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Slack Alert (Medium)",
"type": "main",
"index": 0
}
],
[
{
"node": "Log Low Priority (No Alert)",
"type": "main",
"index": 0
}
]
]
},
"Check if Resolved": {
"main": [
[
{
"node": "Route by Urgency",
"type": "main",
"index": 0
}
]
]
},
"Wait for SLA Window": {
"main": [
[
{
"node": "Check Request Status",
"type": "main",
"index": 0
}
]
]
},
"Check Request Status": {
"main": [
[
{
"node": "Check if Resolved",
"type": "main",
"index": 0
}
]
]
},
"Log Request to Sheets": {
"main": [
[
{
"node": "Wait for SLA Window",
"type": "main",
"index": 0
}
]
]
},
"Daily Summary Schedule": {
"main": [
[
{
"node": "Get Unresolved Requests",
"type": "main",
"index": 0
}
]
]
},
"Workflow Configuration": {
"main": [
[
{
"node": "Normalize Request Fields",
"type": "main",
"index": 0
}
]
]
},
"Get Unresolved Requests": {
"main": [
[
{
"node": "Aggregate Unresolved Requests",
"type": "main",
"index": 0
}
]
]
},
"Send Slack Alert (High)": {
"main": [
[
{
"node": "Email Manager (High)",
"type": "main",
"index": 0
}
]
]
},
"Classify Urgency with AI": {
"main": [
[
{
"node": "Log Request to Sheets",
"type": "main",
"index": 0
}
]
]
},
"Normalize Request Fields": {
"main": [
[
{
"node": "Classify Urgency with AI",
"type": "main",
"index": 0
}
]
]
},
"Maintenance Request Webhook": {
"main": [
[
{
"node": "Workflow Configuration",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Unresolved Requests": {
"main": [
[
{
"node": "Send Daily Summary Email",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Property managers and operations teams who want better visibility into unresolved maintenance requests.
Source: https://n8n.io/workflows/12687/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Consulting firms in strategy, management, or IT who want to automate client onboarding and internal task assignment.
OpenAI, Google Sheets, Slack +3
Property management teams handling leases, IDs, and compliance documents.
Google Drive, OpenAI, Google Sheets +2
Watch on Youtube▶️
HTTP Request, Email Send, Google Sheets +3
Automatically detects missed Zoom demos booked via Calendly and triggers AI-powered follow-up sequences.
HTTP Request, OpenAI, Email Send +3
Pyragogy AI Village - Orchestrazione Master (Architettura Profonda V2). Uses start, postgres, openAi, emailSend. Webhook trigger; 35 nodes.
Start, Postgres, OpenAI +3