Reddit自由职业工作监控与Google表格跟踪和Telegram警报
中级
这是一个Lead Generation领域的自动化工作流,包含 11 个节点。主要使用 Set, Code, Filter, SplitOut, Telegram 等节点。 Reddit自由职业工作监控与Google表格跟踪和Telegram警报
前置要求
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"meta": {
"instanceId": "b6731f6e46273cffeac6b5188a5b3bcb0840c00108e73b48ae2b799ac6e8e081",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "f1342627-4d31-4f16-a020-cda26f14748c",
"name": "每 5 分钟运行一次",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
240,
120
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "2ae99530-e45a-46b4-9a88-24fb5c54bf8b",
"name": "查找自由职业需求帖子",
"type": "n8n-nodes-base.httpRequest",
"position": [
460,
120
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "80f04d39-58c3-4342-9729-ba9f073db667",
"name": "提取帖子元数据",
"type": "n8n-nodes-base.set",
"position": [
680,
120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "541383f1-5ed9-4033-978b-442276908247",
"name": "确保需求是有偿的",
"type": "n8n-nodes-base.filter",
"position": [
1260,
340
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f75740b3-480f-42bd-9033-192c9817be3f",
"name": "获取帖子 UTC 时间",
"type": "n8n-nodes-base.set",
"position": [
2060,
560
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "61ed2ab7-9cb3-4f70-ab00-0afa578f1b42",
"name": "检查现有行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1480,
340
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "ab92c8aa-79f3-45b6-8651-2cfea0372e8b",
"name": "筛选唯一帖子",
"type": "n8n-nodes-base.code",
"position": [
1700,
340
],
"parameters": {},
"typeVersion": 2
},
{
"id": "853ef1e0-a238-4e4c-ab5e-459d9a75233b",
"name": "保存到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2280,
560
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "71efa8e6-8e1a-4042-ae9f-2d41f195c93c",
"name": "在 Telegram 中通知用户",
"type": "n8n-nodes-base.telegram",
"position": [
2500,
560
],
"webhookId": "b033adda-57ee-46ee-97e2-96de0b3e598e",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "da33c131-b34b-402a-8ecd-20432a3cabd6",
"name": "将数组拆分为单独帖子",
"type": "n8n-nodes-base.splitOut",
"position": [
900,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c2aac5ed-06d3-4582-99da-bb4b1da7d845",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
0
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Save in sheets": {
"main": [
[
{
"node": "Inform User in telegram",
"type": "main",
"index": 0
}
]
]
},
"Get UTC of Post": {
"main": [
[
{
"node": "Save in sheets",
"type": "main",
"index": 0
}
]
]
},
"Check present Rows": {
"main": [
[
{
"node": "Filter Unique Posts",
"type": "main",
"index": 0
}
]
]
},
"Filter Unique Posts": {
"main": [
[
{
"node": "Get UTC of Post",
"type": "main",
"index": 0
}
]
]
},
"Run Every 5 Minutes": {
"main": [
[
{
"node": "Look for freelance requirement posts",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata": {
"main": [
[
{
"node": "Seperate array into individual posts",
"type": "main",
"index": 0
}
]
]
},
"Make sure the requirement is paid": {
"main": [
[
{
"node": "Check present Rows",
"type": "main",
"index": 0
}
]
]
},
"Look for freelance requirement posts": {
"main": [
[
{
"node": "Extract Post Metadata",
"type": "main",
"index": 0
}
]
]
},
"Seperate array into individual posts": {
"main": [
[
{
"node": "Make sure the requirement is paid",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 潜在客户开发
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
Reddit至Google表格:跟踪自由职业/工作线索
Reddit至Google表格:跟踪自由职业/工作线索
If
Set
Code
+8
33 节点iamvaar
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
基于公司ID的Apollo数据丰富
使用Apollo、Google Sheets和Telegram基于公司ID丰富采购联系人
If
Set
Code
+9
27 节点Khaisa Studio
潜在客户开发
自动化Leadfeeder和Apollo.io数据收集
线索丰富管道:从Leadfeeder到Apollo再到Google Sheets
If
Set
Code
+9
23 节点Khairul Muhtadin
潜在客户开发
使用Gemini+LangChain+Sheets监控Reddit负面公关品牌声誉
使用Gemini+LangChain+Sheets监控Reddit负面公关品牌声誉
Set
Code
Split Out
+7
10 节点iamvaar
AI 摘要总结
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
Set
Code
Limit
+9
18 节点Cong Nguyen
市场调研