每周LinkedIn联系人同步与分析(使用Apify和Google Sheets)
中级
这是一个Lead Generation, Multimodal AI领域的自动化工作流,包含 13 个节点。主要使用 If, Code, Cron, Wait, HttpRequest 等节点。 每周LinkedIn联系人同步与分析(使用Apify和Google Sheets)
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"meta": {
"instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc"
},
"nodes": [
{
"id": "20f1dbb0-303a-4129-87ea-0130f619d86b",
"name": "设置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e24ff50b-bb32-4450-9617-c8e64f70eaea",
"name": "每周同步(周日凌晨 2 点)",
"type": "n8n-nodes-base.cron",
"position": [
688,
560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3c9344c6-3f3c-4123-b26a-04160d3e7069",
"name": "开始 LinkedIn 抓取",
"type": "n8n-nodes-base.httpRequest",
"position": [
896,
560
],
"parameters": {},
"typeVersion": 4.1
},
{
"id": "51b11269-7779-47a9-b613-489bb2870dec",
"name": "提取运行 ID",
"type": "n8n-nodes-base.code",
"position": [
1088,
560
],
"parameters": {},
"typeVersion": 2
},
{
"id": "41c86b36-af09-4e88-849a-e624e0b6dbdb",
"name": "等待抓取(30 秒)",
"type": "n8n-nodes-base.wait",
"position": [
1296,
560
],
"webhookId": "d784a7fd-6bb6-4d1b-800f-1191c354bc94",
"parameters": {},
"typeVersion": 1
},
{
"id": "fd27f571-51c5-4ac3-bd2a-fc977653362c",
"name": "检查抓取状态",
"type": "n8n-nodes-base.httpRequest",
"position": [
1488,
560
],
"parameters": {},
"typeVersion": 4.1
},
{
"id": "8adef10e-6281-41b7-8fac-1580bcb676a6",
"name": "抓取完成?",
"type": "n8n-nodes-base.if",
"position": [
1696,
560
],
"parameters": {},
"typeVersion": 2
},
{
"id": "207a9ab4-b0ac-457a-9819-4a44f23fbefa",
"name": "获取抓取数据",
"type": "n8n-nodes-base.httpRequest",
"position": [
1888,
464
],
"parameters": {},
"typeVersion": 4.1
},
{
"id": "f4ad1f43-e96c-43c3-ac29-42672ee3b081",
"name": "处理联系人数据",
"type": "n8n-nodes-base.code",
"position": [
2096,
464
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d9008ae6-20ab-485d-a14d-28f665ce9730",
"name": "清除现有数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
384
],
"parameters": {},
"typeVersion": 4
},
{
"id": "4ae5f39a-1c29-461f-940b-462294cc8e2b",
"name": "保存联系人到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
544
],
"parameters": {},
"typeVersion": 4
},
{
"id": "c159d043-ceb1-43b2-879b-d5f6eabe22b5",
"name": "生成同步摘要",
"type": "n8n-nodes-base.code",
"position": [
2496,
544
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e2cf5870-02fa-48e3-a9a4-e07885383d34",
"name": "等待和重试(60 秒)",
"type": "n8n-nodes-base.wait",
"position": [
1696,
704
],
"webhookId": "f4502062-9b68-43b6-9069-a8e0c68ab165",
"parameters": {},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Extract Run ID": {
"main": [
[
{
"node": "Wait for Scrape (30s)",
"type": "main",
"index": 0
}
]
]
},
"Get Scraped Data": {
"main": [
[
{
"node": "Process Connections Data",
"type": "main",
"index": 0
}
]
]
},
"Scrape Completed?": {
"main": [
[
{
"node": "Get Scraped Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait & Retry (60s)",
"type": "main",
"index": 0
}
]
]
},
"Wait & Retry (60s)": {
"main": [
[
{
"node": "Check Scrape Status",
"type": "main",
"index": 0
}
]
]
},
"Check Scrape Status": {
"main": [
[
{
"node": "Scrape Completed?",
"type": "main",
"index": 0
}
]
]
},
"Start LinkedIn Scrape": {
"main": [
[
{
"node": "Extract Run ID",
"type": "main",
"index": 0
}
]
]
},
"Wait for Scrape (30s)": {
"main": [
[
{
"node": "Check Scrape Status",
"type": "main",
"index": 0
}
]
]
},
"Process Connections Data": {
"main": [
[
{
"node": "Clear Existing Data",
"type": "main",
"index": 0
},
{
"node": "Save Connections to Sheets",
"type": "main",
"index": 0
}
]
]
},
"Weekly Sync (Sunday 2AM)": {
"main": [
[
{
"node": "Start LinkedIn Scrape",
"type": "main",
"index": 0
}
]
]
},
"Save Connections to Sheets": {
"main": [
[
{
"node": "Generate Sync Summary",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 潜在客户开发, 多模态 AI
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
使用Postiz自动创建AI新闻视频并发布到社交媒体
使用GPT-4o和HeyGen创建AI新闻视频并发布到社交媒体
Set
Code
Wait
+10
37 节点David Olusola
内容创作
基于公司ID的Apollo数据丰富
使用Apollo、Google Sheets和Telegram基于公司ID丰富采购联系人
If
Set
Code
+9
27 节点Khaisa Studio
潜在客户开发
LinkedIn潜在客户生成与CRM自动化套件
使用Apify提取LinkedIn个人资料并为Google Sheets CRM自动生成潜在客户数据
If
Set
Code
+7
18 节点David Olusola
潜在客户开发
自动化Leadfeeder和Apollo.io数据收集
线索丰富管道:从Leadfeeder到Apollo再到Google Sheets
If
Set
Code
+9
23 节点Khairul Muhtadin
潜在客户开发
基于SMS的天气警报(OpenWeather + Twilio)
基于SMS的天气警报(OpenWeather + Twilio)
If
Code
Cron
+3
9 节点David Olusola
个人效率
通过Rapiwa API发送表单提交的WhatsApp确认
基于Rapiwa API和Google表格的WhatsApp号码验证与确认系统
If
Code
Wait
+5
17 节点SpaGreen Creative
潜在客户开发
工作流信息
难度等级
中级
节点数量13
分类2
节点类型7
作者
David Olusola
@dae221I help ambitious businesses eliminate operational bottlenecks and scale faster with AI automation. My clients typically see 40-60% efficiency gains within 90 days. Currently accepting 3 new projects this quarter - david@daexai.com
外部链接
在 n8n.io 查看 →
分享此工作流