BrowserflowとGoogle Sheetsを活用したLinkedInリクエストとア破冰メッセージの自動化
上級
これはSales, HR, AI, Marketing分野の自動化ワークフローで、44個のノードを含みます。主にIf, Set, Sort, Limit, SplitOutなどのノードを使用、AI技術を活用したスマート自動化を実現。 Browserflow と Google Sheets を使って LinkedIn リクエストとブレイクアウトメッセージを自動化
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (44)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"nodes": [
{
"id": "0c71b4d0-6242-4aa0-abde-57b7961b19dd",
"name": "クリック時 ‘Test workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
-220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a87bafb7-fe4d-4125-91f0-d9cb07271d37",
"name": "If connected",
"type": "n8n-nodes-base.if",
"position": [
4620,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "78b4685c-1cfb-4801-a671-8fe035138ed3",
"name": "If not message sent",
"type": "n8n-nodes-base.if",
"position": [
4840,
-720
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "1f61c7ce-f4be-44c8-8e0b-41a55301b4af",
"name": "If not invite sent",
"type": "n8n-nodes-base.if",
"position": [
4840,
-420
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "57aaf87f-6d84-40e5-9d99-94c67f6dbc40",
"name": "Update message sent",
"type": "n8n-nodes-base.googleSheets",
"position": [
5280,
-545
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "8ff459a0-9023-4e73-b82e-79925bf1304e",
"name": "Update invite sent",
"type": "n8n-nodes-base.googleSheets",
"position": [
5280,
-245
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "be8df92c-6072-457b-bb9c-a37fa806e46a",
"name": "スケジュールトリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
-420
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "94fdb018-6bcd-4bd1-ad64-c540bffaa635",
"name": "Update is relation",
"type": "n8n-nodes-base.googleSheets",
"position": [
5060,
-620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "18889bd9-6746-4c0f-a01b-3a6c24556420",
"name": "If relation?",
"type": "n8n-nodes-base.if",
"position": [
4180,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "b797df08-23ff-474c-a850-40cf19f33a52",
"name": "Generate email",
"type": "n8n-nodes-base.executeWorkflow",
"notes": "Calling subworkflow (see under)",
"onError": "continueRegularOutput",
"position": [
3740,
-620
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "c1db5f92-e443-47fd-bc13-9c9c94defa2f",
"name": "Search for user profile",
"type": "n8n-nodes-base.httpRequest",
"notes": "Search by Name and company",
"position": [
880,
-620
],
"parameters": {},
"executeOnce": false,
"notesInFlow": true,
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "c7baf889-8002-4f34-bb13-814544bd3382",
"name": "Get profile posts",
"type": "n8n-nodes-base.httpRequest",
"position": [
1320,
-420
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "6856b9b2-263e-4542-b57f-bae59d8eb279",
"name": "分割出力",
"type": "n8n-nodes-base.splitOut",
"position": [
1540,
-420
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "b70be38f-ab85-4386-94de-8be19f430f30",
"name": "制限",
"type": "n8n-nodes-base.limit",
"position": [
1980,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2037083b-65ff-423e-add9-82631ab8c4e1",
"name": "集計",
"type": "n8n-nodes-base.aggregate",
"position": [
2160,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bcca8db0-ecaf-43be-819f-85a5b3161a4e",
"name": "Get company posts",
"type": "n8n-nodes-base.httpRequest",
"position": [
2640,
-420
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "1e92021e-af03-4cb4-a542-843ce287c066",
"name": "分割出力1",
"type": "n8n-nodes-base.splitOut",
"position": [
2860,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "27b9b333-f2d8-4b73-8ab9-17f2e47f319c",
"name": "制限1",
"type": "n8n-nodes-base.limit",
"position": [
3300,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "40535e7e-aa33-4c23-92e8-2ba996b0cb7d",
"name": "集計1",
"type": "n8n-nodes-base.aggregate",
"position": [
3520,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fd2ff6c9-31cf-45e8-b598-8005c459e83f",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
-820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e67ec580-0a55-49d4-9252-69fc92bf2eae",
"name": "設定 your data here",
"type": "n8n-nodes-base.set",
"position": [
220,
-270
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7df4051a-72fb-460b-92fa-39a2bd4cdbdc",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-90,
-1060
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0f8f39ec-0885-46de-80db-3b95fb4dfce5",
"name": "If username is empty",
"type": "n8n-nodes-base.if",
"position": [
1100,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "52114828-975f-4e52-bb9e-f2defa063bec",
"name": "If company ID is empty",
"type": "n8n-nodes-base.if",
"position": [
2420,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "95981f8d-fcd8-4494-a5ce-85977f323222",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2380,
-820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ea632274-5035-47bf-beee-05860cdf86e4",
"name": "OpenAI チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
240,
500
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1ef7ef7b-e7d7-4aaf-b70f-fdbddba806ad",
"name": "構造化出力パーサー",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
360,
500
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "be4e2a75-7b5d-447e-9f0f-aeb75d57cc33",
"name": "Generate Subject and cover letter based on match",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
200,
280
],
"parameters": {},
"typeVersion": 1.5
},
{
"id": "80b3d58d-2d4e-4bff-b4d4-7483a7395c1b",
"name": "When Executed by Another Workflow",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-20,
280
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "d84a32f0-e326-496f-a688-8ecd5757cb42",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "52d25040-1923-448f-b576-67b67b73e162",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aed8cbe1-b382-4fed-858e-147ba7bc8fe0",
"name": "設定 response to 0 - 2",
"type": "n8n-nodes-base.set",
"position": [
3520,
-720
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "32bd210f-6366-4fda-92c9-8e5f2497c009",
"name": "設定 response to 0 - 1",
"type": "n8n-nodes-base.set",
"position": [
2180,
-740
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "01468467-9d2b-4eb3-a93a-a25c95ccafd2",
"name": "Fetch Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
-270
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "27758dfa-11d2-45e2-88bc-0563a2ac36fa",
"name": "Update data",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
-620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "6f8bf3c8-5cbd-4eee-a4b6-4bf808453554",
"name": "設定 is_connection",
"type": "n8n-nodes-base.set",
"position": [
4400,
-720
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "21189e0e-fbc2-4e2f-86f0-dfe6cc53f33d",
"name": "Is it a connection?",
"type": "n8n-nodes-browserflow.browserflow",
"position": [
4400,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0e555129-caa2-42aa-bc04-67ef467e0e1a",
"name": "Send message with LinkedIn",
"type": "n8n-nodes-browserflow.browserflow",
"position": [
5060,
-820
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6a31ff75-767f-44f1-a1d6-f36ee4b42e98",
"name": "Send connection request",
"type": "n8n-nodes-browserflow.browserflow",
"position": [
5060,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a5f1e4c-8ba4-4a3a-ae2a-cbba705358af",
"name": "Next item",
"type": "n8n-nodes-base.splitInBatches",
"position": [
660,
-270
],
"parameters": {},
"typeVersion": 3
},
{
"id": "5f5d0d99-f5db-4b5d-bc04-7d3fd7143293",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3690,
-1020
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9b52eef3-6b9e-4a8f-93fb-02b68d9ae2cd",
"name": "ソート",
"type": "n8n-nodes-base.sort",
"position": [
3080,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fd218308-e57d-42ef-905b-c0a900dd179f",
"name": "ソート1",
"type": "n8n-nodes-base.sort",
"position": [
1760,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "82c8aba2-9a19-4715-8b42-212ac6a9d41d",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
-1060
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Sort": {
"main": [
[
{
"node": "Limit1",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Sort1": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Limit1": {
"main": [
[
{
"node": "Aggregate1",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "52114828-975f-4e52-bb9e-f2defa063bec",
"type": "main",
"index": 0
}
]
]
},
"5a5f1e4c-8ba4-4a3a-ae2a-cbba705358af": {
"main": [
[],
[
{
"node": "c1db5f92-e443-47fd-bc13-9c9c94defa2f",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Sort1",
"type": "main",
"index": 0
}
]
]
},
"Aggregate1": {
"main": [
[
{
"node": "b797df08-23ff-474c-a850-40cf19f33a52",
"type": "main",
"index": 0
}
]
]
},
"01468467-9d2b-4eb3-a93a-a25c95ccafd2": {
"main": [
[
{
"node": "5a5f1e4c-8ba4-4a3a-ae2a-cbba705358af",
"type": "main",
"index": 0
}
]
]
},
"Split Out1": {
"main": [
[
{
"node": "Sort",
"type": "main",
"index": 0
}
]
]
},
"27758dfa-11d2-45e2-88bc-0563a2ac36fa": {
"main": [
[
{
"node": "18889bd9-6746-4c0f-a01b-3a6c24556420",
"type": "main",
"index": 0
}
]
]
},
"a87bafb7-fe4d-4125-91f0-d9cb07271d37": {
"main": [
[
{
"node": "78b4685c-1cfb-4801-a671-8fe035138ed3",
"type": "main",
"index": 0
}
],
[
{
"node": "1f61c7ce-f4be-44c8-8e0b-41a55301b4af",
"type": "main",
"index": 0
}
]
]
},
"18889bd9-6746-4c0f-a01b-3a6c24556420": {
"main": [
[
{
"node": "Set is_connection",
"type": "main",
"index": 0
}
],
[
{
"node": "21189e0e-fbc2-4e2f-86f0-dfe6cc53f33d",
"type": "main",
"index": 0
}
]
]
},
"b797df08-23ff-474c-a850-40cf19f33a52": {
"main": [
[
{
"node": "27758dfa-11d2-45e2-88bc-0563a2ac36fa",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set your data here",
"type": "main",
"index": 0
}
]
]
},
"bcca8db0-ecaf-43be-819f-85a5b3161a4e": {
"main": [
[
{
"node": "Split Out1",
"type": "main",
"index": 0
}
]
]
},
"c7baf889-8002-4f34-bb13-814544bd3382": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "be4e2a75-7b5d-447e-9f0f-aeb75d57cc33",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Set is_connection": {
"main": [
[
{
"node": "a87bafb7-fe4d-4125-91f0-d9cb07271d37",
"type": "main",
"index": 0
}
]
]
},
"1f61c7ce-f4be-44c8-8e0b-41a55301b4af": {
"main": [
[
{
"node": "6a31ff75-767f-44f1-a1d6-f36ee4b42e98",
"type": "main",
"index": 0
}
]
]
},
"Set your data here": {
"main": [
[
{
"node": "01468467-9d2b-4eb3-a93a-a25c95ccafd2",
"type": "main",
"index": 0
}
]
]
},
"8ff459a0-9023-4e73-b82e-79925bf1304e": {
"main": [
[
{
"node": "5a5f1e4c-8ba4-4a3a-ae2a-cbba705358af",
"type": "main",
"index": 0
}
]
]
},
"94fdb018-6bcd-4bd1-ad64-c540bffaa635": {
"main": [
[]
]
},
"78b4685c-1cfb-4801-a671-8fe035138ed3": {
"main": [
[
{
"node": "0e555129-caa2-42aa-bc04-67ef467e0e1a",
"type": "main",
"index": 0
}
],
[
{
"node": "94fdb018-6bcd-4bd1-ad64-c540bffaa635",
"type": "main",
"index": 0
}
]
]
},
"21189e0e-fbc2-4e2f-86f0-dfe6cc53f33d": {
"main": [
[
{
"node": "a87bafb7-fe4d-4125-91f0-d9cb07271d37",
"type": "main",
"index": 0
}
]
]
},
"57aaf87f-6d84-40e5-9d99-94c67f6dbc40": {
"main": [
[
{
"node": "5a5f1e4c-8ba4-4a3a-ae2a-cbba705358af",
"type": "main",
"index": 0
}
]
]
},
"0f8f39ec-0885-46de-80db-3b95fb4dfce5": {
"main": [
[
{
"node": "Set response to 0 - 1",
"type": "main",
"index": 0
}
],
[
{
"node": "c7baf889-8002-4f34-bb13-814544bd3382",
"type": "main",
"index": 0
}
]
]
},
"Set response to 0 - 1": {
"main": [
[
{
"node": "52114828-975f-4e52-bb9e-f2defa063bec",
"type": "main",
"index": 0
}
]
]
},
"Set response to 0 - 2": {
"main": [
[
{
"node": "b797df08-23ff-474c-a850-40cf19f33a52",
"type": "main",
"index": 0
}
]
]
},
"52114828-975f-4e52-bb9e-f2defa063bec": {
"main": [
[
{
"node": "Set response to 0 - 2",
"type": "main",
"index": 0
}
],
[
{
"node": "bcca8db0-ecaf-43be-819f-85a5b3161a4e",
"type": "main",
"index": 0
}
]
]
},
"c1db5f92-e443-47fd-bc13-9c9c94defa2f": {
"main": [
[
{
"node": "0f8f39ec-0885-46de-80db-3b95fb4dfce5",
"type": "main",
"index": 0
}
]
]
},
"6a31ff75-767f-44f1-a1d6-f36ee4b42e98": {
"main": [
[
{
"node": "8ff459a0-9023-4e73-b82e-79925bf1304e",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "be4e2a75-7b5d-447e-9f0f-aeb75d57cc33",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"0e555129-caa2-42aa-bc04-67ef467e0e1a": {
"main": [
[
{
"node": "57aaf87f-6d84-40e5-9d99-94c67f6dbc40",
"type": "main",
"index": 0
}
]
]
},
"80b3d58d-2d4e-4bff-b4d4-7483a7395c1b": {
"main": [
[
{
"node": "be4e2a75-7b5d-447e-9f0f-aeb75d57cc33",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Set your data here",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 営業, 人事, 人工知能, マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
HDWリードジェットバグ
AIエージェントを使用した自動LinkedInリード生成、スコアリング、コミュニケーション
If
Code
Sort
+
If
Code
Sort
86 ノードAndrey
営業
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
AIを使ってWordPressのブログ記事に自動でタグを追加
AIを使ってWordPressブログ記事に自動でタグを付ける
If
Set
Code
+
If
Set
Code
32 ノードLudwig
人工知能
WordPressブログの自動化プロフェッショナル版（先端研究）v2.1マーケットプラグイン
GPT-4o、Perplexity AI、そして多言語対応を使ったSEO最適化ブログ作成の自動化
If
Set
Xml
+
If
Set
Xml
125 ノードDaniel Ng
コンテンツ作成
OpenAIスクリプト、Leonardo画像、HeyGenバーチャルキャラを使ってAI動画を作成する
OpenAIスクリプト、Leonardoイメージ、HeyGenバーチャルアバターでAIビデオを作成
If
Set
Code
+
If
Set
Code
68 ノードAdam Crafts
デザイン
ワークフロー情報
難易度
上級
ノード数44
カテゴリー4
ノードタイプ18
作成者
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
外部リンク
n8n.ioで表示 →
このワークフローを共有