(Tung) Extracción de facturas OCR a hoja de cálculo copia
Avanzado
Este es unFinance, AIflujo de automatización del dominio deautomatización que contiene 25 nodos.Utiliza principalmente nodos como If, Set, Code, Wait, GoogleDrive, combinando tecnología de inteligencia artificial para lograr automatización inteligente. OCR automático de facturas y recibos a Google Sheets - compatible con disparadores de Google Drive, Gmail y Telegram
Requisitos previos
- •Credenciales de API de Google Drive
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Cuenta de Google y credenciales de API de Gmail
- •Credenciales de API de Google Sheets
- •Bot Token de Telegram
Nodos utilizados (25)
Categoría
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"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": "Mover archivo a cadena 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 a cadena",
"type": "n8n-nodes-base.set",
"position": [
2900,
-1220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "182783f8-5285-4506-aa7b-d6f1fdbf5492",
"name": "Analizar cadena",
"type": "n8n-nodes-base.code",
"position": [
3200,
-1220
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ca6d6fc1-8fce-48da-9de5-2395ff4ee3e8",
"name": "Agregar a Hojas de Google",
"type": "n8n-nodes-base.googleSheets",
"position": [
3500,
-1220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "5b512370-b6e8-4cb7-b4d3-333ba15ac666",
"name": "Google Drive Obtener Recibo",
"type": "n8n-nodes-base.googleDrive",
"position": [
1720,
-1340
],
"parameters": {},
"typeVersion": 3
},
{
"id": "76c34c54-8666-4b3d-bb3f-ae79a6847cde",
"name": "Telegram Desencadenar Imagen",
"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 Desencadenador",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
1060,
-720
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "d3a929a9-441f-4896-9a98-d32f374c8a83",
"name": "Separar archivos binarios",
"type": "n8n-nodes-base.code",
"position": [
1940,
-480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "db81d68b-d937-47bd-adfc-215bd4797754",
"name": "Iterar sobre adjuntos",
"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": "Iterar sobre correos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1400,
-720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c4c4193a-983b-4f46-9d61-03ecff3157be",
"name": "Esperar guardado",
"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": "Iterar sobre elementos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1400,
-1360
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f3ee46f7-b3a8-4dfd-8b1f-da92613d5fe9",
"name": "Crear nombre de archivo",
"type": "n8n-nodes-base.code",
"position": [
2420,
-720
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d7bde712-ece9-4613-9771-379f99a2300d",
"name": "Crear nombre de archivo para Telegram",
"type": "n8n-nodes-base.code",
"position": [
1400,
-60
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f564d3b2-9be8-4119-9cc2-b4a61809af9f",
"name": "Google Drive Desencadenar Archivos Nuevos",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
1060,
-1360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3f4adb77-2ab4-4e7f-b9d4-4b030aaf1f68",
"name": "Nota adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8a9de5a7-0314-49d0-b87f-513bbb5e9531",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7b9dc2de-464d-4c76-9ec0-44717bf29753",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-1460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "56c7a141-3265-4528-9f5c-ad3326bcf84e",
"name": "Google Guardar Archivos 2",
"type": "n8n-nodes-base.googleDrive",
"position": [
1740,
-60
],
"parameters": {},
"typeVersion": 3
},
{
"id": "e7b8fa1b-9510-450d-a35e-4a0338efa9f0",
"name": "Google Drive Guardar Archivos",
"type": "n8n-nodes-base.googleDrive",
"position": [
2720,
-720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "95dc537f-75c1-47dc-b929-838b63f97e25",
"name": "Esperar guardado de datos",
"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": "Nota adhesiva2",
"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": "Agregar a Google Sheets",
"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
}
]
]
},
"Agregar a Google Sheets": {
"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
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Finanzas, Inteligencia Artificial
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Tienda de mascotas 4
🐶 Agente AI para citas en tiendas de mascotas
If
Set
Code
+
If
Set
Code
187 NodosBruno Dias
Inteligencia Artificial
Procesamiento y validación de facturas - Plantilla n8n
Verificación y confirmación de facturas con Gmail, Drive, Sheets y OCR AI
If
Set
Code
+
If
Set
Code
47 NodosDhrumil Patel
Finanzas
基于AIdeMISagente
基于AIdegestión信息系统agente
If
Set
Code
+
If
Set
Code
129 NodosKumar Shivam
Soporte
WordPress Blog Automation Pro (Investigación profunda) v2.1 Marketplace
Usar GPT-4o, Perplexity AI y soporte multilingüe para automatizar la creación de blogs optimizados para SEO
If
Set
Xml
+
If
Set
Xml
125 NodosDaniel Ng
Creación de contenido
[Plantilla] Tienda de mascotas AI v8
🐶 Asistente de tienda de mascotas AI - Integrado con GPT-4o, Google Calendar y WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 NodosAmanda Benks
Ventas
agente de restaurante AI [plantilla]
🤖 asistente de restaurante AI para WhatsApp, Instagram y Messenger
If
N8n
Set
+
If
N8n
Set
239 NodosAmanda Benks
Otros
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos25
Categoría2
Tipos de nodos13
Descripción de la dificultad
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
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo