Bright Data、Gemini AI、Google Sheetsを使用したキーワード別Crunchbaseスタートアップ分析
中級
これはAI, Marketing分野の自動化ワークフローで、13個のノードを含みます。主にIf, Code, Wait, Merge, FormTriggerなどのノードを使用、AI技術を活用したスマート自動化を実現。 Bright Data、Gemini AI、Google Sheetsを使ってキーワード別にCrunchbaseのスタートアップ企業を分析
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •Google Gemini API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "71eb5622cf8abac565805540c0900dbae437dddbda45bf1b87bf3bfeea26393c"
},
"nodes": [
{
"id": "03a69683-ae41-4457-a067-f8eb3070e6cc",
"name": "スナップショット進捗",
"type": "n8n-nodes-base.httpRequest",
"position": [
-120,
-220
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/progress/{{ $('HTTP Request- Post API call to Bright Data').item.json.snapshot_id }}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer YOUR_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "042743bc-4a3a-4be7-87d2-5a0d7327b2aa",
"name": "HTTP リクエスト - Bright DataへのAPI呼び出しをPOST",
"type": "n8n-nodes-base.httpRequest",
"position": [
-620,
40
],
"parameters": {
"url": "https://api.brightdata.com/datasets/v3/trigger",
"method": "POST",
"options": {},
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "keyword",
"value": "={{ $json[\"Keyword\"] }}"
}
]
},
"queryParameters": {
"parameters": [
{
"name": "dataset_id",
"value": "gd_l1vijqt9jfj7olije"
},
{
"name": "type",
"value": "discover_new"
},
{
"name": "discover_by",
"value": "keyword"
},
{
"name": "include_errors",
"value": "true"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer YOUR_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "4ae4d5a0-b266-4620-ae74-1230a1622437",
"name": "待機 - Bright Dataのポーリング",
"type": "n8n-nodes-base.wait",
"position": [
-340,
-220
],
"webhookId": "8005a2b3-2195-479e-badb-d90e4240e699",
"parameters": {
"amount": 15
},
"executeOnce": false,
"typeVersion": 1.1
},
{
"id": "fdd36a29-ee46-4737-892c-a8095db01233",
"name": "条件分岐 - スナップショットのステータス確認（データ準備完了可否）",
"type": "n8n-nodes-base.if",
"position": [
100,
-220
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7932282b-71bb-4bbb-ab73-4978e554de7e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "running"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6ef4e903-ef2d-4b0d-921b-30e848ad7590",
"name": "HTTP リクエスト - Bright Dataからのデータ取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
320,
-220
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }}",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer YOUR_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "5686b066-2f14-4aa9-bfd0-834f02e514c7",
"name": "コード - JSONデータの解析とクリーニング",
"type": "n8n-nodes-base.code",
"position": [
540,
-220
],
"parameters": {
"language": "python",
"pythonCode": "from datetime import datetime\n\nall_companies = _input.all()\n\nvalid_companies = []\nfor item in all_companies:\n company = item.json\n date_str = company.get(\"founded_date\")\n try:\n date = datetime.strptime(date_str, \"%Y-%m-%d\")\n valid_companies.append((date, company))\n except (TypeError, ValueError):\n continue\n\nsorted_companies = sorted(valid_companies, key=lambda x: x[0], reverse=True)\n\ncleaned = []\nfor _, c in sorted_companies[:10]:\n founders = c.get(\"founders\") or []\n products = c.get(\"products_and_services\") or []\n financials = c.get(\"financials_highlights\") or {}\n\n cleaned.append({\n \"name\": c.get(\"name\"),\n \"founded\": c.get(\"founded_date\"),\n \"about\": c.get(\"about\"),\n \"num_employees\": c.get(\"num_employees\"),\n \"type\": c.get(\"type\"),\n \"ipo_status\": c.get(\"ipo_status\"),\n \"full_description\": c.get(\"full_description\", \"\"),\n \"monthly_visits\": c.get(\"monthly_visits\"),\n \"social_media_links\": c.get(\"social_media_links\", []),\n \"website\": c.get(\"website\"),\n \"address\": c.get(\"address\"),\n \"funding_total\": financials.get(\"funding_total\"),\n \"num_investors\": c.get(\"num_investors\") or financials.get(\"num_investors\"),\n \"lead_investors\": financials.get(\"num_lead_investors\"),\n \"founders\": \", \".join([p.get(\"value\") for p in founders if p.get(\"value\")]),\n \"products_and_services\": \", \".join([p.get(\"product_name\") for p in products if p.get(\"product_name\")]),\n \"crunchbase_link\": c.get(\"url\"),\n \"ai_analysis\": \"\"\n })\n\nreturn [{\n \"json\": {\n \"companies\": cleaned\n }\n}]\n"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "29f39c43-e688-43de-b249-5407abd3ff50",
"name": "付箋ノート",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-400
],
"parameters": {
"content": "## Note \nModify the JSON keys in the code to include only the fields you want. The current structure is a sample template"
},
"typeVersion": 1
},
{
"id": "29b00dad-9e5d-45fd-87ad-0c1a6659bfcd",
"name": "Google Gemini チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
340,
220
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash"
},
"typeVersion": 1
},
{
"id": "92076574-6e30-4436-81b0-a016c47d707e",
"name": "Google Gemini - 比較分析",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
340,
40
],
"parameters": {
"text": "={{$json}}",
"messages": {
"messageValues": [
{
"message": "=You will be provided with data for companies from Crunchbase, operating in the sector (or field of interests) that user requested by [keyword].\n\nPlease perform a comparative analysis of these companies. Highlight key similarities, differences, perspectives, and any notable outliers. The [keyword] user requested initially: {{ $('When User Completes Form').first().json['Keyword']}}.\nDon't start your answer with 'Okay'."
}
]
},
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "10dacf61-006d-4821-aced-72beb4de1cf0",
"name": "ユーザーフォーム完了時",
"type": "n8n-nodes-base.formTrigger",
"position": [
-840,
40
],
"webhookId": "41d0bffa-f5ca-4df7-b757-ca5a1e472b8a",
"parameters": {
"options": {
"ignoreBots": true
},
"formTitle": "Search from Crunchbase by keyword",
"formFields": {
"values": [
{
"fieldLabel": "Keyword",
"placeholder": "e.g. \"AI in healthcare\"",
"requiredField": true
}
]
},
"responseMode": "lastNode",
"formDescription": "Please provide a keyword to search and compare relevant startups"
},
"typeVersion": 2.2
},
{
"id": "28aa3e45-bbaa-40a1-b0ec-33c81e8a1a7a",
"name": "マージ",
"type": "n8n-nodes-base.merge",
"position": [
780,
-80
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "e7da127a-864c-4957-8be9-a48229885c78",
"name": "コード - JSONとAI出力の結合",
"type": "n8n-nodes-base.code",
"position": [
1000,
-80
],
"parameters": {
"language": "python",
"pythonCode": "input_0 = _input.all(0)\ninput_1 = _input.all(1) \n\nif not input_0 or not input_1:\n raise ValueError(\"Missing input data on one of the inputs.\")\n\ncompanies = input_0[0].json.get(\"companies\")\nanalysis_text = input_1[1].json.get(\"text\")\n\nif companies:\n companies[0][\"ai_analysis\"] = analysis_text\n\nreturn [{ \"json\": company } for company in companies]\n"
},
"typeVersion": 2
},
{
"id": "60268912-b8e8-4fd9-ac86-ad5e4494e013",
"name": "Google Sheets - 結果のエクスポート",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-80
],
"parameters": {
"columns": {
"value": {
"name": "={{ $json.companies[0].name }}"
},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "founded",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "founded",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "about",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "num_employees",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "num_employees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ipo_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ipo_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "full_description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "full_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "social_media_links",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "social_media_links",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_total",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "funding_total",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "num_investors",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "num_investors",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lead_investors",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "lead_investors",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "founders",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "founders",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "products_and_services",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "products_and_services",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "crunchbase_link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "crunchbase_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "text",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "companies",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "companies",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/134y4U1gc8DvM4bPhSfOUtZhjoBvx62dTsff2P8niGAg/edit#gid=0",
"cachedResultName": "results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "134y4U1gc8DvM4bPhSfOUtZhjoBvx62dTsff2P8niGAg",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/134y4U1gc8DvM4bPhSfOUtZhjoBvx62dTsff2P8niGAg/edit?usp=drivesdk",
"cachedResultName": "Crunchbase Output"
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
}
],
"pinData": {},
"connections": {
"28aa3e45-bbaa-40a1-b0ec-33c81e8a1a7a": {
"main": [
[
{
"node": "e7da127a-864c-4957-8be9-a48229885c78",
"type": "main",
"index": 0
}
]
]
},
"03a69683-ae41-4457-a067-f8eb3070e6cc": {
"main": [
[
{
"node": "fdd36a29-ee46-4737-892c-a8095db01233",
"type": "main",
"index": 0
}
]
]
},
"29b00dad-9e5d-45fd-87ad-0c1a6659bfcd": {
"ai_languageModel": [
[
{
"node": "92076574-6e30-4436-81b0-a016c47d707e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"10dacf61-006d-4821-aced-72beb4de1cf0": {
"main": [
[
{
"node": "042743bc-4a3a-4be7-87d2-5a0d7327b2aa",
"type": "main",
"index": 0
}
]
]
},
"4ae4d5a0-b266-4620-ae74-1230a1622437": {
"main": [
[
{
"node": "03a69683-ae41-4457-a067-f8eb3070e6cc",
"type": "main",
"index": 0
}
]
]
},
"60268912-b8e8-4fd9-ac86-ad5e4494e013": {
"main": [
[]
]
},
"5686b066-2f14-4aa9-bfd0-834f02e514c7": {
"main": [
[
{
"node": "92076574-6e30-4436-81b0-a016c47d707e",
"type": "main",
"index": 0
},
{
"node": "28aa3e45-bbaa-40a1-b0ec-33c81e8a1a7a",
"type": "main",
"index": 0
}
]
]
},
"e7da127a-864c-4957-8be9-a48229885c78": {
"main": [
[
{
"node": "60268912-b8e8-4fd9-ac86-ad5e4494e013",
"type": "main",
"index": 0
}
]
]
},
"92076574-6e30-4436-81b0-a016c47d707e": {
"main": [
[
{
"node": "28aa3e45-bbaa-40a1-b0ec-33c81e8a1a7a",
"type": "main",
"index": 1
}
]
]
},
"042743bc-4a3a-4be7-87d2-5a0d7327b2aa": {
"main": [
[
{
"node": "4ae4d5a0-b266-4620-ae74-1230a1622437",
"type": "main",
"index": 0
}
]
]
},
"6ef4e903-ef2d-4b0d-921b-30e848ad7590": {
"main": [
[
{
"node": "5686b066-2f14-4aa9-bfd0-834f02e514c7",
"type": "main",
"index": 0
}
]
]
},
"fdd36a29-ee46-4737-892c-a8095db01233": {
"main": [
[
{
"node": "4ae4d5a0-b266-4620-ae74-1230a1622437",
"type": "main",
"index": 0
}
],
[
{
"node": "6ef4e903-ef2d-4b0d-921b-30e848ad7590",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 人工知能, マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Bright Data キーワードメールニュースレターとAI要約
Bright DataキーワードメールニュースレターとAI要約
If
Code
Wait
+
If
Code
Wait
13 ノードGleb D
人工知能
コンペティタ価格照会・レポートジェネレーター
Bright Dataを基にコンペティタ価格照会とレポートジェネレーター
If
Set
Code
+
If
Set
Code
19 ノードGleb D
人工知能
Twitterのプロフィール名からプロフィールを検索し、投稿をスクレイピングしてコンテンツをAIで分析し、Google Sheetsに保存
Bright DataとGeminiを使って名称でTwitterの投稿を検索・スクレイピング・分析する
If
Set
Code
+
If
Set
Code
22 ノードGleb D
人工知能
AI、ElevenLabs、マルチプラットフォーム公開を使ってPOVビデオの作成と承認
AI、ElevenLabs、そしてマルチプラットフォーム公開を使ったPOVビデオの作成と承認（TikTok/IG/YT）
If
Set
Code
+
If
Set
Code
60 ノードImmanuel
デザイン
競合企業のコンテンツ分析を通じて市場調査と SEO のコンテンツカンパスを発見
競合サイトのコンテンツ空白をInfraNodusのGraphRAGで分析し、SEOを支援
If
Code
Wait
+
If
Code
Wait
37 ノードInfraNodus
人工知能
TikTok投稿自動化エージェント V3.1
🚀 Gemini AIと自動投稿でポッドキャストをバイラルTikTokクリップに変換 ✅
If
Set
Code
+
If
Set
Code
54 ノードMateo Fiorito Rocha
デザイン
