Route critical lab results using Google Sheets, Slack, Gmail, Gemini, and Twilio

by Ciphernutz IT Services ✓ · 1 views · created 2026-10-02 · Ticket Management, AI Summarization

What this workflow does

This AI workflow has 21 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets, Slack, Gmail and Google Gemini and 1 more. It also calls lis.example over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

1. Read limits (Google Sheets): uses Google Sheets
2. Fetch LIS results (HTTP Request): calls lis.example
3. Read doctors (Google Sheets): uses Google Sheets
4. Read log (Google Sheets): uses Google Sheets
5. Prepare result (Code): runs custom JavaScript code
6. Route (Switch): routes items into 5 branches
7. Write doctor note (Google Gemini): uses Google Gemini
8. Notify the lab (Slack): uses Slack
9. Save to log (Google Sheets): append
10. Apply doctor note (Code): runs custom JavaScript code

…plus 9 more steps. See the full node list below.

Services it uses

Google SheetsSlackGmailGoogle GeminiTwilio

HTTP calls to: lis.example

Before you upgrade to n8n 3.0

Nodes used (12)

• Webhookn8n-nodes-base.webhook
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Switchn8n-nodes-base.switch
• Ifn8n-nodes-base.if
• Slackn8n-nodes-base.slack
• Waitn8n-nodes-base.wait
• Gmailn8n-nodes-base.gmail
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Twilion8n-nodes-base.twilio
• Schedule Triggern8n-nodes-base.scheduleTrigger
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview A lab result routing workflow that notifies the ordering physician by severity, using thresholds you control. Critical results trigger an immediate Slack and SMS alert with acknowledgment tracking and automatic escalation to a backup physician…

View the original on n8n.io → Check your own copy