使用Gemini+LangChain+Sheets监控Reddit负面公关品牌声誉
中级
这是一个AI Summarization, Multimodal AI领域的自动化工作流,包含 10 个节点。主要使用 Set, Code, SplitOut, HttpRequest, GoogleSheets 等节点。 使用Gemini+LangChain+Sheets监控Reddit负面公关品牌声誉
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (10)
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"meta": {
"instanceId": "b6731f6e46273cffeac6b5188a5b3bcb0840c00108e73b48ae2b799ac6e8e081",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "5fd46f9a-1249-425f-87be-bdf4ade9942b",
"name": "计划触发器1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
128,
96
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "222a0498-76d4-400a-a2a8-03a56a7588cd",
"name": "Extract Post Metadata1",
"type": "n8n-nodes-base.set",
"position": [
576,
96
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "9738e2da-6af2-4c65-a129-dfbbadaafd01",
"name": "Seperate array into individual posts1",
"type": "n8n-nodes-base.splitOut",
"position": [
800,
96
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f37847d0-7934-4a9e-aed2-3e77f0614dac",
"name": "Append to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1728,
96
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "663a5764-bb73-43b3-8fb2-131879c0f2de",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
1488,
96
],
"parameters": {},
"typeVersion": 2
},
{
"id": "07a53cf0-3ad1-486a-bf99-7831ad1b313c",
"name": "Look for Latest posts",
"type": "n8n-nodes-base.httpRequest",
"position": [
352,
96
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "92b25221-e542-48f0-ad97-1a85b39d73d2",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1040,
96
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "625b1e0a-fb13-45af-bf80-c4dd4280f26c",
"name": "Google Vertex Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleVertex",
"position": [
1024,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "35e66e1d-4790-4d14-8984-5b7d461e2397",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1232,
400
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "ccd6e80d-d6c4-4032-8498-b5cf0d34413b",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-816,
-192
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Code": {
"main": [
[
{
"node": "Append to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Look for Latest posts",
"type": "main",
"index": 0
}
]
]
},
"Look for Latest posts": {
"main": [
[
{
"node": "Extract Post Metadata1",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Metadata1": {
"main": [
[
{
"node": "Seperate array into individual posts1",
"type": "main",
"index": 0
}
]
]
},
"Google Vertex Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Seperate array into individual posts1": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - AI 摘要总结, 多模态 AI
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
每日 WhatsApp 群组智能分析:GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析:GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
基于Supabase、Google表格和Gmail的自动化用户重新激活系统
使用Supabase、Google表格和Gmail的自动化用户重新激活系统
Set
Code
Gmail
+9
14 节点iamvaar
社交媒体
自动化会议准备
使用 GPT-5 和 Gemini 研究从日历到 Slack 通过 Attio CRM 自动准备会议
If
Set
Code
+16
39 节点Harry Siggins
AI 摘要总结
使用 Mistral AI、LinkedIn 和 Google Sheets 自动化职位搜索与简历定制
使用 Mistral AI、LinkedIn 和 Google Sheets 自动化职位搜索与简历定制
Set
Code
Html
+18
46 节点Jordan Hoyle
个人效率
WordPress博客自动化专业版(深度研究)v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
内容聚合
使用Gemini AI从网站文章自动化社交媒体帖子发布到LinkedIn和X/Twitter
If
Set
Xml
+16
34 节点Vadim
内容创作