Medical alert triage workflow that receives webhook submissions, validates required fields, classifies alerts by urgency and species, routes critical standard alerts to Slack and Google Sheets, sends critical exotic alerts to Slack, Gmail (exotic specialist), and Sheets, logs routine standard alerts to Sheets, routes routine exotic alerts to Gmail and Sheets, logs incomplete submissions to Sheets with a founder Gmail alert, and catches API failures with a founder pipeline failure Gmail alert.
n8n · workflow canvasproduction build
Context
A veterinary medical alert system needed to distinguish between standard and exotic animals, escalate critical cases immediately via Slack, route exotic specialist alerts via Gmail, and ensure founders are notified when submissions are incomplete or when pipeline failures occur.
Approach
Built a two-part n8n workflow system with a webhook medical alert submission trigger and a separate API failure error trigger. The main flow normalizes and classifies the alert, validates required fields, and branches on urgency and species combinations: critical standard goes to Slack and Sheets, critical exotic goes to Slack, Gmail, and Sheets, routine standard logs to Sheets, routine exotic goes to Gmail and Sheets, and incomplete submissions log to Sheets with a founder Gmail alert.
Architecture
Workflow 1
Medical Alert Submission (Webhook)
Set: Normalize & Classify Alert
If: Required Fields Present?
No: Google Sheets: Log Incomplete Alert to Error + Gmail: Founder - Incomplete Alert
Yes
Switch: Route by Urgency x Species
critical_standard: Slack: Critical Emergency Alert + Google Sheets: Log Critical Standard Alert
