使用AI和Apify将LinkedIn帖子互动转化为合格潜在客户
高级
这是一个Lead Generation, AI Summarization领域的自动化工作流，包含 26 个节点。主要使用 If, Set, Code, Wait, Airtable 等节点。 使用AI和Apify将LinkedIn帖子互动转化为合格潜在客户
前置要求
- •Airtable API Key
- •可能需要目标 API 的认证凭证
使用的节点 (26)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "8d70623c0c9f4448eda9626cd8185192c28447e191325b0c0d94d3f40d23be3a"
},
"nodes": [
{
"id": "89ac2fe8-a5df-4150-b921-318e641b429c",
"name": "条件3",
"type": "n8n-nodes-base.if",
"position": [
1740,
440
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "fe7ae37d-2d50-4308-b340-b3cfed20a2f0",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json && Object.keys($json).length > 0 }}",
"rightValue": ""
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "2cc1a9bb-8b33-4af5-83ac-5af7906f778b",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
1960,
440
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a8672809-182b-4e13-96e4-7a2550c8f796",
"name": "linkedin_scraper_out",
"type": "string",
"value": "={{ $('Aggregate').item.json.fullName[0] }}\n{{ $('Aggregate').item.json.jobTitle[0] }}\n{{ $('Aggregate').item.json.companyName[0] }}\n{{ $('Aggregate').item.json.companyIndustry[0] }}\n{{ $('Aggregate').item.json.companyWebsite[0] }}\n{{ $('Aggregate').item.json.topSkillsByEndorsements[0] }}\n{{ $('Aggregate').item.json.about[0] }}\n{{ $('Aggregate').item.json.title[0] }}\n{{ $('Aggregate').item.json.description[0] }}\n{{ $('Aggregate').item.json.text[0] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "198608d6-f63c-41d1-b612-161c208a8514",
"name": "结构化输出解析器1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2340,
660
],
"parameters": {
"jsonSchemaExample": "{\n \"icp\": \"true/false\",\n \"reasoning\": \"Brief explanation of classification decision based on the data analysis\"\n}"
},
"typeVersion": 1.2
},
{
"id": "f48f1abd-b702-451f-8e75-4aabe1e3515f",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1660,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1124ab40-bbe3-4202-a16f-61228dbdb728",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
1000,
440
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "fullName"
},
{
"fieldToAggregate": "jobTitle"
},
{
"fieldToAggregate": "companyName"
},
{
"fieldToAggregate": "companyIndustry"
},
{
"fieldToAggregate": "companyWebsite"
},
{
"fieldToAggregate": "topSkillsByEndorsements"
},
{
"fieldToAggregate": "about"
},
{
"fieldToAggregate": "experiences[0].title"
},
{
"fieldToAggregate": "experiences[0].subComponents[0].description"
},
{
"fieldToAggregate": "experiences[1].title"
},
{
"fieldToAggregate": "experiences[1].subComponents[0].description[0].text"
}
]
}
},
"typeVersion": 1
},
{
"id": "25405123-3526-43b6-811e-afafb3796a39",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-160,
140
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b7097e6a-a156-41ad-b506-ebcb78a1538c",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json && Object.keys($json).length > 0 }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a22810dc-dee3-4e34-8f64-85e4026785fa",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "cae1c603-11e7-4c83-bac1-008690c56a09",
"name": "检查重复",
"type": "n8n-nodes-base.airtable",
"position": [
-380,
140
],
"parameters": {
"base": {
"__rl": true,
"mode": "id",
"value": ""
},
"table": {
"__rl": true,
"mode": "id",
"value": ""
},
"options": {},
"operation": "search",
"authentication": "airtableOAuth2Api",
"filterByFormula": "=({Name} = \"{{ $json.profile_name }}\")"
},
"typeVersion": 2.1,
"alwaysOutputData": true
},
{
"id": "fd30b54c-a01a-4db5-8556-7ca3605b47d4",
"name": "清理数据",
"type": "n8n-nodes-base.set",
"position": [
-640,
140
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "28682a76-7670-4af5-a3c8-b85d485dcad8",
"name": "profile_urn",
"type": "string",
"value": "={{ $json.reactor.urn }}"
},
{
"id": "7bc40d85-d383-4b27-a89b-dc8607adc40a",
"name": "profile_name",
"type": "string",
"value": "={{ $json.reactor.name }}"
},
{
"id": "ce4d0feb-c803-4c6e-a448-b3f6921593c4",
"name": "profile_job_title",
"type": "string",
"value": "={{ $json.reactor.headline }}"
},
{
"id": "735110e2-a403-4cf3-bac2-c2fa598b7c67",
"name": "profile_linkedin_url",
"type": "string",
"value": "={{ $json.reactor.profile_url }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "de1ccf48-08d0-4058-964c-c9e940546e42",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-920,
120
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "c7676bae-f6c4-4746-a88f-ed877bb09d83",
"name": "等待速率限制",
"type": "n8n-nodes-base.wait",
"position": [
-1140,
120
],
"webhookId": "1a90f5d4-c201-4866-9b46-fb99e1a0a798",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "ea9be84c-663a-424b-9f82-49a1c0faad63",
"name": "创建新记录",
"type": "n8n-nodes-base.airtable",
"position": [
240,
140
],
"parameters": {
"base": {
"__rl": true,
"mode": "id",
"value": ""
},
"table": {
"__rl": true,
"mode": "id",
"value": ""
},
"columns": {
"value": {
"URN": "={{ $('Clean Data').item.json.profile_urn }}",
"Name": "={{ $('Clean Data').item.json.profile_name }}",
"Title": "={{ $('Clean Data').item.json.profile_job_title }}",
"Profile URL": "={{ $('Clean Data').item.json.profile_linkedin_url }}"
},
"schema": [
{
"id": "URN",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "URN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Profile URL",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Profile URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MSP?",
"type": "boolean",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "MSP?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reason",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Reason",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create",
"authentication": "airtableOAuth2Api"
},
"typeVersion": 2.1
},
{
"id": "3766e2ce-7f5f-430a-ac6d-d31c1ef595db",
"name": "随机延迟",
"type": "n8n-nodes-base.code",
"position": [
460,
140
],
"parameters": {
"jsCode": "// Random Time Generator - Returns single random time object\n\n// Function to generate random seconds with decimal places\nfunction generateRandomSeconds(min = 0.1, max = 60, decimalPlaces = 1) {\n const randomValue = Math.random() * (max - min) + min;\n return Number(randomValue.toFixed(decimalPlaces));\n}\n\n// Generate single random time\nconst seconds = generateRandomSeconds(0.1, 60, 1);\n\n// Return array with single object (n8n requirement)\nreturn [{\n seconds: seconds,\n formatted: `${seconds} seconds`,\n milliseconds: seconds * 1000\n}];"
},
"typeVersion": 2
},
{
"id": "03fb46da-5027-4996-87d1-511b20860f34",
"name": "随机延迟等待",
"type": "n8n-nodes-base.wait",
"position": [
680,
140
],
"webhookId": "73d87027-2b93-4798-a496-05090671f858",
"parameters": {
"amount": "={{ $('Random Delay').item.json.seconds }}"
},
"typeVersion": 1.1
},
{
"id": "107aee62-4ced-47a6-8063-ac0f0ecc2e49",
"name": "随机延迟生成器",
"type": "n8n-nodes-base.code",
"position": [
1220,
440
],
"parameters": {
"jsCode": "// Random Time Generator - Returns single random time object\n\n// Function to generate random seconds with decimal places\nfunction generateRandomSeconds(min = 0.1, max = 60, decimalPlaces = 1) {\n const randomValue = Math.random() * (max - min) + min;\n return Number(randomValue.toFixed(decimalPlaces));\n}\n\n// Generate single random time\nconst seconds = generateRandomSeconds(0.1, 60, 1);\n\n// Return array with single object (n8n requirement)\nreturn [{\n seconds: seconds,\n formatted: `${seconds} seconds`,\n milliseconds: seconds * 1000\n}];\n"
},
"typeVersion": 2
},
{
"id": "139536cf-6039-48e7-a41f-21d98171bb33",
"name": "随机延迟等待节点",
"type": "n8n-nodes-base.wait",
"position": [
1440,
440
],
"webhookId": "e77b3d5b-d56f-4cba-8d79-60781a0f327e",
"parameters": {
"amount": "={{ $('Random Delay Generator').item.json.seconds }}"
},
"typeVersion": 1.1
},
{
"id": "490c6df0-e206-4673-ad2a-fbb2c50bb5ae",
"name": "更新记录",
"type": "n8n-nodes-base.airtable",
"position": [
2560,
440
],
"parameters": {
"base": {
"__rl": true,
"mode": "id",
"value": ""
},
"table": {
"__rl": true,
"mode": "id",
"value": ""
},
"columns": {
"value": {
"id": "={{ $('Create New Record').item.json.id }}",
"MSP?": "={{ $('AI ICP Classification').item.json.output.msp }}",
"Reason": "={{ $('AI ICP Classification').item.json.output.reasoning }}",
"Email Address": "={{$('Enrich LinkedIn Profile').first().json.email}}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "URN",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "URN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Profile URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Profile URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MSP?",
"type": "boolean",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "MSP?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reason",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Reason",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"authentication": "airtableOAuth2Api"
},
"typeVersion": 2.1
},
{
"id": "5d693aa7-79b0-4a19-b7b6-888710743617",
"name": "AI ICP 分类",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
2180,
440
],
"parameters": {
"text": "=You are an AI classifier that determines if a person works for xxxx based on LinkedIn scraper data.\nTask: Analyze the provided LinkedIn data and classify the person as icp or non-icp.\n\nData input: {{ $('Edit Fields1').item.json.linkedin_scraper_out }}\n\nJob Indicators:\n\nJob titles containing: \n\nInstructions:\n\nIf scraper returns blank/no data → = false\nAnalyze job title, company name, company description, and industry\nLook for XXX-related keywords and services\nProvide classification with reasoning\n\nExamples:\nInput: No data returned from scraper\njson{\n \"icp\": false,\n \"reasoning\": \"No data returned from scraping\"\n}\nInput: Job Title: \"Senior Network Engineer at TechCorp MSP\"\njson{\n \"icp\": true,\n \"reasoning\": \"Job title indicates and company name explicitly mentions keywords\"\n}\nInput: Job Title: \"Marketing Manager at Nike\"\njson{\n \"icp\": false,\n \"reasoning\": \"Marketing role at retail company with no indication of managed keywords services\"\n} ",
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "623feb13-cc50-4d71-964c-e076af7f7987",
"name": "抓取帖子互动",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1380,
120
],
"parameters": {
"url": "https://api.apify.com/v2/acts/apimaestro~linkedin-post-reactions/run-sync-get-dataset-items?token= ",
"method": "POST",
"options": {},
"jsonBody": "{\n \"post_url\": \"YOUR_POST_URN\",\n \"page_number\": 1\n}",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2
},
{
"id": "63f90fba-ffaa-434e-bdd0-b5368f35f0f2",
"name": "丰富 LinkedIn 个人资料",
"type": "n8n-nodes-base.httpRequest",
"position": [
780,
440
],
"parameters": {
"url": "https://api.apify.com/v2/acts/dev_fusion~linkedin-profile-scraper/run-sync-get-dataset-items?token=",
"method": "POST",
"options": {},
"jsonBody": "={\n \"profileUrls\": [\n \"{{ $('Clean Data').item.json.profile_linkedin_url }}\"\n ]\n}\n",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "a6c1e1e0-d708-42da-b234-a4cec31700e2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2420,
-80
],
"parameters": {
"width": 640,
"height": 1040,
"content": "## 🎯 LinkedIn ICP 潜在客户资格认定自动化"
},
"typeVersion": 1
},
{
"id": "6323c901-a4f8-4a41-b548-fe55e4576fff",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
-240
],
"parameters": {
"color": 7,
"width": 400,
"height": 300,
"content": "## 1. 提取帖子互动"
},
"typeVersion": 1
},
{
"id": "005853d9-c286-47bc-ba22-4b8dd01865be",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-220
],
"parameters": {
"color": 7,
"width": 400,
"height": 300,
"content": "## 2. 清理和去重潜在客户"
},
"typeVersion": 1
},
{
"id": "691b8dee-1378-4f02-82dd-0108b6bbbaad",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
620,
680
],
"parameters": {
"color": 7,
"width": 400,
"height": 300,
"content": "## 3. 丰富 LinkedIn 个人资料"
},
"typeVersion": 1
},
{
"id": "50fe618e-7334-4fe0-aaf7-459d705f1e99",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2100,
60
],
"parameters": {
"color": 7,
"width": 400,
"height": 300,
"content": "## 4. AI 驱动的 ICP 分类"
},
"typeVersion": 1
},
{
"id": "7fdca041-4a8b-4e98-b8dc-fef55ea10ee8",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
940,
-360
],
"parameters": {
"color": 3,
"width": 460,
"height": 420,
"content": "### ⚠️ LinkedIn 安全性和速率限制警告！"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
],
[
{
"node": "Create New Record",
"type": "main",
"index": 0
}
]
]
},
"If3": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Random Delay Generator",
"type": "main",
"index": 0
}
]
]
},
"Clean Data": {
"main": [
[
{
"node": "Check Duplication",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "AI ICP Classification",
"type": "main",
"index": 0
}
]
]
},
"Random Delay": {
"main": [
[
{
"node": "Random Delay Wait",
"type": "main",
"index": 0
}
]
]
},
"Update Record": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Clean Data",
"type": "main",
"index": 0
}
]
]
},
"Wait Rate Limit": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Check Duplication": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Create New Record": {
"main": [
[
{
"node": "Random Delay",
"type": "main",
"index": 0
}
]
]
},
"Random Delay Wait": {
"main": [
[
{
"node": "Enrich LinkedIn Profile",
"type": "main",
"index": 0
}
]
]
},
"AI ICP Classification": {
"main": [
[
{
"node": "Update Record",
"type": "main",
"index": 0
}
]
]
},
"Scrape Post Reactions": {
"main": [
[
{
"node": "Wait Rate Limit",
"type": "main",
"index": 0
}
]
]
},
"Random Delay Generator": {
"main": [
[
{
"node": "Random Delay Wait Node",
"type": "main",
"index": 0
}
]
]
},
"Random Delay Wait Node": {
"main": [
[
{
"node": "If3",
"type": "main",
"index": 0
}
]
]
},
"Enrich LinkedIn Profile": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "AI ICP Classification",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Scrape Post Reactions",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
监控LinkedIn帖子并使用OpenAI和Airtable创建AI内容摘要
监控LinkedIn帖子并使用OpenAI和Airtable创建AI内容摘要
If
Set
Code
+10
30 节点Anna Bui
内容创作
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
联系人信息丰富化
基于 Apollo、LinkedIn 和 GPT-4o 的全面联系人信息丰富化，适用于 HubSpot
If
Set
Code
+15
24 节点Interlock GTM
潜在客户开发
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
使用 Gemini AI 和 Airtable 从图片生成 Shopify 产品列表
使用 Gemini AI 和 Airtable 从图片生成 Shopify 产品列表
If
Set
Code
+16
33 节点MANISH KUMAR
内容创作
