Bright DataとOpenAIを使用したCrunchbase B2Bリード発見パイプライン
上級
これはSales, AI分野の自動化ワークフローで、21個のノードを含みます。主にSet, Function, HttpRequest, GoogleSheets, ManualTriggerなどのノードを使用、AI技術を活用したスマート自動化を実現。 Bright Data、GPT-4o、Google Sheetsを使ってCrunchbaseからB2Bリードを抽出・要約する
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (21)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定を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": "ワークフロー「テスト」クリック時",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1700,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "592205af-c46a-45c3-8662-6bdae78b6465",
"name": "URLと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": "Bright Data Webリクエストの実行",
"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からテキストデータ抽出",
"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 スプレッドシート",
"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": "構造化出力パーサー",
"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": "構造化データ抽出",
"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": "要約用バイナリデータ作成",
"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": "構造化データ抽出用バイナリデータ作成",
"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": "要約コンテンツをディスクに書き込み",
"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": "構造化コンテンツをディスクに書き込み",
"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通知を開始",
"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": "付箋",
"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": "付箋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": "コンテンツの要約",
"type": "@n8n/n8n-nodes-langchain.chainSummarization",
"position": [
-600,
-420
],
"parameters": {
"options": {},
"chunkingMode": "advanced"
},
"typeVersion": 2
},
{
"id": "388023f6-710b-468c-a7c3-593818cfa87c",
"name": "付箋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": "付箋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": "付箋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": "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": "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": "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
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 営業, 人工知能
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Bright Data と OpenAI 4o mini を使用した自動履歴書求人情報マッチングエンジン
Bright Data MCP と OpenAI 4o mini を使った自動履歴書職業マッチングエンジン
Set
Function
Split Out
+
Set
Function
Split Out
22 ノードRanjan Dailata
人事
DNB企業検索と抽出：Bright DataとOpenAI 4o miniを使用
Bright Data そして OpenAI 4o mini に基づく DNB 社検索と抽出
Set
Function
Mcp Client
+
Set
Function
Mcp Client
18 ノードRanjan Dailata
プロダクト
AIアゲント駆動のProduct Huntデータ抽出と検索（Bright DataとGoogle Geminiを使用）
Bright Data MCPとGoogle Gemini AIを使ってProduct Huntデータをクロールして検索
Set
Function
Mcp Client
+
Set
Function
Mcp Client
21 ノードRanjan Dailata
人工知能
Brave検索による構造化データ抽出（Bright Data MCP + Google Gemini）
Bright Data MCPとGoogle Geminiを使用してBrave検索から構造化されたデータを抽出
Set
Switch
Function
+
Set
Switch
Function
24 ノードRanjan Dailata
人工知能
Bright Dataを使用したブランドコンテンツの抽出・要約・感情分析
Bright DataとGoogle Geminiを使用してブランドコンテンツを抽出および分析
Set
Function
Http Request
+
Set
Function
Http Request
23 ノードRanjan Dailata
人工知能
Amazon製品の価格下落をBright Dataで抽出・要約・分析
Bright DataとGoogle GeminiでAmazonの価格下落情報を抽出・要約・分析
Set
Wait
Merge
+
Set
Wait
Merge
26 ノードRanjan Dailata
人工知能
ワークフロー情報
難易度
上級
ノード数21
カテゴリー2
ノードタイプ11
作成者
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/)
外部リンク
n8n.ioで表示 →
このワークフローを共有