Pipeline de découverte de prospects B2B Crunchbase utilisant Bright Data et OpenAI
Ceci est unSales, AIworkflow d'automatisation du domainecontenant 21 nœuds.Utilise principalement des nœuds comme Set, Function, HttpRequest, GoogleSheets, ManualTrigger, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Extraire et résumer les prospects B2B à partir de Crunchbase avec Bright Data, GPT-4o et Google Sheets
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
Nœuds utilisés (21)
Catégorie
{
"id": "pexxaVEwqIYmTXud",
"meta": {
"instanceId": "885b4fb4a6a9c2cb5621429a7b972df0d05bb724c20ac7dac7171b62f1c7ef40",
"templateCredsSetupCompleted": true
},
"name": "Crunchbase B2B Lead Discovery Pipeline with Bright Data & OpenAI",
"tags": [
{
"id": "Kujft2FOjmOVQAmJ",
"name": "Engineering",
"createdAt": "2025-04-09T01:31:00.558Z",
"updatedAt": "2025-04-09T01:31:00.558Z"
},
{
"id": "ZOwtAMLepQaGW76t",
"name": "Building Blocks",
"createdAt": "2025-04-13T15:23:40.462Z",
"updatedAt": "2025-04-13T15:23:40.462Z"
},
{
"id": "ddPkw7Hg5dZhQu2w",
"name": "AI",
"createdAt": "2025-04-13T05:38:08.053Z",
"updatedAt": "2025-04-13T05:38:08.053Z"
}
],
"nodes": [
{
"id": "7ed032ae-3f0c-4666-be5f-fbe5acf109a6",
"name": "Lors du clic sur 'Tester le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1700,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "592205af-c46a-45c3-8662-6bdae78b6465",
"name": "Définir l'URL et la Zone Bright Data",
"type": "n8n-nodes-base.set",
"position": [
-1480,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3aedba66-f447-4d7a-93c0-8158c5e795f9",
"name": "url",
"type": "string",
"value": "https://www.crunchbase.com/organization/stripe"
},
{
"id": "4e7ee31d-da89-422f-8079-2ff2d357a0ba",
"name": "zone",
"type": "string",
"value": "web_unlocker1"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "01126593-b23e-4a85-b09e-d6f10dac5a76",
"name": "Effectuer une Requête Web Bright Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1260,
-80
],
"parameters": {
"url": "https://api.brightdata.com/request",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "zone",
"value": "={{ $json.zone }}"
},
{
"name": "url",
"value": "={{ $json.url }}"
},
{
"name": "format",
"value": "raw"
},
{
"name": "data_format",
"value": "markdown"
}
]
},
"genericAuthType": "httpHeaderAuth",
"headerParameters": {
"parameters": [
{}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "kdbqXuxIR8qIxF7y",
"name": "Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "f716c1e6-0001-4cbf-a5a5-78509d02d55e",
"name": "Extracteur de Données Textuelles depuis Markdown",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
-1040,
-80
],
"parameters": {
"text": "=You need to analyze the below markdown and convert to textual data. Please do not output with your own thoughts. Make sure to output with textual data only with no links, scripts, css etc.\n\n{{ $json.data }}",
"messages": {
"messageValues": [
{
"message": "You are a markdown expert"
}
]
},
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "5e54e7e9-b0d1-41a9-a828-f94c852b7b20",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-220,
80
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "output",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "output",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"Structured Data"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15JBt1NjWELZVwcCAaD8B4JwjOojPf-HJ4D_F68etiOo/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15JBt1NjWELZVwcCAaD8B4JwjOojPf-HJ4D_F68etiOo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15JBt1NjWELZVwcCAaD8B4JwjOojPf-HJ4D_F68etiOo/edit?usp=drivesdk",
"cachedResultName": "B2B Discovery"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Zjoxh2BUZ6VXGQhA",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "f71f7108-7439-458d-80eb-1ca96c8f621a",
"name": "Analyseur de Sortie Structurée",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-400,
500
],
"parameters": {
"jsonSchemaExample": "{\n \"organization\": {\n \"name\": \"string\",\n \"about\": \"string\",\n \"headquartersLocation\": \"string\",\n \"headquartersRegions\": \"string\",\n \"numberOfEmployees\": \"string\",\n \"lastFundingType\": \"string\",\n \"ipoStatus\": \"string\",\n \"website\": \"string\",\n \"cbRankCompany\": \"string\",\n \"totalAcquisitions\": \"integer\",\n \"totalInvestmentsMade\": \"integer\",\n \"totalCrunchbaseContacts\": \"integer\",\n \"totalEmployeeProfiles\": \"integer\",\n \"industries\": [\"string\"],\n \"foundedDate\": \"string\",\n \"founders\": [\"string\"],\n \"operatingStatus\": \"string\",\n \"legalName\": \"string\",\n \"relatedHubs\": [\"string\"],\n \"hubTags\": [\"string\"],\n \"companyType\": \"string\",\n \"contactEmail\": \"string\",\n \"phoneNumber\": \"string\",\n \"recentNews\": [\n {\n \"date\": \"string\",\n \"source\": \"string\",\n \"title\": \"string\"\n }\n ],\n \"productsAndServices\": [\n {\n \"productName\": \"string\",\n \"productDescription\": \"string\"\n }\n ],\n \"listsFeaturingThisCompany\": [\n {\n \"listName\": \"string\",\n \"numberOfOrganizations\": \"string\",\n \"totalFundingAmount\": \"string\",\n \"numberOfInvestors\": \"string\"\n }\n ]\n }\n}\n"
},
"typeVersion": 1.2
},
{
"id": "3ec3c998-c674-45c8-bcbb-6a9e382e25aa",
"name": "Extracteur de Données Structurées",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
-580,
280
],
"parameters": {
"text": "=Extract the structured info from the below content.\n\nHere's the Content: {{ $json.text }}",
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "3a9d7bb0-e63a-454f-86f1-cf86379255b9",
"name": "Créer des données binaires pour la Synthèse",
"type": "n8n-nodes-base.function",
"position": [
-220,
-320
],
"parameters": {
"functionCode": "items[0].binary = {\n data: {\n data: new Buffer(JSON.stringify(items[0].json, null, 2)).toString('base64')\n }\n};\nreturn items;"
},
"typeVersion": 1
},
{
"id": "029bb734-b422-43bb-96da-a8a47e22dc49",
"name": "Créer des données binaires pour l'Extraction de Données Structurées",
"type": "n8n-nodes-base.function",
"position": [
-220,
280
],
"parameters": {
"functionCode": "items[0].binary = {\n data: {\n data: new Buffer(JSON.stringify(items[0].json, null, 2)).toString('base64')\n }\n};\nreturn items;"
},
"typeVersion": 1
},
{
"id": "9e9cc726-9004-4ca0-bc0f-a20f7c2ed2a1",
"name": "Écrire le contenu synthétisé sur le disque",
"type": "n8n-nodes-base.readWriteFile",
"position": [
0,
-320
],
"parameters": {
"options": {},
"fileName": "=d:\\Crunchbase-Summary.json",
"operation": "write"
},
"typeVersion": 1
},
{
"id": "a9736eb9-8b01-40fd-b856-5a6311e007d3",
"name": "Écrire le contenu structuré sur le disque",
"type": "n8n-nodes-base.readWriteFile",
"position": [
0,
280
],
"parameters": {
"options": {},
"fileName": "=d:\\Crunchbase-Summary.json",
"operation": "write"
},
"typeVersion": 1
},
{
"id": "481b2c05-76c8-424f-9f7c-c172428dc865",
"name": "Déclencher une Notification Webhook pour les données extraites",
"type": "n8n-nodes-base.httpRequest",
"position": [
-220,
480
],
"parameters": {
"url": "https://webhook.site/7b5380a0-0544-48dc-be43-0116cb2d52c2",
"options": {},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "summary",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "0b94f3f7-5961-43c6-a092-19662581430d",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1720,
-420
],
"parameters": {
"width": 400,
"height": 300,
"content": "## Note\n\nDeals with the Crunchbase B2B Lead Discovery by utilizing the Bright Data Web Unlocker Product.\n\n**Please make sure to set the crunch base URL with the Bright Data zone name. Also update the Webhook Notification URL of your interest**\n\n**Please make sure to update the Google Sheets node credentials with your account**"
},
"typeVersion": 1
},
{
"id": "2bd7450f-9e3e-4df9-9a22-f6a5db2ea7bf",
"name": "Note adhésive 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
-420
],
"parameters": {
"width": 480,
"height": 300,
"content": "## LLM Usages\n\nOpenAI GPT 4o model is being used.\n\nBasic LLM Chain for converting the markdown to textual content. Also perform the structured data extraction.\n\nSummarization Chain is being used for creating a summary of the extracted Crunchbase textual content."
},
"typeVersion": 1
},
{
"id": "c5246dc6-ce52-45c2-886c-1898508f71d8",
"name": "Synthétiser le contenu",
"type": "@n8n/n8n-nodes-langchain.chainSummarization",
"position": [
-600,
-420
],
"parameters": {
"options": {},
"chunkingMode": "advanced"
},
"typeVersion": 2
},
{
"id": "388023f6-710b-468c-a7c3-593818cfa87c",
"name": "Note adhésive 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
20
],
"parameters": {
"color": 6,
"width": 860,
"height": 660,
"content": "## Structured Data Extract"
},
"typeVersion": 1
},
{
"id": "38ccdc64-6d2f-4581-94d2-751095f39e48",
"name": "Note adhésive 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-520
],
"parameters": {
"color": 4,
"width": 860,
"height": 480,
"content": "## Summarization"
},
"typeVersion": 1
},
{
"id": "8e159838-7c02-4f54-b56a-885f5912a384",
"name": "Note adhésive 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1720,
-880
],
"parameters": {
"color": 7,
"width": 400,
"height": 400,
"content": "## Logo\n\n\n\n"
},
"typeVersion": 1
},
{
"id": "f4541bbd-d1e8-430d-8ee1-aea78db73eb8",
"name": "Modèle de Chat OpenAI",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-1020,
140
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "vPKynKbDzJ5ZU4cU",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "072ee9ed-f24a-4bf8-b23a-4d26d74ba6c8",
"name": "Modèle de Chat OpenAI 1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-560,
-200
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "vPKynKbDzJ5ZU4cU",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "fa17f3f4-54cc-4e28-93ac-67c5d120a6da",
"name": "Modèle de Chat OpenAI 2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-580,
480
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "vPKynKbDzJ5ZU4cU",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "675b44fd-e258-4f63-9d6b-c40a25c3bf19",
"connections": {
"5e54e7e9-b0d1-41a9-a828-f94c852b7b20": {
"main": [
[]
]
},
"f4541bbd-d1e8-430d-8ee1-aea78db73eb8": {
"ai_languageModel": [
[
{
"node": "f716c1e6-0001-4cbf-a5a5-78509d02d55e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"072ee9ed-f24a-4bf8-b23a-4d26d74ba6c8": {
"ai_languageModel": [
[
{
"node": "c5246dc6-ce52-45c2-886c-1898508f71d8",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"fa17f3f4-54cc-4e28-93ac-67c5d120a6da": {
"ai_languageModel": [
[
{
"node": "3ec3c998-c674-45c8-bcbb-6a9e382e25aa",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"c5246dc6-ce52-45c2-886c-1898508f71d8": {
"main": [
[
{
"node": "3a9d7bb0-e63a-454f-86f1-cf86379255b9",
"type": "main",
"index": 0
}
]
]
},
"f71f7108-7439-458d-80eb-1ca96c8f621a": {
"ai_outputParser": [
[
{
"node": "3ec3c998-c674-45c8-bcbb-6a9e382e25aa",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"3ec3c998-c674-45c8-bcbb-6a9e382e25aa": {
"main": [
[
{
"node": "5e54e7e9-b0d1-41a9-a828-f94c852b7b20",
"type": "main",
"index": 0
},
{
"node": "029bb734-b422-43bb-96da-a8a47e22dc49",
"type": "main",
"index": 0
},
{
"node": "481b2c05-76c8-424f-9f7c-c172428dc865",
"type": "main",
"index": 0
}
]
]
},
"592205af-c46a-45c3-8662-6bdae78b6465": {
"main": [
[
{
"node": "01126593-b23e-4a85-b09e-d6f10dac5a76",
"type": "main",
"index": 0
}
]
]
},
"01126593-b23e-4a85-b09e-d6f10dac5a76": {
"main": [
[
{
"node": "f716c1e6-0001-4cbf-a5a5-78509d02d55e",
"type": "main",
"index": 0
}
]
]
},
"7ed032ae-3f0c-4666-be5f-fbe5acf109a6": {
"main": [
[
{
"node": "592205af-c46a-45c3-8662-6bdae78b6465",
"type": "main",
"index": 0
}
]
]
},
"f716c1e6-0001-4cbf-a5a5-78509d02d55e": {
"main": [
[
{
"node": "c5246dc6-ce52-45c2-886c-1898508f71d8",
"type": "main",
"index": 0
},
{
"node": "3ec3c998-c674-45c8-bcbb-6a9e382e25aa",
"type": "main",
"index": 0
}
]
]
},
"3a9d7bb0-e63a-454f-86f1-cf86379255b9": {
"main": [
[
{
"node": "9e9cc726-9004-4ca0-bc0f-a20f7c2ed2a1",
"type": "main",
"index": 0
}
]
]
},
"029bb734-b422-43bb-96da-a8a47e22dc49": {
"main": [
[
{
"node": "a9736eb9-8b01-40fd-b856-5a6311e007d3",
"type": "main",
"index": 0
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Ventes, Intelligence Artificielle
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Ranjan Dailata
@ranjancseA Human Agent based out of India specialized in handling AI-powered automations. For business enquiries, send me an email at ranjancse@gmail.com LinkedIn: [https://www.linkedin.com/in/ranjan-dailata/](https://www.linkedin.com/in/ranjan-dailata/)
Partager ce workflow