(Tung) Extraction OCR de factures vers une feuille de calcul copie
Avancé
Ceci est unFinance, AIworkflow d'automatisation du domainecontenant 25 nœuds.Utilise principalement des nœuds comme If, Set, Code, Wait, GoogleDrive, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. OCR automatique des factures et reçus vers Google Sheets - avec déclencheurs Google Drive, Gmail et Telegram
Prérequis
- •Informations d'identification Google Drive API
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Compte Google et informations d'identification Gmail API
- •Informations d'identification Google Sheets API
- •Token Bot Telegram
Nœuds utilisés (25)
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
{
"id": "qClJP4aIscQySnQK",
"meta": {
"instanceId": "b3df22d2875c82e3ba1883c50049ed9cee0bcabf99d2b486961d2245a09e3964",
"templateCredsSetupCompleted": true
},
"name": "(Tung) OCR invoice extract to spreadsheet copy",
"tags": [],
"nodes": [
{
"id": "ceb8fcc7-c733-4842-8988-2f19695658e4",
"name": "Prompt",
"type": "n8n-nodes-base.set",
"position": [
2320,
-1340
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7bba23a4-9ff4-4c0f-9702-6de444b8701e",
"name": "Déplacer le fichier en chaîne base64",
"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 vers chaîne",
"type": "n8n-nodes-base.set",
"position": [
2900,
-1220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "182783f8-5285-4506-aa7b-d6f1fdbf5492",
"name": "Analyser la chaîne",
"type": "n8n-nodes-base.code",
"position": [
3200,
-1220
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ca6d6fc1-8fce-48da-9de5-2395ff4ee3e8",
"name": "Ajouter à Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
3500,
-1220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "5b512370-b6e8-4cb7-b4d3-333ba15ac666",
"name": "Google Drive Obtenir Reçu",
"type": "n8n-nodes-base.googleDrive",
"position": [
1720,
-1340
],
"parameters": {},
"typeVersion": 3
},
{
"id": "76c34c54-8666-4b3d-bb3f-ae79a6847cde",
"name": "Telegram Déclencheur Image",
"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 Déclencheur",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
1060,
-720
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "d3a929a9-441f-4896-9a98-d32f374c8a83",
"name": "Séparer les fichiers binaires",
"type": "n8n-nodes-base.code",
"position": [
1940,
-480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "db81d68b-d937-47bd-adfc-215bd4797754",
"name": "Boucler sur les pièces jointes",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2100,
-740
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2cbb56fc-eb6a-4f61-8204-bcde99c164c4",
"name": "Si",
"type": "n8n-nodes-base.if",
"position": [
1640,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "97c167d3-db62-48ae-b9ab-4add617e1258",
"name": "Boucler sur les emails",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1400,
-720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c4c4193a-983b-4f46-9d61-03ecff3157be",
"name": "Attendre la sauvegarde",
"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": "Boucler sur les éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1400,
-1360
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f3ee46f7-b3a8-4dfd-8b1f-da92613d5fe9",
"name": "Créer un nom de fichier",
"type": "n8n-nodes-base.code",
"position": [
2420,
-720
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d7bde712-ece9-4613-9771-379f99a2300d",
"name": "Créer un nom de fichier pour Telegram",
"type": "n8n-nodes-base.code",
"position": [
1400,
-60
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f564d3b2-9be8-4119-9cc2-b4a61809af9f",
"name": "Google Drive Déclencheur Nouveaux Fichiers",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
1060,
-1360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3f4adb77-2ab4-4e7f-b9d4-4b030aaf1f68",
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8a9de5a7-0314-49d0-b87f-513bbb5e9531",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7b9dc2de-464d-4c76-9ec0-44717bf29753",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-1460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "56c7a141-3265-4528-9f5c-ad3326bcf84e",
"name": "Google Sauvegarder Fichiers 2",
"type": "n8n-nodes-base.googleDrive",
"position": [
1740,
-60
],
"parameters": {},
"typeVersion": 3
},
{
"id": "e7b8fa1b-9510-450d-a35e-4a0338efa9f0",
"name": "Google Drive Sauvegarder Fichiers",
"type": "n8n-nodes-base.googleDrive",
"position": [
2720,
-720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "95dc537f-75c1-47dc-b929-838b63f97e25",
"name": "Attendre la sauvegarde des données",
"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": "Note adhésive2",
"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
}
]
]
}
}
}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
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
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
Traitement et validation de factures - modèle n8n
Validation et confirmation des factures avec Gmail, Drive, Sheets et OCR IA
If
Set
Code
+
If
Set
Code
47 NœudsDhrumil Patel
Finance
基于AIdeMISagent
基于AIdegestion信息系统agent
If
Set
Code
+
If
Set
Code
129 NœudsKumar Shivam
Support
Version professionnelle de l'automatisation de blog WordPress (recherche approfondie) v2.1 sur le marché
Automatisation de la création de blog optimisé pour le SEO avec GPT-4o, Perplexity AI et support multilingue
If
Set
Xml
+
If
Set
Xml
125 NœudsDaniel Ng
Création de contenu
[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
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds25
Catégorie2
Types de nœuds13
Description de la difficulté
Auteur
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
Liens externes
Voir sur n8n.io →
Partager ce workflow