Reddit至Google表格：跟踪自由职业/工作线索
高级
这是一个Lead Generation领域的自动化工作流，包含 33 个节点。主要使用 If、Set、Code、Merge、Filter 等节点。 Reddit至Google表格：跟踪自由职业/工作线索
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "b6731f6e46273cffeac6b5188a5b3bcb0840c00108e73b48ae2b799ac6e8e081",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "04becc9e-1219-4d5d-87b0-d788b4566ed8",
"name": "招聘相关评论",
"type": "n8n-nodes-base.filter",
"position": [
1180,
400
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "db5366b3-0a45-4bef-bfb8-91c80f69a6b6",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1520,
400
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c72c05d0-b6d5-4307-986d-b12d0f9cf1e6",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
-680,
-220
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f72871e6-c32b-412d-b8fe-5f4ce10c41f9",
"name": "提取帖子元数据",
"type": "n8n-nodes-base.set",
"position": [
-460,
-220
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "dce2b24f-e7c8-4100-86bb-f5d51bf2347b",
"name": "将数组拆分为单独帖子",
"type": "n8n-nodes-base.splitOut",
"position": [
-240,
-220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "270581bf-6e27-48eb-bf93-30c1e11ff922",
"name": "HTTP请求1",
"type": "n8n-nodes-base.httpRequest",
"position": [
-680,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f3c70ed5-cd34-4213-84f3-0cd6628a6252",
"name": "提取帖子元数据1",
"type": "n8n-nodes-base.set",
"position": [
-460,
-20
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "eae24fb3-44fb-4cb8-b157-5b868b0f2d71",
"name": "将数组分离为单独帖子1",
"type": "n8n-nodes-base.splitOut",
"position": [
-240,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f3a59858-a094-425e-9cd2-cf0e7517d239",
"name": "HTTP请求2",
"type": "n8n-nodes-base.httpRequest",
"position": [
-680,
180
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "a17fb5c2-36e2-41d1-a6e3-4ea4bc02eefa",
"name": "提取帖子元数据2",
"type": "n8n-nodes-base.set",
"position": [
-460,
180
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "7dbc702d-f62f-4aeb-a635-ad5a5e5b1120",
"name": "将数组分离为单独帖子2",
"type": "n8n-nodes-base.splitOut",
"position": [
-240,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4f35c59b-e512-4629-971f-f11672ce1109",
"name": "HTTP请求3",
"type": "n8n-nodes-base.httpRequest",
"position": [
-680,
380
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "09668680-9cdf-4436-8009-0e9b484f465b",
"name": "提取帖子元数据3",
"type": "n8n-nodes-base.set",
"position": [
-460,
380
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "ba230844-0a37-4d28-8805-f54bc1bb98f1",
"name": "将数组分离为单独帖子3",
"type": "n8n-nodes-base.splitOut",
"position": [
-240,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9535e134-4a67-4997-ab27-b7503bdfe25d",
"name": "HTTP请求4",
"type": "n8n-nodes-base.httpRequest",
"position": [
-680,
580
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "67130ebe-7cd2-43cc-bc90-7be9d0272a27",
"name": "提取帖子元数据4",
"type": "n8n-nodes-base.set",
"position": [
-460,
580
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "76c71a43-c722-497c-b679-b2def1ea80e9",
"name": "将数组分离为单独帖子4",
"type": "n8n-nodes-base.splitOut",
"position": [
-240,
580
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7ae47de8-56df-439f-9171-dfd822fd0315",
"name": "HTTP请求5",
"type": "n8n-nodes-base.httpRequest",
"position": [
-680,
780
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "0a7a02a7-8da5-4e3b-97ef-9185150b463c",
"name": "提取帖子元数据5",
"type": "n8n-nodes-base.set",
"position": [
-460,
780
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "02422331-50c1-4514-a5de-816caa8fbcdf",
"name": "将数组分离为单独帖子5",
"type": "n8n-nodes-base.splitOut",
"position": [
-240,
780
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f3fe6f03-0837-47c0-9a42-2586d43a378b",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
440,
320
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "561f0943-dfa3-4996-a5c9-d55816e6931b",
"name": "HTTP请求6",
"type": "n8n-nodes-base.httpRequest",
"position": [
-680,
980
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "87672942-3f52-4b8e-b127-f29bfda058cf",
"name": "提取帖子元数据6",
"type": "n8n-nodes-base.set",
"position": [
-460,
980
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "8ce5fce5-8082-4faf-b0e9-22aa28007859",
"name": "将数组分离为单独帖子6",
"type": "n8n-nodes-base.splitOut",
"position": [
-240,
980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "25ecda48-9dda-4e09-a706-982f5c1c0dc6",
"name": "HTTP请求7",
"type": "n8n-nodes-base.httpRequest",
"position": [
-680,
1180
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "5e3f5332-a0f2-42e1-bf0b-35b54426a79e",
"name": "提取帖子元数据7",
"type": "n8n-nodes-base.set",
"position": [
-460,
1180
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "3e65993e-6d66-43c5-8d10-5b82243325f4",
"name": "将数组分离为单独帖子7",
"type": "n8n-nodes-base.splitOut",
"position": [
-240,
1180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d501a2c0-b965-4316-8984-9bbd7aa6fe80",
"name": "从多个帖子获取多条评论",
"type": "n8n-nodes-base.reddit",
"position": [
660,
420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4f66b9d6-d89f-4407-a991-6a6923d70ec9",
"name": "移除版主评论",
"type": "n8n-nodes-base.if",
"position": [
880,
420
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "b2014028-66a1-427d-96da-bb50f2ed9327",
"name": "获取现有潜在客户",
"type": "n8n-nodes-base.googleSheets",
"position": [
1460,
400
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "cdb62081-0cf5-4963-8f11-4eaf555bf8b5",
"name": "筛选唯一潜在客户",
"type": "n8n-nodes-base.code",
"position": [
1680,
400
],
"parameters": {},
"typeVersion": 2
},
{
"id": "370622ad-1a60-434f-b4e6-b480f8f346f1",
"name": "添加潜在客户到Google表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1900,
400
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5ca55e9b-4989-4512-809d-a543c325dc92",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3700,
-260
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "Get many comments FROM multiple POSTS",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Extract Post Metadata",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request1": {
"main": [
[
{
"node": "Extract Post Metadata1",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request2": {
"main": [
[
{
"node": "Extract Post Metadata2",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request3": {
"main": [
[
{
"node": "Extract Post Metadata3",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request4": {
"main": [
[
{
"node": "Extract Post Metadata4",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request5": {
"main": [
[
{
"node": "Extract Post Metadata5",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request6": {
"main": [
[
{
"node": "Extract Post Metadata6",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request7": {
"main": [
[
{
"node": "Extract Post Metadata7",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
},
{
"node": "HTTP Request1",
"type": "main",
"index": 0
},
{
"node": "HTTP Request2",
"type": "main",
"index": 0
},
{
"node": "HTTP Request3",
"type": "main",
"index": 0
},
{
"node": "HTTP Request4",
"type": "main",
"index": 0
},
{
"node": "HTTP Request5",
"type": "main",
"index": 0
},
{
"node": "HTTP Request6",
"type": "main",
"index": 0
},
{
"node": "HTTP Request7",
"type": "main",
"index": 0
}
]
]
},
"Get present leads": {
"main": [
[
{
"node": "Filter Unique Leads",
"type": "main",
"index": 0
}
]
]
},
"Filter Unique Leads": {
"main": [
[
{
"node": "Add Leads to Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Remove Mod Comments": {
"main": [
[
{
"node": "Hiring-related Comments",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata": {
"main": [
[
{
"node": "Seperate array into individual posts",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata1": {
"main": [
[
{
"node": "Seperate array into individual posts1",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata2": {
"main": [
[
{
"node": "Seperate array into individual posts2",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata3": {
"main": [
[
{
"node": "Seperate array into individual posts3",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata4": {
"main": [
[
{
"node": "Seperate array into individual posts4",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata5": {
"main": [
[
{
"node": "Seperate array into individual posts5",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata6": {
"main": [
[
{
"node": "Seperate array into individual posts6",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata7": {
"main": [
[
{
"node": "Seperate array into individual posts7",
"type": "main",
"index": 0
}
]
]
},
"Hiring-related Comments": {
"main": [
[
{
"node": "Get present leads",
"type": "main",
"index": 0
}
]
]
},
"Seperate array into individual posts": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Get many comments FROM multiple POSTS": {
"main": [
[
{
"node": "Remove Mod Comments",
"type": "main",
"index": 0
}
]
]
},
"Seperate array into individual posts1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Seperate array into individual posts2": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Seperate array into individual posts3": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 3
}
]
]
},
"Seperate array into individual posts4": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 4
}
]
]
},
"Seperate array into individual posts5": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 5
}
]
]
},
"Seperate array into individual posts6": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 6
}
]
]
},
"Seperate array into individual posts7": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 7
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Lead Generation等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Reddit自由职业工作监控与Google表格跟踪和Telegram警报
Reddit自由职业工作监控与Google表格跟踪和Telegram警报
Set
Code
Filter
+6
11 节点iamvaar
Lead Generation
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
Lead Generation
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
Other
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
Content Creation
内容聚合
使用Gemini AI从网站文章自动化社交媒体帖子发布到LinkedIn和X/Twitter
If
Set
Xml
+16
34 节点Vadim
Content Creation
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
If
Set
Code
+16
48 节点Daniel Lianes
Content Creation
