使用 GPT-4O、PhantomBuster 和 Google Sheets 的个性化 LinkedIn 外展
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 16 个节点。主要使用 Gmail, Limit, Aggregate, HttpRequest, GoogleSheets 等节点。 使用 GPT-4O、PhantomBuster 和 Google Sheets 的个性化 LinkedIn 外展
前置要求
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "73e3c0fd395bfd0d194601f37f29fe40e0317103ab5899d92df39eaef2eb4c87",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "b8539b60-3399-43ce-93ab-13ebe20ec771",
"name": "触发PhantomBuster智能体",
"type": "n8n-nodes-base.httpRequest",
"position": [
1696,
96
],
"parameters": {
"url": "https://api.phantombuster.com/api/v2/agents/launch",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "id",
"value": "={{ $('Sticky Note4').item.json.phantombuster_agent_id }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-Phantombuster-Key",
"value": "={{ $credentials.phantombusterApi.apiKey }}"
}
]
}
},
"credentials": {
"phantombusterApi": {
"id": "phantombusterApi",
"name": "PhantomBuster API"
}
},
"typeVersion": 4.2
},
{
"id": "e2d8083d-8473-4e3f-8046-cc6ef3c1a980",
"name": "添加到Google表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1248,
96
],
"parameters": {
"columns": {
"value": {
"id": "={{ $('Limit1').item.json.vmid }}",
"name": "={{ $('Limit1').item.json.name }}",
"title": "={{ $('Limit1').item.json.title }}",
"last_name": "={{ $('Limit1').item.json.lastName }}",
"photo_url": "={{ $('Limit1').item.json.profileImageUrl }}",
"first_name": "={{ $('Limit1').item.json.firstName }}",
"icebreaker": "={{ $json.message.content.icebreaker }}",
"linkedin_url": "={{ $('Limit1').item.json.linkedInProfileUrl }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_status",
"type": "string",
"display": true,
"required": false,
"displayName": "email_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "photo_url",
"type": "string",
"display": true,
"required": false,
"displayName": "photo_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "icebreaker",
"type": "string",
"display": true,
"required": false,
"displayName": "icebreaker",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"useAppend": true
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "googleSheetsOAuth2Api",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "80846526-ff04-4e1b-8745-262f8515c6a3",
"name": "个性化外联",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
896,
96
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "You are a helpful, intelligent writing assistant."
},
{
"content": "Your task is to take as input a bunch of LinkedIn profile information of a user, and then generate a very short, very punchy icebreaker that I can use as a variable in my connection request.\n\nReturn your results in this format:\n\n{\"icebreaker\":\"Icebreaker goes here\"}\n\nIn order to ensure icebreakers are punchy and high-quality, make them follow this template:\n\nHey {{name}}, loved seeing {{thingAboutThem}}. I'm also into {{plausibleTieIn}}, thought I'd connect.\n\nFor {{thingAboutThem}} and {{plausibleTieIn}}, never use the exact information provided in a LinkedIn field. Instead, always paraphrase. This makes it seem human written, instead of just an automated message. Also, make it super short. Don't say stuff like \"passionate about turning vision into reality\" or anything like that—be extremely laconic and spartan."
},
{
"content": "{\"linkedInFields\":\"John Toraason, Peru Illinois United States, President Founder at Toraason Marketing Group,\"}"
},
{
"role": "assistant",
"content": "{\n \"icebreaker\": \"Hey John, loved seeing your Toraason Marketing Group journey. I'm also building brands, thought I'd connect.\"\n}"
},
{
"content": "={\"linkedInFields\":\"{{ $json.firstName }} {{ $json.lastName }} , {{ $json.location }}, {{ $json.title }} at {{ $json.companyName }}, current experience: {{ $json.titleDescription }} at {{ $json.companyName }}\"} "
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "openAiApi",
"name": "OpenAI account"
}
},
"typeVersion": 1.6
},
{
"id": "4aedf991-1644-4f86-96e7-920874276ac0",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
1472,
96
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "21365e6e-89ac-4d39-979f-5ad487454249",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
448,
96
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "googleSheetsOAuth2Api",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "8c58d792-93b1-4a71-9061-d08a55263524",
"name": "限制1",
"type": "n8n-nodes-base.limit",
"position": [
672,
96
],
"parameters": {
"maxItems": 10
},
"typeVersion": 1
},
{
"id": "67029c61-416f-4fbd-9e32-d8e1d4422312",
"name": "从表格中删除行或列",
"type": "n8n-nodes-base.googleSheets",
"position": [
1920,
96
],
"parameters": {
"operation": "delete",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
},
"numberToDelete": 10
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "googleSheetsOAuth2Api",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "66d51e51-5b3d-4f05-8a20-d07b8f9b9f49",
"name": "从表格1中删除行或列",
"type": "n8n-nodes-base.googleSheets",
"position": [
224,
96
],
"parameters": {
"operation": "delete",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
},
"numberToDelete": 10
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "googleSheetsOAuth2Api",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "78985aa9-3dcd-4c18-a4b6-47b37bc75f0a",
"name": "发送消息",
"type": "n8n-nodes-base.gmail",
"position": [
2128,
96
],
"webhookId": "ce5e7da2-7c8b-4cc0-89f7-76d09da57ec8",
"parameters": {
"sendTo": "",
"message": "LinkedIn connection request campaign completed successfully.",
"options": {},
"subject": "Connection Request Sent",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "gmailOAuth2",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "1385458c-49f9-46a9-ad50-b22cd50ab5bb",
"name": "计划触发器1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
224
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 2
}
]
}
},
"typeVersion": 1.2
},
{
"id": "94b0f87e-021b-471f-891a-2889b2597a30",
"name": "计划触发器2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
-32
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 19
}
]
}
},
"typeVersion": 1.2
},
{
"id": "fe056929-674f-417f-a819-0f83546c50c0",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
-208
],
"parameters": {
"width": 624,
"height": 256,
"content": "步骤2：数据处理与AI个性化"
},
"typeVersion": 1
},
{
"id": "3df1e47e-2cf5-49b9-9ad0-855dbf04d505",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-256,
-320
],
"parameters": {
"width": 416,
"height": 272,
"content": "步骤1：自动调度"
},
"typeVersion": 1
},
{
"id": "83397ef1-6f39-4bca-a446-8eab7d77e96b",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1248,
-208
],
"parameters": {
"width": 512,
"height": 256,
"content": "步骤3：潜在客户管理与活动执行"
},
"typeVersion": 1
},
{
"id": "c82ced29-e169-47ea-9aaf-41cc97a37b9a",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1904,
-160
],
"parameters": {
"width": 432,
"height": 240,
"content": "步骤4：清理与通知系统"
},
"typeVersion": 1
},
{
"id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1696,
-160
],
"parameters": {
"width": 320,
"height": 180,
"content": "⚙️ 需要设置"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Limit1": {
"main": [
[
{
"node": "Personalize Outreach",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Trigger PhantomBuster Agent",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Delete rows or columns from sheet1",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger2": {
"main": [
[
{
"node": "Delete rows or columns from sheet1",
"type": "main",
"index": 0
}
]
]
},
"Add to Google Sheet": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Limit1",
"type": "main",
"index": 0
}
]
]
},
"Personalize Outreach": {
"main": [
[
{
"node": "Add to Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Trigger PhantomBuster Agent": {
"main": [
[
{
"node": "Delete rows or columns from sheet",
"type": "main",
"index": 0
}
]
]
},
"Delete rows or columns from sheet": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"Delete rows or columns from sheet1": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
TikTok轮播复制器与翻译器
使用Gemini Vision和Midjourney自动翻译并重新创建TikTok轮播内容
If
Wait
Gmail
+11
21 节点Xavier Tai
内容创作
WordPress、OpenAI与Perplexity的自动化SEO博客发布
WordPress、OpenAI与Perplexity的自动化SEO博客发布
Set
Limit
Split Out
+14
43 节点LukaszB
内容创作
使用OpenAI-Gemini创建Dev.to文章 - AI生成带图片内容
使用OpenAI/Gemini创建Dev.to文章 - AI生成带图片内容
Set
Limit
Split Out
+13
30 节点LukaszB
内容创作
使用GPT 5 Nano和Google Sheets的网站SEO常见问题生成器
使用GPT 5 Nano和Google Sheets的网站SEO常见问题生成器
Set
Xml
Code
+11
35 节点Oriol Seguí
内容创作
使用Dumpling AI从YouTube视频自动生成平台特定帖子
使用GPT-4o和Dumpling AI从YouTube视频自动生成Instagram、Facebook和LinkedIn帖子
Set
Code
Merge
+6
20 节点Yang
内容创作
Apollo 数据抓取与触达流程 1 ✅
使用 Apollo、AI 解析和定时邮件跟进自动生成潜在客户
If
Code
Wait
+13
39 节点Deniz
内容创作
工作流信息
难度等级
高级
节点数量16
分类2
节点类型8
作者
Hassan
@sycordaAI Automation Strategist. I build AI agents that increase your revenue while reducing costs.
外部链接
在 n8n.io 查看 →
分享此工作流