通过AI代理从Telegram记录餐食营养到Google Sheets
高级
这是一个Other, AI领域的自动化工作流，包含 23 个节点。主要使用 If, Set, Code, Limit, SplitOut 等节点，结合人工智能技术实现智能自动化。 使用AI代理从Telegram记录餐食营养信息到Google Sheets
前置要求
- •Telegram Bot Token
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (23)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "cab4467e-449e-4823-abe5-eb0368883e9c",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
740,
180
],
"webhookId": "231e8ee3-320f-47c7-8368-03965732d709",
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "a32a646b-80f2-46a4-81c2-7e3b5a4a192c",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
940,
140
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {
"temperature": 0
}
},
"credentials": {
"openAiApi": {
"id": "1IOLtYX7aTspCAN8",
"name": "OpenAI Pollup"
}
},
"typeVersion": 1.2
},
{
"id": "3d934326-ad89-477f-9ab6-b97c04960597",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1160,
140
],
"parameters": {
"jsonSchemaExample": "\n[{\"name\": \"total Protein\",\n \"quantity\": 86,\n \"unit\": \"gr\"\n},\n {\"name\": \"total lipids\",\n \"quantity\": 86,\n \"unit\": \"gr\"\n},\n {\"name\": \"total carbohydrats\",\n \"quantity\": 86,\n \"unit\": \"gr\"\n},\n {\"name\": \"total potassium\",\n \"quantity\": 86,\n \"unit\": \"gr\"\n},\n {\"name\": \"total magnesium\",\n \"quantity\": 86,\n \"unit\": \"gr\"\n},\n {\"name\": \"total sodium\",\n \"quantity\": 86,\n \"unit\": \"gr\"\n},\n {\"name\": \"total kcal\",\n \"quantity\": 248,\n \"unit\": \"kcal\"\n},\n {\n \"reasoning\": \"this is my reasoning\"\n }\n]"
},
"typeVersion": 1.2
},
{
"id": "5a086fb6-6f12-40b6-aa82-64bb2d76b730",
"name": "获取音频文件",
"type": "n8n-nodes-base.telegram",
"position": [
300,
-280
],
"webhookId": "36dfe00d-6f05-419a-a80a-f6c7321e9a7d",
"parameters": {
"fileId": "={{ $json.message.voice.file_id }}",
"resource": "file"
},
"credentials": {
"telegramApi": {
"id": "ynY4cqTMvfHfi0bc",
"name": "Mes repas bot"
}
},
"typeVersion": 1.2
},
{
"id": "f72d4182-26e2-4026-8097-7e4cef50bfed",
"name": "转录录音",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
520,
-280
],
"parameters": {
"options": {},
"resource": "audio",
"operation": "transcribe",
"binaryPropertyName": "=data"
},
"credentials": {
"openAiApi": {
"id": "1IOLtYX7aTspCAN8",
"name": "OpenAI Pollup"
}
},
"typeVersion": 1.6
},
{
"id": "0f3b227f-b15a-410c-9333-a40c3e1b95ee",
"name": "限制",
"type": "n8n-nodes-base.limit",
"position": [
1996,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fddaae3c-d7e6-4cb4-bb23-f734dcbefb85",
"name": "接收 Telegram 消息",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-140,
-180
],
"webhookId": "34756bf0-27bd-4384-9e46-549473c307a0",
"parameters": {
"updates": [
"message",
"channel_post"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "ynY4cqTMvfHfi0bc",
"name": "Mes repas bot"
}
},
"typeVersion": 1.2
},
{
"id": "9c6c00ca-e6f6-4f0b-b120-2249978379aa",
"name": "如果是语音消息",
"type": "n8n-nodes-base.if",
"position": [
80,
-180
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fb7a6885-6149-4666-bd3a-5eebde28d601",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.message.voice }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "97e56ec8-3a71-4e0d-a626-07a5113b09b7",
"name": "从消息设置聊天输入",
"type": "n8n-nodes-base.set",
"position": [
740,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3af0daa0-795f-45e8-ae10-fca10950b855",
"name": "chatInput",
"type": "string",
"value": "={{ $json.message.text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e1609f06-f769-4dfe-98e4-a56e95217307",
"name": "从语音设置聊天输入",
"type": "n8n-nodes-base.set",
"position": [
740,
-280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3af0daa0-795f-45e8-ae10-fca10950b855",
"name": "chatInput",
"type": "string",
"value": "={{ $json.text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "42acb130-91f7-4d94-8b6b-c6b6b79f59f9",
"name": "成分和营养素列表",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
960,
-80
],
"parameters": {
"text": "=\n*\"Approximate the kcals, protein, carbohydrates, lipids (fats), and electrolyte (sodium, potassium, magnesium, Zinc and Iron) content in the following dietary intake statement: \n\n{{ $json.chatInput }}\n\nProvide estimates for each component based on typical nutritional values. Break down the contributions from each food item (steak, salad, vinaigrette) and give a total number for each nutrient. \n\nGive the total result as a json, with as name, the name of the nutrient, as quantity, the total summed value, and as unit the unit that been chosen (gr, mg).\nPut the reasoning in another variable called \"reasonning\"\n",
"options": {
"systemMessage": "You are a nutrition expert."
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.8
},
{
"id": "b27195f2-cb45-45d8-ab87-60e76828f7c4",
"name": "展开列表",
"type": "n8n-nodes-base.splitOut",
"position": [
1336,
-80
],
"parameters": {
"include": "={{ $json.output }}",
"options": {},
"fieldToSplitOut": "output"
},
"typeVersion": 1
},
{
"id": "cf95c6a1-8ed4-45ee-90d0-fe87300c2968",
"name": "添加日期",
"type": "n8n-nodes-base.code",
"position": [
1556,
-80
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "let entry = $input.item.json.output\nlet my_date = new Date()\n\nlet my_date_f = (my_date.getTime() / 86400000) + 25569;\nentry.my_date = my_date_f\nreturn {json: entry}"
},
"typeVersion": 2
},
{
"id": "a0fd85ad-5cce-4419-af80-a6ff50a93631",
"name": "存储到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1776,
-80
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "quantity",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "quantity",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "unit",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "unit",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "my_date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "my_date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HdL1iwHvIhN44yW_HzRbjC--ZxItCfyX-wObjWzZHAc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1HdL1iwHvIhN44yW_HzRbjC--ZxItCfyX-wObjWzZHAc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1HdL1iwHvIhN44yW_HzRbjC--ZxItCfyX-wObjWzZHAc/edit?usp=drivesdk",
"cachedResultName": "Mes repas"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "06ee2513-0622-450b-b195-84cdef13cd27",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
-380
],
"parameters": {
"color": 4,
"height": 340,
"content": "## 发送 Telegram 消息"
},
"typeVersion": 1
},
{
"id": "fc4a2f5b-5565-4644-bd9f-74da73818698",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
-380
],
"parameters": {
"color": 5,
"width": 460,
"content": "## 设置"
},
"typeVersion": 1
},
{
"id": "9e4e2ead-0c19-4799-8004-adaf30a5e0b1",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1700,
-220
],
"parameters": {
"color": 4,
"height": 320,
"content": "## 检查您的数据"
},
"typeVersion": 1
},
{
"id": "e57b8eef-d72d-46b2-ae1b-5d61a2c22d01",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
260,
-380
],
"parameters": {
"color": 4,
"width": 640,
"height": 260,
"content": "## 如果是音频文件"
},
"typeVersion": 1
},
{
"id": "9bd1447e-bcde-4b4c-92c9-76120c9a42d2",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
560,
80
],
"parameters": {
"color": 4,
"width": 340,
"height": 260,
"content": "## 测试"
},
"typeVersion": 1
},
{
"id": "ac3a7c88-782a-4943-a332-2509287df840",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
-220
],
"parameters": {
"color": 4,
"width": 340,
"height": 320,
"content": "## 个性化提示词！！"
},
"typeVersion": 1
},
{
"id": "58642d48-d97e-4a3d-84ea-a4de580e4c25",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2140,
-220
],
"parameters": {
"color": 4,
"height": 320,
"content": "## 个性化响应消息"
},
"typeVersion": 1
},
{
"id": "c6b8206c-bcb0-4034-8f99-9a4165770709",
"name": "响应消息",
"type": "n8n-nodes-base.telegram",
"position": [
2216,
-80
],
"webhookId": "8e646f8a-1f21-4719-b5f2-0cc5fad144df",
"parameters": {
"text": "Your meal has been saved",
"chatId": "={{ $('If it's a voice message').item.json.message.chat.id }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "ynY4cqTMvfHfi0bc",
"name": "Mes repas bot"
}
},
"typeVersion": 1.2
},
{
"id": "414d1da4-94e0-454d-acf9-a8344d1168b4",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
-200
],
"parameters": {
"width": 460,
"height": 260,
"content": "## 联系我"
},
"typeVersion": 1
}
],
"connections": {
"Limit": {
"main": [
[
{
"node": "Respond message",
"type": "main",
"index": 0
}
]
]
},
"Add date": {
"main": [
[
{
"node": "Store in sheet",
"type": "main",
"index": 0
}
]
]
},
"Get Audio File": {
"main": [
[
{
"node": "Transcribe Recording",
"type": "main",
"index": 0
}
]
]
},
"Store in sheet": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Explode the list": {
"main": [
[
{
"node": "Add date",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "List of Ingredients and nutrients",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Transcribe Recording": {
"main": [
[
{
"node": "Set chatInput from voice",
"type": "main",
"index": 0
}
]
]
},
"If it's a voice message": {
"main": [
[
{
"node": "Get Audio File",
"type": "main",
"index": 0
}
],
[
{
"node": "Set chatInput from message",
"type": "main",
"index": 0
}
]
]
},
"Receive Telegram message": {
"main": [
[
{
"node": "If it's a voice message",
"type": "main",
"index": 0
}
]
]
},
"Set chatInput from voice": {
"main": [
[
{
"node": "List of Ingredients and nutrients",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "List of Ingredients and nutrients",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Set chatInput from message": {
"main": [
[
{
"node": "List of Ingredients and nutrients",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "List of Ingredients and nutrients",
"type": "main",
"index": 0
}
]
]
},
"List of Ingredients and nutrients": {
"main": [
[
{
"node": "Explode the list",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 其他, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
个人 - 申请 TRM
通过 Telegram 机器人和 AI 日期识别获取哥伦比亚比索兑美元汇率
If
Set
Code
+16
31 节点Juan Sanchez
财务
LinkedIn人才管道：AI驱动的候选人搜索与排名（GPT-4o）
LinkedIn人才管道：AI驱动的候选人搜索与排名（GPT-4o）
If
Set
Code
+14
24 节点Badr
人力资源
构建与销售AI自动化与智能体
构建与销售AI自动化与智能体
If
Set
Wait
+15
74 节点NICKYAI
其他
AI 代理餐厅 [模板]
🤖 WhatsApp、Instagram 和 Messenger 的 AI 餐厅助手
If
N8n
Set
+37
239 节点Amanda Benks
其他
HDW潜在客户越野车
使用AI代理的自动化LinkedIn潜在客户生成、评分与沟通
If
Code
Sort
+17
86 节点Andrey
销售
工作流信息
难度等级
高级
节点数量23
分类2
节点类型14
作者
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
外部链接
在 n8n.io 查看 →
分享此工作流