Workflow n8n
ProspectLens : recherche auto d'entreprises
Workflow n8n prêt à l'emploi pour transformer vos listes en prospects qualifiés. Il orchestre Google Sheets, Cal.com et Splitinbatches pour enrichir, filtrer et planifier des RDV automatiquement, tout en respectant les bonnes pratiques de sécurité et de gestion d'erreurs. Idéal pour les équipes growth et les fondateurs qui veulent scaler la qualification sans embauche. Tags clés : n8n, prospection, scraping.
Catégorie: prospection · Tags: n8n, prospection, scraping, automation❤ 0
Vue d'ensemble du workflow n8n
Schéma des nœuds et connexions de ce workflow n8n, généré à partir du JSON n8n.
Inscris-toi pour voir l'intégralité du workflow
Inscription gratuite
S'inscrire gratuitementBesoin d'aide ?{
"metadata": {
"id": 1924,
"name": "ProspectLens company research",
"rank": -6.960842963462477,
"tags": [
"automation",
"n8n",
"production-ready",
"excellent",
"optimized"
],
"active": 0,
"filename": "2006_Filter_Manual_Automation_Webhook.json",
"file_hash": "60136c42c4ecc69546a117a47df9f02f",
"file_size": 13760,
"complexity": "medium",
"created_at": "",
"node_count": 7,
"updated_at": "",
"analyzed_at": "2026-01-07 21:25:07",
"description": "Automated workflow: ProspectLens company research. This workflow integrates 7 different services: filter, stickyNote, httpRequest, stopAndError, manualTrigger. It contains 11 nodes and follows best practices for error handling and security.",
"workflow_id": "wwvUsosYUyMfpGbB",
"integrations": [
"Google Sheets",
"Cal.com",
"Splitinbatches"
],
"trigger_type": "Manual"
},
"raw_json": {
"id": "wwvUsosYUyMfpGbB",
"meta": {
"owner": "n8n-user",
"status": "active",
"license": "MIT",
"category": "automation",
"priority": "high",
"createdAt": "2025-09-29T07:07:44.906539",
"updatedAt": "2025-09-29T07:07:44.906560",
"versionId": "1.0.0",
"instanceId": "workflow-82c3e5fd",
"environment": "production"
},
"name": "ProspectLens company research",
"tags": [
"automation",
"n8n",
"production-ready",
"excellent",
"optimized"
],
"nodes": [
{
"id": "fd68acdf-ed1e-4f69-a046-fcdaa626acca",
"name": "When clicking ‘Test workflow’",
"type": "n8n-nodes-base.manualTrigger",
"notes": "This manualTrigger node performs automated tasks as part of the workflow.",
"position": [
720,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d4e4875a-e41f-4248-937a-a4658c23eb5e",
"name": "Filter",
"type": "n8n-nodes-base.filter",
"notes": "Only process rows which have empty processed_at field",
"position": [
1160,
400
],
"parameters": {
"options": {
"looseTypeValidation": true
},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "5aca0836-4797-41d3-8094-f3a170e5a3c9",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.processed_at }}",
"rightValue": ""
}
]
}
},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "e12c1846-dd38-414c-8e2e-8d0834ad8668",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"notes": "This stickyNote node performs automated tasks as part of the workflow.",
"position": [
880,
20
],
"parameters": {
"width": 725,
"height": 316.25,
"content": "## Company research via Google Sheets and ProspectLens\n\nGet your API key:\n{{ $env.API_BASE_URL }}\n\nCopy Google Sheet template:\n{{ $env.WEBHOOK_URL }}"
},
"typeVersion": 1
},
{
"id": "b0385041-92c4-41a4-b0e8-9f2a7cc6fd56",
"name": "Save company data into Sheets",
"type": "n8n-nodes-base.googleSheets",
"notes": "This googleSheets node performs automated tasks as part of the workflow.",
"position": [
2000,
380
],
"parameters": {
"columns": {
"value": {
"data": "={{ JSON.stringify($json.data).substr(0, 2000) }}",
"name": "={{ $json.data.properties.title }}",
"funds": "={{ $json.data.info.funding_rounds_summary.funding_total.value }}",
"domain": "={{ $('Filter').item.json.domain }}",
"traffic": "={{ $json.data.info.semrush_summary.semrush_visits_latest_month }}",
"location": "={{ $json.data.info.semrush_location_list[0].location_identifiers[0].value }}",
"description": "={{ $json.data.properties.short_description }}",
"domain_name": "={{ $json.data.info.company_about_fields.website.hostname }}",
"processed_at": "={{ (new Date).toISOString() }}",
"year_founded": "={{ $json.data.info.overview_fields_extended.founded_on.value }}",
"funding_round": "={{ $json.data.info.funding_rounds_summary.last_funding_type }}",
"last_funding_at": "={{ $json.data.info.funding_rounds_summary.last_funding_at }}"
},
"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": "processed_at",
"type": "string",
"display": true,
"required": false,
"displayName": "processed_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "data",
"type": "string",
"display": true,
"required": false,
"displayName": "data",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain_name",
"type": "string",
"display": true,
"required": false,
"displayName": "domain_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "traffic",
"type": "string",
"display": true,
"required": false,
"displayName": "traffic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funds",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "funds",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "year_founded",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "year_founded",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_round",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "funding_round",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_funding_at",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "last_funding_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"domain"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "{{ $env.WEBHOOK_URL }}",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1X2hKT8cD6fTQUdALg91EwQDCM58YNY4pHe-7rmESzlk",
"cachedResultUrl": "{{ $env.WEBHOOK_URL }}",
"cachedResultName": "n8n_prospectlens"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "vowsrhMIxy2PRDbH",
"name": "Google Sheets account"
}
},
"typeVersion": 4.4
},
{
"id": "e048f8d0-57c2-43ac-bedf-1a517b203df3",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"notes": "Used to keep low concurrency (1 thread)",
"position": [
1400,
380
],
"parameters": {
"options": {}
},
"notesInFlow": true,
"typeVersion": 3
},
{
"id": "b6898b5e-dba5-425d-8f9b-d996dcb6cff2",
"name": "ProspectLens API call",
"type": "n8n-nodes-base.httpRequest",
"notes": "ProspectLens API",
"onError": "continueErrorOutput",
"maxTries": 2,
"position": [
1680,
380
],
"parameters": {
"url": "{{ $env.BASE_URL }}",
"options": {
"response": {
"response": {}
}
},
"authentication": "{{ $credentials.genericCredentialType }}",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "tcCkO83Qn399Hizf",
"name": "APIRoad auth"
}
},
"notesInFlow": true,
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "4c625e34-728c-49ae-8e22-4b4a343354cb",
"name": "Get all rows from Sheets",
"type": "n8n-nodes-base.googleSheets",
"notes": "This googleSheets node performs automated tasks as part of the workflow.",
"position": [
940,
400
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "{{ $env.WEBHOOK_URL }}",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1X2hKT8cD6fTQUdALg91EwQDCM58YNY4pHe-7rmESzlk",
"cachedResultUrl": "{{ $env.WEBHOOK_URL }}",
"cachedResultName": "n8n_prospectlens"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "vowsrhMIxy2PRDbH",
"name": "Google Sheets account"
}
},
"typeVersion": 4.4
}
],
"notes": "Excellent quality workflow: ProspectLens company research. This workflow has been optimized for production use with comprehensive error handling, security, and documentation.",
"active": false,
"pinData": {},
"settings": {
"timezone": "UTC",
"retryCount": 3,
"retryDelay": 1000,
"retryOnFail": true,
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": null,
"maxExecutions": 1000,
"executionOrder": "v1",
"executionTimeout": 3600,
"saveManualExecutions": true
},
"versionId": "ea844f9f-c06e-4a0c-98db-a670709c2025",
"connections": {
"4c625e34-728c-49ae-8e22-4b4a343354cb": {
"main": [
[
{
"node": "error-handler-4c625e34-728c-49ae-8e22-4b4a343354cb-73f6ff08",
"type": "main",
"index": 0
}
]
]
},
"b0385041-92c4-41a4-b0e8-9f2a7cc6fd56": {
"main": [
[
{
"node": "error-handler-b0385041-92c4-41a4-b0e8-9f2a7cc6fd56-a85c0966",
"type": "main",
"index": 0
}
]
]
},
"b6898b5e-dba5-425d-8f9b-d996dcb6cff2": {
"main": [
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2",
"type": "main",
"index": 0
}
],
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-edc74dae",
"type": "main",
"index": 0
}
],
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-e874db6c",
"type": "main",
"index": 0
}
],
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-5eec2d3f",
"type": "main",
"index": 0
}
],
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-dfec4d35",
"type": "main",
"index": 0
}
],
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-9289e9e2",
"type": "main",
"index": 0
}
],
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-356250dd",
"type": "main",
"index": 0
}
],
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-d6ded6ce",
"type": "main",
"index": 0
}
],
[
{
"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-c3fb2266",
"type": "main",
"index": 0
}
]
]
}
},
"description": "Automated workflow: ProspectLens company research. This workflow integrates 7 different services: filter, stickyNote, httpRequest, stopAndError, manualTrigger. It contains 11 nodes and follows best practices for error handling and security."
}
}