📊 WhatsApp和Telegram的AI令牌追踪器 - 将AI使用情况保存到Google表格
高级
这是一个Finance, AI, IT Ops领域的自动化工作流，包含 37 个节点。主要使用 If, Set, Code, Filter, Switch 等节点，结合人工智能技术实现智能自动化。 📊 WhatsApp和Telegram的AI令牌追踪器 - 将AI使用情况保存到Google表格
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Telegram Bot Token
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •Airtable API Key
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (37)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "aeYhwC8OyRGijiTb",
"meta": {
"instanceId": "b79da95dcb1b69eebc3470f6fd833d7e53e389c229c716386bdb8e7c291ad2b9"
},
"name": "📊 WhatsApp 和 Telegram 的 AI Token 追踪器 – 将 AI 使用情况保存到 Google Sheets",
"tags": [
{
"id": "mhx5MJAkz32rJgeQ",
"name": "iloveflows.com",
"createdAt": "2025-05-09T14:28:31.509Z",
"updatedAt": "2025-05-09T14:28:31.509Z"
}
],
"nodes": [
{
"id": "bbfc6da2-6c99-4907-b46f-a32df9308aef",
"name": "发送邮件",
"type": "n8n-nodes-base.gmailTool",
"disabled": true,
"position": [
660,
280
],
"webhookId": "18eaba1a-1821-4b08-b623-7496a908f4d3",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "3e402e46-f5f9-432f-bee1-9b7c5f98c2b4",
"name": "获取联系人",
"type": "n8n-nodes-base.airtableTool",
"disabled": true,
"position": [
760,
280
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "36d8be2b-76a9-4ee1-b42e-185d867552e8",
"name": "日志",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
0
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "54800e58-3348-4ea7-b1f2-f3b330441add",
"name": "创建活动",
"type": "n8n-nodes-base.googleCalendarTool",
"disabled": true,
"position": [
860,
280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "ce41257e-356f-4b7a-b92e-90a766a29ce5",
"name": "清理",
"type": "n8n-nodes-base.code",
"position": [
1020,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a91da594-54cc-4bba-83ae-db4a3d5a6aa6",
"name": "错误",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
280
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "431a8770-0a6b-4d63-ad40-2be04216ebdc",
"name": "错误响应",
"type": "n8n-nodes-base.telegram",
"position": [
1720,
280
],
"webhookId": "4129bcc4-aa42-4404-8cf4-9731422f7e86",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b649cc8a-4814-4730-a18a-ed3a40c79701",
"name": "响应",
"type": "n8n-nodes-base.telegram",
"position": [
1720,
0
],
"webhookId": "e71223d1-8880-4a0f-98b1-d7b002378954",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e86b5d5d-05a2-46f9-82a7-1fca39ec88ce",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4277b9b8-2be1-4e7a-a89e-e446287007df",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "540d74a0-e4e8-426d-b39f-5553ffd8d203",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f8fdc426-f97e-4d51-affe-7443b368d3a5",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1bb5794e-82ff-4d59-a640-db42fd043604",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "13b54670-f5c8-4ffd-b746-0f3a8e5301d2",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
"name": "清理",
"type": "n8n-nodes-base.code",
"position": [
1020,
280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e48dbb12-ddd1-4891-84b2-5afbfe5eab28",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
580,
-20
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "07cf1d5a-7f4f-4827-bf33-fa4deca0fb8b",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "eafbda63-9d18-4c5b-8528-ec6f99b6d513",
"name": "Evolution API",
"type": "n8n-nodes-base.webhook",
"position": [
-620,
80
],
"webhookId": "08b83c00-ab4b-4753-8415-93168690ce57",
"parameters": {},
"typeVersion": 2
},
{
"id": "631e3652-49d3-4a53-8f8f-44baab5fc4fb",
"name": "获取媒体",
"type": "n8n-nodes-base.httpRequest",
"position": [
-20,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "85ae2fa7-17af-408f-9c98-03ca6e8c8e57",
"name": "便签19",
"type": "n8n-nodes-base.stickyNote",
"position": [
-300,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4a23d554-a01f-4eed-9325-01a9d8464279",
"name": "便签20",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3195e145-a460-40b0-92e4-aba90f60ee42",
"name": "音频或文本分离",
"type": "n8n-nodes-base.if",
"position": [
-240,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "73ec0645-70f4-40d2-abe2-14a64dc1bcff",
"name": "转换为文件",
"type": "n8n-nodes-base.convertToFile",
"position": [
120,
-20
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "8f4c5346-4a0f-4f48-b2a7-00863d7305db",
"name": "音频转录",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
260,
-20
],
"parameters": {},
"typeVersion": 1.6
},
{
"id": "b338cf7b-1a87-4a66-8b20-e20357dc81fd",
"name": "Telegram",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-620,
260
],
"webhookId": "dcfa2f69-f5d4-4f3d-926f-d14f6e3e59f3",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "30d66342-6afb-4bc6-801e-b04359204feb",
"name": "便签21",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "72bd6f8f-ebad-4f38-8028-520fb76d6f6c",
"name": "过滤器",
"type": "n8n-nodes-base.filter",
"position": [
260,
280
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"name": "文本映射",
"type": "n8n-nodes-base.set",
"position": [
-20,
280
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "96e1ec07-f9d5-4d7f-93ba-fb20b94fec6e",
"name": "聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
500,
300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed",
"name": "输入源",
"type": "n8n-nodes-base.switch",
"position": [
1340,
-20
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "96279412-1dad-4af2-a327-280f9cd8e866",
"name": "映射",
"type": "n8n-nodes-base.set",
"position": [
-480,
80
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "614e597e-e7a5-4296-be51-d3b9649d00f8",
"name": "映射1",
"type": "n8n-nodes-base.set",
"position": [
-480,
260
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "be1d7967-70bd-403b-8d1f-7b3949ae7deb",
"name": "WhatsApp",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
-80
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "c6cb3ba8-0655-405d-b440-563f2c7f2de6",
"name": "WhatsApp 错误",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
200
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "a375dd86-192c-4bc8-b62f-d92a17c6d0c2",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bd7b5899-0060-4cf9-a776-486c94186124",
"name": "输入源1",
"type": "n8n-nodes-base.switch",
"position": [
1340,
260
],
"parameters": {},
"typeVersion": 3.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "d3370083-c273-4631-83e3-9df174874430",
"connections": {
"Log": {
"main": [
[
{
"node": "Input Source",
"type": "main",
"index": 0
}
]
]
},
"Map": {
"main": [
[
{
"node": "Audio or Text Separation",
"type": "main",
"index": 0
}
]
]
},
"Map1": {
"main": [
[
{
"node": "Text Mapping",
"type": "main",
"index": 0
}
]
]
},
"Errors": {
"main": [
[
{
"node": "Input Source1",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Clean Up",
"type": "main",
"index": 0
}
],
[
{
"node": "Clean_Up",
"type": "main",
"index": 0
}
]
]
},
"Clean Up": {
"main": [
[
{
"node": "Log",
"type": "main",
"index": 0
}
]
]
},
"Clean_Up": {
"main": [
[
{
"node": "Errors",
"type": "main",
"index": 0
}
]
]
},
"Telegram": {
"main": [
[
{
"node": "Map1",
"type": "main",
"index": 0
}
]
]
},
"GET Media": {
"main": [
[
{
"node": "Convert to File",
"type": "main",
"index": 0
}
]
]
},
"Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Send Email": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Create Event": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Get Contacts": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Input Source": {
"main": [
[
{
"node": "WhatsApp",
"type": "main",
"index": 0
}
],
[
{
"node": "Response",
"type": "main",
"index": 0
}
]
]
},
"Text Mapping": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Evolution API": {
"main": [
[
{
"node": "Map",
"type": "main",
"index": 0
}
]
]
},
"Input Source1": {
"main": [
[
{
"node": "WhatsApp Erro",
"type": "main",
"index": 0
}
],
[
{
"node": "Error Response",
"type": "main",
"index": 0
}
]
]
},
"Convert to File": {
"main": [
[
{
"node": "Audio Transcription",
"type": "main",
"index": 0
}
]
]
},
"Audio Transcription": {
"main": [
[
{
"node": "Text Mapping",
"type": "main",
"index": 0
}
]
]
},
"Audio or Text Separation": {
"main": [
[
{
"node": "GET Media",
"type": "main",
"index": 0
}
],
[
{
"node": "Text Mapping",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 财务, 人工智能, IT 运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
🌍 AI WhatsApp翻译器 + 语音转录器与HubSpot集成
基于OpenAI Whisper和GPT-4的多语言WhatsApp翻译器，集成HubSpot
If
N8n
Set
+18
107 节点Amanda Benks
其他
AI 代理餐厅 [模板]
🤖 WhatsApp、Instagram 和 Messenger 的 AI 餐厅助手
If
N8n
Set
+37
239 节点Amanda Benks
其他
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
智能资金管理器
基于Telegram、Google Sheets和OpenAI的AI驱动收据和支出追踪器
If
Set
Code
+13
50 节点Khairul Muhtadin
财务
个人 - 申请 TRM
通过 Telegram 机器人和 AI 日期识别获取哥伦比亚比索兑美元汇率
If
Set
Code
+16
31 节点Juan Sanchez
财务
工作流信息
难度等级
高级
节点数量37
分类3
节点类型18
作者
Amanda Benks
@amandaHi loves! I've been making workflows for n8n for two years, and I hope you like my flows <3
外部链接
在 n8n.io 查看 →
分享此工作流