使用 Browserflow 和 Google Sheets 自动化 LinkedIn
高级
这是一个Sales, HR, AI, Marketing领域的自动化工作流，包含 44 个节点。主要使用 If, Set, Sort, Limit, SplitOut 等节点，结合人工智能技术实现智能自动化。 使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (44)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "0c71b4d0-6242-4aa0-abde-57b7961b19dd",
"name": "点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
-220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a87bafb7-fe4d-4125-91f0-d9cb07271d37",
"name": "如果已连接",
"type": "n8n-nodes-base.if",
"position": [
4620,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "78b4685c-1cfb-4801-a671-8fe035138ed3",
"name": "如果未发送消息",
"type": "n8n-nodes-base.if",
"position": [
4840,
-720
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "1f61c7ce-f4be-44c8-8e0b-41a55301b4af",
"name": "如果未发送邀请",
"type": "n8n-nodes-base.if",
"position": [
4840,
-420
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "57aaf87f-6d84-40e5-9d99-94c67f6dbc40",
"name": "更新消息已发送",
"type": "n8n-nodes-base.googleSheets",
"position": [
5280,
-545
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "8ff459a0-9023-4e73-b82e-79925bf1304e",
"name": "更新邀请已发送",
"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": "更新是关系",
"type": "n8n-nodes-base.googleSheets",
"position": [
5060,
-620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "18889bd9-6746-4c0f-a01b-3a6c24556420",
"name": "如果是关系？",
"type": "n8n-nodes-base.if",
"position": [
4180,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "b797df08-23ff-474c-a850-40cf19f33a52",
"name": "生成邮件",
"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": "搜索用户资料",
"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": "获取资料帖子",
"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": "获取公司帖子",
"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": "在此设置您的数据",
"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": "如果用户名为空",
"type": "n8n-nodes-base.if",
"position": [
1100,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "52114828-975f-4e52-bb9e-f2defa063bec",
"name": "如果公司ID为空",
"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": "根据匹配生成主题和求职信",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
200,
280
],
"parameters": {},
"typeVersion": 1.5
},
{
"id": "80b3d58d-2d4e-4bff-b4d4-7483a7395c1b",
"name": "当被另一个工作流执行时",
"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": "设置响应为0-2",
"type": "n8n-nodes-base.set",
"position": [
3520,
-720
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "32bd210f-6366-4fda-92c9-8e5f2497c009",
"name": "设置响应为0-1",
"type": "n8n-nodes-base.set",
"position": [
2180,
-740
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "01468467-9d2b-4eb3-a93a-a25c95ccafd2",
"name": "获取数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
-270
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "27758dfa-11d2-45e2-88bc-0563a2ac36fa",
"name": "更新数据",
"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": "是否是连接？",
"type": "n8n-nodes-browserflow.browserflow",
"position": [
4400,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0e555129-caa2-42aa-bc04-67ef467e0e1a",
"name": "通过LinkedIn发送消息",
"type": "n8n-nodes-browserflow.browserflow",
"position": [
5060,
-820
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6a31ff75-767f-44f1-a1d6-f36ee4b42e98",
"name": "发送连接请求",
"type": "n8n-nodes-browserflow.browserflow",
"position": [
5060,
-420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a5f1e4c-8ba4-4a3a-ae2a-cbba705358af",
"name": "下一项",
"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": {
"9b52eef3-6b9e-4a8f-93fb-02b68d9ae2cd": {
"main": [
[
{
"node": "27b9b333-f2d8-4b73-8ab9-17f2e47f319c",
"type": "main",
"index": 0
}
]
]
},
"b70be38f-ab85-4386-94de-8be19f430f30": {
"main": [
[
{
"node": "2037083b-65ff-423e-add9-82631ab8c4e1",
"type": "main",
"index": 0
}
]
]
},
"fd218308-e57d-42ef-905b-c0a900dd179f": {
"main": [
[
{
"node": "b70be38f-ab85-4386-94de-8be19f430f30",
"type": "main",
"index": 0
}
]
]
},
"27b9b333-f2d8-4b73-8ab9-17f2e47f319c": {
"main": [
[
{
"node": "40535e7e-aa33-4c23-92e8-2ba996b0cb7d",
"type": "main",
"index": 0
}
]
]
},
"2037083b-65ff-423e-add9-82631ab8c4e1": {
"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
}
]
]
},
"6856b9b2-263e-4542-b57f-bae59d8eb279": {
"main": [
[
{
"node": "fd218308-e57d-42ef-905b-c0a900dd179f",
"type": "main",
"index": 0
}
]
]
},
"40535e7e-aa33-4c23-92e8-2ba996b0cb7d": {
"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
}
]
]
},
"1e92021e-af03-4cb4-a542-843ce287c066": {
"main": [
[
{
"node": "9b52eef3-6b9e-4a8f-93fb-02b68d9ae2cd",
"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": "6f8bf3c8-5cbd-4eee-a4b6-4bf808453554",
"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
}
]
]
},
"be8df92c-6072-457b-bb9c-a37fa806e46a": {
"main": [
[
{
"node": "e67ec580-0a55-49d4-9252-69fc92bf2eae",
"type": "main",
"index": 0
}
]
]
},
"bcca8db0-ecaf-43be-819f-85a5b3161a4e": {
"main": [
[
{
"node": "1e92021e-af03-4cb4-a542-843ce287c066",
"type": "main",
"index": 0
}
]
]
},
"c7baf889-8002-4f34-bb13-814544bd3382": {
"main": [
[
{
"node": "6856b9b2-263e-4542-b57f-bae59d8eb279",
"type": "main",
"index": 0
}
]
]
},
"ea632274-5035-47bf-beee-05860cdf86e4": {
"ai_languageModel": [
[
{
"node": "be4e2a75-7b5d-447e-9f0f-aeb75d57cc33",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"6f8bf3c8-5cbd-4eee-a4b6-4bf808453554": {
"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
}
]
]
},
"e67ec580-0a55-49d4-9252-69fc92bf2eae": {
"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": "32bd210f-6366-4fda-92c9-8e5f2497c009",
"type": "main",
"index": 0
}
],
[
{
"node": "c7baf889-8002-4f34-bb13-814544bd3382",
"type": "main",
"index": 0
}
]
]
},
"32bd210f-6366-4fda-92c9-8e5f2497c009": {
"main": [
[
{
"node": "52114828-975f-4e52-bb9e-f2defa063bec",
"type": "main",
"index": 0
}
]
]
},
"aed8cbe1-b382-4fed-858e-147ba7bc8fe0": {
"main": [
[
{
"node": "b797df08-23ff-474c-a850-40cf19f33a52",
"type": "main",
"index": 0
}
]
]
},
"52114828-975f-4e52-bb9e-f2defa063bec": {
"main": [
[
{
"node": "aed8cbe1-b382-4fed-858e-147ba7bc8fe0",
"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
}
]
]
},
"1ef7ef7b-e7d7-4aaf-b70f-fdbddba806ad": {
"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
}
]
]
},
"0c71b4d0-6242-4aa0-abde-57b7961b19dd": {
"main": [
[
{
"node": "e67ec580-0a55-49d4-9252-69fc92bf2eae",
"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 查看 →
分享此工作流