(Tung) OCR-Rechnungsextraktion in Kopie des Speichernota
Experte
Dies ist ein Finance, AI-Bereich Automatisierungsworkflow mit 25 Nodes. Hauptsächlich werden If, Set, Code, Wait, GoogleDrive und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Automatische OCR-Verarbeitung von Rechnungen und Quittungen in Google Sheets – mit Trigger-Nodes für Google Drive, Gmail und Telegram
Voraussetzungen
- •Google Drive API-Anmeldedaten
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google-Konto + Gmail API-Anmeldedaten
- •Google Sheets API-Anmeldedaten
- •Telegram Bot Token
Verwendete Nodes (25)
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
{
"id": "qClJP4aIscQySnQK",
"meta": {
"instanceId": "b3df22d2875c82e3ba1883c50049ed9cee0bcabf99d2b486961d2245a09e3964",
"templateCredsSetupCompleted": true
},
"name": "(Tung) OCR invoice extract to spreadsheet copy",
"tags": [],
"nodes": [
{
"id": "ceb8fcc7-c733-4842-8988-2f19695658e4",
"name": "Eingabeaufforderung",
"type": "n8n-nodes-base.set",
"position": [
2320,
-1340
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7bba23a4-9ff4-4c0f-9702-6de444b8701e",
"name": "Datei in Base64-String verschieben",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2020,
-1340
],
"parameters": {},
"typeVersion": 1
},
{
"id": "df138485-9a6a-4d3e-a1ca-1c9568b5e76f",
"name": "Gemini API",
"type": "n8n-nodes-base.httpRequest",
"position": [
2620,
-1340
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "e104546f-cf93-43c4-b5b4-5c66b046a72e",
"name": "JSON zu String",
"type": "n8n-nodes-base.set",
"position": [
2900,
-1220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "182783f8-5285-4506-aa7b-d6f1fdbf5492",
"name": "String parsen",
"type": "n8n-nodes-base.code",
"position": [
3200,
-1220
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ca6d6fc1-8fce-48da-9de5-2395ff4ee3e8",
"name": "Zu Google Tabellen hinzufügen",
"type": "n8n-nodes-base.googleSheets",
"position": [
3500,
-1220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "5b512370-b6e8-4cb7-b4d3-333ba15ac666",
"name": "Google Drive Beleg abrufen",
"type": "n8n-nodes-base.googleDrive",
"position": [
1720,
-1340
],
"parameters": {},
"typeVersion": 3
},
{
"id": "76c34c54-8666-4b3d-bb3f-ae79a6847cde",
"name": "Telegram Bildauslöser",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
1060,
-60
],
"webhookId": "ef2f6b1f-b608-4e2f-9abe-02fe8ae0f085",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "9e8e821f-b6f7-4014-937e-9fe734c0e9c9",
"name": "Gmail Auslöser",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
1060,
-720
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "d3a929a9-441f-4896-9a98-d32f374c8a83",
"name": "Binärdateien aufteilen",
"type": "n8n-nodes-base.code",
"position": [
1940,
-480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "db81d68b-d937-47bd-adfc-215bd4797754",
"name": "Anhänge durchlaufen",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2100,
-740
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2cbb56fc-eb6a-4f61-8204-bcde99c164c4",
"name": "Wenn",
"type": "n8n-nodes-base.if",
"position": [
1640,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "97c167d3-db62-48ae-b9ab-4add617e1258",
"name": "E-Mails durchlaufen",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1400,
-720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c4c4193a-983b-4f46-9d61-03ecff3157be",
"name": "Auf Speicherung warten",
"type": "n8n-nodes-base.wait",
"position": [
3020,
-720
],
"webhookId": "a6742af7-28b5-469a-92d6-3f74845692fd",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "df28230d-7d7d-4817-8aba-615a9a266ad5",
"name": "Elemente durchlaufen",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1400,
-1360
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f3ee46f7-b3a8-4dfd-8b1f-da92613d5fe9",
"name": "Dateiname erstellen",
"type": "n8n-nodes-base.code",
"position": [
2420,
-720
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d7bde712-ece9-4613-9771-379f99a2300d",
"name": "Dateiname für Telegram erstellen",
"type": "n8n-nodes-base.code",
"position": [
1400,
-60
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f564d3b2-9be8-4119-9cc2-b4a61809af9f",
"name": "Google Drive Auslöser für neue Dateien",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
1060,
-1360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3f4adb77-2ab4-4e7f-b9d4-4b030aaf1f68",
"name": "Kurznotiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8a9de5a7-0314-49d0-b87f-513bbb5e9531",
"name": "Kurznotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7b9dc2de-464d-4c76-9ec0-44717bf29753",
"name": "Kurznotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-1460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "56c7a141-3265-4528-9f5c-ad3326bcf84e",
"name": "Google Dateien speichern 2",
"type": "n8n-nodes-base.googleDrive",
"position": [
1740,
-60
],
"parameters": {},
"typeVersion": 3
},
{
"id": "e7b8fa1b-9510-450d-a35e-4a0338efa9f0",
"name": "Google Drive Dateien speichern",
"type": "n8n-nodes-base.googleDrive",
"position": [
2720,
-720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "95dc537f-75c1-47dc-b929-838b63f97e25",
"name": "Auf Speicherung der Daten warten",
"type": "n8n-nodes-base.wait",
"position": [
3820,
-1220
],
"webhookId": "211ca61f-1915-4fb7-9ebf-8304c75d536e",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "d40ea975-5a33-485c-9811-7444181209ca",
"name": "Kurznotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-1480
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"errorWorkflow": "7XxwbKvr4yHpGpKg",
"executionOrder": "v1"
},
"versionId": "a6b663dd-a23e-4e18-abb8-65c23310056a",
"connections": {
"2cbb56fc-eb6a-4f61-8204-bcde99c164c4": {
"main": [
[
{
"node": "d3a929a9-441f-4896-9a98-d32f374c8a83",
"type": "main",
"index": 0
}
],
[
{
"node": "97c167d3-db62-48ae-b9ab-4add617e1258",
"type": "main",
"index": 0
}
]
]
},
"ceb8fcc7-c733-4842-8988-2f19695658e4": {
"main": [
[
{
"node": "df138485-9a6a-4d3e-a1ca-1c9568b5e76f",
"type": "main",
"index": 0
}
]
]
},
"df138485-9a6a-4d3e-a1ca-1c9568b5e76f": {
"main": [
[
{
"node": "e104546f-cf93-43c4-b5b4-5c66b046a72e",
"type": "main",
"index": 0
}
]
]
},
"182783f8-5285-4506-aa7b-d6f1fdbf5492": {
"main": [
[
{
"node": "ca6d6fc1-8fce-48da-9de5-2395ff4ee3e8",
"type": "main",
"index": 0
}
]
]
},
"9e8e821f-b6f7-4014-937e-9fe734c0e9c9": {
"main": [
[
{
"node": "97c167d3-db62-48ae-b9ab-4add617e1258",
"type": "main",
"index": 0
}
]
]
},
"e104546f-cf93-43c4-b5b4-5c66b046a72e": {
"main": [
[
{
"node": "182783f8-5285-4506-aa7b-d6f1fdbf5492",
"type": "main",
"index": 0
}
]
]
},
"df28230d-7d7d-4817-8aba-615a9a266ad5": {
"main": [
[],
[
{
"node": "5b512370-b6e8-4cb7-b4d3-333ba15ac666",
"type": "main",
"index": 0
}
]
]
},
"c4c4193a-983b-4f46-9d61-03ecff3157be": {
"main": [
[
{
"node": "db81d68b-d937-47bd-adfc-215bd4797754",
"type": "main",
"index": 0
}
]
]
},
"f3ee46f7-b3a8-4dfd-8b1f-da92613d5fe9": {
"main": [
[
{
"node": "e7b8fa1b-9510-450d-a35e-4a0338efa9f0",
"type": "main",
"index": 0
}
]
]
},
"97c167d3-db62-48ae-b9ab-4add617e1258": {
"main": [
[
{
"node": "db81d68b-d937-47bd-adfc-215bd4797754",
"type": "main",
"index": 0
}
],
[
{
"node": "2cbb56fc-eb6a-4f61-8204-bcde99c164c4",
"type": "main",
"index": 0
}
]
]
},
"ca6d6fc1-8fce-48da-9de5-2395ff4ee3e8": {
"main": [
[
{
"node": "95dc537f-75c1-47dc-b929-838b63f97e25",
"type": "main",
"index": 0
}
]
]
},
"95dc537f-75c1-47dc-b929-838b63f97e25": {
"main": [
[
{
"node": "df28230d-7d7d-4817-8aba-615a9a266ad5",
"type": "main",
"index": 0
}
]
]
},
"db81d68b-d937-47bd-adfc-215bd4797754": {
"main": [
[],
[
{
"node": "f3ee46f7-b3a8-4dfd-8b1f-da92613d5fe9",
"type": "main",
"index": 0
}
]
]
},
"d3a929a9-441f-4896-9a98-d32f374c8a83": {
"main": [
[
{
"node": "97c167d3-db62-48ae-b9ab-4add617e1258",
"type": "main",
"index": 0
}
]
]
},
"76c34c54-8666-4b3d-bb3f-ae79a6847cde": {
"main": [
[
{
"node": "d7bde712-ece9-4613-9771-379f99a2300d",
"type": "main",
"index": 0
}
]
]
},
"e7b8fa1b-9510-450d-a35e-4a0338efa9f0": {
"main": [
[
{
"node": "c4c4193a-983b-4f46-9d61-03ecff3157be",
"type": "main",
"index": 0
}
]
]
},
"5b512370-b6e8-4cb7-b4d3-333ba15ac666": {
"main": [
[
{
"node": "7bba23a4-9ff4-4c0f-9702-6de444b8701e",
"type": "main",
"index": 0
}
]
]
},
"7bba23a4-9ff4-4c0f-9702-6de444b8701e": {
"main": [
[
{
"node": "ceb8fcc7-c733-4842-8988-2f19695658e4",
"type": "main",
"index": 0
}
]
]
},
"d7bde712-ece9-4613-9771-379f99a2300d": {
"main": [
[
{
"node": "56c7a141-3265-4528-9f5c-ad3326bcf84e",
"type": "main",
"index": 0
}
]
]
},
"f564d3b2-9be8-4119-9cc2-b4a61809af9f": {
"main": [
[
{
"node": "df28230d-7d7d-4817-8aba-615a9a266ad5",
"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
Haustierladen 4
🐥 KI-Terminassistent für Tierbedarfsgeschäfte
If
Set
Code
+
If
Set
Code
187 NodesBruno Dias
Künstliche Intelligenz
Rechnungsverarbeitung und Verifizierung - n8n-Vorlage
Rechnungsvalidierung und Bestätigung basierend auf Gmail, Drive, Tabellen und OCR-KI
If
Set
Code
+
If
Set
Code
47 NodesDhrumil Patel
Finanzen
AI-Powered MIS Agent
If
Set
Code
+
If
Set
Code
129 NodesKumar Shivam
Support
WordPress-Blog-Automatisierung Professional Edition (Deep Research) v2.1 Markt
Automatisierung der Erstellung von SEO-optimierten Blogs mit GPT-4o, Perplexity AI und mehrsprachiger Unterstützung
If
Set
Xml
+
If
Set
Xml
125 NodesDaniel Ng
Content-Erstellung
[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
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes25
Kategorie2
Node-Typen13
Autor
Daniel Ng
@danielngA Growth Hacker, Digital Marketer & AI Automation Builder with 10+ years of experience in Digital Marketing & Workflow Automation. Based in Helsinki, Finland. For questions about my templates and customization, contact me at: daniel@aiautomationpro.org
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen