使用LinkedIn职位信号、Apify、Apollo.io和Google Gemini自动化销售拓展
高级
这是一个自动化工作流，包含 47 个节点。主要使用 If, Code, Limit, Merge, Filter 等节点。 基于LinkedIn职位信号使用Apify和Google Gemini生成个性化销售拓展
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (47)
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "6ZDejfbyr1msa2zv",
"meta": {
"instanceId": "1a54c41d9050a8f1fa6f74ca858828ad9fb97b9fafa3e9760e576171c531a787",
"templateCredsSetupCompleted": true
},
"name": "使用LinkedIn职位信号、Apify、Apollo.io和Google Gemini自动化销售拓展",
"tags": [],
"nodes": [
{
"id": "0fd7b446-8b69-4fb4-b79e-f69fbe4082ab",
"name": "使用电子邮件更新表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2560,
1008
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $('Filter for Batching').item.json.Email }}",
"Subject": "={{ $json.output.subject }}",
"Email Body": "={{ $json.output.email_body }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Occupation",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Occupation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn Url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company LinkedIn Url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company LinkedIn Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Employee Count",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Employee Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Job Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subject",
"type": "string",
"display": true,
"required": false,
"displayName": "Subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Body",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Body",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo/edit?usp=drivesdk",
"cachedResultName": "LinkedIn Lead Gen"
}
},
"typeVersion": 4
},
{
"id": "12d544fc-86d7-4cbf-9be7-ed6d4730dbdf",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
1936,
1376
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "78b63764-9948-40ca-be63-f188ff8faeba",
"name": "多表：您可以连接多个表以实现有组织的数据结构",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2496,
1376
],
"parameters": {
"jsonSchemaExample": "{\n \"subject\": \"A short, catchy, question-based subject line\",\n \"email_body\": \"The full email body, 100-120 words, without any salutation or sign-off.\"\n}"
},
"typeVersion": 1.3
},
{
"id": "6e685361-565d-4dc6-9149-a6c2b23fe2c3",
"name": "点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-816,
160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9af7695c-fb5d-4a23-b7e3-8d26a821b4d1",
"name": "移除重复项",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
-768,
496
],
"parameters": {
"compare": "selectedFields",
"options": {
"removeOtherFields": false,
"disableDotNotation": false
},
"fieldsToCompare": "companyName"
},
"typeVersion": 2
},
{
"id": "c1348833-1b28-4270-ae53-4dbcfc93251e",
"name": "运行LinkedIn职位爬虫",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
-432,
96
],
"parameters": {
"memory": 4096,
"actorId": {
"__rl": true,
"mode": "list",
"value": "hKByXkMQaC5Qt9UMN",
"cachedResultUrl": "https://console.apify.com/actors/hKByXkMQaC5Qt9UMN/input",
"cachedResultName": "Linkedin Jobs Scraper - PPR (curious_coder/linkedin-jobs-scraper)"
},
"timeout": {},
"customBody": "{\n \"count\": 100,\n \"scrapeCompany\": true,\n \"urls\": [\n \"https://www.linkedin.com/jobs/search-results/?distance=25&f_TPR=r86400&geoId=103644278&keywords=ML%20Engineer&origin=SEMANTIC_SEARCH_HISTORY\"\n ]\n}"
},
"typeVersion": 1
},
{
"id": "5e36853c-5e15-42ac-9c7e-95c60aadf9da",
"name": "获取数据集项",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
96,
160
],
"parameters": {
"limit": 110,
"offset": {},
"resource": "Datasets",
"datasetId": "={{ $json.defaultDatasetId }}"
},
"typeVersion": 1
},
{
"id": "92470dd9-7f01-4795-b36a-8d1553a12e80",
"name": "检查公司规模<250",
"type": "n8n-nodes-base.if",
"position": [
592,
208
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "ed72c7e6-2a1f-4c8e-b87c-7ab53ea8f356",
"operator": {
"type": "number",
"operation": "lt"
},
"leftValue": "={{ $json.companyEmployeesCount }}",
"rightValue": 250
}
]
}
},
"typeVersion": 2.2
},
{
"id": "9469d083-1393-4661-bc1a-2626be76b3af",
"name": "移除HR相关行业",
"type": "n8n-nodes-base.if",
"position": [
-400,
496
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "cd695047-a0f4-4058-b83b-339c5fe77a9c",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.industries }}",
"rightValue": "Human Resources"
},
{
"id": "7b9d94db-da9c-4b94-8961-0827f5175f9c",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.industries }}",
"rightValue": "Staffing and Recruiting"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "13ccb5b9-221b-4be6-ba7c-02c53205fc63",
"name": "准备最终公司详情",
"type": "n8n-nodes-base.code",
"position": [
112,
496
],
"parameters": {
"jsCode": "// n8n Function Node\n// Keep only required fields + extract clean domain from companyWebsite\n// Wrap output in \"company\" wrapper\n\nreturn items.map(item => {\n const data = item.json;\n\n let domain = null;\n if (data.companyWebsite) {\n let website = data.companyWebsite.trim();\n\n // If no protocol, prepend http://\n if (!/^https?:\\/\\//i.test(website)) {\n website = \"http://\" + website;\n }\n\n try {\n const parsedUrl = new URL(website);\n domain = parsedUrl.hostname.replace(/^www\\./, \"\"); // remove \"www.\"\n } catch (err) {\n // Fallback: strip query/hash manually\n domain = website\n .replace(/^(https?:\\/\\/)?(www\\.)?/, \"\")\n .split(/[/?#]/)[0]; // take only domain part\n }\n }\n\n return {\n json: {\n company: { // 👈 wrapper added\n companyName: data.companyName || null,\n companyLinkedInUrl: data.companyLinkedInUrl || data.companyLinkedinUrl || null,\n companyWebsite: data.companyWebsite || null,\n industries: data.industries || null,\n location: data.location || null,\n employeeCount: data.companyEmployeesCount || null,\n jobTitle: data.jobTitle || data.title || null,\n companyDescription: data.companyDescription || null,\n domain: domain\n }\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "43d308cf-516a-4acf-8b77-f20a3947f0cb",
"name": "检查域名存在性",
"type": "n8n-nodes-base.if",
"position": [
-800,
816
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8f1130d1-8082-48a4-9f97-a05df2e6f725",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.company.domain }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c25ec326-deb9-490e-97ab-ebe3521e41a0",
"name": "Apollo获取目标人员",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1168,
1312
],
"parameters": {
"url": "https://api.apollo.io/api/v1/people/search",
"method": "POST",
"options": {},
"jsonBody": "={\n \"q_organization_domains_list\": [\"{{ $json.company.domain }}\"],\n \"person_seniorities\": [\"vp\", \"head\", \"director\", \"founder\", \"c-suite\", \"lead\"],\n \"person_titles\": [\n \"engineering\",\n \"technology\",\n \"product\",\n \"operations\",\n \"infrastructure\",\n \"devops\",\n \"data science\",\n \"machine learning\",\n \"cloud\"\n ],\n \"pagination\": { \"page\": 1, \"per_page\": 2 }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"typeVersion": 4.2
},
{
"id": "b42ec2f9-f178-49e3-aaf8-026fb1b3b360",
"name": "Apollo邮箱查找器",
"type": "n8n-nodes-base.httpRequest",
"position": [
-496,
1648
],
"parameters": {
"url": "https://api.apollo.io/v1/people/match",
"method": "POST",
"options": {},
"jsonBody": "={\n \"id\": \"{{ $json.person.personId }}\"\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"typeVersion": 4.2
},
{
"id": "dbd59767-6054-4a77-b097-73b537b7404d",
"name": "清理邮箱详情",
"type": "n8n-nodes-base.code",
"position": [
16,
1648
],
"parameters": {
"jsCode": "// Extract only person.id + email\nreturn items.map(item => {\n return {\n json: {\n email: { // 👈 wrapped object\n id: item.json.person?.id || null,\n email: item.json.person?.email || null\n }\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "c2d53522-21bb-4d04-b3f5-f6c935356c9a",
"name": "构建人员完整详情结构",
"type": "n8n-nodes-base.code",
"position": [
816,
896
],
"parameters": {
"jsCode": "// N8N JavaScript Code Node - Clean Data Merging (No Debug)\n// Mapping Logic:\n// - person.personId <-> email.id (one-to-one, unique)\n// - person.companyName <-> company.companyName (many-to-one, multiple persons per company)\n\n// Get all input items\nconst allItems = $input.all();\n\n// Step 1: Build email lookup by personId (one-to-one mapping)\nconst emailMap = {};\nallItems.forEach(item => {\n const jsonData = item.json || {};\n if (jsonData.email && jsonData.email.id) {\n emailMap[jsonData.email.id] = jsonData.email.email;\n }\n});\n\n// Step 2: Build company lookup by companyName (many-to-one mapping)\nconst companyMap = {};\nallItems.forEach(item => {\n const jsonData = item.json || {};\n if (jsonData.company && jsonData.company.companyName) {\n companyMap[jsonData.company.companyName] = jsonData.company;\n }\n});\n\n// Step 3: Merge person with email + company info\nconst outputItems = [];\n\nallItems.forEach(item => {\n const jsonData = item.json || {};\n if (!jsonData.person) return;\n \n const person = jsonData.person;\n const personId = person.personId;\n const companyName = person.companyName;\n \n // Get email from emailMap (unique per person)\n const email = emailMap[personId] || null;\n \n // Get company info from companyMap (same for all persons at this company)\n const companyInfo = companyMap[companyName] || {};\n \n // Create merged record\n const mergedItem = {\n json: {\n ...person, // Spread all person fields\n email: email,\n companyDescription: companyInfo.companyDescription || null,\n jobTitle: companyInfo.jobTitle || null,\n employeeCount: companyInfo.employeeCount || null\n }\n };\n \n outputItems.push(mergedItem);\n});\n\n// Return the merged results\nreturn outputItems;"
},
"typeVersion": 2
},
{
"id": "326bb4c6-ce73-4e76-9576-685319d00b1e",
"name": "将潜在客户添加到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1040,
560
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.email }}",
"Domain": "={{ $json.primaryDomain }}",
"Company": "={{ $json.companyName }}",
"Location": "={{ $json.city }}, {{ $json.country }}",
"Job Title": "={{ $json.jobTitle }}",
"Last Name": "={{ $json.lastName }}",
"First Name": "={{ $json.firstName }}",
"Occupation": "={{ $json.title }}",
"Company URL": "={{ $json.companyWebsite }}",
"LinkedIn Url": "={{ $json.personLinkedInUrl }}",
"Employee Count": "={{ $json.employeeCount }}",
"Company Description": "={{ $json.companyDescription }}",
"Company LinkedIn Url": "={{ $json.companyLinkedInUrl }}"
},
"schema": [
{
"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": "Occupation",
"type": "string",
"display": true,
"required": false,
"displayName": "Occupation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn Url",
"type": "string",
"display": true,
"required": false,
"displayName": "LinkedIn Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company LinkedIn Url",
"type": "string",
"display": true,
"required": false,
"displayName": "Company LinkedIn Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company URL",
"type": "string",
"display": true,
"required": false,
"displayName": "Company URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Employee Count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Employee Count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Job Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Body",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email Body",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo/edit?usp=drivesdk",
"cachedResultName": "LinkedIn Lead Gen"
}
},
"typeVersion": 4.6
},
{
"id": "636f4815-dae0-4628-aa65-775781c405b5",
"name": "获取潜在客户数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
1488,
560
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gUD7SVkq1spzbZXzMDh5kbXPD6ftqWPBwBgwZi3_gdo/edit?usp=drivesdk",
"cachedResultName": "LinkedIn Lead Gen"
}
},
"typeVersion": 4
},
{
"id": "bb071500-09fa-492c-a64c-20fdd384e42a",
"name": "验证邮箱ID和邮件内容",
"type": "n8n-nodes-base.if",
"position": [
2160,
576
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0640b75d-662e-4625-a038-92c099b79f25",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Subject }}",
"rightValue": ""
},
{
"id": "6d30f170-03fd-4e89-9a56-ab87e8c7c01a",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json[\"Email Body\"] }}",
"rightValue": ""
},
{
"id": "81d61ac3-f195-4516-8259-331f7190a0c3",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.Email }}",
"rightValue": "@"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "012dd6c0-612d-4bbb-b690-43282abc2df0",
"name": "潜在客户邮件生成器",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
2032,
1008
],
"parameters": {
"text": "=Act as an expert B2B copywriter specializing in cold outreach for tech recruitment services.\n\n\nYour task is to write a personalized, friendly, and professional cold email. The goal is to get the attention of a busy executive by offering a clear solution to their current hiring needs.\n\n\nBACKGROUND & CONTEXT:\n\nOur Service: We provide pre-vetted, skilled remote tech talent (AI/ML Engineers, DevOps, etc.).\n\nTarget Company: US-based, under 250 employees.\n\nTarget Persona: CEO, CTO, Head of Engineering, VP of Operations.\n\nTrigger Event: The target company is actively hiring for a specific tech role.\n\nKey Value Proposition:\n\nSave significant time in the hiring process.\n\nSave 30-40% on budget compared to a direct, in-house hire.\n\n\nINPUT VARIABLES (You will use these to personalize the email):\n\n{{ $json.Company }}: The name of the company.\n\n{{ $json['Job Title'] }}: The specific job title they are hiring for (e.g., \"AI Engineer\").\n\n{{ $json.Occupation }}: The job title of the person I'm emailing (e.g., \"CTO\").\n\n\nINSTRUCTIONS & CONSTRAINTS:\n\n\n1. Subject Line:\n\nGenerate catchy subject line.\n\nEach subject line must be 7-8 words maximum.\n\nThey should be intriguing and directly related to their hiring needs. Examples: \"Your AI Engineer role,\" \"An idea for your engineering team,\" \"Filling your {{ $json['Job Title'] }} role.\"\n\n\n2. Email Body:\n\nWrite the email body only. Do not include a salutation like \"Hi {{ $json['First Name'] }}\".\n\nThe email must start with the exact phrase: \"Saw that {{ $json.Company }} is hiring for a {{ $json['Job Title'] }}.\"\n\nThe tone must be professional, friendly, and easy to understand.\n\nCrucially, avoid high-level marketing jargon or complex AI-related terminology. Keep the language simple and direct.\n\nFocus the message on the two main benefits: filling the role faster and more affordably. Mention the 30-40% savings.\n\nThe total word count for the body must be under 120 words.\n\nEnd with a soft, low-pressure call-to-action, such as asking if they are open to exploring alternative ways to build their team",
"batching": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "2c3b430d-d1bb-42d6-ab31-88ced73e58f3",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-912,
-32
],
"parameters": {
"height": 360,
"content": "## ▶️ 启动工作流"
},
"typeVersion": 1
},
{
"id": "0d3f4c5f-c716-40ab-87b3-e5f74f705e65",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-512,
-176
],
"parameters": {
"width": 260,
"height": 440,
"content": "## 从Apify运行LinkedIn职位爬虫"
},
"typeVersion": 1
},
{
"id": "3743dc33-a59f-4ee4-95a2-9956c99c3981",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
16,
-112
],
"parameters": {
"width": 260,
"height": 420,
"content": "## 获取数据集项"
},
"typeVersion": 1
},
{
"id": "8bb80fc2-cd66-4664-8b44-16fb8776a61c",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
512,
-48
],
"parameters": {
"width": 260,
"height": 420,
"content": "## 检查公司规模<250"
},
"typeVersion": 1
},
{
"id": "2425cb33-44ce-411b-a01d-aede93c801b5",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1072,
496
],
"parameters": {
"color": 5,
"height": 100,
"content": "## 移除重复条目"
},
"typeVersion": 1
},
{
"id": "e5937705-ff40-41c7-bb0a-3864fac0e9dc",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-448,
368
],
"parameters": {
"color": 5,
"height": 120,
"content": "## 移除HR相关公司"
},
"typeVersion": 1
},
{
"id": "17a39567-8afb-4faa-a29f-ca7522cf3408",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
96,
368
],
"parameters": {
"color": 5,
"height": 120,
"content": "## 准备最终公司详情"
},
"typeVersion": 1
},
{
"id": "603bc9a8-e1be-49e2-a789-2bc84da68ee2",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-816,
736
],
"parameters": {
"color": 5,
"height": 80,
"content": "## 检查域名存在性"
},
"typeVersion": 1
},
{
"id": "ee151293-9743-4df6-bf8c-fab51cf5df10",
"name": "限制公司搜索",
"type": "n8n-nodes-base.limit",
"position": [
-128,
848
],
"parameters": {
"maxItems": 5
},
"typeVersion": 1
},
{
"id": "6f6e8313-f32e-4bd1-8ff8-973593afd95d",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-176,
752
],
"parameters": {
"color": 5,
"height": 80,
"content": "## 限制公司搜索"
},
"typeVersion": 1
},
{
"id": "00d91745-b097-4049-805e-8133294b46fe",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1488,
1248
],
"parameters": {
"color": 6,
"height": 260,
"content": "## Apollo获取目标人员"
},
"typeVersion": 1
},
{
"id": "f7572335-877a-4033-82f8-bb7bda1a38ff",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-848,
1088
],
"parameters": {
"color": 6,
"height": 260,
"content": "## 清理人员详情"
},
"typeVersion": 1
},
{
"id": "786da361-b3f8-45ee-a4d5-4b1a0a00c9c7",
"name": "清理人员详情",
"type": "n8n-nodes-base.code",
"position": [
-768,
1360
],
"parameters": {
"jsCode": "// Flatten + dedupe by (person.id + companyName)\nlet results = [];\nlet seen = new Set();\n\nitems.forEach(item => {\n const people = item.json.people || [];\n\n people.forEach(person => {\n if (!person.id) return;\n\n const company = person.organization || {};\n const uniqueKey = person.id + \"|\" + (company.name || \"\"); \n\n if (seen.has(uniqueKey)) return;\n seen.add(uniqueKey);\n\n let websiteUrl = company.website_url || null;\n let domain = company.primary_domain || null;\n\n if (!domain && websiteUrl) {\n try {\n const parsedUrl = new URL(websiteUrl);\n domain = parsedUrl.hostname.replace(/^www\\./, \"\");\n } catch (err) {\n domain = websiteUrl.replace(/^(https?:\\/\\/)?(www\\.)?/, \"\").split(/[/?#]/)[0];\n }\n }\n\n results.push({\n json: {\n person: { // 👈 wrapped object\n uniqueKey: uniqueKey,\n personId: person.id || null,\n firstName: person.first_name || null,\n lastName: person.last_name || null,\n personLinkedInUrl: person.linkedin_url || null,\n title: person.title || null,\n city: person.city || null,\n country: person.country || null,\n companyName: company.name || null,\n companyWebsite: websiteUrl,\n primaryDomain: domain,\n companyLinkedInUrl: company.linkedin_url || null\n }\n }\n });\n });\n});\n\nreturn results;\n"
},
"typeVersion": 2
},
{
"id": "f847fb0f-f82b-47c9-a493-9e859bc16a4e",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-576,
1840
],
"parameters": {
"color": 6,
"height": 260,
"content": "## Apollo邮箱查找器"
},
"typeVersion": 1
},
{
"id": "18a68ac3-c63f-44aa-9169-a080eb1a21ce",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
1840
],
"parameters": {
"color": 6,
"height": 220,
"content": "## 清理邮箱详情"
},
"typeVersion": 1
},
{
"id": "2713732b-136d-4f9d-8964-ef5b54adeff6",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
1296
],
"parameters": {
"color": 4,
"width": 280,
"height": 240,
"content": "## 合并数据"
},
"typeVersion": 1
},
{
"id": "20fc29b2-1b85-4f55-847f-51161415391b",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
768,
1056
],
"parameters": {
"color": 4,
"width": 280,
"height": 240,
"content": "## 构建人员完整详情结构"
},
"typeVersion": 1
},
{
"id": "6a07323e-c5aa-4cfa-8f8b-19662806e35b",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
352
],
"parameters": {
"color": 3,
"width": 280,
"height": 240,
"content": "## 将潜在客户保存到Google Sheets"
},
"typeVersion": 1
},
{
"id": "0b81960f-6d52-498d-9bd7-34689431fb88",
"name": "便签 16",
"type": "n8n-nodes-base.stickyNote",
"position": [
1408,
336
],
"parameters": {
"color": 3,
"width": 280,
"height": 260,
"content": "## 获取潜在客户数据"
},
"typeVersion": 1
},
{
"id": "d19a3c2d-ec40-4263-aa09-799f3ab25e7a",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
2080,
352
],
"parameters": {
"color": 3,
"width": 280,
"height": 300,
"content": "## 验证邮箱ID和邮件内容"
},
"typeVersion": 1
},
{
"id": "0ccfe835-fc19-4ffa-acf8-644bc6149633",
"name": "便签18",
"type": "n8n-nodes-base.stickyNote",
"position": [
1408,
1152
],
"parameters": {
"color": 2,
"width": 280,
"height": 180,
"content": "## 应用最终筛选"
},
"typeVersion": 1
},
{
"id": "fd60f2ef-f30c-4450-9ce4-273946d0f3ed",
"name": "便签19",
"type": "n8n-nodes-base.stickyNote",
"position": [
1952,
816
],
"parameters": {
"color": 2,
"width": 360,
"height": 240,
"content": "## 潜在客户邮件生成器"
},
"typeVersion": 1
},
{
"id": "14f000f8-c23b-43fb-9dc8-53c056d09345",
"name": "便签20",
"type": "n8n-nodes-base.stickyNote",
"position": [
1792,
1520
],
"parameters": {
"color": 2,
"width": 360,
"height": 240,
"content": "## Google Gemini聊天模型"
},
"typeVersion": 1
},
{
"id": "17ef075d-dde3-4999-9868-f78f867fa322",
"name": "便签21",
"type": "n8n-nodes-base.stickyNote",
"position": [
2448,
816
],
"parameters": {
"color": 2,
"width": 360,
"height": 240,
"content": "## 使用邮件更新表格"
},
"typeVersion": 1
},
{
"id": "d7ec9db4-05eb-4e9c-8916-26b046252611",
"name": "便签22",
"type": "n8n-nodes-base.stickyNote",
"position": [
2416,
1536
],
"parameters": {
"color": 2,
"width": 360,
"height": 240,
"content": "## 结构化输出解析器"
},
"typeVersion": 1
},
{
"id": "26ab04ae-8f36-4268-ac75-0628e12e321d",
"name": "便签23",
"type": "n8n-nodes-base.stickyNote",
"position": [
2880,
1200
],
"parameters": {
"color": 2,
"width": 440,
"height": 240,
"content": "## 需要帮助？"
},
"typeVersion": 1
},
{
"id": "30bffaa6-f024-4725-a969-06f489de54d1",
"name": "合并数据",
"type": "n8n-nodes-base.merge",
"position": [
480,
1120
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3.2
},
{
"id": "db0db762-142e-4ea8-8ff3-f868fd7d262c",
"name": "批处理筛选",
"type": "n8n-nodes-base.filter",
"position": [
1520,
1008
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fed38656-1a21-4b77-babe-3c49a6f36124",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.row_number }}",
"rightValue": 83
}
]
}
},
"typeVersion": 2.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "75ee3ba0-b483-48b3-a185-cd0aaec04290",
"connections": {
"Merge Data": {
"main": [
[
{
"node": "Structuring Complete Details of Person",
"type": "main",
"index": 0
}
]
]
},
"Get dataset Items": {
"main": [
[
{
"node": "Checks Company Size < 250",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicates": {
"main": [
[
{
"node": "Removes HR Related Industry",
"type": "main",
"index": 0
}
]
]
},
"Apollo Email Finder": {
"main": [
[
{
"node": "Sanitising Email Details",
"type": "main",
"index": 0
}
]
]
},
"Fetching Leads Data": {
"main": [
[
{
"node": "Validates Email Id and Email Content",
"type": "main",
"index": 0
}
]
]
},
"Filter for Batching": {
"main": [
[
{
"node": "Lead Email Generator",
"type": "main",
"index": 0
}
]
]
},
"Lead Email Generator": {
"main": [
[
{
"node": "Update Sheet with Email",
"type": "main",
"index": 0
}
]
]
},
"Adding Leads to Sheets": {
"main": [
[
{
"node": "Fetching Leads Data",
"type": "main",
"index": 0
}
]
]
},
"Limit Companies Search": {
"main": [
[
{
"node": "Merge Data",
"type": "main",
"index": 0
},
{
"node": "Apollo Get Targeted Personnel",
"type": "main",
"index": 0
}
]
]
},
"Checks Domain Existence": {
"main": [
[
{
"node": "Limit Companies Search",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Lead Email Generator",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Sanitising Email Details": {
"main": [
[
{
"node": "Merge Data",
"type": "main",
"index": 2
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Lead Email Generator",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Checks Company Size < 250": {
"main": [
[
{
"node": "Remove Duplicates",
"type": "main",
"index": 0
}
]
]
},
"Sanitising Person Details": {
"main": [
[
{
"node": "Apollo Email Finder",
"type": "main",
"index": 0
},
{
"node": "Merge Data",
"type": "main",
"index": 1
}
]
]
},
"Removes HR Related Industry": {
"main": [
[
{
"node": "Prepare Final Company Details",
"type": "main",
"index": 0
}
]
]
},
"Run the LinkedIn Job Scraper": {
"main": [
[
{
"node": "Get dataset Items",
"type": "main",
"index": 0
}
]
]
},
"Apollo Get Targeted Personnel": {
"main": [
[
{
"node": "Sanitising Person Details",
"type": "main",
"index": 0
}
]
]
},
"Prepare Final Company Details": {
"main": [
[
{
"node": "Checks Domain Existence",
"type": "main",
"index": 0
}
]
]
},
"Validates Email Id and Email Content": {
"main": [
[
{
"node": "Filter for Batching",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Run the LinkedIn Job Scraper",
"type": "main",
"index": 0
}
]
]
},
"Structuring Complete Details of Person": {
"main": [
[
{
"node": "Adding Leads to Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Apify、Apollo.io和Google Gemini自动化LinkedIn职位AI驱动潜在客户生成
自动化LinkedIn职位潜在客户生成：Apify、Apollo.io和Google Gemini
If
Code
Limit
+11
47 节点Intuz
潜在客户开发
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
实时 - 使用Gemini和Creatomate自动化病毒式AI视频制作与发布
使用Gemini和Creatomate自动化AI视频创作与多平台发布
Set
Code
Wait
+15
47 节点Intuz
内容创作
01 使用AI媒体买家分析Facebook广告表现并将洞察发送到Google Sheets
使用Gemini AI分析Facebook广告并将洞察发送到Google Sheets
If
Set
Code
+13
34 节点JJ Tham
市场调研
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
使用Apify、Google Gemini和Sheets实时自动化Upwork提案生成
使用Apify、Google Gemini和Sheets自动化AI Upwork提案生成
If
Set
Gmail
+8
25 节点Intuz
潜在客户开发
工作流信息
难度等级
高级
节点数量47
分类-
节点类型14
作者
Intuz
@intuzWorkflow automation can help automate your routine activities and help saves $$$, as well as hours of time. As a boutique tech consulting company, Intuz help businesses with custom AI/ML, AI Workflow Automations, and software development. Automate your business workflow for: Sales Marketing Accounting Finance Operations E-Commerce Customer Support Admin & Backoffice Logistics & Supply Chain
外部链接
在 n8n.io 查看 →
分享此工作流