11 - B2B インテリジェンスアップロードリンク
中級
これはLead Generation, Multimodal AI分野の自動化ワークフローで、13個のノードを含みます。主にIf, Set, Hubspot, GoogleSheets, OpenAiなどのノードを使用。 GPT-4o-mini を使って Google Sheets の会社情報を自動で豊富にし、HubSpot との同期
前提条件
- •HubSpot API Key
- •Google Sheets API認証情報
- •OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定を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": "📥 シートトリガー - 新規会社",
"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": "🧹 フィルター: 会社名が空白でない",
"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 Enrichment (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": "🧾 リッチ化されたデータの解析",
"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: ドメインで会社を検索",
"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": "⚖️ 確認: 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": "🏢 HubSpot に会社を作成",
"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": "🧰 シートデータの準備",
"type": "n8n-nodes-base.set",
"position": [
-84,
80
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "471e239f-294c-42c7-8077-8631efe0212e",
"name": "📊 Google シートを更新",
"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": "付箋",
"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": "付箋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": "付箋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": "付箋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
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - リード獲得, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
22 - マルチソースリードルーティング
リードルーティングシステム：資格判定を行い、TypeformリードをHubSpot、Sheets、Airtableに誘導
If
Gmail
Hubspot
+
If
Gmail
Hubspot
13 ノードAvkash Kakdiya
リード獲得
15 - LeadFlow オートメーション
OpenAI GPT-4O、HubSpot、Slack、Google Sheetsを使ってGmailのリードフォローアップを自動化
If
Set
Code
+
If
Set
Code
14 ノードAvkash Kakdiya
AI要約
09 - リードプロフィール強化ツール
自動化されたリード情報の豊富さとパーソナライズされたアウトレーシュ：HubSpot、Phantombuster、GPT
If
Set
Code
+
If
Set
Code
30 ノードAvkash Kakdiya
リードナーチャリング
17 - AI LinkedIn 返信ジェネレーター
LinkedIn のコメントへの GPT-3.5 を使った自動返信と Google Sheets 内での追跡
If
Set
Http Request
+
If
Set
Http Request
13 ノードAvkash Kakdiya
マルチモーダルAI
AIを活用したリードジェネレーション（Apollo、LinkedInリサーチ、4段階のパーソナライズメール）
AIを活用したリードジェネレーション：Apollo、LinkedInリサーチ、4段階のパーソナライズメールを使用
If
Set
Code
+
If
Set
Code
30 ノードGain FLow AI
リード獲得
14 - ドメイン流量エンチャー
GoogleスプレッドシートとAirtableでSimilarWebのトラフィックデータを使ってドメイン情報を補完する
Set
Code
Airtable
+
Set
Code
Airtable
9 ノードAvkash Kakdiya
市場調査
ワークフロー情報
難易度
中級
ノード数13
カテゴリー2
ノードタイプ7
作成者
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.
外部リンク
n8n.ioで表示 →
このワークフローを共有