Pipeline de découverte de prospects B2B Crunchbase utilisant Bright Data et OpenAI

Avancé

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

Prérequis
  • Peut nécessiter les informations d'identification d'authentification de l'API cible
  • Informations d'identification Google Sheets API
  • Clé API OpenAI
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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![logo](https://images.seeklogo.com/logo-png/43/1/brightdata-logo-png_seeklogo-439974.png)\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
          }
        ]
      ]
    }
  }
}
Foire aux questions

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

Moteur de correspondance automatique CV-emploi avec Bright Data et OpenAI 4o mini
Bright Data MCP与OpenAI 4o minideautomatisation简历职位匹配引擎
Set
Function
Split Out
+
Set
Function
Split Out
22 NœudsRanjan Dailata
Ressources Humaines
Recherche et extraction d'entreprises DNB avec Bright Data et OpenAI 4o mini
Recherche et extraction d'entreprises DNB avec Bright Data et OpenAI 4o mini
Set
Function
Mcp Client
+
Set
Function
Mcp Client
18 NœudsRanjan Dailata
Produit
Extraction et recherche de données ProductHunt pilotées par un agent IA (en utilisant Bright Data et Google Gemini)
Extraire et rechercher des données ProductHunt avec Bright Data MCP et Google Gemini AI
Set
Function
Mcp Client
+
Set
Function
Mcp Client
21 NœudsRanjan Dailata
Intelligence Artificielle
Extraction structurée de données de recherche Brave (Bright Data MCP + Google Gemini)
Extraire des données structurées à partir de recherches Brave avec Bright Data MCP et Google Gemini
Set
Switch
Function
+
Set
Switch
Function
24 NœudsRanjan Dailata
Intelligence Artificielle
Extraction, résumé et analyse de sentiment de contenu de marque avec Bright Data
Extraire et analyser le contenu de marque avec Bright Data et Google Gemini
Set
Function
Http Request
+
Set
Function
Http Request
23 NœudsRanjan Dailata
Intelligence Artificielle
Extraction, résumé et analyse des baisses de prix des produits Amazon avec Bright Data
utilisationBright DataetGoogle Geminiextraction、总结etanalyse亚马逊降价信息
Set
Wait
Merge
+
Set
Wait
Merge
26 NœudsRanjan Dailata
Intelligence Artificielle
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds21
Catégorie2
Types de nœuds11
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
Ranjan Dailata

Ranjan Dailata

@ranjancse

A 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/)

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34