查找Reddit潜在客户并使用Llama3 AI和Google表格生成个性化回复
中级
这是一个AI, Marketing领域的自动化工作流，包含 14 个节点。主要使用 If, Set, Code, Reddit, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 查找Reddit潜在客户并使用Llama3 AI和Google表格生成个性化回复
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "3fb03f7852f4e2f7aeee7e1edbc7b11d424da3c67ffc7980f5d45ea0e00b1fa9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "6e6dbef8-5068-4e08-b5c9-356bfa92bacd",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1160,
2750
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7c5387d7-c96f-4d1d-b35f-edb3687a8a69",
"name": "获取现有帖子1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-720,
2650
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "bcfab50a-cb46-4546-8351-9f15f8fddcce",
"name": "记录无关帖子",
"type": "n8n-nodes-base.googleSheets",
"position": [
756,
2500
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "da43e4b5-90cc-4e19-a793-1ff0edd0b379",
"name": "记录相关帖子",
"type": "n8n-nodes-base.googleSheets",
"position": [
756,
2850
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "af58b686-b86d-4484-99b8-b575d479fe3e",
"name": "发布Reddit评论",
"type": "n8n-nodes-base.reddit",
"position": [
976,
2950
],
"parameters": {},
"typeVersion": 1
},
{
"id": "136b95ed-15f1-46dc-8e37-c1864cb4c206",
"name": "帖子是否相关？",
"type": "n8n-nodes-base.if",
"position": [
536,
2500
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "3015d949-5bea-48df-b3d2-4d39ec8f220c",
"name": "解析AI响应",
"type": "n8n-nodes-base.code",
"position": [
316,
2500
],
"parameters": {},
"typeVersion": 2
},
{
"id": "5a7e3ca1-6beb-438f-ae7b-c41b0c456758",
"name": "Ollama聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOllama",
"position": [
-40,
2740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1e9b7447-d5b5-405c-854d-b5e0c3b877dd",
"name": "AI相关性分析",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-60,
2400
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "c35aa9a2-d727-4e4a-a7f6-18129b8c758f",
"name": "逐个处理帖子",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-280,
2750
],
"parameters": {},
"typeVersion": 3
},
{
"id": "75122d4c-687b-468b-98d6-66cc80dca814",
"name": "筛选新帖子",
"type": "n8n-nodes-base.code",
"position": [
-500,
2750
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a46dd2d7-8843-4999-bf7c-2e8c209fae48",
"name": "处理帖子字段",
"type": "n8n-nodes-base.set",
"position": [
-720,
2850
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3.4
},
{
"id": "6c37690a-b6fd-409c-b94b-cb056197cc08",
"name": "获取Reddit帖子",
"type": "n8n-nodes-base.reddit",
"position": [
-940,
2750
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f7279c5b-f67b-494f-bf7b-720c664993d8",
"name": "便利贴",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
2140
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Filter New Posts": {
"main": [
[
{
"node": "Process One Post at a Time",
"type": "main",
"index": 0
}
]
]
},
"Get Reddit Posts": {
"main": [
[
{
"node": "Process Post Fields",
"type": "main",
"index": 0
},
{
"node": "Get Existing Posts1",
"type": "main",
"index": 0
}
]
]
},
"Is Post Relevant?": {
"main": [
[
{
"node": "Log Relevant Post",
"type": "main",
"index": 0
}
],
[
{
"node": "Log Irrelevant Post",
"type": "main",
"index": 0
}
]
]
},
"Log Relevant Post": {
"main": [
[
{
"node": "Post Reddit Comment",
"type": "main",
"index": 0
}
]
]
},
"Ollama Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Relevance Analysis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Parse AI Response": {
"main": [
[
{
"node": "Is Post Relevant?",
"type": "main",
"index": 0
}
]
]
},
"Get Existing Posts1": {
"main": [
[
{
"node": "Filter New Posts",
"type": "main",
"index": 0
}
]
]
},
"Log Irrelevant Post": {
"main": [
[
{
"node": "Process One Post at a Time",
"type": "main",
"index": 0
}
]
]
},
"Post Reddit Comment": {
"main": [
[
{
"node": "Process One Post at a Time",
"type": "main",
"index": 0
}
]
]
},
"Process Post Fields": {
"main": [
[
{
"node": "Filter New Posts",
"type": "main",
"index": 0
}
]
]
},
"AI Relevance Analysis": {
"main": [
[
{
"node": "Parse AI Response",
"type": "main",
"index": 0
}
]
]
},
"Process One Post at a Time": {
"main": [
[
{
"node": "Get Reddit Posts",
"type": "main",
"index": 0
}
],
[
{
"node": "AI Relevance Analysis",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Get Reddit Posts",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
使用AI生成评论和邮件摘要在Reddit上推广YouTube视频
使用AI生成评论和邮件摘要在Reddit上推广YouTube视频
If
Set
Code
+13
29 节点Ari Nakos
人工智能
AI营销代理：Reddit + OpenRouter + Gmail 潜在客户生成
AI营销代理：通过Reddit、OpenRouter和Gmail进行潜在客户生成
If
Set
Code
+12
23 节点Ari Nakos
销售
抓取Meta广告库并使用Gemini分析视频广告，将数据存储到Google Sheets
使用Gemini分析Meta广告库视频广告，并将结果存储到Google Sheets
Set
Code
Sort
+11
24 节点Daniel Setzermann
人工智能
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
If
Set
Code
+21
40 节点Immanuel
人工智能
我的工作流5
使用AI邮件个性化的自动化LinkedIn潜在客户生成（未完成）
If
Set
Code
+9
37 节点Matthieu
销售
