Suivi automatique des revenus et des dépenses dans Google Sheets via Telegram
Avancé
Ceci est unPersonal Productivityworkflow d'automatisation du domainecontenant 31 nœuds.Utilise principalement des nœuds comme Code, Switch, Telegram, GoogleSheets, TelegramTrigger. Suivre automatiquement les revenus et les dépenses dans des feuilles Google avec Telegram
Prérequis
- •Token Bot Telegram
- •Informations d'identification Google Sheets API
Nœuds utilisés (31)
Catégorie
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
{
"meta": {
"instanceId": "ba73835d772fb31a8c93dbcda773c1ef34e21227b9c152c1ee6fdf0eab995f28",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "326fd72f-6856-47f8-a033-7adbb2eea738",
"name": "Telegram - Message entrant Webhook",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-100,
200
],
"webhookId": "d38ec46a-5c4e-48af-a415-400392021f4c",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "f8d79eab-fbcd-46e2-822d-b64f6cdf2343",
"name": "Détecter le type de message",
"type": "n8n-nodes-base.code",
"position": [
80,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cd68fd6e-653a-4cd1-92a4-ebcc7821c36e",
"name": "Router par type d'entrée",
"type": "n8n-nodes-base.switch",
"position": [
260,
200
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40",
"name": "Traiter /start ou saisie de message",
"type": "n8n-nodes-base.switch",
"position": [
480,
0
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "35faafd8-42c9-44cb-8612-deaa5270f186",
"name": "Afficher les options Revenu/Dépense",
"type": "n8n-nodes-base.telegram",
"position": [
700,
-160
],
"webhookId": "34ce0d27-2e04-4402-beef-cbfc0b0c2c7f",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "83d3e6b4-c30c-418b-bc09-53876fd047a3",
"name": "Valider le format de saisie",
"type": "n8n-nodes-base.code",
"position": [
700,
20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259",
"name": "Extraire le type de données",
"type": "n8n-nodes-base.code",
"position": [
940,
20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "50185b94-d3ce-4c5b-b88a-eb48712abc1b",
"name": "Router selon le type de données",
"type": "n8n-nodes-base.switch",
"position": [
1140,
20
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66",
"name": "Analyser les données de revenu",
"type": "n8n-nodes-base.code",
"position": [
1340,
-100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ba76cb99-365d-4b49-8935-ca44a17662b6",
"name": "Enregistrer le revenu dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
-100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ea50a3b1-40ff-48d3-940c-badc9c474526",
"name": "Notifier l'utilisateur (Revenu enregistré)",
"type": "n8n-nodes-base.telegram",
"position": [
1740,
-100
],
"webhookId": "39b21e24-7b4f-4c83-b410-e0824d8f1089",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "9d8399a5-f689-4589-b5ab-2b5735613a12",
"name": "Analyser les données de dépense",
"type": "n8n-nodes-base.code",
"position": [
1340,
40
],
"parameters": {},
"typeVersion": 2
},
{
"id": "73831130-fb6a-4040-8857-b256203b8502",
"name": "Enregistrer la dépense dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
40
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fa0c19ae-f044-4533-b885-9ddc26522344",
"name": "Notifier l'utilisateur (Dépense en attente)",
"type": "n8n-nodes-base.telegram",
"position": [
1740,
40
],
"webhookId": "baf321e6-3b8f-4451-aaa3-a2c768635d55",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "f06a85ad-5f76-485c-94cf-8465aae0ea50",
"name": "Envoyer une demande d'approbation",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
40
],
"webhookId": "3745c927-de23-40f5-9149-9085fd62c886",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "4e3b3a12-3b18-4bd2-ac24-25e39e1c171b",
"name": "Analyser la réponse du callback",
"type": "n8n-nodes-base.code",
"position": [
480,
360
],
"parameters": {},
"typeVersion": 2
},
{
"id": "775e82a0-083b-4d1d-b31c-ce6069572e36",
"name": "Router selon le type de callback",
"type": "n8n-nodes-base.switch",
"position": [
700,
320
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"name": "Mettre à jour le statut d'approbation",
"type": "n8n-nodes-base.googleSheets",
"position": [
940,
220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "a5990c44-03a0-4fe5-b822-be593b352559",
"name": "Obtenir la ligne approuvée",
"type": "n8n-nodes-base.googleSheets",
"position": [
1140,
220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ca1d1ff9-9d0c-44eb-8e64-4c2785692c35",
"name": "Notifier l'utilisateur du résultat d'approbation",
"type": "n8n-nodes-base.telegram",
"position": [
1340,
220
],
"webhookId": "8a346a95-d9a8-43e7-9b7e-46efcdfa53c9",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e5142ba0-50d8-450a-bbd1-45488cf6c386",
"name": "Obtenir la ligne pour la vue détaillée",
"type": "n8n-nodes-base.googleSheets",
"position": [
940,
420
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fe629ffa-ded8-4e94-bda9-a4206a928e06",
"name": "Formater le message de détail de dépense",
"type": "n8n-nodes-base.code",
"position": [
1140,
420
],
"parameters": {},
"typeVersion": 2
},
{
"id": "fd3f93a9-6664-4821-9a37-8e63bcafdd8d",
"name": "Envoyer le détail de dépense au superviseur",
"type": "n8n-nodes-base.telegram",
"position": [
1340,
420
],
"webhookId": "0c007b17-b53c-4c0d-92e5-f9a7f5a270e5",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "461f7a4e-035b-4ed9-baa1-cd79586d2e3e",
"name": "Afficher le format de saisie de revenu",
"type": "n8n-nodes-base.code",
"position": [
940,
580
],
"parameters": {},
"typeVersion": 2
},
{
"id": "afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a",
"name": "Afficher le format de saisie de dépense",
"type": "n8n-nodes-base.code",
"position": [
940,
740
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a7efd0d0-363f-4d27-9744-81e3eb9587a5",
"name": "Envoyer le message de format de revenu",
"type": "n8n-nodes-base.telegram",
"position": [
1140,
580
],
"webhookId": "ad996647-1e41-4a81-9e31-001dc890cead",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "710ecddd-d353-41e7-8749-9a11e5816607",
"name": "Envoyer le message de format de dépense",
"type": "n8n-nodes-base.telegram",
"position": [
1140,
740
],
"webhookId": "6307cfda-748c-47a6-8e6d-1428c69ee157",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "936e41c7-727c-47db-a093-c0ad14b86f0e",
"name": "Note autocollante",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1460,
-1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aca473db-b4b3-4b48-8bb8-9f213af8fd0f",
"name": "Note autocollante1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1700,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8065e1bb-a036-43dd-8427-1e98d9335339",
"name": "Note autocollante2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "75124148-3558-4cba-84fd-eb2dafba86a6",
"name": "Note autocollante3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1460,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"a5990c44-03a0-4fe5-b822-be593b352559": {
"main": [
[
{
"node": "ca1d1ff9-9d0c-44eb-8e64-4c2785692c35",
"type": "main",
"index": 0
}
]
]
},
"8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259": {
"main": [
[
{
"node": "50185b94-d3ce-4c5b-b88a-eb48712abc1b",
"type": "main",
"index": 0
}
]
]
},
"dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66": {
"main": [
[
{
"node": "ba76cb99-365d-4b49-8935-ca44a17662b6",
"type": "main",
"index": 0
}
]
]
},
"9d8399a5-f689-4589-b5ab-2b5735613a12": {
"main": [
[
{
"node": "73831130-fb6a-4040-8857-b256203b8502",
"type": "main",
"index": 0
}
]
]
},
"f8d79eab-fbcd-46e2-822d-b64f6cdf2343": {
"main": [
[
{
"node": "cd68fd6e-653a-4cd1-92a4-ebcc7821c36e",
"type": "main",
"index": 0
}
]
]
},
"cd68fd6e-653a-4cd1-92a4-ebcc7821c36e": {
"main": [
[
{
"node": "4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40",
"type": "main",
"index": 0
}
],
[
{
"node": "4e3b3a12-3b18-4bd2-ac24-25e39e1c171b",
"type": "main",
"index": 0
}
]
]
},
"ba76cb99-365d-4b49-8935-ca44a17662b6": {
"main": [
[
{
"node": "ea50a3b1-40ff-48d3-940c-badc9c474526",
"type": "main",
"index": 0
}
]
]
},
"73831130-fb6a-4040-8857-b256203b8502": {
"main": [
[
{
"node": "fa0c19ae-f044-4533-b885-9ddc26522344",
"type": "main",
"index": 0
}
]
]
},
"f06a85ad-5f76-485c-94cf-8465aae0ea50": {
"main": [
[]
]
},
"83d3e6b4-c30c-418b-bc09-53876fd047a3": {
"main": [
[
{
"node": "8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259",
"type": "main",
"index": 0
}
]
]
},
"45561880-459f-4b5b-97b4-0f0d8185be2d": {
"main": [
[
{
"node": "a5990c44-03a0-4fe5-b822-be593b352559",
"type": "main",
"index": 0
}
]
]
},
"e5142ba0-50d8-450a-bbd1-45488cf6c386": {
"main": [
[
{
"node": "fe629ffa-ded8-4e94-bda9-a4206a928e06",
"type": "main",
"index": 0
}
]
]
},
"4e3b3a12-3b18-4bd2-ac24-25e39e1c171b": {
"main": [
[
{
"node": "775e82a0-083b-4d1d-b31c-ce6069572e36",
"type": "main",
"index": 0
}
]
]
},
"50185b94-d3ce-4c5b-b88a-eb48712abc1b": {
"main": [
[
{
"node": "dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66",
"type": "main",
"index": 0
}
],
[
{
"node": "9d8399a5-f689-4589-b5ab-2b5735613a12",
"type": "main",
"index": 0
}
],
[]
]
},
"461f7a4e-035b-4ed9-baa1-cd79586d2e3e": {
"main": [
[
{
"node": "a7efd0d0-363f-4d27-9744-81e3eb9587a5",
"type": "main",
"index": 0
}
]
]
},
"afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a": {
"main": [
[
{
"node": "710ecddd-d353-41e7-8749-9a11e5816607",
"type": "main",
"index": 0
}
]
]
},
"fa0c19ae-f044-4533-b885-9ddc26522344": {
"main": [
[
{
"node": "f06a85ad-5f76-485c-94cf-8465aae0ea50",
"type": "main",
"index": 0
}
]
]
},
"326fd72f-6856-47f8-a033-7adbb2eea738": {
"main": [
[
{
"node": "f8d79eab-fbcd-46e2-822d-b64f6cdf2343",
"type": "main",
"index": 0
}
]
]
},
"775e82a0-083b-4d1d-b31c-ce6069572e36": {
"main": [
[
{
"node": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"type": "main",
"index": 0
}
],
[
{
"node": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"type": "main",
"index": 0
}
],
[
{
"node": "e5142ba0-50d8-450a-bbd1-45488cf6c386",
"type": "main",
"index": 0
}
],
[
{
"node": "461f7a4e-035b-4ed9-baa1-cd79586d2e3e",
"type": "main",
"index": 0
}
],
[
{
"node": "afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a",
"type": "main",
"index": 0
}
]
]
},
"fe629ffa-ded8-4e94-bda9-a4206a928e06": {
"main": [
[
{
"node": "fd3f93a9-6664-4821-9a37-8e63bcafdd8d",
"type": "main",
"index": 0
}
]
]
},
"4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40": {
"main": [
[
{
"node": "35faafd8-42c9-44cb-8612-deaa5270f186",
"type": "main",
"index": 0
}
],
[
{
"node": "83d3e6b4-c30c-418b-bc09-53876fd047a3",
"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é - Productivité personnelle
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
Générer des images via Telegram avec Pollinations et un article de blog avec Gemini 2.5
Générer des images et des articles de blog avec Pollinations via Telegram et Gemini 2.5
If
Set
Code
+
If
Set
Code
34 NœudsFahmi Oktafian
Création de contenu
Assistant IA multimodal Telegram avec Gemini, génération vocale et d'images
Construire un assistant IA multimodal sur Telegram avec Gemini, la voix et la génération d'images
If
Set
Code
+
If
Set
Code
95 NœudsIniyavan JC
Productivité personnelle
Créer un chatbot IA multimodèle avec Telegram, AIMLAPI et Google Sheets
Utiliser Telegram, AIMLAPI et Google Sheets pour créer un chatbot IA multimodal
If
Set
Code
+
If
Set
Code
25 NœudsAI/ML API | D1m7asis
Productivité personnelle
Nouvelle tâche Notion pour Telegram
Utiliser GPT-3.5 pour créer des tâches Notion à partir de messages Telegram
Code
Switch
Telegram
+
Code
Switch
Telegram
11 NœudsJason Krol
Productivité personnelle
Enregistrements des dépenses Telegram et Google Sheets : Résumé hebdomadaire et rappels de budget
Suivi des dépenses Telegram et Google Sheets : résumé hebdomadaire et rappels de budget
Code
Telegram
Google Sheets
+
Code
Telegram
Google Sheets
15 NœudsGtaras
Productivité personnelle
🍳 Compagnon de cuisine — Flux de travail 30 étapes (Telegram + Google Sheets + LLM)
utilisationAI驱动deTelegrambotetGoogle Sheetsdonnées库gestion食谱
Switch
Function
Telegram
+
Switch
Function
Telegram
41 NœudsIssam AGGOUR
Productivité personnelle
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds31
Catégorie1
Types de nœuds6
Description de la difficulté
Auteur
Fahmi Oktafian
@fahmi3322Hi! I’m Fahmi Oktafian, a developer and automation enthusiast with expertise in n8n, Node.js, and API integrations. I specialize in building smart, scalable workflows — from auto-publishing content to WordPress, sending automated Telegram notifications, to processing AI-based summaries and paraphrase. I’m passionate about helping businesses save time, increase efficiency, and automate their digital processes with clean and user-friendly solutions.
Liens externes
Voir sur n8n.io →
Partager ce workflow