{"product_id":"n8n-lab-results-routing-slack-gmail-twilio-alerts","title":"n8n Lab Results Routing: Slack, Gmail, Twilio Alerts","description":"\u003ch3\u003eAutomatically route lab results to the right doctor—by severity—with Slack, Gmail, and Twilio alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives lab results, classifies them using thresholds you control in Google Sheets, and notifies the ordering physician appropriately. Critical values trigger immediate Slack and SMS alerts with acknowledgment tracking and automatic escalation—while abnormal results are emailed and every outcome is logged for audit.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests lab results\u003c\/strong\u003e via an HTTP webhook (or, if you prefer, fetches results from an LIS endpoint on a schedule).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration from Google Sheets\u003c\/strong\u003e: test limits, doctor contact details, and prior notification history from tabs named \u003cem\u003eLimits\u003c\/em\u003e, \u003cem\u003eDoctors\u003c\/em\u003e, and \u003cem\u003eLog\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and normalizes\u003c\/strong\u003e incoming data (JSON or HL7 ORU text), including \u003cstrong\u003eunit normalization with supported conversions\u003c\/strong\u003e, checks for missing fields, and suppresses duplicates using the log.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies results\u003c\/strong\u003e as critical, abnormal, normal, duplicate, or “needs lab review” based on your thresholds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a short, non-diagnostic note\u003c\/strong\u003e using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, restating severity, value, unit, and required action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies by severity\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eCritical\u003c\/strong\u003e: sends a Slack DM (and a \u003cstrong\u003eTwilio SMS\u003c\/strong\u003e when a phone number exists) with an acknowledgment link. It waits \u003cstrong\u003e15 minutes\u003c\/strong\u003e and escalates to a backup Slack contact if not acknowledged.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eAbnormal\u003c\/strong\u003e: emails the ordering doctor via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudits everything\u003c\/strong\u003e: unroutable items, delivery failures, and all statuses\/messages are appended to the \u003cstrong\u003eGoogle Sheets Log\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNotify ordering physicians instantly for \u003cstrong\u003ecritical lab results\u003c\/strong\u003e with acknowledgment and escalation.\u003c\/li\u003e\n  \u003cli\u003eEmail clinicians for \u003cstrong\u003eabnormal results\u003c\/strong\u003e using Gmail while keeping a complete audit trail.\u003c\/li\u003e\n  \u003cli\u003ePrevent repeated alerts by detecting \u003cstrong\u003eduplicate** notifications\u003c\/strong\u003e based on historical logs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n\u003c\/strong\u003e nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, and \u003cstrong\u003eswitch\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Limits\/Doctors\/Log), \u003cstrong\u003eSlack\u003c\/strong\u003e (DM + escalation), \u003cstrong\u003eGmail\u003c\/strong\u003e (abnormal notifications), \u003cstrong\u003eTwilio\u003c\/strong\u003e (SMS for critical alerts), and \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (non-diagnostic note generation).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e Create a Google Sheets document with tabs \u003cem\u003eLimits\u003c\/em\u003e, \u003cem\u003eDoctors\u003c\/em\u003e, and \u003cem\u003eLog\u003c\/em\u003e, then connect Google Sheets in n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46157942653107,"sku":"N8N-20335","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dy_vR4MBVdEQB4uQ5HbMS_6oxpzNXd.png?v=1791019160","url":"https:\/\/buyflowscripts.com\/products\/n8n-lab-results-routing-slack-gmail-twilio-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}