8
n8n 中文网amn8n.com

使用Gemini+LangChain+Sheets监控Reddit负面公关品牌声誉

中级

这是一个AI Summarization, Multimodal AI领域的自动化工作流,包含 10 个节点。主要使用 Set, Code, SplitOut, HttpRequest, GoogleSheets 等节点。 使用Gemini+LangChain+Sheets监控Reddit负面公关品牌声誉

前置要求
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 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)可能需要您自行付费。

工作流信息
难度等级
中级
节点数量10
分类2
节点类型10
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

外部链接
在 n8n.io 查看

分享此工作流