This workflow corresponds to n8n.io template #2113 — 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 →
{
"meta": {
"templateId": "2113"
},
"nodes": [
{
"id": "2e93b7a1-f22c-4e34-8bbe-09763d428ab6",
"name": "Get Leads",
"type": "n8n-nodes-base.httpRequest",
"position": [
1040,
522
],
"parameters": {
"url": "=https://api.leadfeeder.com/accounts/{{ $json.id }}/leads",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "start_date",
"value": "={{ $now.minus(1, 'day').toFormat('yyyy-MM-dd') }}"
},
{
"name": "end_date",
"value": "={{ $now.toFormat('yyyy-MM-dd') }}"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.1
},
{
"id": "0274033f-582a-40f6-9c08-161a81cfb2ab",
"name": "Filter Leads by company criteria",
"type": "n8n-nodes-base.filter",
"position": [
640,
762.4643026004727
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "077363ca-c785-497c-bae9-24829bb321cd",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.metrics.employees }}",
"rightValue": 100
}
]
}
},
"typeVersion": 2
},
{
"id": "918af2ea-38ab-4d36-abf0-628119216835",
"name": "Enrich company",
"type": "n8n-nodes-base.clearbit",
"position": [
420,
762
],
"parameters": {
"domain": "={{ $json.attributes.website_url }}",
"additionalFields": {}
},
"credentials": {
"clearbitApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "5ee23d2a-5eb6-4edd-8668-6053294d26cb",
"name": "Setup",
"type": "n8n-nodes-base.set",
"position": [
640,
282.4643026004727
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7b5f7c85-7455-439a-8427-7b45c67c7903",
"name": "Leadfeeder Accounts",
"type": "array",
"value": "=[\"n8n\",\"someOtherAccount\"]"
},
{
"id": "61e2ddbd-380e-4b6e-8652-048b948994e5",
"name": "Google Sheets URL",
"type": "string",
"value": "https://docs.google.com/spreadsheets/d/1a2gfBjZZpN0jiD7apR8fPplRp2aPHVy2_5lp4Yzp778/edit?usp=sharing"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "425b3030-d745-4fe0-a489-c6d79f1d6dca",
"name": "Get all Leedfeeder accounts",
"type": "n8n-nodes-base.httpRequest",
"position": [
420,
522.4643026004727
],
"parameters": {
"url": "https://api.leadfeeder.com/accounts",
"options": {},
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.1
},
{
"id": "2a547ddc-131d-4628-83f1-516d07dddde9",
"name": "Only for wanted accounts",
"type": "n8n-nodes-base.filter",
"position": [
840,
522.4643026004727
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7c08f7c1-b6d4-47cc-91f8-e55a6d800eb3",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $('Setup').first().json[\"Leadfeeder Accounts\"].includes($json.attributes.name) }}",
"rightValue": "n8n"
}
]
}
},
"typeVersion": 2
},
{
"id": "8083e9c2-ffcd-4060-87eb-f726349d1bc3",
"name": "Split out accounts",
"type": "n8n-nodes-base.splitOut",
"position": [
640,
522.4643026004727
],
"parameters": {
"options": {},
"fieldToSplitOut": "data"
},
"typeVersion": 1
},
{
"id": "59696b1e-ff16-49d4-abc2-d830ce612fb5",
"name": "Split Out Leads",
"type": "n8n-nodes-base.splitOut",
"position": [
1220,
522.4643026004727
],
"parameters": {
"options": {},
"fieldToSplitOut": "data"
},
"typeVersion": 1
},
{
"id": "0618bc71-d8b3-4f8e-891b-127a391994fe",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
799.9999999999991,
208.53380614657158
],
"parameters": {
"color": 6,
"width": 370.00000000000045,
"height": 239.93049645390096,
"content": "### Setup\n1. Add your **Leedfeeder** credentials. The name should be `Authorization` and the value `Token token=yourapitoken`. You can find your token via **Settings -> Personal -> API-Token**\n2. Add your **Google Sheet** credentials\n3. Save the **Leedfeeder** account names you want to use in the `Setup` node\n4. Copy the [Google Sheets Template](https://docs.google.com/spreadsheets/d/1a2gfBjZZpN0jiD7apR8fPplRp2aPHVy2_5lp4Yzp778/edit?usp=sharing) and add its URL to the `Setup` node"
},
"typeVersion": 1
},
{
"id": "c23e9507-6413-4343-add3-ee1539b424fd",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
420,
282.4643026004727
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7
}
]
}
},
"typeVersion": 1.1
},
{
"id": "68f4a72e-c857-4e7c-8176-5e2494be2553",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1380,
466.4643026004727
],
"parameters": {
"color": 5,
"width": 193,
"height": 220,
"content": "Adjust your engagement criteria here"
},
"typeVersion": 1
},
{
"id": "648ef9d3-1ea7-42ff-9c80-16f05e9ff7f6",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
707.4643026004727
],
"parameters": {
"color": 5,
"width": 193,
"height": 215,
"content": "Adjust your company criteria here"
},
"typeVersion": 1
},
{
"id": "bc1e5cb1-fb6b-45a8-a23b-b3d890b7cc79",
"name": "Filter leads by engagement",
"type": "n8n-nodes-base.filter",
"position": [
1420,
522.4643026004727
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b97c4134-48e9-4a55-b002-5db3e4304e0d",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.attributes.visits }}",
"rightValue": 3
}
]
}
},
"typeVersion": 2
},
{
"id": "9c59a495-7fc6-4d11-b15c-0e72c9f33164",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
240
],
"parameters": {
"color": 5,
"width": 193,
"height": 186.77446808510643,
"content": "Adjust the schedule here"
},
"typeVersion": 1
},
{
"id": "9ee5c6ac-544b-42fa-9432-92ae45ee40dd",
"name": "Save leads to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
840,
762.4643026004727
],
"parameters": {
"columns": {
"value": {
"name": "={{ $json.name }}",
"domain": "={{ $json.domain }}",
"visits": "={{ $('Split Out Leads').item.json.attributes.visits }}",
"quality": "={{ $('Split Out Leads').item.json.attributes.quality }}",
"twitter": "={{ $json.twitter.handle ? $json.twitter.handle : $('Split Out Leads').item.json.attributes.twitter_handle }}",
"linkedin": "={{ $json.linkedin.handle ? $json.linkedin.handle : $('Split Out Leads').item.json.attributes.linkedin_handle }}",
"employees": "={{ $json.metrics.employees ? $json.metrics.employees : $('Split Out Leads').item.json.attributes.employee_count }}",
"description": "={{ $json.description }}"
},
"schema": [
{
"id": "domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employees",
"type": "string",
"display": true,
"required": false,
"displayName": "employees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitter",
"type": "string",
"display": true,
"required": false,
"displayName": "twitter",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "quality",
"type": "string",
"display": true,
"required": false,
"displayName": "quality",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "visits",
"type": "string",
"display": true,
"required": false,
"displayName": "visits",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"domain"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1a2gfBjZZpN0jiD7apR8fPplRp2aPHVy2_5lp4Yzp778/edit#gid=0",
"cachedResultName": "Visitors"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Setup').first().json[\"Google Sheets URL\"] }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
}
],
"connections": {
"Setup": {
"main": [
[
{
"node": "Get all Leedfeeder accounts",
"type": "main",
"index": 0
}
]
]
},
"Get Leads": {
"main": [
[
{
"node": "Split Out Leads",
"type": "main",
"index": 0
}
]
]
},
"Enrich company": {
"main": [
[
{
"node": "Filter Leads by company criteria",
"type": "main",
"index": 0
}
]
]
},
"Split Out Leads": {
"main": [
[
{
"node": "Filter leads by engagement",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Setup",
"type": "main",
"index": 0
}
]
]
},
"Split out accounts": {
"main": [
[
{
"node": "Only for wanted accounts",
"type": "main",
"index": 0
}
]
]
},
"Only for wanted accounts": {
"main": [
[
{
"node": "Get Leads",
"type": "main",
"index": 0
}
]
]
},
"Filter leads by engagement": {
"main": [
[
{
"node": "Enrich company",
"type": "main",
"index": 0
}
]
]
},
"Get all Leedfeeder accounts": {
"main": [
[
{
"node": "Split out accounts",
"type": "main",
"index": 0
}
]
]
},
"Filter Leads by company criteria": {
"main": [
[
{
"node": "Save leads to Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
clearbitApigoogleSheetsOAuth2ApihttpHeaderAuth
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow streamlines the process of exporting and enriching leads based on specific company criteria, saving you hours of manual data handling by automatically filtering, enhancing, and splitting datasets for targeted analysis. It's ideal for sales or marketing teams managing large lead lists who need to segment prospects by account details without sifting through spreadsheets. The key step involves using Clearbit to enrich filtered leads from an HTTP source, followed by splitOut nodes that divide the data into separate Google Sheets for different accounts, ensuring clean, actionable exports.
Use this workflow when you have a scheduled need to process and categorise leads from external APIs, such as weekly exports for account-based marketing campaigns. Avoid it for real-time processing or very small datasets under 100 leads, where manual handling might suffice. Common variations include adjusting filters for industry-specific criteria or integrating additional HTTP requests for custom lead sources.
About this workflow
Splitout Filter Export. Uses httpRequest, clearbit, splitOut, stickyNote. Scheduled trigger; 15 nodes.
Source: https://github.com/Zie619/n8n-workflows — 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 automates video distribution to 9 social platforms simultaneously using Blotato's API. It includes both a scheduled publisher (checks Google Sheets for videos marked "Ready") and a subwo
YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.
This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relev
ofn hook v0.24.0 beta. Uses start, httpRequest, functionItem, itemLists. Scheduled trigger; 42 nodes.
Security teams, DevOps engineers, vulnerability analysts, and automation builders who want to eliminate repetitive Nessus scan parsing, AI-based risk triage, and manual reporting. Designed for orgs fo