📊 Tracker de jetons AI pour WhatsApp et Telegram - Enregistrement de l'utilisation de l'AI dans Google Sheets
Avancé
Ceci est unFinance, AI, IT Opsworkflow d'automatisation du domainecontenant 37 nœuds.Utilise principalement des nœuds comme If, Set, Code, Filter, Switch, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. 📊 Tracker de jetons IA pour WhatsApp et Telegram - Enregistrement de l'utilisation de l'IA dans Google Sheets
Prérequis
- •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
- •Token Bot Telegram
- •Compte Google et informations d'identification Gmail API
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Clé API Airtable
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
Nœuds utilisés (37)
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"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": "Envoyer un e-mail",
"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": "Obtenir les contacts",
"type": "n8n-nodes-base.airtableTool",
"disabled": true,
"position": [
760,
280
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "36d8be2b-76a9-4ee1-b42e-185d867552e8",
"name": "Journal",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
0
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "54800e58-3348-4ea7-b1f2-f3b330441add",
"name": "Créer un événement",
"type": "n8n-nodes-base.googleCalendarTool",
"disabled": true,
"position": [
860,
280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "ce41257e-356f-4b7a-b92e-90a766a29ce5",
"name": "Nettoyage",
"type": "n8n-nodes-base.code",
"position": [
1020,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a91da594-54cc-4bba-83ae-db4a3d5a6aa6",
"name": "Erreurs",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
280
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "431a8770-0a6b-4d63-ad40-2be04216ebdc",
"name": "Réponse d'erreur",
"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": "Réponse",
"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": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4277b9b8-2be1-4e7a-a89e-e446287007df",
"name": "Note adhésive 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "540d74a0-e4e8-426d-b39f-5553ffd8d203",
"name": "Note adhésive 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f8fdc426-f97e-4d51-affe-7443b368d3a5",
"name": "Note adhésive 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1bb5794e-82ff-4d59-a640-db42fd043604",
"name": "Note adhésive 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "13b54670-f5c8-4ffd-b746-0f3a8e5301d2",
"name": "Note adhésive 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
"name": "Nettoyage",
"type": "n8n-nodes-base.code",
"position": [
1020,
280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e48dbb12-ddd1-4891-84b2-5afbfe5eab28",
"name": "Note adhésive 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"name": "Agent IA",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
580,
-20
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "07cf1d5a-7f4f-4827-bf33-fa4deca0fb8b",
"name": "Note adhésive 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": "OBTENIR Media",
"type": "n8n-nodes-base.httpRequest",
"position": [
-20,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "85ae2fa7-17af-408f-9c98-03ca6e8c8e57",
"name": "Note adhésive 19",
"type": "n8n-nodes-base.stickyNote",
"position": [
-300,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4a23d554-a01f-4eed-9325-01a9d8464279",
"name": "Note adhésive 20",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3195e145-a460-40b0-92e4-aba90f60ee42",
"name": "Séparation audio ou texte",
"type": "n8n-nodes-base.if",
"position": [
-240,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "73ec0645-70f4-40d2-abe2-14a64dc1bcff",
"name": "Convertir en fichier",
"type": "n8n-nodes-base.convertToFile",
"position": [
120,
-20
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "8f4c5346-4a0f-4f48-b2a7-00863d7305db",
"name": "Transcription audio",
"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": "Note adhésive 21",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "72bd6f8f-ebad-4f38-8028-520fb76d6f6c",
"name": "Filtre",
"type": "n8n-nodes-base.filter",
"position": [
260,
280
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"name": "Cartographie de texte",
"type": "n8n-nodes-base.set",
"position": [
-20,
280
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "96e1ec07-f9d5-4d7f-93ba-fb20b94fec6e",
"name": "Modèle de chat",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
500,
300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed",
"name": "Source d'entrée",
"type": "n8n-nodes-base.switch",
"position": [
1340,
-20
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "96279412-1dad-4af2-a327-280f9cd8e866",
"name": "Carte",
"type": "n8n-nodes-base.set",
"position": [
-480,
80
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "614e597e-e7a5-4296-be51-d3b9649d00f8",
"name": "Carte 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": "Erreur WhatsApp",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
200
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "a375dd86-192c-4bc8-b62f-d92a17c6d0c2",
"name": "Note adhésive 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bd7b5899-0060-4cf9-a776-486c94186124",
"name": "Source d'entrée 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": {
"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
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Finance, Intelligence Artificielle, Opérations IT
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
[Modèle] AI Pet Shop v8
🐶 Assistant de magasin de pets IA - Intégration de GPT-4o, Google Calendar et WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 NœudsAmanda Benks
Ventes
Agent IA restaurant [Modèle]
🤖 Assistant IA pour WhatsApp, Instagram et Messenger
If
N8n
Set
+
If
N8n
Set
239 NœudsAmanda Benks
Autres
Petite boutique 4
🐶 Agent IA pour les réservations de magasins de pets
If
Set
Code
+
If
Set
Code
187 NœudsBruno Dias
Intelligence Artificielle
intelligent资金gestion器
基于Telegram、Google SheetsetOpenAIdeAI驱动收据et支出追踪器
If
Set
Code
+
If
Set
Code
50 NœudsKhairul Muhtadin
Finance
Personnel - Candidature TRM
Obtenir le taux de change Peso colombien contre Dollar américain via un bot Telegram et la reconnaissance de dates IA
If
Set
Code
+
If
Set
Code
31 NœudsJuan Sanchez
Finance
🤖 WhatsApp AI个人assistant：GPT-4o、记忆et日程安排功能
AI个人assistant：intégrationGPT-4o、RAGet语音功能，utilisationSupabasedeWhatsAppassistant
If
Set
Wait
+
If
Set
Wait
76 NœudsAmanda Benks
Intelligence Artificielle
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds37
Catégorie3
Types de nœuds18
Description de la difficulté
Auteur
Amanda Benks
@amandaHi loves! I've been making workflows for n8n for two years, and I hope you like my flows <3
Liens externes
Voir sur n8n.io →
Partager ce workflow