使用 Browserflow 和 Google Sheets 跟踪自动化 LinkedIn 邀请
高级
这是一个Lead Nurturing, Miscellaneous, Multimodal AI领域的自动化工作流，包含 23 个节点。主要使用 If, Set, Wait, Limit, Filter 等节点。 使用 Browserflow 和 Google Sheets 跟踪自动化 LinkedIn 邀请
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "e2b72466a589dd1250fc94a8e861457e040bf25b07f6b069958c036d3f2bfe77",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "9ee2794b-b0ca-45f3-af78-5089b156a4bc",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-784,
-592
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d1e6e3bd-8ad2-4415-8c9a-f3bd035fd4ed",
"name": "限制",
"type": "n8n-nodes-base.limit",
"position": [
288,
-592
],
"parameters": {
"maxItems": 5
},
"typeVersion": 1
},
{
"id": "59fef9a9-9191-4af8-b050-4eb80c91cedf",
"name": "未连接",
"type": "n8n-nodes-browserflow.browserflow",
"position": [
-464,
-48
],
"parameters": {
"linkedinUrl": "={{ $('contacts').item.json.url }}"
},
"credentials": {
"browserflowApi": {
"id": "xVoYL8fNGAXfZvQX",
"name": "Browserflow account"
}
},
"typeVersion": 1
},
{
"id": "5b597bf1-d128-4c56-aa5b-50e9a875f4f7",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-224,
-48
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "a71cb67c-639f-49e5-9d64-30b19a067e20",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
},
"leftValue": "={{ $json.is_connection }}",
"rightValue": ""
},
{
"id": "52065840-16a5-4492-b914-c09383cae858",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
},
"leftValue": "={{ $json.is_pending }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "cc8cfe32-d384-4d22-9f71-8f238771dede",
"name": "发送邀请",
"type": "n8n-nodes-browserflow.browserflow",
"position": [
288,
-240
],
"parameters": {
"message": "={{ $json.message }}",
"operation": "sendConnectionInvite",
"addMessage": true,
"linkedinUrl": "={{ $('contacts').item.json.url }}"
},
"credentials": {
"browserflowApi": {
"id": "xVoYL8fNGAXfZvQX",
"name": "Browserflow account"
}
},
"typeVersion": 1
},
{
"id": "6ae4df3c-92fb-4330-b185-7c2cc18097fc",
"name": "消息",
"type": "n8n-nodes-base.set",
"position": [
16,
-240
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "499bbff5-88f0-4c51-acae-71106cd32c4d",
"name": "message",
"type": "string",
"value": "=Dear {{ $('contacts').item.json.firstname }},\nRight now building a framework to help revenu teams to drive efficient outbound strategies. This n8n automation is part of the solution. Happy to connect and get your feedback !\nThe n8n About team."
}
]
}
},
"typeVersion": 3.4
},
{
"id": "d1e4c9c7-805e-4d16-956f-fe2b49ae4cbf",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-752,
-64
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "072908e0-eb3a-429e-9b93-b61c5520b423",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
800,
128
],
"webhookId": "39849edd-3556-4405-a12c-24634d5d61b9",
"parameters": {
"amount": 60
},
"typeVersion": 1.1
},
{
"id": "f977bbc7-1841-4157-9caf-de34b7bac7af",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1072,
-784
],
"parameters": {
"color": 7,
"width": 688,
"height": 1472,
"content": "# 使用 Browserflow 管理 LinkedIn 邀请"
},
"typeVersion": 1
},
{
"id": "490770f2-7aa1-420e-9c5c-e40357f548a7",
"name": "联系人",
"type": "n8n-nodes-base.googleSheets",
"position": [
-256,
-592
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1877973285,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VPUd7xbigvW4dIjyvsSRn3Y3jpITjyZneCIEU0HK_Hw/edit#gid=1877973285",
"cachedResultName": "contacts"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.googlesheetid }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "0xG6VARJ6hnHx2T1",
"name": "Google Sheets account"
}
},
"typeVersion": 4.4
},
{
"id": "43996334-8e32-4f69-88d4-1ff420baa73c",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-304,
-720
],
"parameters": {
"color": 7,
"width": 192,
"height": 96,
"content": ""
},
"typeVersion": 1
},
{
"id": "d071f42c-af34-4e17-8f12-19dbc2d65f74",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-544,
-720
],
"parameters": {
"color": 7,
"width": 192,
"height": 96,
"content": "设置您要使用的 Google Sheet ID"
},
"typeVersion": 1
},
{
"id": "086470a9-e3c7-455c-89c6-4c16c432a0b8",
"name": "设置",
"type": "n8n-nodes-base.set",
"position": [
-496,
-592
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4b74909d-6a40-422f-9d5a-1d72f5577f3f",
"name": "googlesheetid",
"type": "string",
"value": "<input your google sheet ID here>"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2fbf5436-3336-47c5-b4b3-d58399b7f588",
"name": "更新联系人",
"type": "n8n-nodes-base.googleSheets",
"position": [
576,
128
],
"parameters": {
"columns": {
"value": {
"invitation": "={{ $('isnotconnected').item.json.is_pending ? \"pending\" : \"connected\" }}",
"row_number": "={{ $('contacts').item.json.row_number }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "firstname",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lastname",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "process",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "process",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "err",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "err",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "invitation",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "invitation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "contacts"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('settings').item.json.googlesheetid }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "0xG6VARJ6hnHx2T1",
"name": "Google Sheets account"
}
},
"typeVersion": 4.4
},
{
"id": "49059013-0634-40f4-981b-35abae3f50f4",
"name": "更新邀请",
"type": "n8n-nodes-base.googleSheets",
"position": [
576,
-240
],
"parameters": {
"columns": {
"value": {
"invitation": "Y",
"row_number": "={{ $('contacts').item.json.row_number }}"
},
"schema": [
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "firstname",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lastname",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "process",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "process",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "err",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "err",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "invitation",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "invitation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "contacts"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('settings').item.json.googlesheetid }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "0xG6VARJ6hnHx2T1",
"name": "Google Sheets account"
}
},
"typeVersion": 4.4
},
{
"id": "8142467b-f381-418c-b60b-ce3d3302bd2a",
"name": "已连接或待处理",
"type": "n8n-nodes-base.noOp",
"position": [
16,
128
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1e374508-72e5-44ef-bc64-e02e63ccffd9",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-32,
-720
],
"parameters": {
"color": 7,
"width": 192,
"height": 96,
"content": "仅包含 \"invitation\" 为空白的联系人"
},
"typeVersion": 1
},
{
"id": "c44aa167-8328-4360-ad92-a4c8b840ae47",
"name": "最终列表",
"type": "n8n-nodes-base.filter",
"position": [
16,
-592
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d1bb2dee-2f47-43df-afe7-99a558791923",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.invitation }}",
"rightValue": "={{ $('settings').item.json.employee }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a101058d-12b1-478c-8df5-795b1df17759",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-32,
-352
],
"parameters": {
"color": 7,
"width": 192,
"height": 368,
"content": "在此节点中更新邀请消息！"
},
"typeVersion": 1
},
{
"id": "aca1f550-7b02-49e2-867f-5834379cc176",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
528,
-352
],
"parameters": {
"color": 7,
"width": 192,
"height": 96,
"content": "将联系人标记为已邀请。invitation = \"Y\""
},
"typeVersion": 1
},
{
"id": "8985a78d-08a1-4f27-9271-98f2ad09cf44",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
-720
],
"parameters": {
"color": 7,
"width": 192,
"height": 96,
"content": "仅用于测试 / 调试"
},
"typeVersion": 1
},
{
"id": "72db3d5a-c0f2-4dc4-b6e1-8fe11255832a",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
528,
320
],
"parameters": {
"color": 7,
"width": 192,
"height": 96,
"content": "将联系人标记为 \"connected\" 或 \"pending\""
},
"typeVersion": 1
},
{
"id": "ff214055-3496-4feb-9d7a-528ea54064a3",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
752,
0
],
"parameters": {
"color": 7,
"width": 192,
"height": 96,
"content": "在此处更新等待时间"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "message",
"type": "main",
"index": 0
}
],
[
{
"node": "alreadyconnectedorpending",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"message": {
"main": [
[
{
"node": "sendinvite",
"type": "main",
"index": 0
}
]
]
},
"contacts": {
"main": [
[
{
"node": "finallist",
"type": "main",
"index": 0
}
]
]
},
"settings": {
"main": [
[
{
"node": "contacts",
"type": "main",
"index": 0
}
]
]
},
"finallist": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"sendinvite": {
"main": [
[
{
"node": "updateinvitation",
"type": "main",
"index": 0
}
]
]
},
"updatecontact": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"isnotconnected": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "isnotconnected",
"type": "main",
"index": 0
}
]
]
},
"updateinvitation": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"alreadyconnectedorpending": {
"main": [
[
{
"node": "updatecontact",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "settings",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客户培育, 杂项, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
GPT-4驱动的冷邮件工作流，包含完全定制的3封邮件跟进
使用GPT-4、Mailgun和Supabase自动化个性化冷邮件序列
If
Set
Code
+22
100 节点Paul
客户培育
使用Airtable、OpenAI和Unipile的自动化LinkedIn潜在客户生成与私信触达
使用Airtable、OpenAI和Unipile的自动化LinkedIn潜在客户生成与私信触达
If
Set
Code
+15
143 节点Ruben AI
客户培育
B2B 外联自动化：LinkedIn 到邮件序列
B2B 外联自动化：使用 GPT、AnyMailFinder 和 Perplexity 从 LinkedIn 到邮件序列
If
Set
Code
+11
25 节点LukaszB
客户培育
邮件外展自动化
使用Google Sheets和Gmail的免费邮件跟进序列
If
Set
Html
+9
18 节点Gerald Denor
客户培育
Google Sheets 联系人同步至 SeaTable（更新插入逻辑）
将 Google Sheets 联系人同步至 SeaTable，支持更新/插入逻辑
If
Set
Sea Table
+6
18 节点Stéphane Heckel
客户关系管理
带版本控制和 Notion 跟踪的 n8n 工作流备份
带版本控制和 Notion 跟踪的 n8n 工作流备份
If
N8n
Wait
+9
28 节点Stéphane Heckel
开发运维
