WORKFLOW · N8N
B2B Demo Lead Rescue Desk: Enrich, Score, Route, and SLA Escalate
Prompts👁 0
WORKFLOW JSON
{
"meta": {
"templateCredsSetupCompleted": false
},
"name": "B2B Demo Lead Rescue Desk: Enrich, Score, Route, and SLA Escalate",
"nodes": [
{
"id": "note-overview",
"name": "Workflow Overview",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1180,
-520
],
"parameters": {
"color": 7,
"width": 560,
"height": 840,
"content": "## B2B Demo Lead Rescue Desk: Enrich, Score, Route, and SLA Escalate\n\n### How it works\n\nThis workflow receives website demo, quote, and integration leads, normalizes inconsistent form payloads, enriches the submitted page context, scores buyer intent, assigns an SLA and owner, logs the lead to Google Sheets, routes Gmail alerts, and returns a structured webhook response.\n\n### Setup steps\n\n- Configure the Lead Intake Webhook URL in your website form or lead capture tool.\n- Replace placeholder Google Sheets credentials, sheet ID, and recipient Gmail addresses.\n- Test with one hot lead, one review lead, one normal lead, and one missing-contact payload.\n- Confirm SLA buckets, owner team routing, dedupe keys, and escalation terms match your sales process.\n\n### Customization\n\nAdjust scoring keywords, budget/timeline rules, recipient lists, and executive escalation thresholds to match your actual sales handoff."
},
"typeVersion": 1
},
{
"id": "note-intake",
"name": "Receive and validate lead",
"type": "n8n-nodes-base.stickyNote",
"position": [
-620,
-220
],
"parameters": {
"color": 7,
"width": 640,
"height": 360,
"content": "## Receive and validate lead\n\nAccepts the incoming website lead webhook, normalizes common form field variants, scores contact quality, and rejects submissions that do not include a usable reply path."
},
"typeVersion": 1
},
{
"id": "note-score-audit",
"name": "Score and audit lead",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
-260
],
"parameters": {
"color": 7,
"width": 900,
"height": 360,
"content": "## Score and audit lead\n\nFetches submitted-page context, extracts title and meta signals, combines page intent with message, budget, timeline, and integration keywords, builds a dedupe key, and appends a complete audit row to Google Sheets."
},
"typeVersion": 1
},
{
"id": "note-missing-contact",
"name": "Reject missing contact",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
180
],
"parameters": {
"color": 7,
"width": 560,
"height": 300,
"content": "## Reject missing contact\n\nBuilds a clear missing-contact response and returns it through the webhook branch before the workflow spends time on enrichment, Sheets logging, or alerts."
},
"typeVersion": 1
},
{
"id": "note-routing",
"name": "Evaluate routing decisions",
"type": "n8n-nodes-base.stickyNote",
"position": [
1060,
-260
],
"parameters": {
"color": 7,
"width": 360,
"height": 600,
"content": "## Evaluate routing decisions\n\nRoutes hot, review, and normal leads to different alert payloads, then checks whether high-priority leads also need executive escalation."
},
"typeVersion": 1
},
{
"id": "note-alerts",
"name": "Send alerts and response",
"type": "n8n-nodes-base.stickyNote",
"position": [
1340,
-520
],
"parameters": {
"color": 7,
"width": 980,
"height": 860,
"content": "## Send alerts and response\n\nBuilds Gmail-ready messages for hot leads, review-queue leads, normal leads, and executive escalations, then returns a clean success payload to the website webhook caller."
},
"typeVersion": 1
},
{
"id": "webhook",
"name": "Lead Intake Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-540,
0
],
"parameters": {
"path": "b2b-demo-lead-rescue",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "normalize",
"name": "Normalize, Score, and Assign Owner",
"type": "n8n-nodes-base.code",
"position": [
-300,
0
],
"parameters": {
"jsCode": "const body = $json.body || $json;\nconst pick = (...keys) => {\n for (const key of keys) {\n const value = body[key] ?? $json[key];\n if (value !== undefined && value !== null && String(value).trim() !== '') return String(value).trim();\n }\n return '';\n};\nconst lead = {\n received_at: new Date().toISOString(),\n name: pick('name', 'full_name', 'contact_name'),\n email: pick('email', 'work_email', 'business_email').toLowerCase(),\n phone: pick('phone', 'mobile', 'tel'),\n company: pick('company', 'organization', 'account'),\n role: pick('role', 'job_title', 'title'),\n message: pick('message', 'details', 'project', 'notes'),\n budget: pick('budget', 'estimated_budget'),\n timeline: pick('timeline', 'requested_timeline', 'deadline'),\n page_url: pick('page_url', 'url', 'landing_page', 'referrer'),\n source: pick('source', 'utm_source') || 'website',\n utm_campaign: pick('utm_campaign'),\n};\nconst text = `${lead.message} ${lead.budget} ${lead.timeline} ${lead.page_url}`.toLowerCase();\nconst tags = [];\nconst tagIf = (condition, tag) => { if (condition) tags.push(tag); };\ntagIf(/demo|book|call|meeting|trial/.test(text), 'demo_request');\ntagIf(/pricing|quote|proposal|budget|cost|estimate/.test(text), 'commercial_intent');\ntagIf(/urgent|asap|today|tomorrow|this week|deadline/.test(text), 'time_sensitive');\ntagIf(/integration|api|crm|hubspot|salesforce|zapier|make|n8n|workflow|automation/.test(text), 'integration_need');\ntagIf(/migration|broken|not working|failed|stuck|error/.test(text), 'rescue_need');\ntagIf(/enterprise|security|compliance|sso|soc2|procurement/.test(text), 'enterprise_process');\nconst contactScore = lead.email.includes('@') ? 20 : (lead.phone.length >= 7 ? 12 : 0);\nconst companyScore = lead.company ? 10 : 0;\nconst roleScore = /founder|owner|ceo|cto|vp|director|head|ops|operations|revops|sales/i.test(lead.role) ? 10 : 0;\nconst budgetScore = lead.budget ? (/\\$|£|€|k|budget|approved/i.test(lead.budget) ? 18 : 8) : 0;\nconst tagScore = Math.min(42, tags.length * 7);\nconst score = Math.min(100, contactScore + companyScore + roleScore + budgetScore + tagScore + (lead.page_url ? 5 : 0));\nlead.intent_tags = tags.join(', ') || 'general_inquiry';\nlead.lead_score = score;\nlead.priority = score >= 72 ? 'hot' : score >= 42 ? 'review' : 'normal';\nlead.sla_minutes = score >= 72 ? 15 : score >= 42 ? 240 : 1440;\nlead.owner_team = /integration|api|workflow|automation|crm|hubspot|salesforce|make|n8n/.test(text) ? 'automation_ops' : 'sales';\nlead.needs_exec_escalation = score >= 82 || /enterprise|procurement|security|sso|soc2/.test(text);\nlead.dedupe_key = `${lead.email || lead.phone || 'unknown'}:${lead.company || 'no-company'}:${lead.page_url || lead.source}`.toLowerCase().replace(/\\s+/g, '-');\nlead.missing_contact = !(lead.email.includes('@') || lead.phone.length >= 7);\nreturn [{ json: lead }];"
},
"typeVersion": 2
},
{
"id": "has-contact",
"name": "Has Usable Contact?",
"type": "n8n-nodes-base.if",
"position": [
-60,
0
],
"parameters": {
"options": {},
"conditions": {
"boolean": [
{
"value1": "={{ $json.missing_contact === false }}",
"value2": true
}
]
}
},
"typeVersion": 2
},
{
"id": "missing-response",
"name": "Build Missing Contact Response",
"type": "n8n-nodes-base.set",
"position": [
180,
260
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ok",
"name": "ok",
"type": "boolean",
"value": "={{ false }}"
},
{
"id": "status",
"name": "status",
"type": "string",
"value": "needs_contact"
},
{
"id": "message",
"name": "response_message",
"type": "string",
"value": "Please include a work email or phone number so the team can follow up."
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "respond-missing",
"name": "Respond Missing Contact",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
420,
260
],
"parameters": {
"options": {
"responseCode": 400
},
"respondWith": "json",
"responseBody": "={{ { ok: $json.ok, status: $json.status, message: $json.response_message } }}"
},
"typeVersion": 1.1
},
{
"id": "fetch-page",
"name": "Fetch Submitted Page Context",
"type": "n8n-nodes-base.httpRequest",
"position": [
180,
-100
],
"parameters": {
"url": "={{ $json.page_url || \"https://example.com\" }}",
"options": {
"timeout": 8000,
"response": {
"response": {
"responseFormat": "text"
}
}
}
},
"typeVersion": 4.2,
"continueOnFail": true
},
{
"id": "page-signals",
"name": "Extract Page Signals",
"type": "n8n-nodes-base.code",
"position": [
420,
-100
],
"parameters": {
"jsCode": "const lead = $('Normalize, Score, and Assign Owner').item.json;\nconst html = String($json.body || $json.data || '');\nconst title = (html.match(/<title[^>]*>([^<]+)<\\/title>/i)?.[1] || '').replace(/\\s+/g, ' ').trim();\nconst desc = (html.match(/<meta[^>]+name=[\"']description[\"'][^>]+content=[\"']([^\"']+)/i)?.[1] || '').replace(/\\s+/g, ' ').trim();\nconst pageText = `${title} ${desc}`.toLowerCase();\nconst pageTags = [];\nfor (const [term, tag] of [['pricing','pricing_page'], ['demo','demo_page'], ['case study','proof_page'], ['integration','integration_page'], ['contact','contact_page']]) {\n if (pageText.includes(term)) pageTags.push(tag);\n}\nconst pageBoost = pageTags.includes('pricing_page') || pageTags.includes('demo_page') ? 8 : pageTags.length ? 3 : 0;\nconst score = Math.min(100, Number(lead.lead_score || 0) + pageBoost);\nreturn [{ json: { ...lead, page_title: title, page_description: desc, page_signal_tags: pageTags.join(', '), lead_score: score, priority: score >= 72 ? 'hot' : score >= 42 ? 'review' : 'normal', sla_minutes: score >= 72 ? 15 : score >= 42 ? 240 : 1440 } }];"
},
"typeVersion": 2
},
{
"id": "audit-row",
"name": "Build Audit Row",
"type": "n8n-nodes-base.set",
"position": [
660,
-100
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "received",
"name": "received_at",
"type": "string",
"value": "={{ $json.received_at }}"
},
{
"id": "priority",
"name": "priority",
"type": "string",
"value": "={{ $json.priority }}"
},
{
"id": "score",
"name": "lead_score",
"type": "number",
"value": "={{ $json.lead_score }}"
},
{
"id": "sla",
"name": "sla_minutes",
"type": "number",
"value": "={{ $json.sla_minutes }}"
},
{
"id": "owner",
"name": "owner_team",
"type": "string",
"value": "={{ $json.owner_team }}"
},
{
"id": "tags",
"name": "intent_tags",
"type": "string",
"value": "={{ $json.intent_tags }}"
},
{
"id": "page_tags",
"name": "page_signal_tags",
"type": "string",
"value": "={{ $json.page_signal_tags }}"
},
{
"id": "dedupe",
"name": "dedupe_key",
"type": "string",
"value": "={{ $json.dedupe_key }}"
},
{
"id": "email",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "company",
"name": "company",
"type": "string",
"value": "={{ $json.company }}"
},
{
"id": "message",
"name": "message",
"type": "string",
"value": "={{ $json.message }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "sheet",
"name": "Append Lead Audit Row",
"type": "n8n-nodes-base.googleSheets",
"position": [
900,
-100
],
"parameters": {
"columns": {
"value": {},
"mappingMode": "autoMapInputData"
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Leads"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "REPLACE_WITH_SPREADSHEET_ID"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "REPLACE_WITH_GOOGLE_SHEETS_CREDENTIAL",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "route",
"name": "Route by Priority",
"type": "n8n-nodes-base.switch",
"position": [
1140,
-100
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.priority }}",
"rightValue": "hot"
}
]
}
},
{
"conditions": {
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.priority }}",
"rightValue": "review"
}
]
}
}
]
},
"options": {
"fallbackOutput": "extra"
}
},
"typeVersion": 3
},
{
"id": "hot-alert",
"name": "Build Hot Lead Alert",
"type": "n8n-nodes-base.set",
"position": [
1380,
-280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "subject",
"name": "email_subject",
"type": "string",
"value": "={{ `[HOT ${$json.lead_score}] ${$json.company || $json.name || $json.email} - ${$json.intent_tags}` }}"
},
{
"id": "body",
"name": "email_body",
"type": "string",
"value": "={{ `SLA: ${$json.sla_minutes} minutes\\nOwner: ${$json.owner_team}\\nTags: ${$json.intent_tags}\\nPage: ${$json.page_url}\\nPage signals: ${$json.page_signal_tags}\\nBudget: ${$json.budget}\\nTimeline: ${$json.timeline}\\nMessage: ${$json.message}\\nDedupe: ${$json.dedupe_key}` }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "send-hot",
"name": "Send Hot Lead Gmail Alert",
"type": "n8n-nodes-base.gmail",
"position": [
1620,
-280
],
"parameters": {
"sendTo": "[email protected]",
"message": "={{ $json.email_body }}",
"options": {},
"subject": "={{ $json.email_subject }}"
},
"credentials": {
"gmailOAuth2": {
"id": "REPLACE_WITH_GMAIL_CREDENTIAL",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "review-alert",
"name": "Build Review Queue Alert",
"type": "n8n-nodes-base.set",
"position": [
1380,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "subject",
"name": "email_subject",
"type": "string",
"value": "={{ `[REVIEW ${$json.lead_score}] ${$json.company || $json.name || $json.email}` }}"
},
{
"id": "body",
"name": "email_body",
"type": "string",
"value": "={{ `Review today. Tags: ${$json.intent_tags}\\nOwner: ${$json.owner_team}\\nMessage: ${$json.message}\\nDedupe: ${$json.dedupe_key}` }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "send-review",
"name": "Send Review Queue Gmail Alert",
"type": "n8n-nodes-base.gmail",
"position": [
1620,
-80
],
"parameters": {
"sendTo": "[email protected]",
"message": "={{ $json.email_body }}",
"options": {},
"subject": "={{ $json.email_subject }}"
},
"credentials": {
"gmailOAuth2": {
"id": "REPLACE_WITH_GMAIL_CREDENTIAL",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "normal-alert",
"name": "Build Normal Lead Note",
"type": "n8n-nodes-base.set",
"position": [
1380,
120
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "subject",
"name": "email_subject",
"type": "string",
"value": "={{ `[NORMAL ${$json.lead_score}] ${$json.company || $json.email}` }}"
},
{
"id": "body",
"name": "email_body",
"type": "string",
"value": "={{ `Next business day follow-up. Tags: ${$json.intent_tags}\\nMessage: ${$json.message}` }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "send-normal",
"name": "Send Normal Lead Gmail Alert",
"type": "n8n-nodes-base.gmail",
"position": [
1620,
120
],
"parameters": {
"sendTo": "[email protected]",
"message": "={{ $json.email_body }}",
"options": {},
"subject": "={{ $json.email_subject }}"
},
"credentials": {
"gmailOAuth2": {
"id": "REPLACE_WITH_GMAIL_CREDENTIAL",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "exec-check",
"name": "Needs Executive Escalation?",
"type": "n8n-nodes-base.if",
"position": [
1860,
-280
],
"parameters": {
"options": {},
"conditions": {
"boolean": [
{
"value1": "={{ Boolean($json.needs_exec_escalation) }}",
"value2": true
}
]
}
},
"typeVersion": 2
},
{
"id": "send-exec",
"name": "Send Executive Escalation",
"type": "n8n-nodes-base.gmail",
"position": [
2100,
-380
],
"parameters": {
"sendTo": "[email protected]",
"message": "={{ `Enterprise/high-score lead needs fast review.\\nOwner: ${$json.owner_team}\\nTags: ${$json.intent_tags}\\nBudget: ${$json.budget}\\nTimeline: ${$json.timeline}\\nMessage: ${$json.message}` }}",
"options": {},
"subject": "={{ `[EXEC ESCALATION] ${$json.company || $json.email} - score ${$json.lead_score}` }}"
},
"credentials": {
"gmailOAuth2": {
"id": "REPLACE_WITH_GMAIL_CREDENTIAL",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "success",
"name": "Build Success Response",
"type": "n8n-nodes-base.set",
"position": [
2100,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ok",
"name": "ok",
"type": "boolean",
"value": "={{ true }}"
},
{
"id": "status",
"name": "status",
"type": "string",
"value": "={{ $json.priority }}"
},
{
"id": "score",
"name": "score",
"type": "number",
"value": "={{ $json.lead_score }}"
},
{
"id": "sla",
"name": "sla_minutes",
"type": "number",
"value": "={{ $json.sla_minutes }}"
},
{
"id": "owner",
"name": "owner_team",
"type": "string",
"value": "={{ $json.owner_team }}"
},
{
"id": "dedupe",
"name": "dedupe_key",
"type": "string",
"value": "={{ $json.dedupe_key }}"
}
]
},
"includeOtherFields": false
},
"typeVersion": 3.4
},
{
"id": "respond-success",
"name": "Respond Success",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
2340,
-80
],
"parameters": {
"options": {
"responseCode": 200
},
"respondWith": "json",
"responseBody": "={{ { ok: $json.ok, status: $json.status, score: $json.score, sla_minutes: $json.sla_minutes, owner_team: $json.owner_team, dedupe_key: $json.dedupe_key } }}"
},
"typeVersion": 1.1
}
],
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "tinyops-b2b-demo-lead-rescue-v1",
"staticData": null,
"connections": {
"Build Audit Row": {
"main": [
[
{
"node": "Append Lead Audit Row",
"type": "main",
"index": 0
}
]
]
},
"Route by Priority": {
"main": [
[
{
"node": "Build Hot Lead Alert",
"type": "main",
"index": 0
}
],
[
{
"node": "Build Review Queue Alert",
"type": "main",
"index": 0
}
],
[
{
"node": "Build Normal Lead Note",
"type": "main",
"index": 0
}
]
]
},
"Has Usable Contact?": {
"main": [
[
{
"node": "Fetch Submitted Page Context",
"type": "main",
"index": 0
}
],
[
{
"node": "Build Missing Contact Response",
"type": "main",
"index": 0
}
]
]
},
"Lead Intake Webhook": {
"main": [
[
{
"node": "Normalize, Score, and Assign Owner",
"type": "main",
"index": 0
}
]
]
},
"Build Hot Lead Alert": {
"main": [
[
{
"node": "Send Hot Lead Gmail Alert",
"type": "main",
"index": 0
}
]
]
},
"Extract Page Signals": {
"main": [
[
{
"node": "Build Audit Row",
"type": "main",
"index": 0
}
]
]
},
"Append Lead Audit Row": {
"main": [
[
{
"node": "Route by Priority",
"type": "main",
"index": 0
}
]
]
},
"Build Normal Lead Note": {
"main": [
[
{
"node": "Send Normal Lead Gmail Alert",
"type": "main",
"index": 0
}
]
]
},
"Build Success Response": {
"main": [
[
{
"node": "Respond Success",
"type": "main",
"index": 0
}
]
]
},
"Build Review Queue Alert": {
"main": [
[
{
"node": "Send Review Queue Gmail Alert",
"type": "main",
"index": 0
}
]
]
},
"Send Executive Escalation": {
"main": [
[
{
"node": "Build Success Response",
"type": "main",
"index": 0
}
]
]
},
"Send Hot Lead Gmail Alert": {
"main": [
[
{
"node": "Needs Executive Escalation?",
"type": "main",
"index": 0
}
]
]
},
"Needs Executive Escalation?": {
"main": [
[
{
"node": "Send Executive Escalation",
"type": "main",
"index": 0
}
],
[
{
"node": "Build Success Response",
"type": "main",
"index": 0
}
]
]
},
"Fetch Submitted Page Context": {
"main": [
[
{
"node": "Extract Page Signals",
"type": "main",
"index": 0
}
]
]
},
"Send Normal Lead Gmail Alert": {
"main": [
[
{
"node": "Build Success Response",
"type": "main",
"index": 0
}
]
]
},
"Send Review Queue Gmail Alert": {
"main": [
[
{
"node": "Build Success Response",
"type": "main",
"index": 0
}
]
]
},
"Build Missing Contact Response": {
"main": [
[
{
"node": "Respond Missing Contact",
"type": "main",
"index": 0
}
]
]
},
"Normalize, Score, and Assign Owner": {
"main": [
[
{
"node": "Has Usable Contact?",
"type": "main",
"index": 0
}
]
]
}
}
}RELATED WORKFLOWS
COMMENTS
No comments yet — be the first.