8
n8n Deutschamn8n.com

Daten von YAPE-Belegen per Telegram OCR extrahieren und in Google Sheets speichern

Experte

Dies ist ein Finance, AI-Bereich Automatisierungsworkflow mit 35 Nodes. Hauptsächlich werden Code, Switch, Telegram, GoogleDrive, GoogleSheets und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Daten von YAPE-Belegen über Telegram OCR extrahieren und in Google Tabellen speichern

Voraussetzungen
  • •Telegram Bot Token
  • •Google Drive API-Anmeldedaten
  • •Google Sheets API-Anmeldedaten
  • •OpenAI API Key

Verwendete Nodes (35)

Code
Switch
Telegram
StickyNote
GoogleDrive
GoogleSheets
Agent
TelegramTrigger
OpenAi
LmChatDeepSeek

Kategorie

Finanzen
Künstliche Intelligenz
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "id": "1Pv5C6tDnHKLP42m",
  "meta": {
    "instanceId": "776aed41e1386255bdcc5feb11ff26417e83dd7ef78fc4f1d04858678b48a66f",
    "templateCredsSetupCompleted": true
  },
  "name": "Extract Data from YAPE Receipts via Telegram OCR and Store in Google Sheets",
  "tags": [
    {
      "id": "xZhfVLCNfp6aB2RH",
      "name": "Agente",
      "createdAt": "2025-03-04T07:58:57.181Z",
      "updatedAt": "2025-03-04T07:58:57.181Z"
    }
  ],
  "nodes": [
    {
      "id": "556d84c0-06f4-487d-8ae5-9b95e2405168",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "77d801b4-01b0-404d-8c8d-5a6631c5dcfd",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "96ee5290-a18a-4f06-900f-76e18cf5d01e",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -380,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2432598f-f665-4af2-b4c5-1436fa3ac4fa",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d4d83da2-6ea4-462a-999c-6acb76045e41",
      "name": "Notiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        400
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cdf5c835-2e62-4e43-a133-d06b3deb6261",
      "name": "Notiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f7e07754-7daa-4eb0-9988-f0c410cdd909",
      "name": "Notiz6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1520,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2c0d137c-d9cf-4f6a-a17c-b6406940f21c",
      "name": "Notiz7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1920,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0bb7d6ee-53a7-4774-bf67-503d38b54fee",
      "name": "Notiz8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2460,
        -340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7d08bb2e-19f7-4e09-9057-9ec595eca07b",
      "name": "Notiz11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1520,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c80b2310-3cd4-42fe-826a-af0498339f2a",
      "name": "🛎️Telegram Listener",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -300,
        -160
      ],
      "webhookId": "d618052b-6fbf-41eb-8f5d-94ec3d1e52a3",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "7eec866f-c414-4039-b2d6-c71e8be0e84a",
      "name": "🔀 Message Classifier",
      "type": "n8n-nodes-base.switch",
      "position": [
        -60,
        -160
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "1c3196df-9e55-4740-bc3d-dad52b4c42a1",
      "name": "Notiz9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -380,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "04b483a8-4dd1-457c-b986-a1be02c1a3ea",
      "name": "Notiz12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        -180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "65bcfc3a-6c2f-4854-b06b-b97b81a1671b",
      "name": "Notiz13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -100,
        -180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0f553483-1028-49a3-8909-af240c61e350",
      "name": "Notiz14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -360,
        -320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c8574753-3971-4b46-819e-a93cb43868ec",
      "name": "🔀 Start Command Handle",
      "type": "n8n-nodes-base.switch",
      "position": [
        260,
        -240
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "8dfcb5c5-0a3a-4be1-835d-43ae8058529c",
      "name": "✉️ Send Welcome Message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        500,
        -240
      ],
      "webhookId": "6166a70a-dfc2-49f3-816d-40f9f43771e4",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "cdfc4a26-f699-41a9-8139-ef8b46c0abb4",
      "name": "Notiz15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        680
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4e81ffe0-53f5-41c2-a9bd-2121791631bd",
      "name": "Notiz16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        -60
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fab3c3d3-49f8-42f2-82e8-c9b7532c3f3a",
      "name": "🗂️Select Best Quality Image",
      "type": "n8n-nodes-base.code",
      "notes": "Process the message to get the file_id of the image",
      "position": [
        240,
        500
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 2
    },
    {
      "id": "05bac483-aaf3-494b-8cf6-629d2379cf62",
      "name": "Notiz17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        300
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cf8f52ca-ba7f-4645-af92-f35cf568e5c4",
      "name": "🖼️Retrieve Image Attachment",
      "type": "n8n-nodes-base.telegram",
      "position": [
        380,
        120
      ],
      "webhookId": "f0ac13cf-72df-4bb8-8a80-b6baba880b06",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "d89cb70a-e043-4273-8a64-e4e820a30193",
      "name": "🖼️Download High-Quality Image",
      "type": "n8n-nodes-base.telegram",
      "position": [
        480,
        500
      ],
      "webhookId": "f0ac13cf-72df-4bb8-8a80-b6baba880b06",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "c50cdead-3d99-4cb5-ad69-852f869bb2d5",
      "name": "📄 Extract Text with OCR",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        840,
        -180
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "31c8539d-9947-4ff4-abf8-c219134a8737",
      "name": "🤖 AI Data Processor",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1140,
        -180
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "8b78d2f1-5045-470d-9e0c-8e77a1553573",
      "name": "🧠 AI Model for Processing",
      "type": "@n8n/n8n-nodes-langchain.lmChatDeepSeek",
      "position": [
        1100,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e6fec2a6-adaa-4d10-a485-10309843e4f6",
      "name": "Notiz18",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1c9d91e4-c891-46ca-97c1-9d1304ca2cd7",
      "name": "🔍 Find Google Sheet in Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1640,
        -120
      ],
      "parameters": {},
      "typeVersion": 3,
      "alwaysOutputData": false
    },
    {
      "id": "098a5510-3385-46bf-831e-5983d3971fa1",
      "name": "🔄 Prepare Data for Insertion",
      "type": "n8n-nodes-base.code",
      "position": [
        2000,
        -120
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "332f9c11-a32a-45c7-8837-18a6ff1f9f70",
      "name": "📑 Insert Data into Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2240,
        -120
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "3165b063-3271-4ca8-a2a9-7a06c58fea01",
      "name": "Notiz19",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2460,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d534f380-0059-4064-9560-d2a6a9f1ebe0",
      "name": "✉️ Send Analysis Result to User",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2580,
        -200
      ],
      "webhookId": "6f98701d-3b50-4920-904a-2dfae8b5817e",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "eddd1ab0-a4f7-45d7-8694-d064081b4c1d",
      "name": "Notiz20",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1920,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "271694c5-f43e-45a7-8e16-635fe1d888a3",
      "name": "Notiz21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2740,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c1cb5829-a6b3-45a8-91da-3bc257f50a4d",
  "connections": {
    "31c8539d-9947-4ff4-abf8-c219134a8737": {
      "main": [
        [
          {
            "node": "1c9d91e4-c891-46ca-97c1-9d1304ca2cd7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7eec866f-c414-4039-b2d6-c71e8be0e84a": {
      "main": [
        [
          {
            "node": "c8574753-3971-4b46-819e-a93cb43868ec",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "cf8f52ca-ba7f-4645-af92-f35cf568e5c4",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "fab3c3d3-49f8-42f2-82e8-c9b7532c3f3a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c80b2310-3cd4-42fe-826a-af0498339f2a": {
      "main": [
        [
          {
            "node": "7eec866f-c414-4039-b2d6-c71e8be0e84a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c8574753-3971-4b46-819e-a93cb43868ec": {
      "main": [
        [
          {
            "node": "8dfcb5c5-0a3a-4be1-835d-43ae8058529c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c50cdead-3d99-4cb5-ad69-852f869bb2d5": {
      "main": [
        [
          {
            "node": "31c8539d-9947-4ff4-abf8-c219134a8737",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8b78d2f1-5045-470d-9e0c-8e77a1553573": {
      "ai_languageModel": [
        [
          {
            "node": "31c8539d-9947-4ff4-abf8-c219134a8737",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "098a5510-3385-46bf-831e-5983d3971fa1": {
      "main": [
        [
          {
            "node": "332f9c11-a32a-45c7-8837-18a6ff1f9f70",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1c9d91e4-c891-46ca-97c1-9d1304ca2cd7": {
      "main": [
        [
          {
            "node": "098a5510-3385-46bf-831e-5983d3971fa1",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "cf8f52ca-ba7f-4645-af92-f35cf568e5c4": {
      "main": [
        [
          {
            "node": "c50cdead-3d99-4cb5-ad69-852f869bb2d5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fab3c3d3-49f8-42f2-82e8-c9b7532c3f3a": {
      "main": [
        [
          {
            "node": "d89cb70a-e043-4273-8a64-e4e820a30193",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d89cb70a-e043-4273-8a64-e4e820a30193": {
      "main": [
        [
          {
            "node": "c50cdead-3d99-4cb5-ad69-852f869bb2d5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "332f9c11-a32a-45c7-8837-18a6ff1f9f70": {
      "main": [
        [
          {
            "node": "d534f380-0059-4064-9560-d2a6a9f1ebe0",
            "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

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

AI-Token-Tracker für WhatsApp und Telegram - AI-Nutzung in Google Sheets speichern
📊 KI-Token-Tracker für WhatsApp und Telegram - Speichert die KI-Nutzung in Google Tabellen
If
Set
Code
+
If
Set
Code
37 NodesAmanda Benks
Finanzen
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
Der ultimative Leitfaden für einen KI-gesteuerten Telegram-Assistenten (PDF, Brave-Suche und Google Workspace)
Multifunktionalen Telegram-Bot mit Gemini, RAG-PDF-Suche und Google Workspace bauen
Set
Code
Wait
+
Set
Code
Wait
79 NodesIssam AGGOUR
Künstliche Intelligenz
Musik-Generierungs-Workflow
KI-Songs und Musikvideos mit Suno API, Flux, Runway und Creatomate generieren
Set
Wait
Merge
+
Set
Wait
Merge
60 NodesJoseph
Sonstiges
Kolumbianische Rechnungsverarbeitung
Mit Gmail, GPT-4o und Google Workspace kolumbianische Rechnungen extrahieren und ordnen
Xml
Code
Merge
+
Xml
Code
Merge
23 NodesJuan Sanchez
Finanzen
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes35
Kategorie2
Node-Typen10
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Autor
Jesús Pérez

Jesús Pérez

@jasp402

JASP402 | Developer Fullstack y QA Automation | Apasionado por la automatización con n8n. Creo workflows personalizados y eficientes para optimizar tus procesos. He desarrollado frameworks y librerías para potenciar la automatización. ¡Conecta conmigo para descubrir cómo puedo ayudarte!

Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34