使用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)可能需要您自行付费。
相关工作流推荐
查找Reddit潜在客户并使用Llama3 AI和Google表格生成个性化回复
查找Reddit潜在客户并使用Llama3 AI和Google表格生成个性化回复
If
Set
Code
+7
14 节点Dhrumil Barot
人工智能
自动帖子生成
使用Ollama、图像创建和Gmail交付生成AI驱动的LinkedIn帖子
Linked In
Email Send
Form Trigger
+7
21 节点Aashit Sharma
设计
AI营销代理:Reddit + OpenRouter + Gmail 潜在客户生成
AI营销代理:通过Reddit、OpenRouter和Gmail进行潜在客户生成
If
Set
Code
+12
23 节点Ari Nakos
销售
AI YouTube分析助手:评论分析与洞察报告
AI YouTube分析助手:评论分析器与洞察报告生成器
If
Set
Code
+9
19 节点Yaron Been
人工智能
完成YouTube
基于细分领域的AI YouTube趋势发现器
If
Set
Code
+10
18 节点Leonardo Grigorio
人工智能
自动博客推广器 - 社交媒体帖子发布器
基于GPT的AI驱动博客文章推广器,用于Instagram、Facebook和X平台
If
Set
Code
+12
44 节点LukaszB
人工智能
工作流信息
难度等级
中级
节点数量13
分类2
节点类型7
作者
Aashit Sharma
@aashitsharmaWith 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 查看 →
分享此工作流