使用Apify、Google Gemini和Sheets实时自动化Upwork提案生成
高级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 25 个节点。主要使用 If, Set, Gmail, Summarize, GoogleSheets 等节点。 使用Apify、Google Gemini和Sheets自动化AI Upwork提案生成
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (25)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "h7kye1TyifE8jVpQ",
"meta": {
"instanceId": "1a54c41d9050a8f1fa6f74ca858828ad9fb97b9fafa3e9760e576171c531a787"
},
"name": "使用 Apify、Google Gemini 和 Sheets 实时自动化 Upwork 提案生成",
"tags": [],
"nodes": [
{
"id": "6de5e3c9-fbef-4fbb-863f-2f100e802601",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-256,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ac26904f-2ee9-4417-bf60-3f059686c0be",
"name": "运行 Upwork Actor 获取列出的工作",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
64,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c86c636f-e414-4ba9-98d1-26a2f2a26175",
"name": "从 Upwork Actor 获取数据集",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
288,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "78dd55ae-37a3-4178-9e70-167dd21666c2",
"name": "将提取的数据添加到 Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
656,
240
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "eb2586a4-6bb2-4302-acf5-5efe6e495076",
"name": "计算新工作数量",
"type": "n8n-nodes-base.summarize",
"position": [
1008,
240
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "6906f045-15e7-4bab-a0a4-97bcd6466257",
"name": "发送邮件通知",
"type": "n8n-nodes-base.gmail",
"position": [
1360,
240
],
"webhookId": "57c8be7f-1f81-469e-81b0-448ef55d6e2f",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "06bbaf29-c309-484e-a711-0d6c3f7c3140",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-48
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d1013079-63ff-4c95-8974-fdf077c5412d",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
96
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e9ccf231-e7cd-42b6-a4ec-774e7a375c61",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c9f81e8f-c955-47bc-9f63-963b7c8de3b6",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
96
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "070434c0-5503-455d-9e69-90522afac0e5",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
32,
560
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "42496b60-1d0a-41b7-be95-262981058f6a",
"name": "Google Gemini聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
464,
976
],
"parameters": {},
"typeVersion": 1
},
{
"id": "efee4d21-e839-4b5f-8c87-6234c6e44f11",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
624,
976
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "963eef64-a1d1-4a1e-9266-93984739f118",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-256,
560
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "a84799f2-70ef-4980-81c3-afc7a8b51c91",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
848,
560
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "9a168243-ebcf-4b0d-9761-cdec750908ff",
"name": "发送消息",
"type": "n8n-nodes-base.gmail",
"position": [
1664,
560
],
"webhookId": "57c8be7f-1f81-469e-81b0-448ef55d6e2f",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "1723dd54-0806-4d3e-bf2e-53ddc5acd929",
"name": "摘要",
"type": "n8n-nodes-base.summarize",
"position": [
1376,
560
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "e3573056-1527-43b7-b724-03ac0f693dad",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1184,
560
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "e42d7f08-c1ab-4e08-bf9e-bc97d842de4b",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "df087f1e-c45a-4363-a076-b28bfd0606cf",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
688
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "33a8cdb2-5908-4201-ba34-9f52b641aaa4",
"name": "提案撰写",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
464,
816
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "26408e94-bf72-493d-8123-583aace9921f",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
816,
720
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ebeb68c3-ac91-4bd0-91e4-03272cdf8c50",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1536,
400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "492bac5d-11ce-45a1-9e57-2475b8895b85",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1136,
736
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5d88a224-02ac-4c9d-8861-bd860673ce66",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
496
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "72a480b8-38e5-4c96-b924-d07bad552e18",
"connections": {
"If": {
"main": [
[
{
"node": "Proposal Crafting",
"type": "main",
"index": 0
}
]
]
},
"Summarize": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Proposal Crafting": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Count the New Jobs": {
"main": [
[
{
"node": "Send Email Notification",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Send Email Notification": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Proposal Crafting",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Proposal Crafting",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Summarize",
"type": "main",
"index": 0
}
]
]
},
"Add the Extracted Data in Sheets": {
"main": [
[
{
"node": "Count the New Jobs",
"type": "main",
"index": 0
}
]
]
},
"Run Upwork Actor for Listed Jobs": {
"main": [
[
{
"node": "Get the Dataset from Upwork Actor",
"type": "main",
"index": 0
}
]
]
},
"Get the Dataset from Upwork Actor": {
"main": [
[
{
"node": "Add the Extracted Data in Sheets",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Run Upwork Actor for Listed Jobs",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Apify、Apollo.io和Google Gemini自动化LinkedIn职位AI驱动潜在客户生成
自动化LinkedIn职位潜在客户生成：Apify、Apollo.io和Google Gemini
If
Code
Limit
+11
47 节点Intuz
潜在客户开发
实时自动化 LinkedIn 档案研究与 AI 外联（使用 Apify、Gemini 和 Sheets）
使用 Apify、Gemini 和 Sheets 自动化 LinkedIn 档案研究与邮件外联
If
Limit
Google Sheets
+6
20 节点Intuz
潜在客户开发
CB资助公司及信息丰富
自动化潜在客户生成与邮件外联：Apify、Apollo.io、GPT-4和Google Sheets
If
Code
Merge
+8
32 节点Intuz
潜在客户开发
使用LinkedIn职位信号、Apify、Apollo.io和Google Gemini自动化销售拓展
基于LinkedIn职位信号使用Apify和Google Gemini生成个性化销售拓展
If
Code
Limit
+11
47 节点Intuz
实时 - 使用Gemini和Creatomate自动化病毒式AI视频制作与发布
使用Gemini和Creatomate自动化AI视频创作与多平台发布
Set
Code
Wait
+15
47 节点Intuz
内容创作
个性化邮件
使用Gemini AI和Google表格创建个性化销售外联邮件
If
Set
Google Sheets
+4
8 节点Intuz
客户培育
工作流信息
难度等级
高级
节点数量25
分类2
节点类型11
作者
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 查看 →
分享此工作流