8
n8n 中文网amn8n.com

每周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)可能需要您自行付费。

工作流信息
难度等级
中级
节点数量13
分类2
节点类型7
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

作者
David Olusola

David Olusola

@dae221

I 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 查看

分享此工作流