Apollo.io かつ Google スプレッドシートを使用した LinkedIn のリード豊富化パイプラインの自動化
上級
これはLead Generation, AI Summarization分野の自動化ワークフローで、33個のノードを含みます。主にIf, Code, Wait, Webhook, SplitOutなどのノードを使用。 Apollo.ioとGoogleスプレッドシートを使用した自動LinkedInリード豊富化パイプライン
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •Google Gemini API Key
使用ノード (33)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "67dd1445921862780ac74448aef33eb969db12b9a6ce95248c7ae86a887cb653",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ee7ba99a-a412-4389-af47-e12a8070a9a1",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
2032,
1296
],
"webhookId": "4584ccbb-4256-4da7-a8df-bee1f3b27084",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "d913c122-3f4a-4fa3-aab3-79c6319ac12e",
"name": "分割",
"type": "n8n-nodes-base.splitOut",
"position": [
2240,
1296
],
"parameters": {},
"typeVersion": 1
},
{
"id": "41a6dc80-fe9e-4cde-b47b-b03ae98feb7f",
"name": "構造化出力パーサー",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2832,
1504
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "0bda86e3-84ab-4b9f-9c74-b871a658bdc6",
"name": "Google Gemini チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2512,
1504
],
"parameters": {},
"typeVersion": 1
},
{
"id": "65af8ed4-cec3-4937-963e-4623473f5b57",
"name": "アイテムをループ",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2448,
1296
],
"parameters": {},
"typeVersion": 3
},
{
"id": "54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed",
"name": "シートで行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
2224,
2016
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ea21290c-588d-443b-b401-d7329063e9bb",
"name": "スケジュールトリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2048,
2016
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"name": "アイテムをループ1",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2720,
2016
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2e9a8548-a8bf-47e3-8fe1-93072276cd9d",
"name": "シートで行を更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
3440,
2032
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ed8a4414-e31d-46d7-9ad6-836faee1a3ac",
"name": "スケジュールトリガー1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
2672
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6951d857-278a-4633-be22-f06937dacb98",
"name": "アイテムをループ2",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2752,
2656
],
"parameters": {},
"typeVersion": 3
},
{
"id": "bb781af1-7246-4bf7-9f77-1f7eb17637ef",
"name": "待機",
"type": "n8n-nodes-base.wait",
"position": [
3648,
2032
],
"webhookId": "e5a3db76-aa67-42c7-8ad1-e916509b7c13",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5127d065-bc43-454c-bc64-02402c23143a",
"name": "待機1",
"type": "n8n-nodes-base.wait",
"position": [
3440,
2656
],
"webhookId": "69d23d48-e9fd-4f7d-bc70-fa2400658e62",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "65efcc77-b567-4fff-a2e8-31b8e0e29f4e",
"name": "シートで行を取得1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
2672
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "71fb0b9d-d8b2-490b-8a55-a515c56fe10e",
"name": "シートで行を更新1",
"type": "n8n-nodes-base.googleSheets",
"position": [
3648,
2656
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "5a81a696-1155-4fbb-966c-82baec8219fe",
"name": "条件分岐",
"type": "n8n-nodes-base.if",
"position": [
2496,
2672
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca",
"name": "条件分岐1",
"type": "n8n-nodes-base.if",
"position": [
2432,
2032
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "bfa61ebd-bdf8-4356-8807-579ea74a06cd",
"name": "スケジュールトリガー2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
3136
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "a3dfff36-07c3-49c6-b7fb-718638854507",
"name": "待機2",
"type": "n8n-nodes-base.wait",
"position": [
3712,
3120
],
"webhookId": "69d23d48-e9fd-4f7d-bc70-fa2400658e62",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "59e93cf6-cf15-4a92-b344-bac485607e07",
"name": "シートで行を更新2",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
3920,
3120
],
"parameters": {},
"typeVersion": 4.7,
"alwaysOutputData": false
},
{
"id": "098cf0b1-6c13-428a-aedf-53f5a4ace309",
"name": "条件分岐2",
"type": "n8n-nodes-base.if",
"position": [
2464,
3136
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "69cc889b-3692-412b-9265-8b6ed4df7a49",
"name": "コード",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"position": [
2928,
3120
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "37e8ea98-60d5-413e-922d-e5fed98e96ef",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
1776,
2528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1ab50ec4-c5f0-4888-8f2c-0b16c518e6ea",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1792,
1856
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9bb1bf69-b5f4-4471-a98e-e4728062391c",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1808,
3072
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d",
"name": "コード1",
"type": "n8n-nodes-base.code",
"position": [
3456,
3120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"name": "アイテムをループ4",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2704,
3088
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723",
"name": "シートで行を取得3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
3136
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"name": "Linkedin スクレイプフォーマッタ",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
2656,
1296
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"name": "値を保存",
"type": "n8n-nodes-base.googleSheets",
"position": [
3008,
1296
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "a3e862b8-9f95-46ad-be2d-a7b06f15a1f0",
"name": "会社名からドメイン",
"type": "n8n-nodes-base.httpRequest",
"position": [
3232,
2032
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "835de11e-aa6d-4e4e-9f2d-7e008155d1db",
"name": "人物検索",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
3024,
2656
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "bfed2a87-6446-4484-aad5-56f4ee3a566e",
"name": "メール検索",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
3184,
3120
],
"parameters": {},
"typeVersion": 4.2
}
],
"pinData": {},
"connections": {
"5a81a696-1155-4fbb-966c-82baec8219fe": {
"main": [
[
{
"node": "6951d857-278a-4633-be22-f06937dacb98",
"type": "main",
"index": 0
}
]
]
},
"72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca": {
"main": [
[
{
"node": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"type": "main",
"index": 0
}
]
]
},
"098cf0b1-6c13-428a-aedf-53f5a4ace309": {
"main": [
[
{
"node": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"type": "main",
"index": 0
}
]
]
},
"69cc889b-3692-412b-9265-8b6ed4df7a49": {
"main": [
[
{
"node": "bfed2a87-6446-4484-aad5-56f4ee3a566e",
"type": "main",
"index": 0
}
]
]
},
"bb781af1-7246-4bf7-9f77-1f7eb17637ef": {
"main": [
[
{
"node": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"type": "main",
"index": 0
}
]
]
},
"1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d": {
"main": [
[
{
"node": "a3dfff36-07c3-49c6-b7fb-718638854507",
"type": "main",
"index": 0
}
]
]
},
"5127d065-bc43-454c-bc64-02402c23143a": {
"main": [
[
{
"node": "71fb0b9d-d8b2-490b-8a55-a515c56fe10e",
"type": "main",
"index": 0
}
]
]
},
"a3dfff36-07c3-49c6-b7fb-718638854507": {
"main": [
[
{
"node": "59e93cf6-cf15-4a92-b344-bac485607e07",
"type": "main",
"index": 0
}
]
]
},
"ee7ba99a-a412-4389-af47-e12a8070a9a1": {
"main": [
[
{
"node": "d913c122-3f4a-4fa3-aab3-79c6319ac12e",
"type": "main",
"index": 0
}
]
]
},
"d913c122-3f4a-4fa3-aab3-79c6319ac12e": {
"main": [
[
{
"node": "65af8ed4-cec3-4937-963e-4623473f5b57",
"type": "main",
"index": 0
}
]
]
},
"bfed2a87-6446-4484-aad5-56f4ee3a566e": {
"main": [
[
{
"node": "1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d",
"type": "main",
"index": 0
}
]
]
},
"3f428a31-7eb0-4e78-b574-bf0b968b652e": {
"main": [
[
{
"node": "65af8ed4-cec3-4937-963e-4623473f5b57",
"type": "main",
"index": 0
}
]
]
},
"835de11e-aa6d-4e4e-9f2d-7e008155d1db": {
"main": [
[
{
"node": "5127d065-bc43-454c-bc64-02402c23143a",
"type": "main",
"index": 0
}
]
]
},
"65af8ed4-cec3-4937-963e-4623473f5b57": {
"main": [
[],
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "main",
"index": 0
}
]
]
},
"748e2b43-e51a-417d-92ff-df0704cef2a9": {
"main": [
[],
[
{
"node": "a3e862b8-9f95-46ad-be2d-a7b06f15a1f0",
"type": "main",
"index": 0
}
]
]
},
"6951d857-278a-4633-be22-f06937dacb98": {
"main": [
[],
[
{
"node": "835de11e-aa6d-4e4e-9f2d-7e008155d1db",
"type": "main",
"index": 0
}
]
]
},
"3fdb7f62-3fad-4067-b6c8-d2e07984370f": {
"main": [
[],
[
{
"node": "69cc889b-3692-412b-9265-8b6ed4df7a49",
"type": "main",
"index": 0
}
]
]
},
"ea21290c-588d-443b-b401-d7329063e9bb": {
"main": [
[
{
"node": "54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed",
"type": "main",
"index": 0
}
]
]
},
"ed8a4414-e31d-46d7-9ad6-836faee1a3ac": {
"main": [
[
{
"node": "65efcc77-b567-4fff-a2e8-31b8e0e29f4e",
"type": "main",
"index": 0
}
]
]
},
"bfa61ebd-bdf8-4356-8807-579ea74a06cd": {
"main": [
[
{
"node": "abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723",
"type": "main",
"index": 0
}
]
]
},
"54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed": {
"main": [
[
{
"node": "72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca",
"type": "main",
"index": 0
}
]
]
},
"2e9a8548-a8bf-47e3-8fe1-93072276cd9d": {
"main": [
[
{
"node": "bb781af1-7246-4bf7-9f77-1f7eb17637ef",
"type": "main",
"index": 0
}
]
]
},
"65efcc77-b567-4fff-a2e8-31b8e0e29f4e": {
"main": [
[
{
"node": "5a81a696-1155-4fbb-966c-82baec8219fe",
"type": "main",
"index": 0
}
]
]
},
"abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723": {
"main": [
[
{
"node": "098cf0b1-6c13-428a-aedf-53f5a4ace309",
"type": "main",
"index": 0
}
]
]
},
"71fb0b9d-d8b2-490b-8a55-a515c56fe10e": {
"main": [
[
{
"node": "6951d857-278a-4633-be22-f06937dacb98",
"type": "main",
"index": 0
}
]
]
},
"59e93cf6-cf15-4a92-b344-bac485607e07": {
"main": [
[
{
"node": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"type": "main",
"index": 0
}
]
]
},
"a3e862b8-9f95-46ad-be2d-a7b06f15a1f0": {
"main": [
[
{
"node": "2e9a8548-a8bf-47e3-8fe1-93072276cd9d",
"type": "main",
"index": 0
}
]
]
},
"0bda86e3-84ab-4b9f-9c74-b871a658bdc6": {
"ai_languageModel": [
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"41a6dc80-fe9e-4cde-b47b-b03ae98feb7f": {
"ai_outputParser": [
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"d83f2237-6fe7-4eb4-b2d7-deba7c26e54e": {
"main": [
[
{
"node": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"type": "main",
"index": 0
}
],
[
{
"node": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - リード獲得, AI要約
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
毎日の WhatsApp グループ スマート分析：GPT-4.1 による分析と音声メッセージの transcrição
毎日の WhatsApp グループ インタラクティブ分析：GPT-4.1 分析と音声メッセージ文字起こし
If
Set
Code
+
If
Set
Code
52 ノードDaniel Lianes
その他
潜在顧客開掘とメールワーキングフロー
Google Maps、SendGrid、AIを使用してB2Bリード獲得とメールマーケティングを自動化
If
Set
Code
+
If
Set
Code
141 ノードEzema Kingsley Chibuzo
リード獲得
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
AI駆動のGoogle Mapsビジネスデータスクレイピングとスプレッドシート出力
AIを基盤としたGoogle Mapsビジネスデータの収集、データの充実化、スプレッドシートへのエクスポートをサポート
If
Code
Wait
+
If
Code
Wait
25 ノードMsaid Mohamed el hadi
リード獲得
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能
第一轮 Telegram と LinkedIn 快速通道 AI 招聘アシスタント
AI候选人筛选流程：LinkedInへTelegram，統合Gemini与Apify
If
Set
Code
+
If
Set
Code
55 ノードDean Pike
人事
ワークフロー情報
難易度
上級
ノード数33
カテゴリー2
ノードタイプ13
作成者
Rahi Uppal
@rahiuppalAI and Automation Consultant with over 1000 hours of experience building, deploying, and solving marketing and sales automation problems. I ship AI products faster by combining business acumen with AI & automation expertise and an engineering mindset. Connect with me on LinkedIn to chat.
外部リンク
n8n.ioで表示 →
このワークフローを共有