8
n8n 中文网amn8n.com

使用Ollama LLMs和Google Sheets生成并优化品牌故事

中级

这是一个AI, Marketing领域的自动化工作流,包含 13 个节点。主要使用 If, Set, GoogleSheets, Agent, ChatTrigger 等节点,结合人工智能技术实现智能自动化。 使用Ollama LLMs和Google Sheets生成并优化品牌故事

前置要求
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "473ff4054f1a6c3ed6f17a2b4a2e55676fe5b921cceb87b2256e6c416c158559",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "f0fa65c1-68a1-4ad8-94f5-12dcce2ce708",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "346fff16-a415-4e28-af89-bfb2dca3a633",
      "name": "评估器智能体",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        700,
        340
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "065c3094-415c-4aa8-a964-85bc73efe394",
      "name": "优化器智能体",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1380,
        420
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "9e38b175-e7d7-454f-8d14-0deef8a9f902",
      "name": "Ollama 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOllama",
      "position": [
        340,
        640
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "123150d5-cd70-4c4e-9803-549d92ae8011",
      "name": "Ollama 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOllama",
      "position": [
        1400,
        660
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7a2e6ce1-fb42-4c44-9ead-356eff3e4fa2",
      "name": "聊天输入:开始故事流程",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -100,
        340
      ],
      "webhookId": "fab30ad7-8a5a-4477-be98-1aa43b92b052",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "9a2f1aa8-b5c9-4887-81c1-2450707b6e4b",
      "name": "品牌叙事智能体",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        120,
        340
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "56a6384a-8ccd-41bd-82d6-ab5882b055d6",
      "name": "设置品牌变量",
      "type": "n8n-nodes-base.set",
      "position": [
        480,
        340
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "47ae1610-3bcc-4507-815a-eea07a36c0d1",
      "name": "将品牌故事保存到表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1360,
        220
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "80beca32-318c-4e55-9678-5302ee2b7d17",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -140,
        620
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "30105c81-95cc-4362-9153-7e6748a08d8e",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        600,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3d16e5be-ca4b-4c0b-a567-e60afeeb7bcb",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        840,
        660
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bd008cb7-78f5-49c4-a76a-76e170946173",
      "name": "评估检查",
      "type": "n8n-nodes-base.if",
      "position": [
        1060,
        340
      ],
      "parameters": {},
      "typeVersion": 2.2
    }
  ],
  "pinData": {},
  "connections": {
    "Evaluator Agent": {
      "main": [
        [
          {
            "node": "Evaluation Check",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Optimizer Agent": {
      "main": [
        [
          {
            "node": "Set Brand variable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Evaluation Check": {
      "main": [
        [
          {
            "node": "Save Brand Story to Sheets",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Optimizer Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Ollama Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Brand Storytelling Agent",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Evaluator Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Ollama Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Optimizer Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Set Brand variable": {
      "main": [
        [
          {
            "node": "Evaluator Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Brand Storytelling Agent": {
      "main": [
        [
          {
            "node": "Set Brand variable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Chat Input: Start Story Flow": {
      "main": [
        [
          {
            "node": "Brand Storytelling Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

中级 - 人工智能, 营销

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

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

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

作者
Aashit Sharma

Aashit Sharma

@aashitsharma

With a strong background in AI agent systems, RAG pipelines, and open-source automation tools like n8n, LangChain, and Ollama, Aashit specializes in crafting end-to-end solutions that merge intelligence with efficiency. He has developed multiple production-ready n8n templates — from personalized interview prep systems and document generators to AI-powered support agents — all designed to empower teams with scalable, low-code automation.

外部链接
在 n8n.io 查看

分享此工作流