Niklas Hatje 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
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
When trying to maximize your outreach, website visitors are often an overlooked source of qualified new leads. This workflow allows your to track and enrich new website visitors and saves them to a Google Sheet once they meet a pre-defined criteria.
Source: https://n8n.io/workflows/2113/ — 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 runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CR
Gmail, Google Sheets, Google Analytics +3
Goal: Get Reddit posts from specific subreddits, filter those mentioning freelance/gigs and n8n, extract top-level comments, remove mod replies, and store everything into Google Sheets.
HTTP Request, Reddit, Google Sheets
This workflow is a comprehensive solution for digital marketers, performance agencies, and e-commerce brands looking to scale their creative testing process on Meta Ads efficiently. It eliminates the
Google Drive, HTTP Request, Google Sheets
This automation creates a seamless daily pipeline that: Pulls yesterday's website visitors from Leadfeeder Enriches company data using Apollo.io's powerful database Delivers enriched leads to your Goo
HTTP Request, Google Sheets, Error Trigger +1
Watch target companies for C-level and VP hiring signals, then send AI-personalized outreach emails when leadership roles are posted.
Google Sheets, @Predictleads/N8N Nodes Predictleads, Slack +2