Automatisierung der Einnahmen- und Ausgabenverfolgung in Google Tabellen über Telegram
Experte
Dies ist ein Personal Productivity-Bereich Automatisierungsworkflow mit 31 Nodes. Hauptsächlich werden Code, Switch, Telegram, GoogleSheets, TelegramTrigger und andere Nodes verwendet. Automatisierung der Einnahmen- und Ausgaben-Verfolgung in Google Sheets über Telegram
Voraussetzungen
- •Telegram Bot Token
- •Google Sheets API-Anmeldedaten
Verwendete Nodes (31)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"meta": {
"instanceId": "ba73835d772fb31a8c93dbcda773c1ef34e21227b9c152c1ee6fdf0eab995f28",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "326fd72f-6856-47f8-a033-7adbb2eea738",
"name": "Telegram - Eingehende 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": "Nachrichtentyp erkennen",
"type": "n8n-nodes-base.code",
"position": [
80,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cd68fd6e-653a-4cd1-92a4-ebcc7821c36e",
"name": "Nach Eingabetyp weiterleiten",
"type": "n8n-nodes-base.switch",
"position": [
260,
200
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40",
"name": "/start oder Nachrichteneingabe verarbeiten",
"type": "n8n-nodes-base.switch",
"position": [
480,
0
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "35faafd8-42c9-44cb-8612-deaa5270f186",
"name": "Einnahmen-/Ausgabenoptionen anzeigen",
"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": "Eingabeformat validieren",
"type": "n8n-nodes-base.code",
"position": [
700,
20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259",
"name": "Datentyp extrahieren",
"type": "n8n-nodes-base.code",
"position": [
940,
20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "50185b94-d3ce-4c5b-b88a-eb48712abc1b",
"name": "Basierend auf Datentyp weiterleiten",
"type": "n8n-nodes-base.switch",
"position": [
1140,
20
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66",
"name": "Einnahmendaten parsen",
"type": "n8n-nodes-base.code",
"position": [
1340,
-100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ba76cb99-365d-4b49-8935-ca44a17662b6",
"name": "Einnahmen in Tabelle speichern",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
-100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ea50a3b1-40ff-48d3-940c-badc9c474526",
"name": "Benutzer über erfasste Einnahme benachrichtigen",
"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": "Ausgabendaten parsen",
"type": "n8n-nodes-base.code",
"position": [
1340,
40
],
"parameters": {},
"typeVersion": 2
},
{
"id": "73831130-fb6a-4040-8857-b256203b8502",
"name": "Ausgabe in Tabelle speichern",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
40
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fa0c19ae-f044-4533-b885-9ddc26522344",
"name": "Benutzer über ausstehende Ausgabe benachrichtigen",
"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": "Genehmigungsanfrage senden",
"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": "Callback-Antwort parsen",
"type": "n8n-nodes-base.code",
"position": [
480,
360
],
"parameters": {},
"typeVersion": 2
},
{
"id": "775e82a0-083b-4d1d-b31c-ce6069572e36",
"name": "Basierend auf Callback-Typ weiterleiten",
"type": "n8n-nodes-base.switch",
"position": [
700,
320
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"name": "Genehmigungsstatus aktualisieren",
"type": "n8n-nodes-base.googleSheets",
"position": [
940,
220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "a5990c44-03a0-4fe5-b822-be593b352559",
"name": "Genehmigte Zeile abrufen",
"type": "n8n-nodes-base.googleSheets",
"position": [
1140,
220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ca1d1ff9-9d0c-44eb-8e64-4c2785692c35",
"name": "Benutzer über Genehmigungsergebnis benachrichtigen",
"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": "Zeile für Detailansicht abrufen",
"type": "n8n-nodes-base.googleSheets",
"position": [
940,
420
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fe629ffa-ded8-4e94-bda9-a4206a928e06",
"name": "Ausgabendetailnachricht formatieren",
"type": "n8n-nodes-base.code",
"position": [
1140,
420
],
"parameters": {},
"typeVersion": 2
},
{
"id": "fd3f93a9-6664-4821-9a37-8e63bcafdd8d",
"name": "Ausgabendetail an Supervisor senden",
"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": "Einnahmen-Eingabeformat anzeigen",
"type": "n8n-nodes-base.code",
"position": [
940,
580
],
"parameters": {},
"typeVersion": 2
},
{
"id": "afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a",
"name": "Ausgaben-Eingabeformat anzeigen",
"type": "n8n-nodes-base.code",
"position": [
940,
740
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a7efd0d0-363f-4d27-9744-81e3eb9587a5",
"name": "Einnahmen-Formatnachricht senden",
"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": "Ausgaben-Formatnachricht senden",
"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": "Notiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1460,
-1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aca473db-b4b3-4b48-8bb8-9f213af8fd0f",
"name": "Notiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1700,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8065e1bb-a036-43dd-8427-1e98d9335339",
"name": "Notiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "75124148-3558-4cba-84fd-eb2dafba86a6",
"name": "Notiz3",
"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
}
]
]
}
}
}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 - Persönliche Produktivität
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
Generierung von Bildern und Blog-Artikeln mit Gemini 2.5 über Pollinations in Telegram
Generieren Sie Bilder und Blog-Artikel mit Pollinations über Telegram und Gemini 2.5
If
Set
Code
+
If
Set
Code
34 NodesFahmi Oktafian
Content-Erstellung
Multimodaler Telegram-KI-Assistent mit Gemini, Sprach- und Bildgenerierung bauen
Multimodalen Telegram-KI-Assistenten mit Gemini, Sprach- und Bildgenerierung bauen
If
Set
Code
+
If
Set
Code
95 NodesIniyavan JC
Persönliche Produktivität
Einen multimodalen KI-Chatbot mit Telegram, AIMLAPI und Google Tabellen erstellen
Erstellen Sie einen multimodalen KI-Chatbot mit Telegram, AIMLAPI und Google Tabellen
If
Set
Code
+
If
Set
Code
25 NodesAI/ML API | D1m7asis
Persönliche Produktivität
Neue Notion-Aufgabe von Telegram
Erstellen Sie Notion-Aufgaben aus Telegram-Nachrichten mit GPT-3.5
Code
Switch
Telegram
+
Code
Switch
Telegram
11 NodesJason Krol
Persönliche Produktivität
Telegram und Google Sheets Kostenabrechnung: Wöchentliche Zusammenfassung und Budget-Erinnerung
Telegram und Google Sheets Ausgabenprotokoll: Wöchentliche Zusammenfassung und Budgetbenachrichtigung
Code
Telegram
Google Sheets
+
Code
Telegram
Google Sheets
15 NodesGtaras
Persönliche Produktivität
🍳 Kochbegleiter — 30-Schritt-Workflow (Telegram + Google Sheets + LLM)
Verwaltung von Rezepten mit einem KI-gesteuerten Telegram-Bot und einer Google Sheets-Datenbank
Switch
Function
Telegram
+
Switch
Function
Telegram
41 NodesIssam AGGOUR
Persönliche Produktivität
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes31
Kategorie1
Node-Typen6
Autor
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.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen