Adem Tasin This workflow corresponds to n8n.io template #10203 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "8iSWr1q9g25U96Ma",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "For Temp_Smart Lead Routing & Qualification System (Typeform to HubSpot)",
"tags": [],
"nodes": [
{
"id": "1081c3e1-1a74-42e2-8965-1f75849c8a77",
"name": "Webhook Trigger",
"type": "n8n-nodes-base.webhook",
"position": [
-1696,
240
],
"parameters": {
"options": {},
"httpMethod": "POST"
},
"typeVersion": 1
},
{
"id": "7e0f9ef2-6da2-49d8-abe5-d5fa24b742f6",
"name": "Extract Lead Data",
"type": "n8n-nodes-base.function",
"position": [
-1440,
240
],
"parameters": {
"functionCode": "const body = $json.body.form_response;\nconst answers = body.answers || [];\nconst fields = body.definition.fields || [];\n\n// yard\u0131mc\u0131 fonksiyon: field id'den title'\u0131 bul\nfunction getTitleById(id) {\n return fields.find(f => f.id === id)?.title?.toLowerCase() || '';\n}\n\n// her answer i\u00e7in title-title e\u015flemesi kur\nconst data = {};\nfor (const a of answers) {\n const title = getTitleById(a.field.id);\n if (title.includes('first name')) data.first_name = a.text;\n if (title.includes('last name')) data.last_name = a.text;\n if (title.includes('company')) data.company = a.text;\n if (a.type === 'email') data.email = a.email;\n}\n\n// domain t\u00fcret\nif (data.email && data.email.includes('@')) {\n data.domain = data.email.split('@')[1];\n}\n\nreturn [{ json: data }];\n"
},
"typeVersion": 1
},
{
"id": "c5fc8f5e-97d1-491e-88a3-bde1e341e190",
"name": "Hunter.io Verification",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1168,
240
],
"parameters": {
"url": "https://api.hunter.io/v2/email-verifier",
"options": {},
"queryParametersUi": {
"parameter": [
{
"name": "email",
"value": "={{$json.email}}"
},
{
"name": "Your_api_key_name",
"value": "="
}
]
}
},
"typeVersion": 1
},
{
"id": "676c92fb-6cc5-46c6-bf7e-142cbcfef69a",
"name": "IF High Priority",
"type": "n8n-nodes-base.if",
"position": [
-1616,
624
],
"parameters": {
"conditions": {
"number": [
{
"value1": "={{$json.lead_score}}",
"value2": 70,
"operation": "largerEqual"
}
]
}
},
"typeVersion": 1
},
{
"id": "74c6baa5-e2a4-4f31-afcc-420186c7c09c",
"name": "HubSpot Create Contact (Qualified)",
"type": "n8n-nodes-base.hubspot",
"position": [
-1168,
576
],
"parameters": {
"email": "={{ $('Extract Lead Data').item.json.email }}",
"options": {},
"additionalFields": {
"city": "={{ $('Lead Scoring & Routing Logic').item.json.locality }}",
"country": "={{ $('Lead Scoring & Routing Logic').item.json.country }}",
"industry": "={{ $('Lead Scoring & Routing Logic').item.json.industry }}",
"lastName": "={{ $('Extract Lead Data').item.json.last_name }}",
"firstName": "={{ $('Extract Lead Data').item.json.first_name }}",
"websiteUrl": "={{ $('Lead Scoring & Routing Logic').item.json.domain }}",
"companyName": "={{ $('Lead Scoring & Routing Logic').item.json.name }}",
"linkedinUrl": "={{ $('Lead Scoring & Routing Logic').item.json.linkedin_url }}",
"customPropertiesUi": {
"customPropertiesValues": [
{
"value": "={{ $('Lead Scoring & Routing Logic').item.json.lead_score }}",
"property": "lead_score"
},
{
"value": "={{ $('Lead Scoring & Routing Logic').item.json.lead_tier }}",
"property": "lead_tier"
},
{
"value": "Qualified",
"property": "lead_stage"
}
]
}
}
},
"typeVersion": 2.2
},
{
"id": "019e15fb-458d-4145-b391-ba81ddf0f3a9",
"name": "Abstract Company Enrichment",
"type": "n8n-nodes-base.httpRequest",
"position": [
-656,
240
],
"parameters": {
"url": "https://companyenrichment.abstractapi.com/v1/",
"options": {
"response": {
"response": {
"responseFormat": "json"
}
}
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "your_api_key_name"
},
{
"name": "domain",
"value": "={{ $json.domain }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "8f58af1b-95ae-482e-84a8-60d00f76cff2",
"name": "Extract Domain for Abstract",
"type": "n8n-nodes-base.code",
"position": [
-912,
240
],
"parameters": {
"jsCode": "const email = $json.data?.email || ''\nlet domain = ''\nif (email.includes('@')) domain = email.split('@')[1]\nreturn [{ json: { domain } }]\n"
},
"typeVersion": 2
},
{
"id": "baca684a-bce0-4805-ac57-165abd08f72e",
"name": "Lead Scoring & Routing Logic",
"type": "n8n-nodes-base.function",
"position": [
-432,
240
],
"parameters": {
"functionCode": "const lead = $json;\n\nlet score = 0;\n\n// \u015eirket b\u00fcy\u00fckl\u00fc\u011f\u00fc\nif (lead.employees_count > 1000) score += 40;\nelse if (lead.employees_count > 100) score += 25;\nelse if (lead.employees_count > 10) score += 10;\n\n// \u00dclke \u00f6nceli\u011fi (\u00f6rnek)\nif (lead.country === 'United States' || lead.country === 'United Kingdom') score += 15;\n\n// Sekt\u00f6r hedefi\nconst targetIndustries = ['Software', 'Internet', 'Information Technology'];\nif (targetIndustries.includes(lead.industry)) score += 20;\n\n// E-posta domain kontrol\u00fc\nif (!lead.domain.includes('gmail') && !lead.domain.includes('yahoo')) score += 10;\n\n// LinkedIn bilgisi varsa\nif (lead.linkedin_url) score += 5;\n\n// Sonu\u00e7\nlet leadTier = 'Cold';\nif (score >= 70) leadTier = 'Hot';\nelse if (score >= 40) leadTier = 'Warm';\n\nreturn [{\n json: {\n ...lead,\n lead_score: score,\n lead_tier: leadTier,\n timestamp: new Date().toISOString()\n }\n}];\n"
},
"typeVersion": 1
},
{
"id": "a54a239f-65ca-4dd4-a7f1-fd0afe151212",
"name": "HubSpot Create Contact (Nurture)",
"type": "n8n-nodes-base.hubspot",
"position": [
-1168,
976
],
"parameters": {
"email": "={{ $('Extract Lead Data').item.json.email }}",
"options": {},
"additionalFields": {
"city": "={{ $('Lead Scoring & Routing Logic').item.json.locality }}",
"country": "={{ $('Lead Scoring & Routing Logic').item.json.country }}",
"industry": "={{ $('Lead Scoring & Routing Logic').item.json.industry }}",
"lastName": "={{ $('Extract Lead Data').item.json.last_name }}",
"firstName": "={{ $('Extract Lead Data').item.json.first_name }}",
"websiteUrl": "={{ $('Lead Scoring & Routing Logic').item.json.domain }}",
"companyName": "={{ $('Lead Scoring & Routing Logic').item.json.name }}",
"linkedinUrl": "={{ $('Lead Scoring & Routing Logic').item.json.linkedin_url }}",
"customPropertiesUi": {
"customPropertiesValues": [
{
"value": "={{ $('Lead Scoring & Routing Logic').item.json.lead_score }}",
"property": "lead_score"
},
{
"value": "={{ $('Lead Scoring & Routing Logic').item.json.lead_tier }}",
"property": "lead_tier"
},
{
"value": "Nurture",
"property": "lead_stage"
}
]
}
}
},
"typeVersion": 2.2
},
{
"id": "202ab634-fe41-4bed-a226-92b260bec673",
"name": "Slack Notification \u2192 \ud83d\udce8 Nurture Alert",
"type": "n8n-nodes-base.slack",
"position": [
-208,
720
],
"parameters": {
"text": "=\ud83d\udd25 *New Nurture Lead Alert*\n\ud83d\udc4b Hey team, a lead is still in NURTURE stage:\n \n\ud83c\udfe2 *{{ $json.results[0].properties.company }}* \n\ud83d\udce7 {{ $json.results[0].properties.email }} \n\ud83d\udca5 Score: {{ $json.results[0].properties.lead_score }} \n\ud83d\udd52 Checked: {{ new Date().toLocaleString('tr-TR') }}\n",
"attachments": [],
"otherOptions": {}
},
"typeVersion": 1
},
{
"id": "ac781aa1-cf6c-46e2-9838-370d24d8dd17",
"name": "Google Sheets Logging \u2192 \ud83d\udcca Nurture Log",
"type": "n8n-nodes-base.googleSheets",
"position": [
-128,
1088
],
"parameters": {
"options": {},
"fieldsUi": {
"fieldValues": [
{
"fieldId": "Date",
"fieldValue": "={{ new Date().toISOString() }}"
},
{
"fieldId": "Company",
"fieldValue": "={{ $json.results[0].properties.company }}"
},
{
"fieldId": "Email",
"fieldValue": "={{ $json.results[0].properties.email }}"
},
{
"fieldId": "Lead Score",
"fieldValue": "={{ $json.results[0].properties.lead_score }}"
},
{
"fieldId": "Stage",
"fieldValue": "={{ $json.results[0].properties.lead_stage }}"
}
]
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"typeVersion": 3,
"alwaysOutputData": false
},
{
"id": "1bb371f4-cf6c-437b-818f-db1cadd281b7",
"name": "Wait (3 Days) \u2192 \u23f3 Delay for Nurture Recheck",
"type": "n8n-nodes-base.wait",
"position": [
-896,
976
],
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "5bf0857e-d999-45d6-80af-1a6c94ac21aa",
"name": "HubSpot API Check \u2192 \ud83d\udd0d HubSpot Revalidation",
"type": "n8n-nodes-base.httpRequest",
"position": [
-528,
976
],
"parameters": {
"url": "https://api.hubapi.com",
"method": "POST",
"options": {},
"jsonBody": "{\n \"filterGroups\": [\n {\n \"filters\": [\n {\n \"propertyName\": \"lead_stage\",\n \"operator\": \"EQ\",\n \"value\": \"Nurture\"\n }\n ]\n }\n ],\n \"properties\": [\"email\", \"lead_score\", \"lead_stage\", \"firstname\", \"company\"]\n}\n",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2
},
{
"id": "437300af-f690-42f3-8bcb-7e0129a5694f",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1776,
-64
],
"parameters": {
"height": 448,
"content": "## \ud83d\udfe2 1. Webhook Trigger\n\ud83e\udde9 Entry Point \u2014 Receives form submissions from Typeform.\n\nAccepts POST requests containing lead info. \nWebhook path: `/webhook/new-lead-webhook`\n"
},
"typeVersion": 1
},
{
"id": "3a9b51fa-4fd5-47e8-96ce-3506aa9d1c32",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1504,
-64
],
"parameters": {
"height": 448,
"content": "## \ud83d\udfe6 2. Extract Lead Data\n\ud83e\udde0 Parses Typeform JSON to extract key fields:\n- first_name \n- last_name \n- email \n- company \n\nAutomatically derives the email domain for enrichment steps.\n"
},
"typeVersion": 1
},
{
"id": "3bf7700f-22a4-4f2a-90a9-1f7ee0d84963",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1232,
-64
],
"parameters": {
"width": 224,
"height": 448,
"content": "## 3.\ud83d\udfe9 Hunter.io Verification\n\u2705 Verifies lead email validity using the Hunter.io API.\n\nEnsures only real and deliverable emails proceed to the next step.\n"
},
"typeVersion": 1
},
{
"id": "d08b19f0-81e9-414a-83c5-9f31dbef9355",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-992,
-64
],
"parameters": {
"height": 448,
"content": "## 4.\ud83d\udfe8 Extract Domain for Abstract\n\ud83e\udde9 Extracts the domain from the lead\u2019s email address.\n\nUsed as input for the Abstract API enrichment request.\n"
},
"typeVersion": 1
},
{
"id": "080bfdc2-9d7a-47c6-b62a-c2ddc11c717f",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-736,
-64
],
"parameters": {
"height": 464,
"content": "## 5.\ud83d\udfe7 Abstract Company Enrichment\n\ud83c\udf10 Calls Abstract API to enrich company details.\n\nFetches industry, employee count, location, and website metadata.\n"
},
"typeVersion": 1
},
{
"id": "4677193f-8ac3-4459-a15d-25bd4bbc72a2",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-64
],
"parameters": {
"width": 304,
"height": 464,
"content": "## 6.\ud83d\udfea Lead Scoring & Routing Logic\n\ud83d\udcca Calculates lead score based on:\n- Company size\n- Target country\n- Industry match\n- Domain type (business vs. free)\n- LinkedIn presence\n\nAssigns lead_tier: Cold / Warm / Hot.\n"
},
"typeVersion": 1
},
{
"id": "d1de8db0-04f7-4d3a-88f3-4ca556eeb847",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1776,
480
],
"parameters": {
"width": 384,
"height": 272,
"content": "## 7.\ud83d\udd35 IF High Priority\n\u2699\ufe0f Decision Node \u2014 Routes leads based on score:\n\n\u2705 TRUE (\u226570): Qualified \u2192 HubSpot (Qualified Path) \n\u274c FALSE (<70): Nurture \u2192 HubSpot (Nurture Path)\n"
},
"typeVersion": 1
},
{
"id": "2e3a2ff8-a594-4d06-b92b-2eb942a8bd2d",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
432
],
"parameters": {
"width": 496,
"height": 320,
"content": "## 7.1 \ud83d\udfe3 HubSpot Create Contact (Qualified)\n\ud83d\ude80 Creates \u201cQualified\u201d contact in HubSpot CRM.\n\nIncludes enrichment data, lead score, and lead stage = Qualified.\n"
},
"typeVersion": 1
},
{
"id": "8a363f72-94d8-4765-ade8-97a14fd1eb35",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
768
],
"parameters": {
"width": 288,
"height": 400,
"content": "## 7.2 \ud83d\udfe4 HubSpot Create Contact (Nurture)\n\ud83c\udf31 Creates \u201cNurture\u201d stage contact in HubSpot.\n\nUsed for lower-priority leads entering a recheck cycle.\n"
},
"typeVersion": 1
},
{
"id": "e1d27554-3d34-458c-a6d1-32d6f32b5fda",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-960,
768
],
"parameters": {
"width": 336,
"height": 400,
"content": "## 7.2.1 \ud83d\udfe0 Wait (3 Days) \u2192 \u23f3 Delay for Nurture Recheck\n\u23f3 Delays workflow for follow-up revalidation.\n\nCurrent test delay: 10 seconds \nProduction delay: 3 days\n"
},
"typeVersion": 1
},
{
"id": "b33cf27b-4fc7-4ceb-986b-61eb78011c93",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-608,
640
],
"parameters": {
"height": 528,
"content": "## 7.2.2 \ud83d\udd34 HubSpot API Check \u2192 \ud83d\udd0d HubSpot Revalidation\n\ud83d\udd0d Queries HubSpot CRM for contacts still in Nurture stage.\n\nReturns latest info like:\n- Email\n- Company\n- Lead Score\n- Lead Stage\n"
},
"typeVersion": 1
},
{
"id": "6012ec36-0b0e-4aab-975e-66b42e64b0c3",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-336,
448
],
"parameters": {
"width": 288,
"height": 448,
"content": "## 7.2.2.1 \ud83d\udfe2 Slack Notification \u2192 \ud83d\udce8 Nurture Alert\n\ud83d\udcac Sends Slack alert for leads still in NURTURE stage.\n\nIncludes:\n\ud83c\udfe2 Company \n\ud83d\udce7 Email \n\ud83d\udca5 Lead Score \n\ud83d\udd52 Timestamp\n"
},
"typeVersion": 1
},
{
"id": "d0067eff-a672-4134-a5c9-f417b1b20a24",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
944
],
"parameters": {
"width": 432,
"height": 352,
"content": "## 7.2.2.2 \ud83d\udfe3 Google Sheets Logging \u2192 \ud83d\udcca Nurture Log \n\ud83d\udcc4 Appends lead details to Google Sheet \u201cNurture Follow-Up Log\u201d.\n\nLogs:\n- Date\n- Company\n- Email\n- Lead Score\n- Stage\n"
},
"typeVersion": 1
},
{
"id": "2545a465-8e72-4c7e-9132-715d139af184",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1824,
912
],
"parameters": {
"width": 480,
"height": 176,
"content": "## \ud83d\udcdd Workflow Summary Note\n\ud83e\udded Smart Lead Routing & Qualification System\n\nAutomates lead intake, enrichment, scoring, and CRM sync.\nEcosystem:\n\nTypeform \u2192 Hunter.io \u2192 Abstract API \u2192 HubSpot \u2192 Slack \u2192 Sheets\n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "d1c43050-e27d-4925-9e7b-b17ddea8324b",
"connections": {
"Webhook Trigger": {
"main": [
[
{
"node": "Extract Lead Data",
"type": "main",
"index": 0
}
]
]
},
"IF High Priority": {
"main": [
[
{
"node": "HubSpot Create Contact (Qualified)",
"type": "main",
"index": 0
}
],
[
{
"node": "HubSpot Create Contact (Nurture)",
"type": "main",
"index": 0
}
]
]
},
"Extract Lead Data": {
"main": [
[
{
"node": "Hunter.io Verification",
"type": "main",
"index": 0
}
]
]
},
"Hunter.io Verification": {
"main": [
[
{
"node": "Extract Domain for Abstract",
"type": "main",
"index": 0
}
]
]
},
"Abstract Company Enrichment": {
"main": [
[
{
"node": "Lead Scoring & Routing Logic",
"type": "main",
"index": 0
}
]
]
},
"Extract Domain for Abstract": {
"main": [
[
{
"node": "Abstract Company Enrichment",
"type": "main",
"index": 0
}
]
]
},
"Lead Scoring & Routing Logic": {
"main": [
[
{
"node": "IF High Priority",
"type": "main",
"index": 0
}
]
]
},
"HubSpot Create Contact (Nurture)": {
"main": [
[
{
"node": "Wait (3 Days) \u2192 \u23f3 Delay for Nurture Recheck",
"type": "main",
"index": 0
}
]
]
},
"HubSpot Create Contact (Qualified)": {
"main": [
[]
]
},
"HubSpot API Check \u2192 \ud83d\udd0d HubSpot Revalidation": {
"main": [
[
{
"node": "Google Sheets Logging \u2192 \ud83d\udcca Nurture Log",
"type": "main",
"index": 0
},
{
"node": "Slack Notification \u2192 \ud83d\udce8 Nurture Alert",
"type": "main",
"index": 0
}
]
]
},
"Wait (3 Days) \u2192 \u23f3 Delay for Nurture Recheck": {
"main": [
[
{
"node": "HubSpot API Check \u2192 \ud83d\udd0d HubSpot Revalidation",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Automate your lead qualification pipeline — capture Typeform Webhook leads, enrich with APIs, score intelligently, and route to HubSpot, Slack, and Sheets in real-time.
Source: https://n8n.io/workflows/10203/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
How it works This Lead Capture & Auto-Qualification workflow transforms raw leads into qualified prospects through intelligent automation. Here's the high-level flow: Lead Intake → Data Validation → E
Clearbit, HTTP Request, HubSpot +1
Enterprise AI Lead Scoring & CRM Sync. Uses httpRequest, hubspot, googleSheets. Webhook trigger; 6 nodes.
HTTP Request, HubSpot, Google Sheets
AI-Powered Lead Qualification & Routing System. Uses supabase, httpRequest, openAi, slack. Webhook trigger; 47 nodes.
Supabase, HTTP Request, OpenAI +2
This template is perfect for: Marketing Teams looking to automatically qualify inbound leads from campaigns Sales Teams wanting to prioritize high-value prospects instantly Agencies offering lead qual
Form Trigger, Slack, OpenAI +5
Who is this for? Event organizers, RevOps teams, sales managers, and marketers running conferences, webinars, or meetups who want to automatically qualify RSVPs and turn attendees into revenue opportu
Google Sheets, OpenAI, HubSpot +1