简单LinkedIn资料收集器
高级
这是一个Sales, AI, Marketing领域的自动化工作流，包含 23 个节点。主要使用 Set, Merge, NocoDb, SplitOut, HttpRequest 等节点，结合人工智能技术实现智能自动化。 使用SerpAPI、OpenAI和NocoDB收集并AI处理LinkedIn个人资料
前置要求
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "W5cevjhP3xIQdMhT",
"meta": {
"instanceId": "b8ef33547995f2a520f12118ac1f7819ea58faa7a1096148cac519fa08be8e99",
"templateCredsSetupCompleted": true
},
"name": "简单 LinkedIn 资料收集器",
"tags": [
{
"id": "DDb2eQi5fXOMcVD6",
"name": "LinkedIn",
"createdAt": "2025-04-27T16:44:17.404Z",
"updatedAt": "2025-04-27T16:44:17.404Z"
},
{
"id": "WvVrZMOsmCMjmf8G",
"name": "leads",
"createdAt": "2025-05-05T13:14:14.918Z",
"updatedAt": "2025-05-05T13:14:14.918Z"
},
{
"id": "hIooJnHTaPcNsX7s",
"name": "SERP",
"createdAt": "2025-05-05T13:14:29.068Z",
"updatedAt": "2025-05-05T13:14:29.068Z"
}
],
"nodes": [
{
"id": "6a120c5d-3405-467e-8073-80bf30f2f0fc",
"name": "手动触发器",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-580,
160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a4cb9af-faff-4fba-a5ce-d2c9bc25a070",
"name": "使用 SerpAPI 进行 Google 搜索",
"type": "n8n-nodes-base.httpRequest",
"position": [
-100,
160
],
"parameters": {
"url": "https://serpapi.com/search",
"options": {},
"sendQuery": true,
"authentication": "predefinedCredentialType",
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "=site:{{ $json.site }} {{ $json.Keyword }} {{ $json.Location }}"
},
{
"name": "hl",
"value": "={{ $json['Host langauge'] }}"
},
{
"name": "gl",
"value": "={{ $json.Geolocation }}"
},
{
"name": "num",
"value": "={{ $json['Number of search results to be returned'] }}"
},
{
"name": "engine",
"value": "={{ $json['Search engine'] }}"
}
]
},
"nodeCredentialType": "serpApi"
},
"credentials": {
"serpApi": {
"id": "mL117f55z8IG4i1V",
"name": "SerpAPI account"
}
},
"typeVersion": 4.2
},
{
"id": "300e3483-0f7b-427d-9f95-bf631dbda3d3",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
340,
160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ab7399a3-8fe8-447b-b9c6-33240e07e2b6",
"name": "NameInLinkedinProfile",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "6f9a2bd6-e46d-4294-adbf-29aec0b8b2eb",
"name": "linkedinUrl",
"type": "string",
"value": "={{ $json.link }}"
},
{
"id": "e1e87eb4-ecc8-4b50-ab74-4c0a0016f84d",
"name": "Snippet",
"type": "string",
"value": "={{ $json.snippet }}"
},
{
"id": "632ee133-06be-4730-9178-6edde40e087a",
"name": "linkedinUrl",
"type": "string",
"value": "={{ $json.link }}"
},
{
"id": "9ce26329-eedf-47ae-815b-f19fc34b2e83",
"name": "Followers",
"type": "string",
"value": "={{ $json.displayed_link }}"
},
{
"id": "39b81062-afd1-468d-95aa-e158bd34b773",
"name": "Keyword",
"type": "string",
"value": "={{ $('Search parameter').item.json.Keyword }}"
},
{
"id": "9e1ab1fc-86eb-44c0-bdcb-bc5dc63f069c",
"name": "Location",
"type": "string",
"value": "={{ $('Search parameter').item.json.Location }}"
},
{
"id": "f9e0eb5e-e81d-4cd3-8b47-d301ae7920e8",
"name": "Rich snippet",
"type": "string",
"value": "={{ $json.rich_snippet.top.extensions }}"
},
{
"id": "fca0eaa4-70e0-4c1e-99a9-bf66477aad0f",
"name": "snippet_highlighted_words",
"type": "string",
"value": "={{ $json.snippet_highlighted_words }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ca824e0a-dddd-401a-a48a-debe4821d24e",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-200
],
"parameters": {
"width": 220,
"height": 520,
"content": "### 需要调整"
},
"typeVersion": 1
},
{
"id": "b8feccbd-6d14-4838-afc3-7fb9a1cd4f04",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
-200
],
"parameters": {
"width": 180,
"height": 520,
"content": "### 无需调整"
},
"typeVersion": 1
},
{
"id": "a5eb2f30-37e1-43b9-8e2c-dde0227908c5",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
300,
-200
],
"parameters": {
"width": 180,
"height": 520,
"content": "### 无需调整"
},
"typeVersion": 1
},
{
"id": "94232837-e5b8-484e-b453-17952b3d8fbe",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
-200
],
"parameters": {
"width": 520,
"height": 520,
"content": "### 需要调整"
},
"typeVersion": 1
},
{
"id": "3e3214b0-ace5-47e2-bb17-2db3c3db1de3",
"name": "丢弃元数据",
"type": "n8n-nodes-base.set",
"position": [
1080,
160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a821b4a3-d4e2-4f37-a154-8606426078ef",
"name": "followers_number",
"type": "number",
"value": "={{ $json.message.content.followers }}"
},
{
"id": "e1ac8cc3-4a51-4c01-9e75-8d92dff3b70d",
"name": "NameOfCompany",
"type": "string",
"value": "={{ $json.message.content.company_name }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2b1a66c3-be8a-4b00-86ee-3438022ad775",
"name": "可下载的 Excel 格式 LinkedIn 资料",
"type": "n8n-nodes-base.convertToFile",
"position": [
1600,
160
],
"parameters": {
"options": {},
"operation": "xlsx"
},
"typeVersion": 1.1
},
{
"id": "b1b982f2-eeb7-4816-be25-aee5568d2283",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
-200
],
"parameters": {
"color": 4,
"width": 540,
"height": 260,
"content": "## 这解决了什么问题？"
},
"typeVersion": 1
},
{
"id": "15340d73-272d-45a1-b96f-b75569bae0b5",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
-200
],
"parameters": {
"width": 180,
"height": 520,
"content": "### 无需调整"
},
"typeVersion": 1
},
{
"id": "da183064-0eb2-4e7d-ad83-7aca8f9b9e36",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
120
],
"parameters": {
"height": 760,
"content": ""
},
"typeVersion": 1
},
{
"id": "1fc2f6f8-df39-47c5-92a1-c1a14cbe0d65",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
100
],
"parameters": {
"color": 4,
"width": 540,
"height": 200,
"content": "## 它做什么？"
},
"typeVersion": 1
},
{
"id": "a522ed81-9d50-464e-b872-42a4c66a8584",
"name": "便签 14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
640
],
"parameters": {
"color": 4,
"width": 540,
"height": 500,
"content": "## 分步说明"
},
"typeVersion": 1
},
{
"id": "69696205-5ed2-4891-8cf3-1bcf9fc83ebd",
"name": "搜索参数",
"type": "n8n-nodes-base.set",
"position": [
-360,
160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d4c0a5dc-c656-45e7-bcd1-2cee3fbc9aa5",
"name": "Keyword",
"type": "string",
"value": "nocode"
},
{
"id": "f5365eff-7e79-411c-8ebb-a7d244e9e1fa",
"name": "Location",
"type": "string",
"value": "Germany"
},
{
"id": "24b4046f-7083-416d-8ae9-bc72c5323b14",
"name": "Number of search results to be returned",
"type": "string",
"value": 20
},
{
"id": "25c114e6-7628-4eb9-9b3e-a6bb5fbae1dc",
"name": "Host langauge",
"type": "string",
"value": "en"
},
{
"id": "ac29cb67-89ec-41ae-870c-196a4bf524a6",
"name": "Geolocation",
"type": "string",
"value": "de"
},
{
"id": "d1e78115-f788-4ffd-9374-60b83e7e2b8a",
"name": "Search engine",
"type": "string",
"value": "google"
},
{
"id": "7af59bb4-548b-4061-8095-3261b2ce8227",
"name": "site",
"type": "string",
"value": "linkedin.com/in"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0b588ebc-eddf-4c4c-a0c2-81cc0e8ae9d1",
"name": "将搜索结果转换为单独项",
"type": "n8n-nodes-base.splitOut",
"position": [
120,
160
],
"parameters": {
"options": {},
"fieldToSplitOut": "organic_results"
},
"typeVersion": 1
},
{
"id": "daef5714-3e40-4ac1-a02e-f3dacddeb5e8",
"name": "公司名称和关注者",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
620,
160
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"options": {},
"messages": {
"values": [
{
"content": "=Transform {{ $json.Followers }} into a number and extract where possible the name of the company in {{ $json.NameInLinkedinProfile }} or in {{ $json.Snippet }} Do not output things like location or name, only followers and company_name"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "0Vdk5RlVe7AoUdAM",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "2f204f01-836c-41ab-97c1-38fee34adffc",
"name": "通过合并生成最终数据",
"type": "n8n-nodes-base.merge",
"position": [
1300,
280
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3.1
},
{
"id": "f52e65b5-1369-4410-99fe-0cb0c11f5da5",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
-60
],
"parameters": {
"width": 180,
"height": 520,
"content": "### 无需调整"
},
"typeVersion": 1
},
{
"id": "de7ace7e-ba9b-4abb-a54b-8996fc9b88a6",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1540,
-60
],
"parameters": {
"width": 220,
"height": 520,
"content": "### 无需调整"
},
"typeVersion": 1
},
{
"id": "17a32318-e1bc-4c07-b6a2-59f47a68a595",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
1540,
480
],
"parameters": {
"width": 780,
"height": 920,
"content": ""
},
"typeVersion": 1
},
{
"id": "d41f26fe-9068-4202-9677-a355c5276999",
"name": "将数据存储在 NocoDB 表中",
"type": "n8n-nodes-base.nocoDb",
"position": [
1600,
520
],
"parameters": {
"table": "mttbkp3hxy9rnwx",
"operation": "create",
"projectId": "puqzjel7f0swv1t",
"dataToSend": "autoMapInputData",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "gjNns0VJMS3P2RQ3",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "98212dd7-5449-4fc1-b96f-3f1b94931c32",
"name": "便签 15",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
320
],
"parameters": {
"color": 4,
"width": 540,
"height": 280,
"content": "## 它是如何做到的？"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ba732d3f-968b-445d-83cc-e58a47b97e30",
"connections": {
"Edit Fields": {
"main": [
[
{
"node": "Company name & followers",
"type": "main",
"index": 0
},
{
"node": "Generate final data via merge",
"type": "main",
"index": 1
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Search parameter",
"type": "main",
"index": 0
}
]
]
},
"Search parameter": {
"main": [
[
{
"node": "Google search w/ SerpAPI",
"type": "main",
"index": 0
}
]
]
},
"Discard meta data": {
"main": [
[
{
"node": "Generate final data via merge",
"type": "main",
"index": 0
}
]
]
},
"Company name & followers": {
"main": [
[
{
"node": "Discard meta data",
"type": "main",
"index": 0
}
]
]
},
"Google search w/ SerpAPI": {
"main": [
[
{
"node": "Turn search results into individual items",
"type": "main",
"index": 0
}
]
]
},
"Generate final data via merge": {
"main": [
[
{
"node": "LinkedIn profiles in Excel for download",
"type": "main",
"index": 0
},
{
"node": "Store data in a NocoDB table",
"type": "main",
"index": 0
}
]
]
},
"Turn search results into individual items": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售, 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI视频生成器 - OpenAI、ElevenLabs与Telegram YouTube发布
集成OpenAI、ElevenLabs并通过Telegram发布至YouTube的AI视频生成器
If
Set
Wait
+15
68 节点FRANK LIN
销售
使用 AI 创建 LinkedIn 贡献并在 Slack 上通知用户
使用 AI 创建 LinkedIn 贡献并在 Slack 上通知用户
Set
Code
Html
+11
33 节点Darryn
人工智能
我的工作流5
使用AI邮件个性化的自动化LinkedIn潜在客户生成（未完成）
If
Set
Code
+9
37 节点Matthieu
销售
搜索 LinkedIn 公司，通过 AI 评分并添加到 Google Sheet CRM
搜索 LinkedIn 公司，通过 AI 评分并添加到 Google Sheet CRM
If
Set
Wait
+7
18 节点Matthieu
销售
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
构建与销售AI自动化与智能体
构建与销售AI自动化与智能体
If
Set
Wait
+15
74 节点NICKYAI
其他
