Bright Data und OpenAI für die Crunchbase B2B-Kundenfindungspipeline

Experte

Dies ist ein Sales, AI-Bereich Automatisierungsworkflow mit 21 Nodes. Hauptsächlich werden Set, Function, HttpRequest, GoogleSheets, ManualTrigger und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Extrahieren und Zusammenfassen von B2B-Leads aus Crunchbase mit Bright Data, GPT-4o und Google Sheets

Voraussetzungen
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • Google Sheets API-Anmeldedaten
  • OpenAI API Key
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "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": "Bei Klick auf 'Workflow testen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1700,
        -80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "592205af-c46a-45c3-8662-6bdae78b6465",
      "name": "URL und Bright Data Zone setzen",
      "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": "Bright Data Webanfrage durchführen",
      "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": "Markdown zu Textdaten Extraktor",
      "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": "Strukturierter Ausgabe Parser",
      "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": "Strukturierter Daten Extraktor",
      "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": "Binärdaten für Zusammenfassung erstellen",
      "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": "Binärdaten für strukturierte Extraktion erstellen",
      "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": "Zusammengefassten Inhalt auf Festplatte schreiben",
      "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": "Strukturierte Inhalte auf Festplatte schreiben",
      "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": "Webhook Benachrichtigung für extrahierte Daten auslösen",
      "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": "Haftnotiz",
      "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": "Haftnotiz1",
      "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": "Inhalt zusammenfassen",
      "type": "@n8n/n8n-nodes-langchain.chainSummarization",
      "position": [
        -600,
        -420
      ],
      "parameters": {
        "options": {},
        "chunkingMode": "advanced"
      },
      "typeVersion": 2
    },
    {
      "id": "388023f6-710b-468c-a7c3-593818cfa87c",
      "name": "Haftnotiz2",
      "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": "Haftnotiz3",
      "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": "Haftnotiz4",
      "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": "OpenAI Chat Model",
      "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": "OpenAI Chat Model1",
      "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": "OpenAI Chat Model2",
      "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
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

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 - Vertrieb, Künstliche Intelligenz

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

Automatisierter Lebenslauf-Job-Matching-Engine mit Bright Data und OpenAI 4o mini
Die automatische Job-Matching-Engine für Lebensläufe von Bright Data MCP und OpenAI 4o mini
Set
Function
Split Out
+
Set
Function
Split Out
22 NodesRanjan Dailata
Personalwesen
DNB-Unternehmenssuche und -extraktion mit Bright Data und OpenAI 4o mini
DNB-Unternehmenssuche und -extraktion auf Basis von Bright Data und OpenAI 4o mini
Set
Function
Mcp Client
+
Set
Function
Mcp Client
18 NodesRanjan Dailata
Produkt
KI-Agenten-gesteuerte ProductHunt-Datenextraktion und -suche (mit Bright Data und Google Gemini)
Extrahieren und Suchen von ProductHunt-Daten mit Bright Data MCP und Google Gemini AI
Set
Function
Mcp Client
+
Set
Function
Mcp Client
21 NodesRanjan Dailata
Künstliche Intelligenz
Brave Suche strukturierte Datenextraktion (Bright Data MCP + Google Gemini)
Extraktion von strukturierten Daten aus Brave Search mit Bright Data MCP und Google Gemini
Set
Switch
Function
+
Set
Switch
Function
24 NodesRanjan Dailata
Künstliche Intelligenz
Markeninhalte mit Bright Data extrahieren, zusammenfassen und Sentiment-Analyse durchführen
Extrahierung und Analyse von Markeninhalten mit Bright Data und Google Gemini
Set
Function
Http Request
+
Set
Function
Http Request
23 NodesRanjan Dailata
Künstliche Intelligenz
Bright Data zur Extraktion, Zusammenfassung und Analyse von Amazon-Preissenkungen nutzen
Extrahieren, Zusammenfassen und Analysieren von Amazon-Preissenkungen mit Bright Data und Google Gemini
Set
Wait
Merge
+
Set
Wait
Merge
26 NodesRanjan Dailata
Künstliche Intelligenz
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes21
Kategorie2
Node-Typen11
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

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

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34