Skip to content
FlowHub
FluxonLab
Google Sheets
Messaging & Notificationsfree

Lead Routing Engine with Sla Auto Reassignment

by Muh Resky AdiansyahUpdated Aug 2026
RequiresGoogle SheetsGoogle SheetsSlack
Share Post Share
Fo1) Form Trigger (New Lead)1) Form Trigger…Co2) Prep Lead3) Get Sales List (active=ON)3) Get Sales Li…Co4) Build Sales List4) Build Sales …5) Get routing_state (last_index)5) Get routing_…Co6) Initial Assign (Round Robin)6) Initial Assi…7) Update routing_state7) Update routi…8) Upsert Lead (leads sheet)8) Upsert Lead …ScSLA Trigger (every 1 hour)SLA Trigger (ev…SLA) Get Sales ListSLA) Get Sales …CoSLA) Build Sales ListSLA) Build Sale…SLA) Get Leads (stage=NEW)SLA) Get Leads …IfSLA) If last route >= 1 hourSLA) If last ro…CoSLA) Re-route to next salesSLA) Re-route t…SLA) Update lead (after reroute)SLA) Update lea…WeSTAGE) Webhook (/demo-stage-update)STAGE) Webhook …STAGE) Update lead stage to CONTACTEDSTAGE) Update l…SLA) Slack Notify (reroute) & ButtonSLA) Slack Noti…9) Slack Notify (New Lead) & Button9) Slack Notify…STAGE) Lookup lead by lead_idSTAGE) Lookup l…CoSTAGE) Prep PayloadSTAGE) Prep Pay…IfSTAGE) If authorizedSTAGE) If autho…HRSTAGE) Slack Feedback - Not allowedSTAGE) Slack Fe…CoSTAGE) Authorize click (must be assigned sales)STAGE) Authoriz…🚨 SLACK ESCALATION🚨 SLACK ESCALA…SeSet Manager idIfIF route_count >= 10IF route_count …ESC) Get escalation flagESC) Get escala…ESC) Set escalation flagESC) Set escala…CoESC) Normalize flag resultESC) Normalize …IfESC) If not escalated yetESC) If not esc…12345678
1/5
FLOWS
STEPS · 8
Starts on an incoming request

On a form submission, routes leads into Google Sheets and notifies Slack, with scheduled SLA checks that auto-reassign overdue leads.

Tags

webhookadvancedGoogle SheetsSlackLead Nurturingdiscoveredpending-review
Connects
sheetsGoogle SheetsSlack
CategoryMessaging & Notifications
Triggerwebhook
Complexityadvanced
Nodes31
AddedJun 27, 2026