{ "edges": [ { "to": "9960d10f-3231-4bbb-8265-9a051cced530", "from": "aaec31d1-c60a-4fde-bbf7-6a9bac5e09da", "toPort": "0", "fromPort": "0" }, { "to": "6035c47b-6f5d-4d47-88bf-ad908cb55adf", "from": "0d9d5f81-fdd0-4ce3-a76b-63d5ff0115b7", "toPort": "0", "fromPort": "0" }, { "to": "7ed141be-6fd4-4729-b700-0d28039273bc", "from": "c898a939-f009-414a-a57a-0cf935901aa7", "toPort": "0", "fromPort": "0" }, { "to": "3b44154e-b2cb-45c7-8b89-84584a0681e8", "from": "c898a939-f009-414a-a57a-0cf935901aa7", "toPort": "0", "fromPort": "1" }, { "to": "aaec31d1-c60a-4fde-bbf7-6a9bac5e09da", "from": "c898a939-f009-414a-a57a-0cf935901aa7", "toPort": "0", "fromPort": "1" }, { "to": "d2224313-0c64-4b3e-9d0d-327e184eff88", "from": "b45702da-c2c7-411b-a9b6-adeb511b37f4", "toPort": "0", "fromPort": "0" }, { "to": "fff5863f-fe64-4458-91df-25dfc423bf30", "from": "7ed141be-6fd4-4729-b700-0d28039273bc", "toPort": "0", "fromPort": "0" }, { "to": "b45702da-c2c7-411b-a9b6-adeb511b37f4", "from": "fff5863f-fe64-4458-91df-25dfc423bf30", "toPort": "0", "fromPort": "0" }, { "to": "aaec31d1-c60a-4fde-bbf7-6a9bac5e09da", "from": "3b44154e-b2cb-45c7-8b89-84584a0681e8", "toPort": "1", "fromPort": "0" }, { "to": "c898a939-f009-414a-a57a-0cf935901aa7", "from": "6035c47b-6f5d-4d47-88bf-ad908cb55adf", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "0d9d5f81-fdd0-4ce3-a76b-63d5ff0115b7", "name": "Gmail Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.gmailTrigger", "simple": false, "filters": { "labelIds": [ "INBOX" ], "readStatus": "both" }, "options": { "downloadAttachments": true, "dataPropertyAttachmentsPrefixName": "attachment_" }, "pollTimes": { "item": [ { "hour": 23, "minute": 59 } ] } }, "position": [ 896, 480 ] }, { "id": "aaec31d1-c60a-4fde-bbf7-6a9bac5e09da", "name": "Merge", "type": "merge", "params": { "mode": "combine", "options": {}, "combineBy": "combineAll" }, "position": [ 2192, 544 ] }, { "id": "9960d10f-3231-4bbb-8265-9a051cced530", "name": "Upload Unprocessed file", "type": "integration", "params": { "driveId": { "__rl": true, "mode": "list", "value": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "id", "value": "={{ $json.id }}" }, "operation": "read", "inputDataFieldName": "=file" }, "position": [ 2384, 544 ] }, { "id": "6035c47b-6f5d-4d47-88bf-ad908cb55adf", "name": "Extract attachment information", "type": "code", "params": { "jsCode": "const outputItems = [];\n\n$input.all().forEach((inputItem) => {\n const { json, binary } = inputItem;\n\n // Iterate all binary attachments (attachment_0, attachment_1...)\n const binaryKeys = Object.keys(binary || {});\n\n if (binaryKeys.length === 0) {\n // Return empty metadata when no attachments to avoid process interruption\n outputItems.push({\n json: {\n \"attachment_name\": \"\",\n \"attachment_extension\": \"\",\n \"mime_type\": \"\",\n \"attachment_size_bytes\": 0,\n \"attachment_size_mb\": 0,\n \"has_attachment\": false,\n \"email_id\": json.id || \"\"\n },\n binary: {}\n });\n return;\n }\n\n // Process each attachment when available\n binaryKeys.forEach((binaryKey) => {\n const att = binary[binaryKey];\n if (!att) return;\n\n // Extract metadata from binary\n const fileName = att.fileName || \"\";\n const fileExt = att.fileExtension || \"\";\n const mimeType = att.mimeType || \"\";\n const fileSizeStr = att.fileSize || \"0 kB\";\n\n // Parse file size to bytes\n let fileSizeBytes = 0;\n const sizeMatch = fileSizeStr.match(/(\\d+(?:\\.\\d+)?)\\s*(kB|MB|GB|B)/i);\n if (sizeMatch) {\n const value = parseFloat(sizeMatch[1]);\n const unit = sizeMatch[2].toUpperCase();\n switch (unit) {\n case \"B\":\n fileSizeBytes = value;\n break;\n case \"KB\":\n fileSizeBytes = value * 1024;\n break;\n case \"MB\":\n fileSizeBytes = value * 1024 * 1024;\n break;\n case \"GB\":\n fileSizeBytes = value * 1024 * 1024 * 1024;\n break;\n }\n }\n\n const fileSizeMB = (fileSizeBytes / 1024 / 1024).toFixed(2);\n\n outputItems.push({\n json: {\n \"attachment_name\": fileName,\n \"attachment_extension\": fileExt,\n \"mime_type\": mimeType,\n \"attachment_size_bytes\": Math.round(fileSizeBytes),\n \"attachment_size_mb\": parseFloat(fileSizeMB),\n \"has_attachment\": true,\n \"email_id\": json.id || \"\",\n \"binary_key\": binaryKey // Used to associate binary files later\n },\n // Core modification: Rename all attachments to \"file\" instead of attachment_X\n binary: {\n file: att\n }\n });\n });\n});\n\nreturn outputItems;" }, "position": [ 1232, 480 ] }, { "id": "c898a939-f009-414a-a57a-0cf935901aa7", "name": "Filter documents", "type": "if", "params": { "options": { "ignoreCase": true }, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": false, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "1d3c412e-2393-4c9f-9505-031b0a9b9f4c", "operator": { "type": "string", "operation": "regex" }, "leftValue": "={{ $json.attachment_name }}", "rightValue": "={{ \"invoice|receipt|expenses|fee\" }}" }, { "id": "b51b0700-dc6c-4342-b67d-f0c060e3e526", "operator": { "type": "string", "operation": "regex" }, "leftValue": "={{ $json.attachment_extension }}", "rightValue": "={{ \"^(jpeg|jpg|png|bmp|tiff|pdf|doc|docx|xls|xlsx)$\" }}" }, { "id": "16f33e86-b523-4fa8-b1be-3cc4ad5a78df", "operator": { "type": "number", "operation": "lt" }, "leftValue": "={{ $json.attachment_size_mb }}", "rightValue": "={{ 50 }}" } ] }, "looseTypeValidation": true }, "position": [ 1552, 480 ] }, { "id": "7ed141be-6fd4-4729-b700-0d28039273bc", "name": "Base64 Encode Document", "type": "passthrough", "params": { "mode": "noOp", "options": { "encoding": "base64" }, "operation": "binaryToPropery", "binaryPropertyName": "=file" }, "position": [ 1920, 288 ] }, { "id": "fff5863f-fe64-4458-91df-25dfc423bf30", "name": "Laiye ADP HTTP Request", "type": "http", "params": { "url": "https://adp.laiye.com/open/agentic_doc_processor/laiye/v1/app/doc/extract", "method": "POST", "options": {}, "jsonBody": "={\n \"app_key\": \"enter_your_app_key\",\n \"app_secret\":\"enter_your_app_secret\",\n \"file_base64\": \"{{ $json.data }}\"\n}", "sendBody": true, "jsonHeaders": "={\n \"X-Access-Key\": \"enter_your_access_key\",\n \"X-Timestamp\": \"{{ $now.valueOf() }}\",\n \"X-Signature\": \"enter_your_access_key\"\n}", "sendHeaders": true, "specifyBody": "json", "specifyHeaders": "json" }, "position": [ 2160, 288 ] }, { "id": "b45702da-c2c7-411b-a9b6-adeb511b37f4", "name": "Result Processor", "type": "code", "params": { "jsCode": " var data = $node['Laiye ADP HTTP Request'].json.data.extraction_result; var mainFields = {};\n var detailHeaders = []; \n var detailRows = [];\n\n for (var i = 0; i < data.length; i++) {\n if (data[i].table_values == null) {\n var name = data[i].field_name;\n var val = 'No Result';\n if (data[i].field_values && data[i].field_values[0]) {\n val = data[i].field_values[0].field_value || 'No Result';\n }\n mainFields[name] = val;\n } else {\n for (var j = 0; j < data[i].table_values[0].length; j++) {\n detailHeaders.push(data[i].table_values[0][j].field_name);\n }\n for (var k = 0; k < data[i].table_values.length; k++) {\n var row = [];\n for (var m = 0; m < data[i].table_values[k].length; m++) {\n var cell = 'No Result';\n if (data[i].table_values[k][m].field_values && data[i].table_values[k][m].field_values[0]) {\n cell = data[i].table_values[k][m].field_values[0].field_value || 'No Result';\n }\n row.push(cell);\n }\n detailRows.push(row);\n }\n }\n }\n\n var keys = Object.keys(mainFields);\n var vals = Object.values(mainFields);\n\n var xml = '';\n xml = xml + '';\n xml = xml + '';\n xml = xml + '';\n xml = xml + '';\n for (var n = 0; n < keys.length; n++) {\n xml = xml + '' + keys[n] + '';\n }\n xml = xml + '';\n xml = xml + '';\n for (var p = 0; p < vals.length; p++) {\n xml = xml + '' + vals[p] + '';\n }\n xml = xml + '';\n xml = xml + '

';\n\n if (detailHeaders.length > 0) {\n xml = xml + '';\n xml = xml + '';\n for (var q = 0; q < detailHeaders.length; q++) {\n xml = xml + '' + detailHeaders[q] + '';\n }\n xml = xml + '';\n for (var r = 0; r < detailRows.length; r++) {\n xml = xml + '';\n for (var s = 0; s < detailRows[r].length; s++) {\n xml = xml + '' + detailRows[r][s] + '';\n }\n xml = xml + '';\n }\n xml = xml + '

';\n }\n\n xml = xml + '';\n\n return [{\n binary: {\n data: {\n data: Buffer.from(xml, 'utf-8').toString('base64'),\n mimeType: 'application/vnd.ms-excel',\n fileName: 'data.xls'\n }\n }\n }];" }, "position": [ 2368, 288 ] }, { "id": "d2224313-0c64-4b3e-9d0d-327e184eff88", "name": "Upload the extracted result document", "type": "integration", "params": { "name": "=n8n_laiye_adp_{{ $('Gmail Trigger').item.json.from.value[0].name }}_{{ $('Filter documents').item.json.attachment_name }}", "driveId": { "__rl": true, "mode": "list", "value": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "id", "value": "={{ $json.id }}" }, "operation": "read", "inputDataFieldName": "=data" }, "position": [ 2592, 288 ] }, { "id": "3b44154e-b2cb-45c7-8b89-84584a0681e8", "name": "Create a pending folder", "type": "integration", "params": { "name": "Untreated document", "driveId": { "__rl": true, "mode": "list", "value": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "list", "value": "root", "cachedResultName": "/ (Root folder)" }, "resource": "folder", "operation": "read" }, "position": [ 1952, 640 ] } ] }

Extract invoices from Gmail with Laiye ADP and save them to Google Drive