Route and reassign leads with SLA using Google Sheets and Slack
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 31 nodes and runs when someone submits an n8n form (“Lead Intake (Generic Form Trigger)”) (plus 2 other triggers). Along the way it connects Google Sheets and Slack.
How it runs
Trigger: When someone submits an n8n form (“Lead Intake (Generic Form Trigger)”) (plus 2 other triggers).
- 2) Prep Lead (Code): runs custom JavaScript code
- SLA) Get Sales List (Google Sheets): uses Google Sheets
- STAGE) Prep Payload (Code): runs custom JavaScript code
- 3) Get Sales List (active=ON) (Google Sheets): uses Google Sheets
- SLA) Build Sales List (Code): runs custom JavaScript code
- STAGE) Lookup lead by lead_id (Google Sheets): uses Google Sheets
- 4) Build Sales List (Code): runs custom JavaScript code
- SLA) Get Leads (stage=NEW) (Google Sheets): uses Google Sheets
- STAGE) Authorize click (must be assigned sales) (Code): runs custom JavaScript code
- 5) Get routing_state (last_index) (Google Sheets): uses Google Sheets
…plus 18 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 (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Webhook
n8n-nodes-base.webhook - Slack
n8n-nodes-base.slack - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set
From the author
Lead-Routing-Engine-with-SLA-Auto-Reassignment This repository contains an SLA-based lead routing workflow built in n8n, designed to ensure fast lead response, fair sales distribution, and controlled escalation without relying on a full CRM system. The…