Rahul Joshi This workflow corresponds to n8n.io template #8478 — 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": "9KRdh9YURctQ9kIo",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Lead Profile Enrichment",
"tags": [
{
"id": "3LcAgx74tbyro0Qm",
"name": "lead-enrichment",
"createdAt": "2025-09-05T05:36:01.542Z",
"updatedAt": "2025-09-05T05:36:01.542Z"
},
{
"id": "VT2auW6qa9EXhGrO",
"name": "sales",
"createdAt": "2025-09-05T05:36:01.501Z",
"updatedAt": "2025-09-05T05:36:01.501Z"
}
],
"nodes": [
{
"id": "b5f6b0d6-369f-4c5f-b118-94a29839f8a9",
"name": "Extract Domain from Email",
"type": "n8n-nodes-base.function",
"position": [
-704,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "069a4d85-19c3-46b9-b759-4c8e5d9974c8",
"name": "Get Company Logo",
"type": "n8n-nodes-base.httpRequest",
"position": [
-432,
-192
],
"parameters": {},
"typeVersion": 4.1
},
{
"id": "a729bd15-33db-441c-bc2f-a82c074587d3",
"name": "Clearbit Company Enrichment",
"type": "n8n-nodes-base.httpRequest",
"position": [
-432,
0
],
"parameters": {},
"typeVersion": 4.1
},
{
"id": "6c4ef611-64ba-4913-a103-422ebd5d4aa7",
"name": "Merge Enrichment Data",
"type": "n8n-nodes-base.function",
"position": [
64,
-80
],
"parameters": {},
"retryOnFail": false,
"typeVersion": 1,
"alwaysOutputData": false
},
{
"id": "86cac053-0ae2-406f-ba48-ce2f92d90460",
"name": "Append to Enriched Leads Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
592,
-240
],
"parameters": {},
"typeVersion": 4
},
{
"id": "d9652af1-de37-4084-b206-a06b2434e023",
"name": "Create a task",
"type": "n8n-nodes-base.clickUp",
"position": [
352,
32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "19015249-6fcb-497e-8326-2635dbd72067",
"name": "Check If Unbooked",
"type": "n8n-nodes-base.if",
"position": [
-976,
-80
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8557aea3-35f2-4664-85c8-fac0248c1173",
"name": "Get row(s) in sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1200,
-80
],
"parameters": {},
"typeVersion": 4
},
{
"id": "bace46f7-0b1d-457b-9756-fb160f46a8d0",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1440,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a802822-cdde-401f-82a3-522e3ca98a76",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
-192,
-80
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "37248473-7f25-49f5-be69-87f71f8f89aa",
"name": "Create a database page",
"type": "n8n-nodes-base.notion",
"position": [
336,
-240
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "6a52ff0b-fbbf-4c71-8a15-1cc469216c1b",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1520,
-288
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c0c3334c-a316-4d62-a9df-d8a497fb5a55",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1248,
112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "89b26487-67da-4723-9912-4b5f5e52850b",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
-336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a36e6320-2834-4fe9-83df-c5083a1453a7",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-768,
112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "27b872b7-6892-4c6c-bf88-a03f972ca96a",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-512,
-432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "33b11579-8056-47f2-a6b7-c8b0b96395ba",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0f8134d0-9797-4e2d-bb31-9f698b1748e0",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "739019a3-ef09-44d4-8d58-3aa1ed8ba4a1",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8cc172f4-530f-4355-9480-9a01365f6c2d",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
304,
-464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "09544996-9c73-4695-8214-9e213a4cf299",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "999336a9-ae3a-480c-8b48-568d2782f894",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
832,
-272
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "ff63fd80-afca-4995-a991-478ed34df3c3",
"connections": {
"Merge": {
"main": [
[
{
"node": "Merge Enrichment Data",
"type": "main",
"index": 0
}
]
]
},
"Get Company Logo": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Check If Unbooked": {
"main": [
[
{
"node": "Extract Domain from Email",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet1": {
"main": [
[
{
"node": "Check If Unbooked",
"type": "main",
"index": 0
}
]
]
},
"Merge Enrichment Data": {
"main": [
[
{
"node": "Create a database page",
"type": "main",
"index": 0
},
{
"node": "Create a task",
"type": "main",
"index": 0
}
]
]
},
"Create a database page": {
"main": [
[
{
"node": "Append to Enriched Leads Sheet",
"type": "main",
"index": 0
}
]
]
},
"Extract Domain from Email": {
"main": [
[
{
"node": "Get Company Logo",
"type": "main",
"index": 0
},
{
"node": "Clearbit Company Enrichment",
"type": "main",
"index": 0
}
]
]
},
"Clearbit Company Enrichment": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Append to Enriched Leads Sheet": {
"main": [
[]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Get row(s) in sheet1",
"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
Description
Source: https://n8n.io/workflows/8478/ — 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.
This workflow triggers when a HubSpot deal stage changes to Closed Won and automatically generates an invoice. It collects deal and contact data, builds a styled invoice, converts it into a PDF, and s
HubSpot Trigger, HTTP Request, Google Sheets +4
Generate market research reports from news and competitor sites to Notion and Slack. Uses errorTrigger, httpRequest, notion, googleSheets. Event-driven trigger; 19 nodes.
Error Trigger, HTTP Request, Notion +2
This n8n template demonstrates how to use AI to score the all Resumes by matching it with Job profile
HTTP Request, Google Gemini Chat, Gmail Trigger +5
simon-apify-youtube-transcript-20250724-v1-ok. Uses httpRequest, lmChatOpenAi, chainLlm, executeWorkflowTrigger. Event-driven trigger; 19 nodes.
HTTP Request, OpenAI Chat, Chain Llm +3
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
HTTP Request, Gmail, Twilio +3