Dispatch and track cold-chain incidents with Google Sheets, Twilio, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 68 nodes and runs when an HTTP POST request hits its webhook URL (plus 4 other triggers). Along the way it connects Google Sheets, Gmail and Twilio.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 4 other triggers).
- Set Intake Configuration (Edit Fields (Set)): sets 4 fields: twilio_from, base_url, ops_manager_phone…
- Decode Callback Data (Code): runs custom JavaScript code
- Set Heartbeat Configuration (Edit Fields (Set)): sets 5 fields: twilio_from, base_url, ops_manager_phone…
- Setup Error Configuration (Edit Fields (Set)): sets 2 fields: admin_phone, twilio_from
- Configure Report Settings (Edit Fields (Set)): sets 1 field: report_email
- Normalize Alert Payload (Code): runs custom JavaScript code
- Retrieve Ticket Info (Google Sheets): uses Google Sheets
- Fetch All Ticket Data (Google Sheets): uses Google Sheets
- Create Error Notification Message (Edit Fields (Set)): sets 1 field: msg
- Gather Report Ticket Data (Google Sheets): uses Google Sheets
…plus 53 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 (11)
- Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Twilio
n8n-nodes-base.twilio - Error Trigger
n8n-nodes-base.errorTrigger - Filter
n8n-nodes-base.filter - Webhook
n8n-nodes-base.webhook
From the author
Quick overview Youtube Video: https://youtu.be/s79Y5rty2WM This workflow ingests cold-chain temperature alerts via webhook, looks up client SLA rules in Google Sheets, assigns severity and dispatches an on-call technician via Twilio SMS, then tracks…