11 - Verlinkung für B2B-Intelligence-Upload
Fortgeschritten
Dies ist ein Lead Generation, Multimodal AI-Bereich Automatisierungsworkflow mit 13 Nodes. Hauptsächlich werden If, Set, Hubspot, GoogleSheets, OpenAi und andere Nodes verwendet. Automatisiertes Bereichern und Synchronisieren von Unternehmensinformationen in Google Sheets mit GPT-4o-mini zu HubSpot
Voraussetzungen
- •HubSpot API Key
- •Google Sheets API-Anmeldedaten
- •OpenAI 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
{
"id": "REMOVED_FOR_PRIVACY",
"meta": {
"instanceId": "REMOVED_FOR_PRIVACY",
"templateCredsSetupCompleted": true
},
"name": "11 - B2B Intel Uplink",
"tags": [],
"nodes": [
{
"id": "6cb9736d-0484-41e5-bb15-1dad740b7ca8",
"name": "📥 Sheet Trigger - Neues Unternehmen",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-1780,
80
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Company's"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "YOUR_GOOGLE_SHEETS_CREDENTIAL_ID",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "ffb9fb95-1acf-496f-89d0-f8ee4a8e5281",
"name": "🧹 Filter: Nicht-leerer Unternehmensname",
"type": "n8n-nodes-base.if",
"position": [
-1560,
80
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json['Company Name'] }}",
"operation": "isNotEmpty"
}
]
}
},
"typeVersion": 1
},
{
"id": "8a554f66-63ed-432a-a7cf-1eced7e69cfd",
"name": "🤖 OpenAI Anreicherung (GPT-4o-mini)",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-1340,
80
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "GPT-4O-MINI"
},
"options": {
"maxTokens": 500,
"temperature": 0.3
},
"messages": {
"values": [
{
"role": "system",
"content": "You are a business intelligence assistant that provides accurate company information. Return your response as a valid JSON object with the following structure:\n{\n \"Company Name\": \"string\"\n \"industry\": \"string\",\n \"description\": \"string (max 200 characters)\",\n \"company_size\": \"string (Small/Medium/Large/Enterprise)\",\n \"headquarters\": \"string (City, Country)\",\n \"website\": \"string (if known, otherwise null)\",\n \"founded_year\": \"number (if known, otherwise null)\",\n \"business_type\": \"string (B2B/B2C/B2B2C)\"\n}\n\nProvide accurate information based on your knowledge. If you're unsure about specific details, use null for that field."
},
{
"content": "=Provide detailed information about the company: {{ $json['Company Name'] }}"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "YOUR_OPENAI_CREDENTIAL_ID",
"name": "OpenAI account"
}
},
"typeVersion": 1
},
{
"id": "66bd0732-d785-4360-9037-1c111da4b7cb",
"name": "🧾 Angereicherte Daten parsen",
"type": "n8n-nodes-base.set",
"position": [
-964,
80
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={{ $json.message.content }}"
},
"typeVersion": 3
},
{
"id": "985924aa-dd77-4d2c-9648-26d6b842942d",
"name": "🔍 HubSpot: Unternehmen per Domain finden",
"type": "n8n-nodes-base.hubspot",
"position": [
-744,
80
],
"parameters": {
"domain": "={{ $json[\"Company Name\"] }}",
"options": {},
"resource": "company",
"operation": "searchByDomain",
"authentication": "appToken"
},
"credentials": {
"hubspotAppToken": {
"id": "YOUR_HUBSPOT_CREDENTIAL_ID",
"name": "HubSpot account"
}
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "bb322fb5-b449-4106-8f39-36c66b742a79",
"name": "⚖️ Prüfung: Unternehmen existiert in HubSpot?",
"type": "n8n-nodes-base.if",
"position": [
-524,
80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e394276a-8753-46d6-bb4e-e993263ef805",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.id }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "bed544fe-3b79-4cd7-9fc9-d938195f73fd",
"name": "🏢 Unternehmen in HubSpot erstellen",
"type": "n8n-nodes-base.hubspot",
"position": [
-304,
155
],
"parameters": {
"name": "={{ $('🧾 Parse Enriched Data').item.json[\"Company Name\"] }}",
"resource": "company",
"authentication": "appToken",
"additionalFields": {
"websiteUrl": "={{ $('🧾 Parse Enriched Data').item.json.website }}",
"description": "={{ $('🧾 Parse Enriched Data').item.json.description }}",
"yearFounded": "={{ $('🧾 Parse Enriched Data').item.json.founded_year }}",
"countryRegion": "={{ $('🧾 Parse Enriched Data').item.json.headquarters }}"
}
},
"credentials": {
"hubspotAppToken": {
"id": "YOUR_HUBSPOT_CREDENTIAL_ID",
"name": "HubSpot account"
}
},
"typeVersion": 2.1
},
{
"id": "bf7b2709-51e7-47bb-99f3-9577cd017484",
"name": "🧰 Sheet-Daten vorbereiten",
"type": "n8n-nodes-base.set",
"position": [
-84,
80
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "471e239f-294c-42c7-8077-8631efe0212e",
"name": "📊 Google Sheet aktualisieren",
"type": "n8n-nodes-base.googleSheets",
"position": [
136,
80
],
"parameters": {
"columns": {
"value": {
"Website": "={{ $('🧾 Parse Enriched Data').item.json.website }}",
"Industry": "={{ $('🧾 Parse Enriched Data').item.json.industry }}",
"Description": "={{ $('🧾 Parse Enriched Data').item.json.description }}",
"Headquaters": "={{ $('🧾 Parse Enriched Data').item.json.headquarters }}",
"Company Name": "={{ $('🧾 Parse Enriched Data').item.json[\"Company Name\"] }}",
"Company Size": "={{ $('🧾 Parse Enriched Data').item.json.company_size }}",
"Founded Year": "={{ $('🧾 Parse Enriched Data').item.json.founded_year }}",
"Buisness Type": "={{ $('🧾 Parse Enriched Data').item.json.business_type }}"
},
"schema": [
{
"id": "Company Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Size",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Headquaters",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Headquaters",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Founded Year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Founded Year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Buisness Type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Buisness Type",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Company Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Company's"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "YOUR_GOOGLE_SHEETS_OAUTH_CREDENTIAL_ID",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "cc020973-ba65-4d33-8418-0d11e46b5f0a",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1840,
-140
],
"parameters": {
"color": 5,
"width": 440,
"height": 560,
"content": "## Lead Intake Filter\n\n*This block triggers the workflow from a newly added row in Google Sheets, representing a fresh lead. It then filters out contacts that are incomplete, duplicated, or already enriched, ensuring that only valid and unique leads proceed for enrichment.*"
},
"typeVersion": 1
},
{
"id": "f7704369-4be3-4505-9dc4-e92115804665",
"name": "Haftnotiz 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1380,
-140
],
"parameters": {
"color": 3,
"width": 580,
"height": 560,
"content": "## Company Intelligence via GPT-4o-mini\n\n*This module uses OpenAI to extract rich company insights such as industry, company size, year founded, and a brief summary. The response is parsed into structured JSON for consistent downstream use.*"
},
"typeVersion": 1
},
{
"id": "08b3b367-79cc-4d7d-bc1d-65323fa72cb7",
"name": "Haftnotiz 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
-140
],
"parameters": {
"width": 620,
"height": 560,
"content": "## CRM Sync: HubSpot Company Management\n\n*Ensures a clean and accurate CRM. First, it checks if the company exists in HubSpot using its domain. If not found, it auto-creates a new entry using enriched data to prevent duplicates and improve outreach workflows.*"
},
"typeVersion": 1
},
{
"id": "74983ef9-6c90-42f8-95be-b53343030af7",
"name": "Haftnotiz 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-140,
-140
],
"parameters": {
"color": 4,
"width": 460,
"height": 560,
"content": "## Google Sheets Recordkeeping\n\n*Captures all enriched and CRM-synced companies in a Google Sheet for visibility and operational traceability. Ensures each entry has a consistent structure for review and auditing.*"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "REMOVED_FOR_PRIVACY",
"connections": {
"bf7b2709-51e7-47bb-99f3-9577cd017484": {
"main": [
[
{
"node": "471e239f-294c-42c7-8077-8631efe0212e",
"type": "main",
"index": 0
}
]
]
},
"471e239f-294c-42c7-8077-8631efe0212e": {
"main": [
[]
]
},
"66bd0732-d785-4360-9037-1c111da4b7cb": {
"main": [
[
{
"node": "985924aa-dd77-4d2c-9648-26d6b842942d",
"type": "main",
"index": 0
}
]
]
},
"bed544fe-3b79-4cd7-9fc9-d938195f73fd": {
"main": [
[
{
"node": "bf7b2709-51e7-47bb-99f3-9577cd017484",
"type": "main",
"index": 0
}
]
]
},
"6cb9736d-0484-41e5-bb15-1dad740b7ca8": {
"main": [
[
{
"node": "ffb9fb95-1acf-496f-89d0-f8ee4a8e5281",
"type": "main",
"index": 0
}
]
]
},
"985924aa-dd77-4d2c-9648-26d6b842942d": {
"main": [
[
{
"node": "bb322fb5-b449-4106-8f39-36c66b742a79",
"type": "main",
"index": 0
}
]
]
},
"8a554f66-63ed-432a-a7cf-1eced7e69cfd": {
"main": [
[
{
"node": "66bd0732-d785-4360-9037-1c111da4b7cb",
"type": "main",
"index": 0
}
]
]
},
"ffb9fb95-1acf-496f-89d0-f8ee4a8e5281": {
"main": [
[
{
"node": "8a554f66-63ed-432a-a7cf-1eced7e69cfd",
"type": "main",
"index": 0
}
],
[]
]
},
"bb322fb5-b449-4106-8f39-36c66b742a79": {
"main": [
[
{
"node": "bf7b2709-51e7-47bb-99f3-9577cd017484",
"type": "main",
"index": 0
}
],
[
{
"node": "bed544fe-3b79-4cd7-9fc9-d938195f73fd",
"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 - Lead-Generierung, Multimodales KI
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
22 - Routing von Leads aus mehreren Quellen
Lead-Routing-System: Qualifizierung und Zuweisung von Typeform-Leads zu HubSpot, Sheets und Airtable
If
Gmail
Hubspot
+
If
Gmail
Hubspot
13 NodesAvkash Kakdiya
Lead-Generierung
15 - LeadFlow Automatisierung
Automatisierte Gmail-Lead-Nachbereitung mit OpenAI GPT-4O, HubSpot, Slack und Google Sheets
If
Set
Code
+
If
Set
Code
14 NodesAvkash Kakdiya
KI-Zusammenfassung
09 - Lead-Profil-Verbesserer
Automatisierung der Lead-Anreicherung und personalisierten Ansprache: HubSpot, Phantombuster und GPT
If
Set
Code
+
If
Set
Code
30 NodesAvkash Kakdiya
Lead-Pflege
17 - KI LinkedIn-Antwortgenerator
Automatisierte Beantwortung von LinkedIn-Kommentaren und Tracking in Google Sheets mit GPT-3.5
If
Set
Http Request
+
If
Set
Http Request
13 NodesAvkash Kakdiya
Multimodales KI
AI-gestützte Lead-Generierung (Apollo, LinkedIn-Recherche und 4-stufige personalisierte E-Mails)
AI-gestützte Lead-Generierung: Nutzung von Apollo, LinkedIn-Recherche und 4-stufigen personalisierten E-Mails
If
Set
Code
+
If
Set
Code
30 NodesGain FLow AI
Lead-Generierung
14 - Domänen-Verkehrs-Anreicher
Anreichung von Domaindaten mit SimilarWeb-Traffikanalyse in Google Sheets und Airtable
Set
Code
Airtable
+
Set
Code
Airtable
9 NodesAvkash Kakdiya
Marktforschung
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes13
Kategorie2
Node-Typen7
Autor
Avkash Kakdiya
@itechnotion🚀 Founder of iTechNotion — we build custom AI-powered automation workflows for startups, agencies, and founders. 💡 Specializing in agentic AI systems, content automation, sales funnels, and digital workers. 🔧 14+ years in tech | Building scalable no-code/low-code solutions using n8n, OpenAI, and other API-first tools. 📬 Let’s automate what slows you down.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen