LinkedIn潜在客户查找与Gemini驱动的个性化触达（Google Sheets）
中级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 SplitOut, EmailSend, FormTrigger, HttpRequest, GoogleSheets 等节点。 LinkedIn潜在客户查找与Gemini驱动的个性化触达（Google Sheets）
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "783d2046f405cc6ecb20ef185376ed1023323a3da628b9d8156b1fb75c75e037",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "75d06417-5d15-4372-9aa5-bc9bf008cf37",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
3472,
-1072
],
"parameters": {
"options": {},
"fieldToSplitOut": "items"
},
"typeVersion": 1
},
{
"id": "bfcd5fd4-3ab1-44ed-ade4-c39ce5fca1e4",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
3696,
-1072
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "7d25973b-07b0-43b3-a067-85dc340b4d8d",
"name": "表单提交",
"type": "n8n-nodes-base.formTrigger",
"position": [
2768,
-1072
],
"webhookId": "1bd6594d-7541-4e65-a2fe-0311eca49001",
"parameters": {
"options": {},
"formTitle": "1.0 S_LG_Find LinkedIn Accounts by keywords and Write personal message for contact",
"formFields": {
"values": [
{
"fieldLabel": "Keywords to find Company / Professional"
},
{
"fieldLabel": "Purpose of Contact"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "4106578e-1721-4da3-8ec0-a85584d32c0d",
"name": "创建布尔搜索字符串",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
2960,
-1072
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "models/gemini-2.5-flash",
"cachedResultName": "models/gemini-2.5-flash"
},
"options": {},
"messages": {
"values": [
{
"content": "=You are a tool that generates Boolean search strings for Google, in order to search for companies or professionals on LinkedIn. \n\n# Task:\n- Based on the keyword and the purpose, generate a suitable keyword string for searching on LinkedIn. \n- Only return the keyword string, without any explanation or additional information. \n- Always add site:linkedin.com to the keyword string. \n\n# Input:\nKeyword: {{ $json['Keywords to find Company / Professional'] }}\nPurpose: {{ $json['Purpose of Contact'] }}"
}
]
}
},
"credentials": {
"googlePalmApi": {
"id": "Atcc45Iqep6u15qs",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "e64562e8-dd4c-448d-8c8c-0d1e3cc00c87",
"name": "获取 LinkedIn 公司",
"type": "n8n-nodes-base.httpRequest",
"position": [
3264,
-1072
],
"parameters": {
"url": "https://www.googleapis.com/customsearch/v1",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "key",
"value": "xxxxxxxxx"
},
{
"name": "cx",
"value": "xxxxx"
},
{
"name": "q",
"value": "={{ $json.content.parts[0].text }}"
},
{
"name": "num",
"value": "20"
},
{
"name": "hl",
"value": "vi"
},
{
"name": "gl",
"value": "vn"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "a69b91dd-72c7-4050-82c7-418175c21d10",
"name": "编写消息",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
4176,
-1056
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "models/gemini-1.5-flash",
"cachedResultName": "models/gemini-1.5-flash"
},
"options": {},
"messages": {
"values": [
{
"content": "=You are an AI that drafts outreach messages.\n\n# Requirements\nBased on the purpose: {{ $('Form submit').item.json['Purpose of Contact'] }}\nand the company information: \nname: {{ $json.name }} \ndescription: {{ $json.des }} \n\nWrite a suitable and personalized outreach message for that specific company. \n\nOnly return the outreach message, without any explanation or additional text. \nIf some information is missing, use placeholders. "
}
]
}
},
"credentials": {
"googlePalmApi": {
"id": "Atcc45Iqep6u15qs",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "f5eefcd1-cfb8-45fc-bc4a-67f88500b2c4",
"name": "更新表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
4496,
-1056
],
"parameters": {
"columns": {
"value": {
"message": "={{ $json.content.parts[0].text }}",
"row_number": 0,
"linkedin_url": "={{ $('Append row in sheet').item.json.linkedin_url }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "des",
"type": "string",
"display": true,
"required": false,
"displayName": "des",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "message",
"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": [
"linkedin_url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TlZ5uDYJAWm_hx_wkI7HXvXwuOL5WBdxRIMwjQ1kpEU/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "=xxxxx"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "urlO8dciDPm5B2zv",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "5159d49c-52fb-43c6-bb1e-9becc104fdcf",
"name": "发送邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
3952,
-1232
],
"webhookId": "f322979e-146f-4022-9f44-bc4eb261e33c",
"parameters": {
"html": "[Link to sheet]",
"options": {},
"subject": "Your auto writing message be completed",
"toEmail": "info@example.com",
"fromEmail": "admin@example.com"
},
"credentials": {
"smtp": {
"id": "CmiyUJFKtSRuiioY",
"name": "SMTP account"
}
},
"typeVersion": 2.1
},
{
"id": "1d35af31-c2cf-42c9-8e5b-e6796990925b",
"name": "在表格中追加行",
"type": "n8n-nodes-base.googleSheets",
"position": [
3952,
-1056
],
"parameters": {
"columns": {
"value": {
"des": "={{ $json.pagemap.metatags[0][\"og:description\"] }}",
"name": "={{ $json.title }}",
"linkedin_url": "={{ $json.link }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "des",
"type": "string",
"display": true,
"required": false,
"displayName": "des",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"linkedin_url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TlZ5uDYJAWm_hx_wkI7HXvXwuOL5WBdxRIMwjQ1kpEU/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "=xxxxx"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "urlO8dciDPm5B2zv",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "e7a90a44-a1bb-4727-9cbd-7d86e6a7a5d0",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3840,
-864
],
"parameters": {
"width": 352,
"content": "## Google Sheets 映射"
},
"typeVersion": 1
},
{
"id": "8bf56071-28f3-4b9d-81dc-c425695ee7a0",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3200,
-1168
],
"parameters": {
"width": 224,
"height": 272,
"content": "### 更新 hl 和 gl 以适配您的位置"
},
"typeVersion": 1
},
{
"id": "414c16fb-3015-489e-bbb5-f51272f45d2a",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2768,
-832
],
"parameters": {
"color": 3,
"width": 448,
"height": 240,
"content": "## 概述"
},
"typeVersion": 1
},
{
"id": "bbc5b875-1b07-406c-b856-ca285a73770e",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2768,
-560
],
"parameters": {
"color": 6,
"width": 448,
"height": 176,
"content": "## 需要设置"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Split Out": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Form submit": {
"main": [
[
{
"node": "Create boolean search strings",
"type": "main",
"index": 0
}
]
]
},
"Update sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Send email",
"type": "main",
"index": 0
}
],
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Writing message": {
"main": [
[
{
"node": "Update sheet",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Writing message",
"type": "main",
"index": 0
}
]
]
},
"Get Linkedin Company": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Create boolean search strings": {
"main": [
[
{
"node": "Get Linkedin Company",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
客户个性分析（八字、DISC、命理学）与 Gemini 和 Google Sheets
使用 Gemini 和 Google Sheets 进行客户个性分析（八字、DISC、命理学）
If
Code
Merge
+7
24 节点Cong Nguyen
潜在客户开发
使用OpenAI、Google表格和CraftMyPDF的自动化询价请求
使用OpenAI、Google表格和CraftMyPDF的自动化询价请求
Code
Email Send
Form Trigger
+5
9 节点Cong Nguyen
客户关系管理
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
Set
Code
Limit
+9
18 节点Cong Nguyen
市场调研
基于本地商业搜索的冷邮件开场白：GPT-4和Dumpling AI
基于本地商业搜索的冷邮件开场白：GPT-4和Dumpling AI
Filter
Split Out
Form Trigger
+5
10 节点Yang
潜在客户开发
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
基于AI的潜在客户生成（Apollo、LinkedIn研究和4步个性化邮件）
基于AI的潜在客户生成：使用Apollo、LinkedIn研究和4步个性化邮件
If
Set
Code
+8
30 节点Gain FLow AI
潜在客户开发
工作流信息
难度等级
中级
节点数量13
分类2
节点类型8
作者
Cong Nguyen
@cong-nguyenI’m a developer specialized in building web and mobile applications with AI integration and intelligent automation. With a solid background in data science, I help businesses build smarter digital solutions using cutting-edge technologies.
外部链接
在 n8n.io 查看 →
分享此工作流