Upwork职位发布者邮件
高级
这是一个Other、AI领域的自动化工作流，包含 21 个节点。主要使用 If、HttpRequest、GoogleSheets、Agent、ScheduleTrigger 等节点，结合人工智能技术实现智能自动化。 Upwork潜在客户开发：通过LinkedIn爬取和AI提取客户邮箱
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "wAomRf96IfSnpTA7",
"meta": {
"instanceId": "84ad02d6104594179f43f1ce9cfe3a81637b2faedb57dafcb9e649b7542988db",
"templateCredsSetupCompleted": true
},
"name": "Upwork 职位发布者邮件",
"tags": [],
"nodes": [
{
"id": "aa72ce26-28ae-4dab-982f-be16fa123d87",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
420,
360
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "wYwTjEv45IzlAOAu",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "94fba561-bc7e-4180-9b5d-beb9482b28b6",
"name": "每 X 小时运行一次",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
140
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "603403fa-6f4b-4124-90ee-f852954e67a4",
"name": "获取最新 Upwork 职位（Apify）",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
140
],
"parameters": {
"url": "https://api.apify.com/v2/actor-tasks/<TASK_ID>/run-sync-get-dataset-items?token=<API_TOKEN>",
"options": {},
"sendBody": true,
"bodyParameters": {
"parameters": [
{}
]
}
},
"typeVersion": 4.2
},
{
"id": "0ed2ab83-1fcb-459c-aa6d-ef81c8414b45",
"name": "从职位中提取公司或个人名称",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
440,
140
],
"parameters": {
"text": "=Title: {{ $json.title }}\nDescription: {{ $json.description }}",
"options": {
"systemMessage": "\"Extract the client's name or company name if it is mentioned. Return only the name or 'null' if not found.\""
},
"promptType": "define"
},
"typeVersion": 1.9
},
{
"id": "ccd6cf3c-2666-45eb-8dc3-6575180c897b",
"name": "是否找到名称？",
"type": "n8n-nodes-base.if",
"position": [
800,
140
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7366a7c6-e767-4aea-96e1-0cbbcbb26100",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json.output }}",
"rightValue": "null"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c9721e93-707d-45c1-a06b-68606157f995",
"name": "未找到名称 - 提前结束",
"type": "n8n-nodes-base.noOp",
"position": [
1240,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4164b6e9-9ba7-4fc6-a1b6-c976f626aea5",
"name": "是个人还是公司？",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1180,
40
],
"parameters": {
"text": "={{ $json.output }}",
"options": {
"systemMessage": "\"Extract the client's name or company name. Return only the 'person' if looks like a person's name if not return 'company'.\"\n"
},
"promptType": "define"
},
"typeVersion": 1.9
},
{
"id": "93c7b341-6257-4ee2-a54f-ecbfcdf0f89b",
"name": "个人或公司？",
"type": "n8n-nodes-base.if",
"position": [
1540,
40
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "729e7baa-ae94-4661-a061-7d656faf820f",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output }}",
"rightValue": "company"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "7dcacf79-eb65-454c-97fd-16ea6aed2f94",
"name": "在 LinkedIn 上搜索公司（Phantombuster）",
"type": "n8n-nodes-base.httpRequest",
"position": [
1960,
-120
],
"parameters": {
"url": "https://api.phantombuster.com/api/v2/agents/<AGENT_ID>/launch",
"method": "POST",
"options": {},
"jsonBody": "={\n \"argument\": {\n \"search\": {{ $json.output }},\n \"numberOfProfiles\": 5,\n \"sessionCookie\": \"<LINKEDIN_SESSION_COOKIE>\"\n },\n \"saveArguments\": true\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "X-Phantombuster-Key-1",
"value": "<YOUR_API_KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "e2f7db77-373e-462a-bc57-57653e067e30",
"name": "抓取 LinkedIn 公司资料",
"type": "n8n-nodes-base.httpRequest",
"position": [
2180,
-120
],
"parameters": {
"url": "https://api.phantombuster.com/api/v2/agents/<AGENT_ID>/launch",
"method": "POST",
"options": {},
"jsonBody": "={\n \"argument\": {\n \"spreadsheetUrl\": {{ $json.profileUrl }},\n \"sessionCookie\": \"<LINKEDIN_SESSION_COOKIE>\"\n },\n \"saveArguments\": true\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "X-Phantombuster-Key-1",
"value": "<YOUR_API_KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "14d7f669-dbc1-484e-b3c0-3d1e83d4c74f",
"name": "查找公司邮箱（Hunter.io）",
"type": "n8n-nodes-base.httpRequest",
"position": [
2400,
-120
],
"parameters": {
"url": "=https://api.hunter.io/v2/domain-search?domain{{ $json.website }}=&api_key=<YOUR_API_KEY>",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "4fd05ce5-495e-4d3a-8998-3120c3456e57",
"name": "在 LinkedIn 上搜索个人（Phantombuster）",
"type": "n8n-nodes-base.httpRequest",
"position": [
1960,
1280
],
"parameters": {
"url": "https://api.phantombuster.com/api/v2/agents/<AGENT_ID>/launch",
"method": "POST",
"options": {},
"jsonBody": "{\n \"argument\": {\n \"search\": {{ $json.output }},\n \"numberOfProfiles\": 3,\n \"sessionCookie\": \"<LINKEDIN_SESSION_COOKIE>\"\n },\n \"saveArguments\": true\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "X-Phantombuster-Key-1",
"value": "<YOUR_API_KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "f048e198-cc4b-4739-be7d-d3d885c6d2bb",
"name": "抓取 LinkedIn 个人资料",
"type": "n8n-nodes-base.httpRequest",
"position": [
2180,
1280
],
"parameters": {
"url": "https://api.phantombuster.com/api/v2/agents/<AGENT_ID>/launch",
"method": "POST",
"options": {},
"jsonBody": "={\n \"argument\": {\n \"spreadsheetUrl\": {{ $json.profileUrl }},\n \"sessionCookie\": \"<LINKEDIN_SESSION_COOKIE>\"\n },\n \"saveArguments\": true\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "X-Phantombuster-Key-1",
"value": "<YOUR_API_KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "dbc8c317-b469-4125-b939-614524a0339b",
"name": "查找个人邮箱（Hunter.io）",
"type": "n8n-nodes-base.httpRequest",
"position": [
2400,
1280
],
"parameters": {
"url": "=https://api.hunter.io/v2/email-finder?domain={{ $json.fullName }}=Ali%20Raza&api_key=<YOUR_API_KEY>",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "047146a8-2b02-4098-a0e9-f8366c42aa4f",
"name": "将结果存储到 Google 表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2760,
20
],
"parameters": {
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Rp7XiR3hxJfv03ZO",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "1e9dee68-e0c2-4588-b6ca-666534d14dd4",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1820,
-2200
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "2085a7ca-f68b-490a-9dcb-3c96fc6a739d",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1820,
-1860
],
"parameters": {
"color": 4,
"width": 1289,
"height": 5558,
"content": "# 🚀 **自动化 Upwork 潜在客户信息丰富工作流**"
},
"typeVersion": 1
},
{
"id": "5bda85dd-7559-4239-9b38-c887a39dbb54",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-2180
],
"parameters": {
"color": 3,
"width": 1800,
"height": 2680,
"content": "## 🧩 **1. 触发器与数据收集**"
},
"typeVersion": 1
},
{
"id": "aa30a465-97e4-449f-a0b4-07a97a0f3d2c",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1880,
-1300
],
"parameters": {
"color": 5,
"width": 700,
"height": 1420,
"content": "## 🏢 **4A. 公司路径**"
},
"typeVersion": 1
},
{
"id": "7d7ec4da-d52c-4563-94df-3dcf88c85ff0",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1900,
160
],
"parameters": {
"color": 6,
"width": 640,
"height": 1300,
"content": "## 👤 **4B. 个人路径**"
},
"typeVersion": 1
},
{
"id": "46f24197-38da-43a1-ba03-1e394169340a",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2680,
-520
],
"parameters": {
"color": 6,
"width": 260,
"height": 720,
"content": "## 📑 **5. 将所有内容存储到 Google 表格**"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Find Company Email (Hunter.io)": [
{
"json": {
"data": {
"domain": "devsync.io",
"emails": [
{
"type": "personal",
"value": "ali.raza@devsync.io",
"sources": [
{
"domain": "devsync.io",
"extracted_on": "2024-12-01",
"last_seen_on": "2025-05-30",
"still_on_page": true
}
],
"linkedin": "https://www.linkedin.com/in/aliraza-devsync",
"position": "Founder",
"last_name": "Raza",
"confidence": 95,
"department": "Executive",
"first_name": "Ali"
},
{
"type": "generic",
"value": "info@devsync.io",
"confidence": 100
}
],
"pattern": "{first}.{last}@devsync.io",
"webmail": false,
"disposable": false,
"organization": "DevSync"
},
"meta": {
"limit": 100,
"offset": 0,
"results": 2
}
}
}
],
"Scrape LinkedIn Person Profile": [
{
"json": {
"skills": [
"Python",
"Distributed Systems",
"Kubernetes",
"GCP"
],
"summary": "Experienced software engineer specializing in backend and distributed systems.",
"fullName": "John Doe",
"headline": "Senior Software Engineer at Google",
"location": "Mountain View, California, United States",
"education": [
{
"degree": "B.S. in Computer Science",
"school": "Stanford University",
"dateRange": "2012 – 2016"
}
],
"profileUrl": "https://www.linkedin.com/in/john-doe-123456/",
"connections": "500+ connections",
"experiences": [
{
"title": "Senior Software Engineer",
"company": "Google",
"location": "Mountain View, CA",
"dateRange": "Jan 2021 – Present",
"description": "Working on scalable cloud infrastructure and ML services."
},
{
"title": "Software Engineer",
"company": "Facebook",
"location": "Menlo Park, CA",
"dateRange": "2017 – 2021"
}
],
"profilePictureUrl": "https://media.licdn.com/dms/image/xyz.jpg"
}
}
],
"Find Personal Email (Hunter.io)": [
{
"json": {
"data": {
"email": "ali.raza@devsync.io",
"score": 93,
"domain": "devsync.io",
"company": "DevSync",
"twitter": null,
"position": "Founder",
"last_name": "Raza",
"first_name": "Ali",
"linkedin_url": "https://www.linkedin.com/in/aliraza-devsync",
"phone_number": null
},
"meta": {
"confidence": 93
}
}
}
],
"Scrape LinkedIn Company Profile": [
{
"json": {
"name": "DevSync",
"founded": "2021",
"website": "https://devsync.io",
"industry": "Computer Software",
"followers": 248,
"companySize": "11-50 employees",
"description": "DevSync is a real-time collaboration tool for distributed software teams.",
"linkedinUrl": "https://www.linkedin.com/company/devsync/",
"specialties": [
"Collaboration",
"Remote Work",
"Agile Tools"
],
"headquarters": "San Francisco, CA"
}
}
],
"Fetch Latest Upwork Jobs (Apify)": [
{
"json": {
"url": "https://www.upwork.com/job/React-developer_~01abcde12345fghij",
"title": "Looking for a React developer for long-term project",
"budget": 1000,
"client": {
"country": "United States",
"feedback": 4.9
},
"category": "Web, Mobile & Software Dev",
"postedAt": "2025-06-07T12:34:56Z",
"description": "We are a San Francisco-based startup called DevSync. We're building a real-time collaboration tool for remote teams..."
}
},
{
"json": {
"url": "https://www.upwork.com/job/AI-ML-Engineer_~01qwerty98765zxcvb",
"title": "AI/ML Engineer Needed for Predictive Model",
"budget": 2000,
"client": {
"country": "Canada",
"feedback": 4.7
},
"category": "Data Science & Analytics",
"postedAt": "2025-06-07T10:22:00Z",
"description": "Our company, BrightData Insights, needs help building a predictive model using open datasets..."
}
}
],
"Search LinkedIn for Person (Phantombuster)": [
{
"json": {
"name": "John Doe",
"title": "Senior Software Engineer at Google",
"location": "Mountain View, California, United States",
"profileUrl": "https://www.linkedin.com/in/john-doe-123456/",
"connectionDegree": "2nd",
"profilePictureUrl": "https://media.licdn.com/dms/image/xyz.jpg"
}
},
{
"json": {
"name": "Johnathan Doe",
"title": "AI Researcher at OpenAI",
"location": "San Francisco Bay Area",
"profileUrl": "https://www.linkedin.com/in/johnathan-doe-78910/",
"connectionDegree": "3rd",
"profilePictureUrl": "https://media.licdn.com/dms/image/abc.jpg"
}
}
],
"Search LinkedIn for Company (Phantombuster)": [
{
"json": {
"name": "DevSync",
"industry": "Computer Software",
"location": "San Francisco Bay Area",
"followers": 248,
"profileUrl": "https://www.linkedin.com/company/devsync/",
"description": "Real-time collaboration tool for remote teams.",
"linkedinSalesNavigatorUrl": null
}
},
{
"json": {
"name": "DevSync Co.",
"industry": "Information Technology & Services",
"location": "Toronto, Canada",
"followers": 123,
"profileUrl": "https://www.linkedin.com/company/devsync-co/",
"description": "Cloud-based productivity platform."
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "9c24521c-85cb-4dbe-b671-43cb6e038740",
"connections": {
"Name is Found?": {
"main": [
[
{
"node": "Is It a Person or Company?",
"type": "main",
"index": 0
}
],
[
{
"node": "No Name Found - End Early",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Extract Company or Person Name from Job",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Is It a Person or Company?",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Run Every X Hours": {
"main": [
[
{
"node": "Fetch Latest Upwork Jobs (Apify)",
"type": "main",
"index": 0
}
]
]
},
"Person or Company?": {
"main": [
[
{
"node": "Search LinkedIn for Company (Phantombuster)",
"type": "main",
"index": 0
}
],
[
{
"node": "Search LinkedIn for Person (Phantombuster)",
"type": "main",
"index": 0
}
]
]
},
"Is It a Person or Company?": {
"main": [
[
{
"node": "Person or Company?",
"type": "main",
"index": 0
}
]
]
},
"Find Company Email (Hunter.io)": {
"main": [
[
{
"node": "Store Results in Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Scrape LinkedIn Person Profile": {
"main": [
[
{
"node": "Find Personal Email (Hunter.io)",
"type": "main",
"index": 0
}
]
]
},
"Find Personal Email (Hunter.io)": {
"main": [
[
{
"node": "Store Results in Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Scrape LinkedIn Company Profile": {
"main": [
[
{
"node": "Find Company Email (Hunter.io)",
"type": "main",
"index": 0
}
]
]
},
"Fetch Latest Upwork Jobs (Apify)": {
"main": [
[
{
"node": "Extract Company or Person Name from Job",
"type": "main",
"index": 0
}
]
]
},
"Extract Company or Person Name from Job": {
"main": [
[
{
"node": "Name is Found?",
"type": "main",
"index": 0
}
]
]
},
"Search LinkedIn for Person (Phantombuster)": {
"main": [
[
{
"node": "Scrape LinkedIn Person Profile",
"type": "main",
"index": 0
}
]
]
},
"Search LinkedIn for Company (Phantombuster)": {
"main": [
[
{
"node": "Scrape LinkedIn Company Profile",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Other、AI等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Upwork 职位聚合与通知器
自动化职位搜索：Upwork 机会聚合与 AI 驱动通知器
Set
Gmail
Http Request
+6
13 节点Yaron Been
Other
Upwork职位聚合与通知器
Upwork职位聚合器，含OpenAI摘要和多渠道通知
Set
Gmail
Http Request
+6
13 节点Yaron Been
Other
智能 Shopify 代理：AI 驱动的弃购车挽回
智能 Shopify 代理：AI 驱动的弃购车挽回系统
If
Wait
Gmail
+7
16 节点Yaron Been
Sales
AI YouTube分析助手：评论分析与洞察报告
AI YouTube分析助手：评论分析器与洞察报告生成器
If
Set
Code
+9
19 节点Yaron Been
AI
使用 GPT-4 自动生成并分发 LinkedIn 帖子到个人资料和群组
使用 GPT-4 自动生成并分发 LinkedIn 帖子到个人资料和群组
If
Code
Limit
+8
14 节点Yaron Been
AI
使用 Phantombuster 的 LinkedIn 帖子互动
使用 Phantombuster、OpenAI GPT 和 Google Sheets 跟踪自动化 LinkedIn 互动
Http Request
Google Sheets
Agent
+3
14 节点Yaron Been
AI
工作流信息
难度等级
高级
节点数量21
分类2
节点类型8
作者
Yaron Been
@yaron-nofluffBuilding AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos
外部链接
在 n8n.io 上查看 →
分享此工作流