使用 Unipile 和 Google Sheets 自动发送 LinkedIn 联系人请求与破冰消息
高级
这是一个Other领域的自动化工作流，包含 44 个节点。主要使用 If, Set, Code, Form, Webhook 等节点。 使用 Unipile 和 Google Sheets 自动发送 LinkedIn 联系人请求与破冰消息
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (44)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "8bf19219-e4c1-4c79-a099-7e6668c4ae93",
"name": "当被其他工作流执行时",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-60,
500
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "4b41d0fd-dab3-45ef-ae61-0009cc6d375c",
"name": "创建 Webhook",
"type": "n8n-nodes-base.httpRequest",
"position": [
800,
-220
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "90098842-5bbc-45cf-adc9-84ca9be2c9b7",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
740,
-340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e2c28135-b7ee-40a0-9b14-a8147dd273da",
"name": "从此处开始",
"type": "n8n-nodes-base.formTrigger",
"position": [
-40,
-220
],
"webhookId": "806a9dba-c405-4fdd-98db-99883acb0362",
"parameters": {},
"typeVersion": 2.2
},
{
"id": "51ae0f60-af6d-4ed3-a988-2a59a179589c",
"name": "Webhook 状态响应",
"type": "n8n-nodes-base.form",
"position": [
1020,
-220
],
"webhookId": "3df5cbfb-3228-43da-b4c0-a300c279b7ae",
"parameters": {},
"typeVersion": 1
},
{
"id": "914e854b-dc8b-4425-a275-2ce262c4482c",
"name": "发送联系请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
1660,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2a03efc1-7bc1-443e-9777-448b549f367a",
"name": "如果不是关系",
"type": "n8n-nodes-base.if",
"position": [
1440,
120
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "87a675d8-b169-4aa7-8666-437aca5d5c46",
"name": "获取 LinkedIn 个人资料",
"type": "n8n-nodes-base.googleSheets",
"position": [
600,
120
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "4d56dff8-824f-4bef-87d9-78f499473dc1",
"name": "填充个人资料",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
120
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "bf9b3704-8e6b-45e3-a63b-82b72b4929cc",
"name": "响应 Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-60,
740
],
"webhookId": "5544529c-10ba-4626-b554-84daec00dcb4",
"parameters": {},
"typeVersion": 2
},
{
"id": "3a6bc6ea-ca8a-411e-b913-3643c4350bff",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
420
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cd6c9157-144b-45d9-8f57-ffce9c8da931",
"name": "获取聊天参与者",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
500
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "bd49f5cc-9b84-42c7-8320-70c5b0802291",
"name": "转换为文件",
"type": "n8n-nodes-base.convertToFile",
"position": [
380,
-220
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "47e7ebc7-3aed-4564-a5b3-bf3d39215590",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3c86a4c8-dfa1-4d0b-8133-6c0d14544faa",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
920
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "65211596-9813-4419-b7bd-078c85cf9bb6",
"name": "从文件提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
360,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0dc99232-ec2b-4f4e-b635-e73bd13046f4",
"name": "从文件1提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
340,
740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "724ad61b-00f9-4576-ae09-3e48d24cca33",
"name": "读取文件",
"type": "n8n-nodes-base.readWriteFile",
"position": [
160,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "65902c49-a150-441d-847f-578209ce15a5",
"name": "写入文件",
"type": "n8n-nodes-base.readWriteFile",
"position": [
600,
-220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "82ac3288-b7b1-491f-9d5f-f5f9e6fa9a0c",
"name": "读取文件1",
"type": "n8n-nodes-base.readWriteFile",
"position": [
140,
740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e627e203-931e-4b6a-bdc5-73e5d1bdb007",
"name": "从文件2提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
340,
500
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3040098d-c1bf-457e-a5bb-6a424066fbd2",
"name": "读取文件2",
"type": "n8n-nodes-base.readWriteFile",
"position": [
140,
500
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bc55190b-cbb6-4e42-b144-13a94cf80530",
"name": "获取 LinkedIn 个人资料1",
"type": "n8n-nodes-base.googleSheets",
"position": [
520,
740
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "37e9feba-9c79-472f-acbd-088bc0186912",
"name": "如果状态为已邀请",
"type": "n8n-nodes-base.if",
"position": [
700,
740
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "117cd9cf-6c29-4efa-8040-65613f58db0a",
"name": "发送破冰消息",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
920,
720
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e1f89ba6-9ce2-46b8-b175-6662deb5e115",
"name": "发送破冰消息1",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
1660,
240
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "bdfe75d4-06e6-4b47-b905-34176eaaf374",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ab62101f-a901-47e5-b725-a7fb6eab24f3",
"name": "拆分 DSN",
"type": "n8n-nodes-base.set",
"position": [
180,
-220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2a2b045a-c064-4014-838c-1474cf673d00",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c5005820-b07c-4572-ad84-25e7154c36c3",
"name": "更新状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
-20
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "497b6d4b-2ce0-4b63-927d-41a022a81a8c",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
-100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a149e351-9f6b-47bf-830c-935e6b9aca3e",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e9d38497-9deb-4a9c-8e60-997e7f8f64f8",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "18f44b02-b7dc-4efc-a28d-0587c6259a20",
"name": "获取用户 LinkedIn 数据",
"type": "n8n-nodes-base.httpRequest",
"position": [
1020,
120
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "e6df2a30-70d7-48ce-9313-e0180038e263",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9f571656-fa9f-41d0-b23a-0273d842ff7e",
"name": "使用此工作流启动整个流程",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-60,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a7586e81-72e5-48eb-a57e-49c3ae1d9814",
"name": "便利贴12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "89a35cf2-c3fc-4f06-b3a6-d2420bcfa862",
"name": "便利贴11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "00fb7683-f732-483a-a6f7-1e90aad7a6c3",
"name": "从 LinkedIn 链接提取用户名",
"type": "n8n-nodes-base.code",
"position": [
820,
120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ad6b7246-85e1-4ec1-b683-9d498305c5d0",
"name": "更新状态1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
720
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ffebd20a-99f5-4ce6-8ad1-2b7a47b4a92d",
"name": "开始聊天",
"type": "n8n-nodes-base.httpRequest",
"position": [
540,
500
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "e67649c3-8803-42a0-88b8-c463c1f16c04",
"name": "返回参与者 ID 和聊天 ID",
"type": "n8n-nodes-base.set",
"position": [
920,
500
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "8e1198a0-550e-45b5-8438-36ebb37f431a",
"name": "更新状态2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
240
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "6282e3ce-03da-4b37-81c0-2abdc34ac04e",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
420
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"connections": {
"Read file": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Read file1": {
"main": [
[
{
"node": "Extract from File1",
"type": "main",
"index": 0
}
]
]
},
"Read file2": {
"main": [
[
{
"node": "Extract from File2",
"type": "main",
"index": 0
}
]
]
},
"Start HERE": {
"main": [
[
{
"node": "Split the DSN",
"type": "main",
"index": 0
}
]
]
},
"Start chat": {
"main": [
[
{
"node": "Get chat participants",
"type": "main",
"index": 0
}
]
]
},
"Write file": {
"main": [
[
{
"node": "Create Webhook",
"type": "main",
"index": 0
}
]
]
},
"Split the DSN": {
"main": [
[
{
"node": "Convert to File",
"type": "main",
"index": 0
}
]
]
},
"Create Webhook": {
"main": [
[
{
"node": "Webhook status response",
"type": "main",
"index": 0
}
]
]
},
"Convert to File": {
"main": [
[
{
"node": "Write file",
"type": "main",
"index": 0
}
]
]
},
"Send Icebreaker": {
"main": [
[
{
"node": "Update status1",
"type": "main",
"index": 0
}
]
]
},
"Response Webhook": {
"main": [
[
{
"node": "Read file1",
"type": "main",
"index": 0
}
]
]
},
"Send Icebreaker1": {
"main": [
[
{
"node": "Update status2",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "Get linkedin profiles",
"type": "main",
"index": 0
}
]
]
},
"Populate profiles": {
"main": [
[
{
"node": "if not is_relationship",
"type": "main",
"index": 0
}
]
]
},
"Extract from File1": {
"main": [
[
{
"node": "Get linkedin profiles1",
"type": "main",
"index": 0
}
]
]
},
"Extract from File2": {
"main": [
[
{
"node": "Start chat",
"type": "main",
"index": 0
}
]
]
},
"If status is invited": {
"main": [
[
{
"node": "Send Icebreaker",
"type": "main",
"index": 0
}
]
]
},
"Send contact request": {
"main": [
[
{
"node": "Update status",
"type": "main",
"index": 0
}
]
]
},
"Get chat participants": {
"main": [
[
{
"node": "Return attendee ID and Chat ID",
"type": "main",
"index": 0
}
]
]
},
"Get linkedin profiles": {
"main": [
[
{
"node": "Extract username from Linkedin Link",
"type": "main",
"index": 0
}
]
]
},
"Get linkedin profiles1": {
"main": [
[
{
"node": "If status is invited",
"type": "main",
"index": 0
}
]
]
},
"Get user Linkedin data": {
"main": [
[
{
"node": "Populate profiles",
"type": "main",
"index": 0
}
]
]
},
"if not is_relationship": {
"main": [
[
{
"node": "Send contact request",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Icebreaker1",
"type": "main",
"index": 0
}
]
]
},
"Webhook status response": {
"main": [
[]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Read file2",
"type": "main",
"index": 0
}
]
]
},
"Extract username from Linkedin Link": {
"main": [
[
{
"node": "Get user Linkedin data",
"type": "main",
"index": 0
}
]
]
},
"Use this worflow to start the whole pocess": {
"main": [
[
{
"node": "Read file",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 其他
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
使用Google Sheets、Forms和Gmail通知自动化多步骤入职流程
使用Google Sheets、Forms和Gmail通知自动化多步骤入职流程
If
Set
Code
+11
31 节点PollupAI
人力资源
CSV到HubSpot上传器（动态字段映射与Google Sheets集成）
具有动态字段映射和Google Sheets集成的CSV到HubSpot上传器
If
Set
Code
+10
36 节点PollupAI
人工智能
HubSpot 联系人同步（含 LinkedIn URL）、变更检测与 Gmail 提醒
同步 HubSpot 联系人（含 LinkedIn URL），检测变更并发送 Gmail 提醒
If
Set
Code
+11
46 节点PollupAI
销售
使用 ComfyUI 生成 AI 媒体：图像、视频、3D 和音频桥接
使用 ComfyUI 生成 AI 媒体：图像、视频、3D 和音频桥接
If
Set
Code
+14
51 节点Nielo
设计
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
工作流信息
难度等级
高级
节点数量44
分类1
节点类型15
作者
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
外部链接
在 n8n.io 查看 →
分享此工作流