Enriquecimiento de datos de empresas con ZoomInfo, Serper y Oxylabs a Google Sheets
Este es unLead Generationflujo de automatización del dominio deautomatización que contiene 19 nodos.Utiliza principalmente nodos como If, Code, Html, Wait, HttpRequest. Automatización del enriquecimiento de datos de empresas en Google Sheets con ZoomInfo, Serper y Oxylabs
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
Nodos utilizados (19)
Categoría
{
"meta": {
"instanceId": "aff7017841e089b12fdff439d182db1ce6e6151977703d9243f6be0543724481",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "6e9e0196-34b7-42ef-9cea-0ee2f29126d9",
"name": "Activador Manual",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-864,
464
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f89efbed-6317-4875-9e70-829a9a4634ba",
"name": "Cargar Dominios No Procesados",
"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": "Procesar Cada Dominio",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-416,
464
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "240a748e-f3d7-47cd-b97e-6d1a31c366c1",
"name": "Buscar en ZoomInfo vía Serper",
"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": "Verificar Resultados de Búsqueda Encontrados",
"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": "Extraer Dominio y URL de ZoomInfo",
"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": "Validar Coincidencia de Dominio",
"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": "Raspar Página de ZoomInfo",
"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": "Extraer Datos de la Empresa",
"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": "Analizar Información de Empresa JSON",
"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": "Guardar Detalles de la Empresa",
"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": "Marcar Dominio como Procesado",
"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": "Retraso por Límite de Tasa",
"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": "Retraso de Procesamiento",
"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": "Nota Adhesiva",
"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": "Nota Adhesiva1",
"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": "Nota Adhesiva2",
"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": "Nota Adhesiva3",
"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": "Nota Adhesiva4",
"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
}
]
]
}
}
}¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Generación de leads
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
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
Compartir este flujo de trabajo