AI-Token-Tracker für WhatsApp und Telegram - AI-Nutzung in Google Sheets speichern
Experte
Dies ist ein Finance, AI, IT Ops-Bereich Automatisierungsworkflow mit 37 Nodes. Hauptsächlich werden If, Set, Code, Filter, Switch und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. 📊 KI-Token-Tracker für WhatsApp und Telegram - Speichert die KI-Nutzung in Google Tabellen
Voraussetzungen
- •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
- •Telegram Bot Token
- •Google-Konto + Gmail API-Anmeldedaten
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Airtable API Key
- •Google Sheets API-Anmeldedaten
- •OpenAI API Key
Verwendete Nodes (37)
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"id": "aeYhwC8OyRGijiTb",
"meta": {
"instanceId": "b79da95dcb1b69eebc3470f6fd833d7e53e389c229c716386bdb8e7c291ad2b9"
},
"name": "📊 AI Token Tracker for WhatsApp & Telegram – Save AI Usage to 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": "E-Mail senden",
"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": "Kontakte abrufen",
"type": "n8n-nodes-base.airtableTool",
"disabled": true,
"position": [
760,
280
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "36d8be2b-76a9-4ee1-b42e-185d867552e8",
"name": "Protokoll",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
0
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "54800e58-3348-4ea7-b1f2-f3b330441add",
"name": "Ereignis erstellen",
"type": "n8n-nodes-base.googleCalendarTool",
"disabled": true,
"position": [
860,
280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "ce41257e-356f-4b7a-b92e-90a766a29ce5",
"name": "Bereinigen",
"type": "n8n-nodes-base.code",
"position": [
1020,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a91da594-54cc-4bba-83ae-db4a3d5a6aa6",
"name": "Fehler",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
280
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "431a8770-0a6b-4d63-ad40-2be04216ebdc",
"name": "Fehlerantwort",
"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": "Antwort",
"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": "Notiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4277b9b8-2be1-4e7a-a89e-e446287007df",
"name": "Notiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "540d74a0-e4e8-426d-b39f-5553ffd8d203",
"name": "Notiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f8fdc426-f97e-4d51-affe-7443b368d3a5",
"name": "Notiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1bb5794e-82ff-4d59-a640-db42fd043604",
"name": "Notiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "13b54670-f5c8-4ffd-b746-0f3a8e5301d2",
"name": "Notiz5",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
"name": "Bereinigen",
"type": "n8n-nodes-base.code",
"position": [
1020,
280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e48dbb12-ddd1-4891-84b2-5afbfe5eab28",
"name": "Notiz6",
"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": "Notiz8",
"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": "Medien abrufen",
"type": "n8n-nodes-base.httpRequest",
"position": [
-20,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "85ae2fa7-17af-408f-9c98-03ca6e8c8e57",
"name": "Notiz19",
"type": "n8n-nodes-base.stickyNote",
"position": [
-300,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4a23d554-a01f-4eed-9325-01a9d8464279",
"name": "Notiz20",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3195e145-a460-40b0-92e4-aba90f60ee42",
"name": "Audio- oder Texttrennung",
"type": "n8n-nodes-base.if",
"position": [
-240,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "73ec0645-70f4-40d2-abe2-14a64dc1bcff",
"name": "In Datei konvertieren",
"type": "n8n-nodes-base.convertToFile",
"position": [
120,
-20
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "8f4c5346-4a0f-4f48-b2a7-00863d7305db",
"name": "Audio-Transkription",
"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": "Notiz21",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "72bd6f8f-ebad-4f38-8028-520fb76d6f6c",
"name": "Filter",
"type": "n8n-nodes-base.filter",
"position": [
260,
280
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"name": "Textzuordnung",
"type": "n8n-nodes-base.set",
"position": [
-20,
280
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "96e1ec07-f9d5-4d7f-93ba-fb20b94fec6e",
"name": "Chat-Modell",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
500,
300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed",
"name": "Eingabequelle",
"type": "n8n-nodes-base.switch",
"position": [
1340,
-20
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "96279412-1dad-4af2-a327-280f9cd8e866",
"name": "Zuordnung",
"type": "n8n-nodes-base.set",
"position": [
-480,
80
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "614e597e-e7a5-4296-be51-d3b9649d00f8",
"name": "Zuordnung1",
"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 Fehler",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
200
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "a375dd86-192c-4bc8-b62f-d92a17c6d0c2",
"name": "Notiz7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bd7b5899-0060-4cf9-a776-486c94186124",
"name": "Eingabequelle1",
"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": {
"36d8be2b-76a9-4ee1-b42e-185d867552e8": {
"main": [
[
{
"node": "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed",
"type": "main",
"index": 0
}
]
]
},
"96279412-1dad-4af2-a327-280f9cd8e866": {
"main": [
[
{
"node": "3195e145-a460-40b0-92e4-aba90f60ee42",
"type": "main",
"index": 0
}
]
]
},
"614e597e-e7a5-4296-be51-d3b9649d00f8": {
"main": [
[
{
"node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"type": "main",
"index": 0
}
]
]
},
"a91da594-54cc-4bba-83ae-db4a3d5a6aa6": {
"main": [
[
{
"node": "bd7b5899-0060-4cf9-a776-486c94186124",
"type": "main",
"index": 0
}
]
]
},
"72bd6f8f-ebad-4f38-8028-520fb76d6f6c": {
"main": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "main",
"index": 0
}
]
]
},
"e7435546-bbc0-4d9c-9e11-23f882cb0077": {
"main": [
[
{
"node": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
"type": "main",
"index": 0
}
],
[
{
"node": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
"type": "main",
"index": 0
}
]
]
},
"46aa0a5e-719f-4e15-9723-60a02bdc82c8": {
"main": [
[
{
"node": "a91da594-54cc-4bba-83ae-db4a3d5a6aa6",
"type": "main",
"index": 0
}
]
]
},
"b338cf7b-1a87-4a66-8b20-e20357dc81fd": {
"main": [
[
{
"node": "614e597e-e7a5-4296-be51-d3b9649d00f8",
"type": "main",
"index": 0
}
]
]
},
"631e3652-49d3-4a53-8f8f-44baab5fc4fb": {
"main": [
[
{
"node": "73ec0645-70f4-40d2-abe2-14a64dc1bcff",
"type": "main",
"index": 0
}
]
]
},
"96e1ec07-f9d5-4d7f-93ba-fb20b94fec6e": {
"ai_languageModel": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"bbfc6da2-6c99-4907-b46f-a32df9308aef": {
"ai_tool": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "ai_tool",
"index": 0
}
]
]
},
"54800e58-3348-4ea7-b1f2-f3b330441add": {
"ai_tool": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "ai_tool",
"index": 0
}
]
]
},
"3e402e46-f5f9-432f-bee1-9b7c5f98c2b4": {
"ai_tool": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "ai_tool",
"index": 0
}
]
]
},
"c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed": {
"main": [
[
{
"node": "be1d7967-70bd-403b-8d1f-7b3949ae7deb",
"type": "main",
"index": 0
}
],
[
{
"node": "b649cc8a-4814-4730-a18a-ed3a40c79701",
"type": "main",
"index": 0
}
]
]
},
"733a7a45-b428-4bc9-806b-16a08749e8eb": {
"main": [
[
{
"node": "72bd6f8f-ebad-4f38-8028-520fb76d6f6c",
"type": "main",
"index": 0
}
]
]
},
"eafbda63-9d18-4c5b-8528-ec6f99b6d513": {
"main": [
[
{
"node": "96279412-1dad-4af2-a327-280f9cd8e866",
"type": "main",
"index": 0
}
]
]
},
"bd7b5899-0060-4cf9-a776-486c94186124": {
"main": [
[
{
"node": "c6cb3ba8-0655-405d-b440-563f2c7f2de6",
"type": "main",
"index": 0
}
],
[
{
"node": "431a8770-0a6b-4d63-ad40-2be04216ebdc",
"type": "main",
"index": 0
}
]
]
},
"73ec0645-70f4-40d2-abe2-14a64dc1bcff": {
"main": [
[
{
"node": "8f4c5346-4a0f-4f48-b2a7-00863d7305db",
"type": "main",
"index": 0
}
]
]
},
"8f4c5346-4a0f-4f48-b2a7-00863d7305db": {
"main": [
[
{
"node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"type": "main",
"index": 0
}
]
]
},
"3195e145-a460-40b0-92e4-aba90f60ee42": {
"main": [
[
{
"node": "631e3652-49d3-4a53-8f8f-44baab5fc4fb",
"type": "main",
"index": 0
}
],
[
{
"node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Finanzen, Künstliche Intelligenz, IT-Betrieb
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
[Template] KI-Haustierladen v8
🐥 KI-Assistent für Tiernahrungsshops - Integriert GPT-4o, Google Kalender und WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 NodesAmanda Benks
Vertrieb
KI-Agent Restaurant [Vorlage]
🤖 KI-Restaurantassistent für WhatsApp, Instagram und Messenger
If
N8n
Set
+
If
N8n
Set
239 NodesAmanda Benks
Sonstiges
Haustierladen 4
🐥 KI-Terminassistent für Tierbedarfsgeschäfte
If
Set
Code
+
If
Set
Code
187 NodesBruno Dias
Künstliche Intelligenz
AI-Powered Receipt and Expense Tracker with Telegram, Google Sheets & OpenAI
If
Set
Code
+
If
Set
Code
50 NodesKhairul Muhtadin
Finanzen
Persönlich - TRM beantragen
Wechselkolumbianischer Peso zu US-Dollar über Telegram-Bot und KI-Datumserkennung abrufen
If
Set
Code
+
If
Set
Code
31 NodesJuan Sanchez
Finanzen
AI Personal Assistant with GPT-4o, RAG & Voice for WhatsApp using Supabase
If
Set
Wait
+
If
Set
Wait
76 NodesAmanda Benks
Künstliche Intelligenz
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes37
Kategorie3
Node-Typen18
Autor
Amanda Benks
@amandaHi loves! I've been making workflows for n8n for two years, and I hope you like my flows <3
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen