ワークフロー11
中級
これはAI分野の自動化ワークフローで、7個のノードを含みます。主にHttpRequest, GoogleSheets, ManualTriggerなどのノードを使用、AI技術を活用したスマート自動化を実現。 Ghost GeniusとGoogleスプレッドシートを使ってLinkedInプロフィールを豊富にする（アカウント不要）
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "aYhTrpk2bbP6PzC7",
"meta": {
"instanceId": "95a1299fb2b16eb2219cb044f54e72c2d00dcd2c72efe717b3c308d200f29927"
},
"name": "My workflow 11",
"tags": [],
"nodes": [
{
"id": "8332ef6d-626b-4fa8-888c-e41284154d73",
"name": "Start",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-400,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e24a9fbf-2812-4386-bee9-857df3ba4924",
"name": "プロフィール情報を取得",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
40,
440
],
"parameters": {
"url": "https://api.ghostgenius.fr/v2/profile",
"options": {
"batching": {
"batch": {
"batchSize": 1,
"batchInterval": 2000
}
}
},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $json.url }}"
}
]
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "c6c53ff4-5c54-48ac-940f-05faf4f335cc",
"name": "プロフィールを復元",
"type": "n8n-nodes-base.googleSheets",
"position": [
-180,
440
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI/edit?usp=drivesdk",
"cachedResultName": "Copy of List of profiles"
}
},
"typeVersion": 4.5
},
{
"id": "ebc0382a-3d69-43bc-a64d-409647649e49",
"name": "更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
260,
440
],
"parameters": {
"columns": {
"value": {
"url": "={{ $('Recover Profiles').item.json.url }}",
"Skills": "={{ ($json.skills?.length > 0) ? $json.skills.join(', ') : '' }}",
"Hiring?": "={{ $json.is_hiring.toString() }}",
"Summary": "={{ $json.summary }}",
"Tagline": "={{ $json.headline }}",
"Lastname": "={{ $json.last_name }}",
"Location": "={{ [$json.geo?.location?.name, $json.geo?.country?.name].filter(Boolean).join(', ') }}",
"Firstname": "={{ $json.first_name }}",
"Followers": "={{ $json.followers }}",
"Languages": "={{ $json.languages?.map(lang => lang.name + ' (' + lang.level + ')').join(', ') ?? '' }}",
"Connections": "={{ $json.connections }}",
"Education 1": "={{ $json.educations?.[0]?.school?.full_name ?? '' }}\n{{ $json.educations?.[0]?.school?.url ?? '' }}\n{{ [$json.educations?.[0]?.start, $json.educations?.[0]?.end].filter(Boolean).join(' - ') }}\n{{ $json.educations?.[0]?.description ?? '' }}\n{{ [$json.educations?.[0]?.grade, $json.educations?.[0]?.major, $json.educations?.[0]?.degree].filter(Boolean).join(' - ') }}",
"Education 2": "={{ $json.educations?.[1]?.school?.full_name ?? '' }}\n{{ $json.educations?.[1]?.school?.url ?? '' }}\n{{ [$json.educations?.[1]?.start, $json.educations?.[1]?.end].filter(Boolean).join(' - ') }}\n{{ $json.educations?.[1]?.description ?? '' }}\n{{ [$json.educations?.[1]?.grade, $json.educations?.[1]?.major, $json.educations?.[1]?.degree].filter(Boolean).join(' - ') }}",
"Education 3": "={{ $json.educations?.[2]?.school?.full_name ?? '' }}\n{{ $json.educations?.[2]?.school?.url ?? '' }}\n{{ [$json.educations?.[2]?.start, $json.educations?.[2]?.end].filter(Boolean).join(' - ') }}\n{{ $json.educations?.[2]?.description ?? '' }}\n{{ [$json.educations?.[2]?.grade, $json.educations?.[2]?.major, $json.educations?.[2]?.degree].filter(Boolean).join(' - ') }}",
"Experience 1": "={{ $json.experiences?.[0]?.company?.name ?? '' }}\n{{ $json.experiences?.[0]?.company?.url ?? '' }}\n{{ ($json.experiences?.[0]?.start ?? '') + (($json.experiences?.[0]?.start && $json.experiences?.[0]?.end) ? ' - ' : '') + ($json.experiences?.[0]?.end ?? '') }}\n{{ $json.experiences?.[0]?.position ?? '' }}\n{{ $json.experiences?.[0]?.location ?? '' }}",
"Experience 2": "={{ $json.experiences?.[1]?.company?.name ?? '' }}\n{{ $json.experiences?.[1]?.company?.url ?? '' }}\n{{ ($json.experiences?.[1]?.start ?? '') + (($json.experiences?.[1]?.start && $json.experiences?.[1]?.end) ? ' - ' : '') + ($json.experiences?.[1]?.end ?? '') }}\n{{ $json.experiences?.[1]?.position ?? '' }}\n{{ $json.experiences?.[1]?.location ?? '' }}",
"Experience 3": "={{ $json.experiences?.[2]?.company?.name ?? '' }}\n{{ $json.experiences?.[2]?.company?.url ?? '' }}\n{{ ($json.experiences?.[2]?.start ?? '') + (($json.experiences?.[2]?.start && $json.experiences?.[2]?.end) ? ' - ' : '') + ($json.experiences?.[2]?.end ?? '') }}\n{{ $json.experiences?.[2]?.position ?? '' }}\n{{ $json.experiences?.[2]?.location ?? '' }}",
"Experience 4": "={{ $json.experiences?.[3]?.company?.name ?? '' }}\n{{ $json.experiences?.[3]?.company?.url ?? '' }}\n{{ ($json.experiences?.[3]?.start ?? '') + (($json.experiences?.[3]?.start && $json.experiences?.[3]?.end) ? ' - ' : '') + ($json.experiences?.[3]?.end ?? '') }}\n{{ $json.experiences?.[3]?.position ?? '' }}\n{{ $json.experiences?.[3]?.location ?? '' }}",
"Experience 5": "={{ $json.experiences?.[4]?.company?.name ?? '' }}\n{{ $json.experiences?.[4]?.company?.url ?? '' }}\n{{ ($json.experiences?.[4]?.start ?? '') + (($json.experiences?.[4]?.start && $json.experiences?.[4]?.end) ? ' - ' : '') + ($json.experiences?.[4]?.end ?? '') }}\n{{ $json.experiences?.[4]?.position ?? '' }}\n{{ $json.experiences?.[4]?.location ?? '' }}",
"Open to work?": "={{ $json.is_open_to_work.toString() }}"
},
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Firstname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lastname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tagline",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Tagline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connections",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Connections",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Followers",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Followers",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Hiring?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Hiring?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Open to work?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Open to work?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Languages",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Languages",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skills",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Skills",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 4",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 4",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience 5",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experience 5",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Education 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Education 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Education 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skills",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Skills",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oiV25COrTMP20nMgNvbtMo2LHcm7ehkqOxbAB-s6PhA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D3aCtCOHUZd2B2KgPmi5_L4a0XyjNLiOiyLH3Jl8PKI/edit?usp=drivesdk",
"cachedResultName": "Copy of List of profiles"
}
},
"typeVersion": 4.5
},
{
"id": "91c969bc-dd32-45a3-a8e7-f69ce94fe365",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
280
],
"parameters": {
"color": 5,
"width": 1040,
"height": 420,
"content": "## Enrich a LinkedIn profile list"
},
"typeVersion": 1
},
{
"id": "62815f2f-a917-4f39-987a-2e0ce9046134",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"width": 420,
"height": 220,
"content": "## Resources\n[Video Setup](https://youtu.be/kIOJeMoCfp4)\n\nGoogle Sheet: [Make a copy here](https://docs.google.com/spreadsheets/d/1oiV25COrTMP20nMgNvbtMo2LHcm7ehkqOxbAB-s6PhA/edit?usp=sharing)\n\nAPI LinkedIn (cookieless): [Ghost Genius](https://ghostgenius.fr)\n\nGoogle Sheet Credential Setup: [Video Tutorial](https://www.youtube.com/watch?v=pWGXlZBGu4k)"
},
"typeVersion": 1
},
{
"id": "f477d4bc-9e67-4b93-a8aa-12bdf2807daa",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
80
],
"parameters": {
"color": 7,
"height": 80,
"content": "# [Setup Video](https://youtu.be/kIOJeMoCfp4)"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "2474bd40-54d9-4582-a58d-2a085b82ab64",
"connections": {
"8332ef6d-626b-4fa8-888c-e41284154d73": {
"main": [
[
{
"node": "c6c53ff4-5c54-48ac-940f-05faf4f335cc",
"type": "main",
"index": 0
}
]
]
},
"e24a9fbf-2812-4386-bee9-857df3ba4924": {
"main": [
[
{
"node": "ebc0382a-3d69-43bc-a64d-409647649e49",
"type": "main",
"index": 0
}
]
]
},
"c6c53ff4-5c54-48ac-940f-05faf4f335cc": {
"main": [
[
{
"node": "e24a9fbf-2812-4386-bee9-857df3ba4924",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 人工知能
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
私のワークフロー5
AIメールパーソナライゼーションを使用した自動LinkedInリード生成（未完了）
If
Set
Code
+
If
Set
Code
37 ノードMatthieu
営業
AIを活用したリードジェネレーションシステム（メールパーソナライズとLinkedIn）
AIを活用したリードジェネレーションシステム：メールパーソナライズとLinkedIn機能を含む
If
Code
Limit
+
If
Code
Limit
51 ノードMatthieu
リード獲得
LinkedIn、OpenAI、Sales Navigatorを使用して有効なリードを作成し、コールドコールスクリプトを自動生成
LinkedIn、OpenAI、Sales Navigatorを使って、合格したリードとコールドケーススクリプトを作成
If
Code
Limit
+
If
Code
Limit
47 ノードMatthieu
リード獲得
研究論文スパイダーをGoogleスプシへ
Bright Dataとn8nを使った研究論文収集の自動化
Set
Code
Html
+
Set
Code
Html
12 ノードYaron Been
人工知能
AIニュース要約ビルダー：Dumpling AIでサイトをスクラップし、GPT-4oで要約
AIニュースドットメ거ー：Dumpling AIによるサイト取得でGPT-4oサマリー
Set
Code
Gmail
+
Set
Code
Gmail
10 ノードYang
人工知能
AI駆動のウェブスクレイピング：Jina、Google Sheets、OpenAIを使ったシンプルなソリューション
AI駆動のウェブスクレイピング：Jina、Google Sheets、OpenAIを使ったシンプルなソリューション
Split Out
Http Request
Google Sheets
+
Split Out
Http Request
Google Sheets
7 ノードDerek Cheung
人工知能
