Analyse von Crunchbase Startups nach Schüsselwort mit Bright Data, Gemini KI und Google Sheets
Fortgeschritten
Dies ist ein AI, Marketing-Bereich Automatisierungsworkflow mit 13 Nodes. Hauptsächlich werden If, Code, Wait, Merge, FormTrigger und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Konkurrenten-startups auf Crunchbase nach Schlüsselwörtern mit Bright Data, Gemini AI und Google Sheets analysieren
Voraussetzungen
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
- •Google Gemini API Key
Verwendete Nodes (13)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"meta": {
"instanceId": "71eb5622cf8abac565805540c0900dbae437dddbda45bf1b87bf3bfeea26393c"
},
"nodes": [
{
"id": "03a69683-ae41-4457-a067-f8eb3070e6cc",
"name": "Snapshot-Fortschritt",
"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 Anfrage - API-Aufruf an Bright Data",
"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": "Warten - Abfrage von 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": "Bedingung - Prüfung des Snapshot-Status (ob Daten bereit sind oder nicht)",
"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 Anfrage - Abruf von Daten von 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": "Code - JSON-Daten analysieren und bereinigen",
"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": "Haftnotiz",
"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 Chat Model",
"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 - Vergleichende Analyse",
"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": "Wenn Benutzer Formular abschließt",
"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": "Zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
780,
-80
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "e7da127a-864c-4957-8be9-a48229885c78",
"name": "Code - Kombinieren von JSON- und AI-Ausgaben",
"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 - Ergebnisse exportieren",
"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
}
]
]
}
}
}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?
Fortgeschritten - Künstliche Intelligenz, Marketing
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
Bright Data Keyword-E-Mail-Newsletter mit KI-Zusammenfassung
Bright Data-Keywords-E-Mail-Newsletter mit KI-Zusammenfassung
If
Code
Wait
+
If
Code
Wait
13 NodesGleb D
Künstliche Intelligenz
Wettbewerbspreisabfrage und Berichtsgenerator
Wettbewerbspreis-Abfrage und Berichtsgenerator mit Bright Data
If
Set
Code
+
If
Set
Code
19 NodesGleb D
Künstliche Intelligenz
Twitter-Profil nach Namen suchen, Beiträge scrapen und Inhalt mit KI analysieren, in Google Sheets speichern
Twitter-Beiträge anhand des Namens, mit Bright Data und Gemini finden, scrapen und analysieren
If
Set
Code
+
If
Set
Code
22 NodesGleb D
Künstliche Intelligenz
Mit KI, ElevenLabs und Mehrplattform-Veröffentlichung POV-Videos erstellen und genehmigen
POV-Videos (TikTok/IG/YT) erstellen, genehmigen und auf mehreren Plattformen mit AI, ElevenLabs veröffentlichen
If
Set
Code
+
If
Set
Code
60 NodesImmanuel
Design
Inhaltslücken für Marktforschung und SEO durch Wettbewerbsinhaltsanalyse entdecken
Analysiere Wettbewerbs-Inhaltslücken auf Websites mit InfraNodus GraphRAG zur Unterstützung der SEO
If
Code
Wait
+
If
Code
Wait
37 NodesInfraNodus
Künstliche Intelligenz
TikTok-Beitrags-Automatisierungsagent V3.1
🚀 Konvertierung von Podcasts in virale TikTok-Snippets mit Gemini KI und automatisiertem Posting ✅
If
Set
Code
+
If
Set
Code
54 NodesMateo Fiorito Rocha
Design
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes13
Kategorie2
Node-Typen10
Autor
Gleb D
@glebdExterne Links
Auf n8n.io ansehen →
Diesen Workflow teilen