使用GPT-4o-mini、表格和Slack自动化Reddit品牌监控和回复
高级
这是一个Social Media, Multimodal AI领域的自动化工作流，包含 20 个节点。主要使用 If, Code, Slack, Reddit, GoogleSheets 等节点。 通过GPT-4o-mini、表格和Slack实现Reddit品牌监控和回复的自动化
前置要求
- •Slack Bot Token 或 Webhook URL
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "db30e8ae4100235addbd4638770997b7ef11878d049073c888ba440ca84c55fc"
},
"nodes": [
{
"id": "947d8563-99c3-40bb-9fef-13f482cb8567",
"name": "每日营销检查",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "Runs every 24 hours to scan Reddit for brand mentions and engagement opportunities",
"position": [
-1456,
32
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 24
}
]
}
},
"typeVersion": 1.2
},
{
"id": "70d74090-8308-4ff8-995a-afa2b3e53448",
"name": "搜索品牌提及",
"type": "n8n-nodes-base.reddit",
"notes": "Searches Reddit for posts mentioning your brand, products, or relevant keywords",
"position": [
-1008,
32
],
"parameters": {
"limit": 50,
"keyword": "={{ $json.brandKeyword }}",
"location": "allReddit",
"operation": "search",
"additionalFields": {
"sort": "new"
}
},
"typeVersion": 1
},
{
"id": "958f4ae4-caf9-46ee-9ab5-e7a5f7cf9da9",
"name": "品牌关键词配置",
"type": "n8n-nodes-base.code",
"notes": "Configure your brand name and relevant keywords to monitor",
"position": [
-1232,
32
],
"parameters": {
"jsCode": "// Configure your brand monitoring keywords\nconst brandKeywords = [\n \"YourBrandName\",\n \"your-product-name\",\n \"industry-keyword\"\n];\n\n// Return array of keywords to search\nreturn brandKeywords.map(keyword => ({\n json: {\n brandKeyword: keyword\n }\n}));"
},
"typeVersion": 2
},
{
"id": "f9fda183-58fe-4b81-a7b3-7ddecaba3ba7",
"name": "AI帖子分析",
"type": "@n8n/n8n-nodes-langchain.openAi",
"notes": "Uses AI to analyze sentiment, relevance, and generate contextual responses",
"position": [
-800,
32
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": ""
},
"options": {
"temperature": 0.7
},
"messages": {
"values": [
{}
]
}
},
"typeVersion": 1.4
},
{
"id": "95982fd8-f412-475e-b4a5-6aaa69ec3b58",
"name": "筛选值得互动的帖子",
"type": "n8n-nodes-base.if",
"notes": "Only engages with posts that are relevant, high-quality, and appropriate",
"position": [
-576,
32
],
"parameters": {
"options": {},
"conditions": {
"options": {
"combineOperation": "all"
},
"conditions": [
{
"id": "condition-relevant",
"operator": {
"type": "boolean",
"operation": "true"
},
"leftValue": "={{ $json.isRelevant }}",
"rightValue": true
},
{
"id": "condition-score",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.engagementScore }}",
"rightValue": 60
},
{
"id": "condition-type",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json.responseType }}",
"rightValue": "pass"
}
]
}
},
"typeVersion": 2
},
{
"id": "71b6a70e-fe6a-4f6e-a5c9-c90181696e56",
"name": "循环处理帖子",
"type": "n8n-nodes-base.splitInBatches",
"notes": "Process each post one at a time to avoid rate limits",
"position": [
-352,
-48
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "1e154007-38ff-4201-8576-972c99bb9197",
"name": "发布有帮助的评论",
"type": "n8n-nodes-base.reddit",
"notes": "Posts AI-generated helpful comment to engage with the community",
"position": [
-128,
-48
],
"parameters": {
"postId": "={{ $('Search Brand Mentions').item.json.data.id }}",
"resource": "postComment",
"commentText": "={{ $('AI Post Analysis').item.json.suggestedResponse }}"
},
"typeVersion": 1
},
{
"id": "dcfe45e5-64ec-4d91-abd2-3472b45fb4dc",
"name": "记录到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"notes": "Tracks all Reddit interactions in a Google Sheet for analysis",
"position": [
96,
-48
],
"parameters": {
"columns": {
"value": {
"postId": "={{ $('Search Brand Mentions').item.json.data.id }}",
"postUrl": "=https://reddit.com{{ $('Search Brand Mentions').item.json.data.permalink }}",
"postTitle": "={{ $('Search Brand Mentions').item.json.data.title }}",
"reasoning": "={{ $('AI Post Analysis').item.json.reasoning }}",
"sentiment": "={{ $('AI Post Analysis').item.json.sentiment }}",
"subreddit": "={{ $('Search Brand Mentions').item.json.data.subreddit }}",
"timestamp": "={{ $now.toISO() }}",
"responseType": "={{ $('AI Post Analysis').item.json.responseType }}",
"commentPosted": "={{ $json.success ? 'Yes' : 'Failed' }}",
"engagementScore": "={{ $('AI Post Analysis').item.json.engagementScore }}"
},
"schema": [
{
"id": "timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postId",
"type": "string",
"display": true,
"required": false,
"displayName": "postId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postTitle",
"type": "string",
"display": true,
"required": false,
"displayName": "postTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subreddit",
"type": "string",
"display": true,
"required": false,
"displayName": "subreddit",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postUrl",
"type": "string",
"display": true,
"required": false,
"displayName": "postUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sentiment",
"type": "string",
"display": true,
"required": false,
"displayName": "sentiment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "engagementScore",
"type": "number",
"display": true,
"required": false,
"displayName": "engagementScore",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "responseType",
"type": "string",
"display": true,
"required": false,
"displayName": "responseType",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "commentPosted",
"type": "string",
"display": true,
"required": false,
"displayName": "commentPosted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reasoning",
"type": "string",
"display": true,
"required": false,
"displayName": "reasoning",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": []
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_SHEET_ID"
}
},
"typeVersion": 4.5
},
{
"id": "0c7a75ed-891c-45dd-95fc-c86c0e07862e",
"name": "生成每日摘要",
"type": "n8n-nodes-base.code",
"notes": "Aggregates all data into a comprehensive daily report",
"position": [
320,
32
],
"parameters": {
"jsCode": "// Aggregate all processed items\nconst items = $input.all();\n\nconst totalPosts = items.length;\nconst postsEngaged = items.filter(i => i.json.commentPosted === 'Yes').length;\nconst sentimentBreakdown = items.reduce((acc, item) => {\n const sentiment = item.json.sentiment || 'unknown';\n acc[sentiment] = (acc[sentiment] || 0) + 1;\n return acc;\n}, {});\n\nconst avgScore = items.reduce((sum, item) => sum + (item.json.engagementScore || 0), 0) / totalPosts;\n\nconst topPosts = items\n .sort((a, b) => (b.json.engagementScore || 0) - (a.json.engagementScore || 0))\n .slice(0, 5)\n .map(item => ({\n title: item.json.postTitle,\n subreddit: item.json.subreddit,\n score: item.json.engagementScore,\n url: item.json.postUrl\n }));\n\nreturn [{\n json: {\n summary: {\n totalPosts,\n postsEngaged,\n engagementRate: `${((postsEngaged / totalPosts) * 100).toFixed(1)}%`,\n avgEngagementScore: avgScore.toFixed(1),\n sentimentBreakdown,\n topPosts,\n reportDate: new Date().toISOString().split('T')[0]\n }\n }\n}];"
},
"typeVersion": 2
},
{
"id": "59090839-871e-4fd1-bd07-251104e4115f",
"name": "发送 Slack 报告",
"type": "n8n-nodes-base.slack",
"notes": "Sends comprehensive daily report to Slack with metrics and top opportunities",
"position": [
528,
32
],
"webhookId": "671ce43f-0973-4fc1-96ce-d0df355db33b",
"parameters": {
"text": "=📊 *Reddit Brand Marketing Daily Report*\n\n*Date:* {{ $json.summary.reportDate }}\n\n*Overall Performance:*\n• Posts Analyzed: {{ $json.summary.totalPosts }}\n• Comments Posted: {{ $json.summary.postsEngaged }}\n• Engagement Rate: {{ $json.summary.engagementRate }}\n• Avg Engagement Score: {{ $json.summary.avgEngagementScore }}/100\n\n*Sentiment Breakdown:*\n{{ Object.entries($json.summary.sentimentBreakdown).map(([k,v]) => `• ${k}: ${v} posts`).join('\\n') }}\n\n*Top 5 Engagement Opportunities:*\n{{ $json.summary.topPosts.map((post, i) => `${i+1}. ${post.title}\\n 📍 r/${post.subreddit} | Score: ${post.score}\\n 🔗 ${post.url}`).join('\\n\\n') }}\n\n✅ All interactions logged to Google Sheets",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "id",
"value": "YOUR_CHANNEL_ID"
},
"otherOptions": {}
},
"typeVersion": 2.2
},
{
"id": "6b53e5f2-79c8-41f9-b779-5efbe6aeaf37",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1904,
-112
],
"parameters": {
"color": 4,
"width": 347,
"height": 469,
"content": "## Reddit品牌营销工作流"
},
"typeVersion": 1
},
{
"id": "4b1cf549-13f1-4acb-bc92-226fc8275380",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1488,
-112
],
"parameters": {
"width": 176,
"height": 112,
"content": "计划触发器每24小时自动运行工作流"
},
"typeVersion": 1
},
{
"id": "61e35218-b58c-42b7-a369-71b42c4d64ef",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1264,
-112
],
"parameters": {
"width": 176,
"height": 112,
"content": "JavaScript代码节点定义要监控Reddit的品牌关键词"
},
"typeVersion": 1
},
{
"id": "b9a32a51-137c-48e1-83aa-82d64001e52f",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
-112
],
"parameters": {
"width": 176,
"height": 112,
"content": "Reddit节点在所有子版块搜索品牌关键词提及"
},
"typeVersion": 1
},
{
"id": "9ca8ec09-cd5d-440b-ba21-3f4c69b62a73",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
-112
],
"parameters": {
"width": 320,
"height": 112,
"content": "OpenAI分析情感、相关性，生成上下文有帮助的评论回复 + 条件节点仅筛选值得互动的高质量相关帖子"
},
"typeVersion": 1
},
{
"id": "b1e5a451-6954-479c-a225-d9c3bfddc55e",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-384,
-192
],
"parameters": {
"width": 176,
"height": 112,
"content": "分批处理每个帖子，遵守限制"
},
"typeVersion": 1
},
{
"id": "dafc1ea5-66a4-4bc0-a6e5-9c954295071b",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-192
],
"parameters": {
"width": 176,
"height": 112,
"content": "Reddit节点将AI生成的评论发布到值得互动的Reddit讨论"
},
"typeVersion": 1
},
{
"id": "2e85a5e7-61df-4969-8012-ddb4a1336178",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
64,
-192
],
"parameters": {
"width": 176,
"height": 112,
"content": "将所有互动数据附加到电子表格进行永久追踪"
},
"typeVersion": 1
},
{
"id": "4529d6c8-87ca-4d11-a609-6463cfe6d236",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
288,
-112
],
"parameters": {
"width": 176,
"height": 112,
"content": "JavaScript汇总指标、情感细分，生成全面的每日报告"
},
"typeVersion": 1
},
{
"id": "ee43aa3b-6acd-40bf-982c-0a667797b886",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
496,
-112
],
"parameters": {
"width": 176,
"height": 112,
"content": "将格式化的每日摘要与指标发布到团队Slack频道"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"AI Post Analysis": {
"main": [
[
{
"node": "Filter Engagement-Worthy",
"type": "main",
"index": 0
}
]
]
},
"Loop Through Posts": {
"main": [
[
{
"node": "Post Helpful Comment",
"type": "main",
"index": 0
}
],
[
{
"node": "Generate Daily Summary",
"type": "main",
"index": 0
}
]
]
},
"Log to Google Sheets": {
"main": [
[
{
"node": "Loop Through Posts",
"type": "main",
"index": 0
}
]
]
},
"Post Helpful Comment": {
"main": [
[
{
"node": "Log to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Brand Keywords Config": {
"main": [
[
{
"node": "Search Brand Mentions",
"type": "main",
"index": 0
}
]
]
},
"Daily Marketing Check": {
"main": [
[
{
"node": "Brand Keywords Config",
"type": "main",
"index": 0
}
]
]
},
"Search Brand Mentions": {
"main": [
[
{
"node": "AI Post Analysis",
"type": "main",
"index": 0
}
]
]
},
"Generate Daily Summary": {
"main": [
[
{
"node": "Send Slack Report",
"type": "main",
"index": 0
}
]
]
},
"Filter Engagement-Worthy": {
"main": [
[
{
"node": "Loop Through Posts",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 社交媒体, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
自动化推荐工作流
使用GPT-4处理推荐信，并通过Google表格自动生成社交媒体卡片
If
Set
Code
+9
34 节点Jitesh Dugar
社交媒体
竞争价格监控与警报（Bright Data、Sheets 和 Slack）
使用 Bright Data、Sheets 和 Slack 进行竞争价格监控与警报
If
Set
Code
+9
29 节点Daniel Shashko
市场调研
Arunava的多智能体智能Reddit自动化
使用AI品牌提及和Baserow跟踪自动评论Reddit帖子
If
Set
Code
+12
35 节点Arunava
社交媒体
通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+7
22 节点Oneclick AI Squad
社交媒体
使用Rapiwa API的批量WhatsApp营销自动化（非官方集成）
使用Rapiwa API从Google Sheets批量发送WhatsApp消息
If
Code
Wait
+6
20 节点SpaGreen Creative
社交媒体
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
工作流信息
难度等级
高级
节点数量20
分类2
节点类型9
作者
Daniel Shashko
@tomaxAI automation specialist and a marketing enthusiast. More than 6 years of experience in SEO/GEO. Senior SEO at Bright Data.
外部链接
在 n8n.io 查看 →
分享此工作流