Skip to content
FlowHubFluxonLab
Google Sheets
Monitoring & Incident Responsefree

Dynamic traffic alarm via Google Maps and Twilio

by Yorgo HaberUpdated Aug 2026
RequiresGoogle SheetsGoogle SheetsTwilioTwilio
Share Post Share
IfCheck if date is todayCheck if date i…Get date & status of alarmGet date & stat…Update alarm date & statusUpdate alarm da…HRGet Latitude/Longitude of Origin AddressGet Latitude/Lo…HRGet Latitude/Longitude of End AddressGet Latitude/Lo…MeMerge all trajectoriesMerge all traje…IfTotal duration < 9:00 AM?Total duration …HRGet real duration between the two addressesGet real durati…Check date & status of alarmCheck date & st…IfCheck if status is equal to 'ini'Check if status…Update alarm statusUpdate alarm st…Send an SMS/MMS/WhatsApp messageSend an SMS/MMS…SeDefine Origin and Destination addressesDefine Origin a…SeGet today's dateScTriggers at 7 AM till 8 AM every minute on weekdaysTriggers at 7 A…12345678910111213141516
1/5
STEPS · 16
Runs on a schedule

On a schedule, reads routes from Google Sheets, checks Google Maps travel times via HTTP, and sends Twilio SMS traffic alerts.

Tags

croncomplexGoogle SheetsTwilioPersonal Productivitydiscoveredpending-review
Connects
sheetsGoogle SheetstwilioTwilio
CategoryMonitoring & Incident Response
Triggercron
Complexitycomplex
Nodes15
AddedJun 27, 2026