Triage construction incidents with GPT-4o, Slack, Gmail and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects OpenAI, Slack, Gmail and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Normalise Payload (Code): runs custom JavaScript code
- Sheets – Fetch Open Incidents (Google Sheets): uses Google Sheets
- Slack: uses Slack
- GPT-4o – Classify Incident (OpenAI): uses OpenAI
- Build Digest Message (Code): runs custom JavaScript code
- Merge Classification (Code): runs custom JavaScript code
- Slack: uses Slack
- Switch: routes items into 3 branches
- Slack: uses Slack
- Gmail: uses Gmail
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Switch
n8n-nodes-base.switch - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick Overview This workflow ingests construction incident webhooks, normalizes the payload, and uses OpenAI GPT-4o-mini to classify each incident by type and urgency, then routes alerts to Slack and Gmail and logs incidents to Google Sheets, with a daily…