PDF de facturas de Gmail a Google Drive y Sheets
Intermedio
Este es unautomatización que contiene 12 nodos.Utiliza principalmente nodos como If, Gmail, Filter, GoogleDrive, GmailTrigger. Carga automática de facturas PDF de Gmail a Google Drive y registro en hojas de cálculo
Requisitos previos
- •Cuenta de Google y credenciales de API de Gmail
- •Credenciales de API de Google Drive
- •Credenciales de API de Google Sheets
Nodos utilizados (12)
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": "OOH6DNGDDDuKrcjk",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Gmail Invoice PDF to Google Drive and Sheets",
"tags": [],
"nodes": [
{
"id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"name": "Gmail Trigger",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
224,
304
],
"parameters": {
"simple": false,
"filters": {
"sender": [],
"labelIds": [
"CATEGORY_PERSONAL"
],
"readStatus": "unread"
},
"options": {
"downloadAttachments": true
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "note1-2345-6789-abcd-ef1234567891",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
128,
80
],
"parameters": {
"color": 5,
"width": 280,
"height": 216,
"content": "## 📧 Gmail Trigger\nThis node monitors your Gmail inbox for new emails containing invoices. It checks every minute for unread emails with 'invoice' in the subject line and downloads any PDF attachments.\n\n**Configure:** Connect your Gmail account credentials"
},
"typeVersion": 1
},
{
"id": "filter-node-123-456-789-abcdef123456",
"name": "¿Tiene archivos adjuntos PDF?",
"type": "n8n-nodes-base.filter",
"position": [
448,
304
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "cond123",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ Object.keys($binary ?? {}).length }}",
"rightValue": 0
},
{
"id": "45eb8d9f-575d-4920-b236-2ea5be8ade19",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "note2-3456-7890-bcde-f12345678902",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
480
],
"parameters": {
"color": 3,
"width": 260,
"height": 140,
"content": "## 🔍 Filter Check\nThis filter ensures we only process emails that actually have attachments (PDFs). Emails without attachments are filtered out."
},
"typeVersion": 1
},
{
"id": "gdrive-upload-123-456-789-abcdef654321",
"name": "Subir a Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
896,
304
],
"parameters": {
"name": "={{ $json.filename || 'invoice_' + $now.toFormat('yyyyMMdd_HHmmss') + '.pdf' }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "root",
"cachedResultName": "/ (Root folder)"
},
"inputDataFieldName": "=attachment_0"
},
"typeVersion": 3
},
{
"id": "note3-4567-8901-cdef-234567890123",
"name": "Nota adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
864,
80
],
"parameters": {
"color": 4,
"width": 300,
"height": 180,
"content": "## 📁 Google Drive Upload\nEach PDF attachment is uploaded to your Google Drive. Files are named using the original filename or a timestamp if not available.\n\n**Configure:** \n- Connect Google Drive credentials\n- Optionally specify a folder ID instead of 'root'"
},
"typeVersion": 1
},
{
"id": "gsheets-append-123-456-789-fedcba098765",
"name": "Registrar en Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1120,
304
],
"parameters": {
"columns": {
"value": {
"name": "={{ $json.name }}"
},
"schema": [
{
"id": "kind",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "kind",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "mimeType",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "mimeType",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "starred",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "starred",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "trashed",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "trashed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "explicitlyTrashed",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "explicitlyTrashed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "parents",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "parents",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "spaces",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "spaces",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "version",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "version",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "webContentLink",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "webContentLink",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "webViewLink",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "webViewLink",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "iconLink",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "iconLink",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hasThumbnail",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "hasThumbnail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "thumbnailVersion",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "thumbnailVersion",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "viewedByMe",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "viewedByMe",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "createdTime",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "createdTime",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "modifiedTime",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "modifiedTime",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "modifiedByMeTime",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "modifiedByMeTime",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "modifiedByMe",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "modifiedByMe",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "owners",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "owners",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lastModifyingUser",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "lastModifyingUser",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "shared",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "shared",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ownedByMe",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ownedByMe",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "downloadRestrictions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "downloadRestrictions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "capabilities",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "capabilities",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "viewersCanCopyContent",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "viewersCanCopyContent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "copyRequiresWriterPermission",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "copyRequiresWriterPermission",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "writersCanShare",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "writersCanShare",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "permissions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "permissions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "permissionIds",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "permissionIds",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "originalFilename",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "originalFilename",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fullFileExtension",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "fullFileExtension",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fileExtension",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "fileExtension",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "md5Checksum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "md5Checksum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sha1Checksum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sha1Checksum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sha256Checksum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sha256Checksum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "size",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "quotaBytesUsed",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "quotaBytesUsed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "headRevisionId",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "headRevisionId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "isAppAuthorized",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "isAppAuthorized",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkShareMetadata",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkShareMetadata",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "inheritedPermissionsDisabled",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "inheritedPermissionsDisabled",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "id",
"value": ""
}
},
"typeVersion": 4.5
},
{
"id": "note4-5678-9012-def0-345678901234",
"name": "Nota adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
896,
496
],
"parameters": {
"color": 6,
"width": 320,
"height": 240,
"content": "## 📊 Google Sheets Logging\nRecords invoice details in a spreadsheet including:\n- Date/time received\n- Sender email\n- Subject line\n- PDF filename\n- Google Drive link\n- File and Email IDs\n\n**Configure:**\n- Connect Google Sheets credentials\n- Add your spreadsheet ID\n- Ensure sheet has headers matching the column names"
},
"typeVersion": 1
},
{
"id": "gmail-mark-read-123-456-789-0987654321ab",
"name": "Marcar correo como leído",
"type": "n8n-nodes-base.gmail",
"position": [
1344,
304
],
"webhookId": "4e776efa-c75c-428c-aad3-a959fa6fe667",
"parameters": {
"messageId": "={{ $('Gmail Trigger').item.json.id }}",
"operation": "markAsRead"
},
"typeVersion": 2.1
},
{
"id": "note5-6789-0123-ef01-456789012345",
"name": "Nota adhesiva4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1376,
112
],
"parameters": {
"color": 2,
"width": 280,
"content": "## ✅ Mark as Processed\nAfter successfully uploading the PDF and logging to sheets, the original email is marked as read so it won't be processed again.\n\n**Note:** Uses same Gmail credentials as trigger"
},
"typeVersion": 1
},
{
"id": "note6-7890-1234-f012-567890123456",
"name": "Nota adhesiva5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-272,
336
],
"parameters": {
"width": 400,
"height": 424,
"content": "## 🚀 Setup Instructions\n\n1. **Gmail OAuth2**: Connect your Gmail account in all Gmail nodes\n2. **Google Drive OAuth2**: Connect your Google Drive account\n3. **Google Sheets OAuth2**: Connect your Google Sheets account\n4. **Spreadsheet Setup**: \n - Create a Google Sheet\n - Add headers: Date, Sender, Subject, Filename, Drive_Link, File_ID, Email_ID\n - Copy the spreadsheet ID from the URL\n - Paste it in the Google Sheets node\n5. **Optional**: Change the Drive folder from 'root' to a specific folder ID\n6. **Test**: Send yourself an email with 'invoice' in subject and a PDF attached"
},
"typeVersion": 1
},
{
"id": "5f57d83d-03a6-4729-aa66-a8ad05d946d6",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
672,
304
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f8e67ccc-5871-4413-ad2a-57849477c0d8",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $binary && Object.keys($binary).length > 0 }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
}
],
"active": false,
"pinData": {},
"settings": {
"timezone": "America/New_York",
"errorWorkflow": "",
"executionOrder": "v1",
"saveManualExecutions": true,
"saveExecutionProgress": true,
"saveDataErrorExecution": "all",
"saveDataSuccessExecution": "all"
},
"connections": {
"5f57d83d-03a6-4729-aa66-a8ad05d946d6": {
"main": [
[
{
"node": "gdrive-upload-123-456-789-abcdef654321",
"type": "main",
"index": 0
}
]
]
},
"a1b2c3d4-e5f6-7890-abcd-ef1234567890": {
"main": [
[
{
"node": "filter-node-123-456-789-abcdef123456",
"type": "main",
"index": 0
}
]
]
},
"filter-node-123-456-789-abcdef123456": {
"main": [
[
{
"node": "5f57d83d-03a6-4729-aa66-a8ad05d946d6",
"type": "main",
"index": 0
}
]
]
},
"gsheets-append-123-456-789-fedcba098765": {
"main": [
[
{
"node": "gmail-mark-read-123-456-789-0987654321ab",
"type": "main",
"index": 0
}
]
]
},
"gdrive-upload-123-456-789-abcdef654321": {
"main": [
[
{
"node": "gsheets-append-123-456-789-fedcba098765",
"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?
Intermedio
¿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
AI驱动decorreo electrónico分诊与automático回复系统，integraciónOpenAIagenteyGmail
AI驱动decorreo electrónico分诊与automático回复系统，integraciónOpenAIagenteyGmail
If
Set
Gmail
+
If
Set
Gmail
68 NodosAbdullahi Ahmed
Creación de contenido
基于AIdeMISagente
基于AIdegestión信息系统agente
If
Set
Code
+
If
Set
Code
129 NodosKumar Shivam
Soporte
Preparación automática de refinamiento ágil usando Gmail, OpenAI y Google Sheets
Usar Gmail, OpenAI y Google Sheets para automatizar la preparación de la detallización ágil
If
Set
Gmail
+
If
Set
Gmail
51 NodosWillemijn
Producto
[MW] Asistente de soporte al cliente con IA - Versión en la nube
Procesamiento automático de soporte al cliente con Gmail, Google Sheets, datos de ERP y GPT-4o AI
If
Set
Gmail
+
If
Set
Gmail
25 NodosAOE Agent Lab
Inteligencia Artificial
Automatización de solicitudes de reserva de hoteles de Gmail a Google Sheets con GPT-4o-mini
Registrar automáticamente solicitudes de reserva de hoteles de Gmail en Google Sheets con GPT-4o-mini
If
Set
Code
+
If
Set
Code
29 NodosGtaras
Extracción de documentos
Automatización de la planificación de sprints de equipos ágiles
Automatización de la planificación de sprints para equipos ágiles con OpenAI, Google Calendar y Gmail
If
Set
Code
+
If
Set
Code
52 NodosWillemijn
Producto
Información del flujo de trabajo
Nivel de dificultad
Intermedio
Número de nodos12
Categoría-
Tipos de nodos7
Descripción de la dificultad
Autor
Toshiya Minami
@minamiEnlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo