TopSourcer - 使用自然语言查找LinkedIn个人资料
高级
这是一个HR, AI领域的自动化工作流，包含 18 个节点。主要使用 If, Code, Wait, HttpRequest, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 使用GPT-4布尔搜索和Google X-ray自动获取LinkedIn候选人
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "UsBaGY83vnyZjRoB",
"meta": {
"instanceId": "d4e74e27d8d0aa53cd4bdff26f47c18bb91437db0b63a6ba8ec9f78df0e0234f",
"templateId": "2808",
"templateCredsSetupCompleted": true
},
"name": "TopSourcer - 使用自然语言查找 LinkedIn 个人资料",
"tags": [],
"nodes": [
{
"id": "16a5f4a2-6e00-40f5-bab7-35526550eacd",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
3240,
-280
],
"webhookId": "88c6a5cc-4b33-438c-ba85-2e075a276a78",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "f9ff2e4f-176b-453d-8743-cab4d9fd408d",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
1040,
-180
],
"webhookId": "475042df-7c36-4658-ab1c-ff55c237621f",
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "b988c049-2400-4a3a-b615-f4048832bd8d",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
-340
],
"parameters": {
"content": "激活工作流后点击\"打开聊天\"。"
},
"typeVersion": 1
},
{
"id": "74cec892-07d6-4e7d-9c6f-becfb51241c8",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
-300
],
"parameters": {
"width": 300,
"content": "在\"用于连接的凭据\"下添加您的 openAI API 密钥。在此处查找：https://platform.openai.com/settings/organization/api-keys"
},
"typeVersion": 1
},
{
"id": "940373af-ca88-44f1-b3c3-fb125ab6daf9",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2800,
-360
],
"parameters": {
"width": 300,
"content": "对于第一个条件：{{ $json.start }} 小于50，因此将\"50\"更改为您期望的结果数量。"
},
"typeVersion": 1
},
{
"id": "c2bc0757-753b-4fee-b42b-65e5a0ff4750",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3160,
-440
],
"parameters": {
"color": 5,
"width": 200,
"content": "等待5秒以避免 Google 的速率限制。虽然由于您使用 Cookie 进行了认证，不太可能被限制速率，但这只是一个预防措施。"
},
"typeVersion": 1
},
{
"id": "9007b42b-1a79-4b98-9d75-71894d660c1d",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3400,
-600
],
"parameters": {
"color": 4,
"width": 380,
"height": 280,
"content": "获取此 Cookie-Editor。https://chromewebstore.google.com/detail/cookie-editor/hlkenndednhfkekhgcdicdfddnkalmdm"
},
"typeVersion": 1
},
{
"id": "b1d2f9dd-227d-4372-89f8-e6d54e94f2fc",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1680,
-320
],
"parameters": {
"content": "连接您的 Google Sheets 帐户并创建一个文档。"
},
"typeVersion": 1
},
{
"id": "df0fb397-55d0-41ec-a9df-2c39019ad68e",
"name": "创建新工作表",
"type": "n8n-nodes-base.googleSheets",
"position": [
1740,
-180
],
"parameters": {
"title": "={{ $('Generate a Boolean Search String').item.json.choices[0].message.content.sheet_name + ' ' + $now }}\n",
"options": {},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1M9UUgw1wPZIBSoPiGTvNIgA19ERgOo5KmD9wx__Y8ZY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1M9UUgw1wPZIBSoPiGTvNIgA19ERgOo5KmD9wx__Y8ZY/edit?usp=drivesdk",
"cachedResultName": "Candidates"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "6wBRjmD77d71tAqP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "678a0b65-de67-41f0-ada6-23cef1226228",
"name": "向新工作表添加列",
"type": "n8n-nodes-base.googleSheets",
"position": [
2220,
-180
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create a new sheet').item.json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1M9UUgw1wPZIBSoPiGTvNIgA19ERgOo5KmD9wx__Y8ZY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1M9UUgw1wPZIBSoPiGTvNIgA19ERgOo5KmD9wx__Y8ZY/edit?usp=drivesdk",
"cachedResultName": "Candidates"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "6wBRjmD77d71tAqP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "767491ab-f7dd-4e23-816b-840bc24e5268",
"name": "设置 Google 搜索的页码",
"type": "n8n-nodes-base.code",
"position": [
2480,
-180
],
"parameters": {
"jsCode": "return [{ json: { start: 0 } }];\n"
},
"typeVersion": 2
},
{
"id": "f76f28a5-8444-4ff9-b62c-0d94a07c6447",
"name": "从 Google HTTP 响应中提取所有 LinkedIn URL",
"type": "n8n-nodes-base.code",
"position": [
3740,
-280
],
"parameters": {
"jsCode": "// Extract LinkedIn profile URLs from HTML\nfunction extractLinkedInUrls(html) {\n // First decode any encoded HTML entities\n html = html.replace(/&/g, '&')\n .replace(/\\\\u003d/g, '=')\n .replace(/\\\\x22/g, '\"')\n .replace(/\\\\x26/g, '&')\n .replace(/\\\\x3e/g, '>')\n .replace(/\\\\x3c/g, '<');\n\n const patterns = [\n // Standard LinkedIn URLs in href\n /(?:https?:)?\\/\\/(?:[a-z]{2,}\\.)?linkedin\\.com\\/in\\/[a-zA-Z0-9._-]+(?:\\/[a-z]{2})?/gi,\n // URLs in encoded strings\n /(?:\"url\"|url=)(?:[^\"&]*?)(?:https?:)?\\/\\/(?:[a-z]{2,}\\.)?linkedin\\.com\\/in\\/[a-zA-Z0-9._-]+(?:\\/[a-z]{2})?/gi,\n // URLs in JSON strings\n /\"(?:https?:)?\\/\\/(?:[a-z]{2,}\\.)?linkedin\\.com\\/in\\/[a-zA-Z0-9._-]+(?:\\/[a-z]{2})?\"/gi\n ];\n\n const urls = new Set();\n \n patterns.forEach(pattern => {\n const matches = html.matchAll(pattern);\n for (const match of matches) {\n let url = match[0];\n \n // Clean up the URL\n url = url.replace(/^\"url\"|^url=|\"$/g, '') // Remove url= prefix and quotes\n .replace(/^[\"']|[\"']$/g, '') // Remove surrounding quotes\n .replace(/\\\\+/g, '') // Remove backslashes\n .trim();\n \n // Ensure URL has protocol\n if (!url.startsWith('http')) {\n url = 'https://' + url.replace(/^\\/\\//, '');\n }\n \n // Only include if it's a LinkedIn profile URL\n if (url.includes('linkedin.com/in/')) {\n // Clean the URL: remove tracking parameters and fragments\n url = url.split(/[?#&]/)[0];\n \n // Remove any trailing slashes\n url = url.replace(/\\/$/, '');\n \n // Add to Set to remove duplicates\n urls.add(url);\n }\n }\n });\n\n return Array.from(urls);\n}\n\n// Get the HTML from input\nconst html = $input.first().json.data;\n\n// Extract URLs and create array of objects\nconst linkedInProfiles = extractLinkedInUrls(html)\n .filter(url => !url.includes('google.com')) // Extra safety check to remove any Google URLs\n .map(url => ({\n linkedin_url: url\n }));\n\n// Return the array of objects directly\nreturn linkedInProfiles;"
},
"typeVersion": 2
},
{
"id": "5a93c8f2-f55b-4d0e-92f8-0d86147f8d13",
"name": "Google 布尔搜索",
"type": "n8n-nodes-base.httpRequest",
"position": [
3500,
-300
],
"parameters": {
"url": "https://www.google.com/search",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "={{ $('Generate a Boolean Search String').first().json.choices[0].message.content.search_string }}\n"
},
{
"name": "start",
"value": "={{ $json.start }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "User-Agent",
"value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "5T6POWjsPfV558Ta",
"name": "Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "37b4f264-34f0-47bb-9b1b-fa53beafb2a9",
"name": "生成布尔搜索字符串",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1320,
-180
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "GPT-4O-MINI"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "You are an expert in Boolean search techniques for Google. When the user send a job description, generate a search string specifically for finding LinkedIn profiles. Your response must always follow this exact format:\nsite:linkedin.com/in [Boolean search string]\nCreate the Boolean search string using precise operators (AND, OR, \"\", *, -) to match the job requirements. Focus only on generating the search string - provide no additional commentary or explanations unless specifically requested.\n\nAlso return sheet_name (less than 100 char)"
},
{
"content": "={{ $json.chatInput }}"
}
]
},
"simplify": false,
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "EX7mky4RGLDD6udW",
"name": "OpenAi account"
}
},
"retryOnFail": false,
"typeVersion": 1.8
},
{
"id": "99041eff-f094-4c2a-a75a-4b01faf33d1b",
"name": "如果未达到预期结果",
"type": "n8n-nodes-base.if",
"position": [
2920,
-200
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "da9f8de0-1e75-4ff3-9f81-8e911251416b",
"operator": {
"type": "number",
"operation": "lt"
},
"leftValue": "={{ $json.start }}",
"rightValue": 50
},
{
"id": "a891c085-7f49-4523-8610-40577b3ffd3b",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "d218a1e8-2959-4b7c-a84d-f8e0df82c5e7",
"name": "将结果追加到工作表",
"type": "n8n-nodes-base.googleSheets",
"position": [
4040,
-280
],
"parameters": {
"columns": {
"value": {
"linkedin_url": "={{ $json.linkedin_url }}"
},
"schema": [
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Headline",
"type": "string",
"display": true,
"required": false,
"displayName": "Headline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Candidate Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Candidate Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experiences Summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Experiences Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education Summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Education Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skills",
"type": "string",
"display": true,
"required": false,
"displayName": "Skills",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "City",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Criteria_Assessment",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Criteria_Assessment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "overall_fit_score",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "overall_fit_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "score_justification",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "score_justification",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Industry",
"type": "string",
"display": true,
"required": false,
"displayName": "Company Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Size",
"type": "string",
"display": true,
"required": false,
"displayName": "Company Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company LinkedIn URL",
"type": "string",
"display": true,
"required": false,
"displayName": "Company LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Website",
"type": "string",
"display": true,
"required": false,
"displayName": "Company Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Current Company Join Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Current Company Join Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Certifications",
"type": "string",
"display": true,
"required": false,
"displayName": "Certifications",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Courses Taken",
"type": "string",
"display": true,
"required": false,
"displayName": "Courses Taken",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Connections Count",
"type": "string",
"display": true,
"required": false,
"displayName": "Connections Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Followers Count",
"type": "string",
"display": true,
"required": false,
"displayName": "Followers Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Languages Spoken",
"type": "string",
"display": true,
"required": false,
"displayName": "Languages Spoken",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Projects",
"type": "string",
"display": true,
"required": false,
"displayName": "Projects",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date Created",
"type": "string",
"display": true,
"required": false,
"displayName": "Date Created",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create a new sheet').first().json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1M9UUgw1wPZIBSoPiGTvNIgA19ERgOo5KmD9wx__Y8ZY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1M9UUgw1wPZIBSoPiGTvNIgA19ERgOo5KmD9wx__Y8ZY/edit?usp=drivesdk",
"cachedResultName": "Candidates"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "6wBRjmD77d71tAqP",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "7a56e7d7-31f8-4115-b993-227bd7221c07",
"name": "起始值加10 - 转到下一页",
"type": "n8n-nodes-base.code",
"position": [
4340,
-220
],
"parameters": {
"jsCode": "// Get the start value from 'Edit Fields2' node\nconst startValue =$('If desired results not reached').first().json.start;\n\n// Add 10 to the start value\nconst start = startValue + 10;\n\n// Return the new value\nreturn [{ json: { start } }];\n"
},
"typeVersion": 2
},
{
"id": "afe22fc0-c9c1-4aab-a11d-d91740f812bb",
"name": "要添加的列",
"type": "n8n-nodes-base.code",
"position": [
1980,
-180
],
"parameters": {
"jsCode": "return [{\n json: {\n \"linkedin_url\": \"\"\n }\n}];\n"
},
"typeVersion": 2
}
],
"active": true,
"pinData": {},
"settings": {},
"versionId": "ce389fd9-7697-4e36-8346-6be9414aecf2",
"connections": {
"Wait": {
"main": [
[
{
"node": "Google Boolean Search",
"type": "main",
"index": 0
}
]
]
},
"Columns to add": {
"main": [
[
{
"node": "Add columns to new sheet",
"type": "main",
"index": 0
}
]
]
},
"Create a new sheet": {
"main": [
[
{
"node": "Columns to add",
"type": "main",
"index": 0
}
]
]
},
"Google Boolean Search": {
"main": [
[
{
"node": "Extracts all linkedin urls from the google http response",
"type": "main",
"index": 0
}
]
]
},
"Add columns to new sheet": {
"main": [
[
{
"node": "set page number for google search",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "Generate a Boolean Search String",
"type": "main",
"index": 0
}
]
]
},
"If desired results not reached": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
],
[]
]
},
"Appends the results to the sheet": {
"main": [
[
{
"node": "Adds 10 to start - Go to next page",
"type": "main",
"index": 0
}
]
]
},
"Generate a Boolean Search String": {
"main": [
[
{
"node": "Create a new sheet",
"type": "main",
"index": 0
}
]
]
},
"set page number for google search": {
"main": [
[
{
"node": "If desired results not reached",
"type": "main",
"index": 0
}
]
]
},
"Adds 10 to start - Go to next page": {
"main": [
[
{
"node": "If desired results not reached",
"type": "main",
"index": 0
}
]
]
},
"Extracts all linkedin urls from the google http response": {
"main": [
[
{
"node": "Appends the results to the sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人力资源, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
LinkedIn人才管道：AI驱动的候选人搜索与排名（GPT-4o）
LinkedIn人才管道：AI驱动的候选人搜索与排名（GPT-4o）
If
Set
Code
+14
24 节点Badr
人力资源
HRMate 修复
使用LlamaIndex和GPT-4o-mini自动化候选人筛选，生成个性化邮件回复
If
Set
Code
+8
30 节点Khairul Muhtadin
人力资源
LinkGPT
使用OpenAI和Hunter自动化LinkedIn档案搜索与冷邮件外联
If
Code
Wait
+6
22 节点Abhijay Vuyyuru
销售
LinkedIn 代理 v2
使用 OpenAI、Hunter 和 Gmail 自动寻找 LinkedIn 潜在客户并发送个性化冷邮件
If
Code
Wait
+7
29 节点Abhijay Vuyyuru
销售
n8n人力资源代理
基于WhatsApp、GPT-4分类和Google Workspace的自动化人力资源服务系统
If
Set
Code
+19
65 节点Tanay Agarwal
人力资源
使用 Bright Data 抓取 LinkedIn 职位列表以获取招聘信号和潜在客户
使用 Bright Data 抓取 LinkedIn 职位列表以获取招聘信号和潜在客户
If
Set
Code
+5
15 节点Yaron Been
销售
工作流信息
难度等级
高级
节点数量18
分类2
节点类型8
作者
Abdullah Maftah
@abdullahI save talent acquisition professionals and 360 recruiters valuable time by automating candidate sourcing, screening, and outreach. Additionally, I build systems that identify potential new clients by searching popular job boards.
外部链接
在 n8n.io 查看 →
分享此工作流