Automatisierung der Unternehmensdaten-Anreicherung von ZoomInfo, Serper und Oxylabs zu Google Sheets
Dies ist ein Lead Generation-Bereich Automatisierungsworkflow mit 19 Nodes. Hauptsächlich werden If, Code, Html, Wait, HttpRequest und andere Nodes verwendet. Automatisierung der Unternehmensdaten-Anreicherung von ZoomInfo, Serper und Oxylabs zu Google Sheets
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
Verwendete Nodes (19)
Kategorie
{
"meta": {
"instanceId": "aff7017841e089b12fdff439d182db1ce6e6151977703d9243f6be0543724481",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "6e9e0196-34b7-42ef-9cea-0ee2f29126d9",
"name": "Manueller Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-864,
464
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f89efbed-6317-4875-9e70-829a9a4634ba",
"name": "Unverarbeitete Domains laden",
"type": "n8n-nodes-base.googleSheets",
"position": [
-640,
464
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "processed"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2062802377,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit#gid=2062802377",
"cachedResultName": "ZoomInfoData"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit?usp=drivesdk",
"cachedResultName": "Get Addresses"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Y43YNvASDhLxJg65",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
"name": "Jede Domain verarbeiten",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-416,
464
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "240a748e-f3d7-47cd-b97e-6d1a31c366c1",
"name": "ZoomInfo über Serper suchen",
"type": "n8n-nodes-base.httpRequest",
"position": [
-192,
176
],
"parameters": {
"url": "https://google.serper.dev/search",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "q",
"value": "=where is \"{{ $json.domain }}\" Czech Republic headquarter? site:zoominfo.com"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "3ff4n7dWTTnGg27S",
"name": "[Serper/Sophia] Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "538ae1c4-e301-4ad1-9be8-0ab40b371068",
"name": "Überprüfen, ob Suchergebnisse gefunden wurden",
"type": "n8n-nodes-base.if",
"position": [
32,
176
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f5f8619e-e07d-4cb7-9369-48a2882e4d35",
"operator": {
"type": "array",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.organic }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2d392b3b-0886-49a9-a69e-d0b2f455c613",
"name": "Domain und ZoomInfo-URL extrahieren",
"type": "n8n-nodes-base.code",
"position": [
256,
80
],
"parameters": {
"jsCode": "const text = $input.first().json.organic[0].snippet;\nconst regex = /(https?:\\/\\/(?:www\\.|(?!www))[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\\.[^\\s]{2,}|www\\.[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\\.[^\\s]{2,}|https?:\\/\\/[a-zA-Z0-9]\\.[^\\s]{2,})(?<![\\\\.\\\\,])/g;\nconst matches = text.match(regex) || [];\n\nreturn matches.map(url => ({\n json: {\n url,\n link: $input.first().json.organic[0].link\n }\n})); "
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "dd4bb8af-1d6f-414f-badd-93d6a4dc7202",
"name": "Validieren, ob Domain übereinstimmt",
"type": "n8n-nodes-base.if",
"position": [
480,
80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "58571e85-2aa7-4383-953f-0135c985e27d",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.url }}",
"rightValue": "={{ $('Process Each Domain').item.json.domain }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "41618147-b735-4a30-83d8-2a8a5f813fc4",
"name": "ZoomInfo-Seite scrapen",
"type": "n8n-nodes-base.httpRequest",
"position": [
704,
80
],
"parameters": {
"url": "https://realtime.oxylabs.io/v1/queries",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "source",
"value": "universal"
},
{
"name": "url",
"value": "={{ $json.link }}"
}
]
},
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "UJNOFcA65c1OotBi",
"name": "[Naveen] Oxylabs"
}
},
"typeVersion": 4.2
},
{
"id": "bd7c4539-0f42-4b66-adb8-efd64638866e",
"name": "Unternehmensdaten extrahieren",
"type": "n8n-nodes-base.html",
"position": [
928,
80
],
"parameters": {
"options": {
"trimValues": true,
"cleanUpText": true
},
"operation": "extractHtmlContent",
"dataPropertyName": "results[0].content",
"extractionValues": {
"values": [
{
"key": "company_info",
"cssSelector": "#ng-state"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "94931e87-9169-48f8-805d-118167195043",
"name": "JSON Unternehmensinfo parsen",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
1152,
80
],
"parameters": {
"jsCode": "\nreturn JSON.parse($input.first().json.company_info).pageData;"
},
"typeVersion": 2
},
{
"id": "c5c398e4-7476-4636-913c-8489f0612af3",
"name": "Unternehmensdetails speichern",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueRegularOutput",
"position": [
1600,
248
],
"parameters": {
"columns": {
"value": {
"city": "={{ $json.address.city }}",
"phone": "={{ $json.about.phone.replace(\"+\", \"'+\") }}",
"state": "={{ $json.address.state }}",
"domain": "={{ $('Process Each Domain').item.json.domain }}",
"address": "={{ $json.address.street }}",
"company": "={{ $json.fullName }}",
"country": "={{ $json.address.country }}",
"revenue": "={{ $json.about.revenue }}",
"industry": "={{ $json.about.industries.map(item => item.name) }}",
"postCode": "={{ $json.address.zip }}",
"employees": "={{ $json.numberOfEmployees }}",
"processed": "true",
"companyLinkedinUrl": "={{ $json.overview.socialNetworkUrls[0].socialNetworkUrl }}"
},
"schema": [
{
"id": "domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postCode",
"type": "string",
"display": true,
"required": false,
"displayName": "postCode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employees",
"type": "string",
"display": true,
"required": false,
"displayName": "employees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "revenue",
"type": "string",
"display": true,
"required": false,
"displayName": "revenue",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "industry",
"type": "string",
"display": true,
"required": false,
"displayName": "industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "companyLinkedinUrl",
"type": "string",
"display": true,
"required": false,
"displayName": "companyLinkedinUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "source_url",
"type": "string",
"display": true,
"required": false,
"displayName": "source_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed",
"type": "string",
"display": true,
"required": false,
"displayName": "processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"domain"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2062802377,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit#gid=2062802377",
"cachedResultName": "ZoomInfoData"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit?usp=drivesdk",
"cachedResultName": "Get Addresses"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Y43YNvASDhLxJg65",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "4b6515e0-4b48-475a-a4e8-2bacbb4ea754",
"name": "Domain als verarbeitet markieren",
"type": "n8n-nodes-base.googleSheets",
"position": [
480,
272
],
"parameters": {
"columns": {
"value": {
"domain": "={{ $('Process Each Domain').item.json.domain }}",
"processed": "true"
},
"schema": [
{
"id": "domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postCode",
"type": "string",
"display": true,
"required": false,
"displayName": "postCode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employees",
"type": "string",
"display": true,
"required": false,
"displayName": "employees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "revenue",
"type": "string",
"display": true,
"required": false,
"displayName": "revenue",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "industry",
"type": "string",
"display": true,
"required": false,
"displayName": "industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "companyLinkedinUrl",
"type": "string",
"display": true,
"required": false,
"displayName": "companyLinkedinUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "source_url",
"type": "string",
"display": true,
"required": false,
"displayName": "source_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed",
"type": "string",
"display": true,
"required": false,
"displayName": "processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"domain"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2062802377,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit#gid=2062802377",
"cachedResultName": "ZoomInfoData"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit?usp=drivesdk",
"cachedResultName": "Get Addresses"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Y43YNvASDhLxJg65",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "2d0e61ec-65ee-4cee-b8c7-bc2b173f6987",
"name": "Rate-Limit-Verzögerung",
"type": "n8n-nodes-base.wait",
"position": [
1376,
80
],
"webhookId": "05ac39a5-6d75-4156-8133-2bdbf1f047d6",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "16d10906-533b-4c3a-981b-7cfec0c11814",
"name": "Verarbeitungsverzögerung",
"type": "n8n-nodes-base.wait",
"position": [
256,
272
],
"webhookId": "57b27518-bce8-40c2-94af-42635ac335fa",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "d78a08b4-ca6b-46cd-9e42-fc6ee38c7e7d",
"name": "Notiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
-640
],
"parameters": {
"width": 960,
"height": 320,
"content": "🏢 ZOOMINFO COMPANY DATA SCRAPER\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n\n🎯 Purpose: Automatically enriches company domains with detailed business information from ZoomInfo\n\n📊 Process Flow:\n1. Loads unprocessed domains from Google Sheet\n2. Searches ZoomInfo via Serper API \n3. Scrapes company data using Oxylabs\n4. Updates sheet with enriched information\n\n⚠️ Respects rate limits and processes domains sequentially"
},
"typeVersion": 1
},
{
"id": "90ca76bc-4281-46a1-a978-62fd84433df3",
"name": "Notiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1152,
-240
],
"parameters": {
"color": 5,
"width": 912,
"height": 880,
"content": "🔧 SETUP REQUIREMENTS\n━━━━━━━━━━━━━━━━━━━━\n\n📋 Google Sheet: Update spreadsheet ID\n🔍 Serper API: Search engine credentials\n🕷️ Oxylabs: Web scraping proxy service\n\n📝 Sheet Structure Required:\n- domain column (input)\n- processed column (tracking)\n- Multiple output columns for company data\n\n🔐 All API credentials must be configured"
},
"typeVersion": 1
},
{
"id": "8dd2282f-ec88-42ca-9f12-d86202b9adc9",
"name": "Notiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
-240
],
"parameters": {
"color": 4,
"width": 864,
"height": 880,
"content": "🔍 SEARCH STRATEGY\n━━━━━━━━━━━━━━━━━\n\n🎯 Query Format:\n\"where is {domain} Czech Republic headquarter? site:zoominfo.com\"\n[You can update the query as per your need]\n\n✅ Success Path: Found ZoomInfo results\n❌ No Results: Mark as processed, skip to next\n\n🔄 Rate limiting prevents API abuse"
},
"typeVersion": 1
},
{
"id": "6e11fb54-7e54-433f-9cdb-9e94616eede1",
"name": "Notiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
656,
-240
],
"parameters": {
"color": 6,
"width": 624,
"height": 880,
"content": "📊 DATA EXTRACTION\n━━━━━━━━━━━━━━━━━━\n\n🕷️ Oxylabs: Bypasses anti-scraping protection \n📄 Target: #ng-state JSON data element\n🔧 Parsing: Extracts pageData from JSON\n\n📋 Extracted Fields:\n- Company name, address, phone\n- Revenue, employees, industry\n- LinkedIn URL and location details"
},
"typeVersion": 1
},
{
"id": "4a275527-b722-47ea-99df-dde7206d080a",
"name": "Notiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1296,
-240
],
"parameters": {
"color": 3,
"width": 736,
"height": 880,
"content": "⚠️ ERROR HANDLING\n━━━━━━━━━━━━━━━━━━\n\n🔄 Continue on Error: Workflow won't stop\n✅ Always Mark Processed: Prevents infinite loops\n⏱️ Rate Limiting: Prevents API blocking\n\n🚨 If scraping fails:\n- Domain still marked as processed\n- Move to next domain automatically"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"6e9e0196-34b7-42ef-9cea-0ee2f29126d9": {
"main": [
[
{
"node": "f89efbed-6317-4875-9e70-829a9a4634ba",
"type": "main",
"index": 0
}
]
]
},
"16d10906-533b-4c3a-981b-7cfec0c11814": {
"main": [
[
{
"node": "4b6515e0-4b48-475a-a4e8-2bacbb4ea754",
"type": "main",
"index": 0
}
]
]
},
"2d0e61ec-65ee-4cee-b8c7-bc2b173f6987": {
"main": [
[
{
"node": "c5c398e4-7476-4636-913c-8489f0612af3",
"type": "main",
"index": 0
}
]
]
},
"b38d94e0-1fc5-4f44-8a4d-e2c363f94c44": {
"main": [
[],
[
{
"node": "240a748e-f3d7-47cd-b97e-6d1a31c366c1",
"type": "main",
"index": 0
}
]
]
},
"bd7c4539-0f42-4b66-adb8-efd64638866e": {
"main": [
[
{
"node": "94931e87-9169-48f8-805d-118167195043",
"type": "main",
"index": 0
}
]
]
},
"c5c398e4-7476-4636-913c-8489f0612af3": {
"main": [
[
{
"node": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
"type": "main",
"index": 0
}
]
]
},
"41618147-b735-4a30-83d8-2a8a5f813fc4": {
"main": [
[
{
"node": "bd7c4539-0f42-4b66-adb8-efd64638866e",
"type": "main",
"index": 0
}
]
]
},
"94931e87-9169-48f8-805d-118167195043": {
"main": [
[
{
"node": "2d0e61ec-65ee-4cee-b8c7-bc2b173f6987",
"type": "main",
"index": 0
}
]
]
},
"f89efbed-6317-4875-9e70-829a9a4634ba": {
"main": [
[
{
"node": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
"type": "main",
"index": 0
}
]
]
},
"4b6515e0-4b48-475a-a4e8-2bacbb4ea754": {
"main": [
[
{
"node": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
"type": "main",
"index": 0
}
]
]
},
"538ae1c4-e301-4ad1-9be8-0ab40b371068": {
"main": [
[
{
"node": "2d392b3b-0886-49a9-a69e-d0b2f455c613",
"type": "main",
"index": 0
}
],
[
{
"node": "16d10906-533b-4c3a-981b-7cfec0c11814",
"type": "main",
"index": 0
}
]
]
},
"240a748e-f3d7-47cd-b97e-6d1a31c366c1": {
"main": [
[
{
"node": "538ae1c4-e301-4ad1-9be8-0ab40b371068",
"type": "main",
"index": 0
}
]
]
},
"dd4bb8af-1d6f-414f-badd-93d6a4dc7202": {
"main": [
[
{
"node": "41618147-b735-4a30-83d8-2a8a5f813fc4",
"type": "main",
"index": 0
}
],
[
{
"node": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
"type": "main",
"index": 0
}
]
]
},
"2d392b3b-0886-49a9-a69e-d0b2f455c613": {
"main": [
[
{
"node": "dd4bb8af-1d6f-414f-badd-93d6a4dc7202",
"type": "main",
"index": 0
}
]
]
}
}
}Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Lead-Generierung
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
Naveen Choudhary
@n8nsteinI create AI-driven n8n workflows that turn repetitive tasks into smooth, hands-off automations. Want to explore an idea? Book a quick consult: https://cal.com/nickchoudhary/30min
Diesen Workflow teilen