{ "edges": [ { "to": "f12591be-0ef5-4cc5-8232-a9058b77d8b6", "from": "041e2680-0585-43e8-8df3-4a04b3c32fc3", "toPort": "0", "fromPort": "0" }, { "to": "797f431f-2ffd-42fc-afbc-f76b5806af67", "from": "041e2680-0585-43e8-8df3-4a04b3c32fc3", "toPort": "0", "fromPort": "1" }, { "to": "964e6cc9-ff3c-49ab-bda0-ca842e6b380e", "from": "49c0e376-9f63-4ded-8d0c-917cc7ddf652", "toPort": "0", "fromPort": "0" }, { "to": "041e2680-0585-43e8-8df3-4a04b3c32fc3", "from": "c33bd39f-5043-418c-88f9-0aaa8bc25c9d", "toPort": "0", "fromPort": "0" }, { "to": "49c0e376-9f63-4ded-8d0c-917cc7ddf652", "from": "8e9e52fa-654e-4b14-b72f-8c57b70744f7", "toPort": "0", "fromPort": "0" }, { "to": "106b531c-143f-4de7-ba98-8ede691a0d01", "from": "8e9e52fa-654e-4b14-b72f-8c57b70744f7", "toPort": "0", "fromPort": "1" }, { "to": "49c0e376-9f63-4ded-8d0c-917cc7ddf652", "from": "106b531c-143f-4de7-ba98-8ede691a0d01", "toPort": "0", "fromPort": "0" }, { "to": "8e9e52fa-654e-4b14-b72f-8c57b70744f7", "from": "5440a265-819f-42d4-8c26-d83cb51eb219", "toPort": "0", "fromPort": "0" }, { "to": "892471ed-1b8a-427c-a310-0f40ec49b632", "from": "f12591be-0ef5-4cc5-8232-a9058b77d8b6", "toPort": "0", "fromPort": "0" }, { "to": "8d44a126-0a95-4283-ab89-2ebf6e40baa7", "from": "b73e78af-3604-4d70-a583-f0074877a411", "toPort": "0", "fromPort": "0" }, { "to": "8d44a126-0a95-4283-ab89-2ebf6e40baa7", "from": "d5f88019-04c7-43e7-a813-efbb52b954a5", "toPort": "0", "fromPort": "0" }, { "to": "5440a265-819f-42d4-8c26-d83cb51eb219", "from": "585218e8-449a-40da-8ce7-d8157998c2f7", "toPort": "0", "fromPort": "0" }, { "to": "797f431f-2ffd-42fc-afbc-f76b5806af67", "from": "892471ed-1b8a-427c-a310-0f40ec49b632", "toPort": "0", "fromPort": "0" }, { "to": "d5f88019-04c7-43e7-a813-efbb52b954a5", "from": "797f431f-2ffd-42fc-afbc-f76b5806af67", "toPort": "0", "fromPort": "0" }, { "to": "88c6cf59-4ad7-4872-a7b1-116590237115", "from": "797f431f-2ffd-42fc-afbc-f76b5806af67", "toPort": "0", "fromPort": "0" }, { "to": "585218e8-449a-40da-8ce7-d8157998c2f7", "from": "402c4d14-ab30-4baf-85b5-daec4ceb06f4", "toPort": "0", "fromPort": "0" }, { "to": "b73e78af-3604-4d70-a583-f0074877a411", "from": "88c6cf59-4ad7-4872-a7b1-116590237115", "toPort": "0", "fromPort": "0" }, { "to": "8d44a126-0a95-4283-ab89-2ebf6e40baa7", "from": "88c6cf59-4ad7-4872-a7b1-116590237115", "toPort": "0", "fromPort": "1" }, { "to": "c33bd39f-5043-418c-88f9-0aaa8bc25c9d", "from": "964e6cc9-ff3c-49ab-bda0-ca842e6b380e", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "402c4d14-ab30-4baf-85b5-daec4ceb06f4", "name": "WH Receive Invoice Data", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "pennylane-invoice", "options": {}, "httpMethod": "POST", "responseMode": "lastNode" }, "position": [ 272, 32 ] }, { "id": "585218e8-449a-40da-8ce7-d8157998c2f7", "name": "Code Validate Payload", "type": "code", "params": { "jsCode": "// Refs: 'WH Receive Invoice Data'\nconst input = $input.first().json;\n\nconst errors = [];\n\nif (!input.customer_name || input.customer_name.trim() === '') {\n errors.push('customer_name is required');\n}\n\nif (!input.customer_email || !input.customer_email.includes('@')) {\n errors.push('customer_email is required and must be valid');\n}\n\nif (!input.items || !Array.isArray(input.items) || input.items.length === 0) {\n errors.push('items array is required and must contain at least one item');\n} else {\n input.items.forEach((item, i) => {\n if (!item.label) errors.push(`items[${i}].label is required`);\n if (!item.quantity || item.quantity <= 0) errors.push(`items[${i}].quantity must be > 0`);\n if (!item.unit_price || item.unit_price <= 0) errors.push(`items[${i}].unit_price must be > 0`);\n });\n}\n\nif (errors.length > 0) {\n throw new Error('Validation failed: ' + errors.join('; '));\n}\n\nreturn [{\n json: {\n customer_name: input.customer_name.trim(),\n customer_email: input.customer_email.trim().toLowerCase(),\n customer_address: input.customer_address || '',\n customer_postal_code: input.customer_postal_code || '00000',\n customer_city: input.customer_city || 'Non renseigné',\n customer_country: input.customer_country || 'FR',\n items: input.items.map(item => ({\n label: item.label,\n quantity: item.quantity,\n unit_price: item.unit_price,\n vat_rate: item.vat_rate || 'FR_200'\n })),\n due_date: input.due_date || new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toISOString().split('T')[0],\n currency: input.currency || 'EUR',\n payment_conditions: input.payment_conditions || '30_days',\n reference: input.reference || null,\n send_email: input.send_email || false,\n notification_email: input.notification_email || null\n }\n}];" }, "position": [ 528, 32 ] }, { "id": "5440a265-819f-42d4-8c26-d83cb51eb219", "name": "PL Search Customer", "type": "http", "params": { "url": "https://app.pennylane.com/api/external/v2/customers", "options": {}, "sendQuery": true, "authentication": "genericCredentialType", "genericAuthType": "httpHeaderAuth", "queryParameters": { "parameters": [ { "name": "filter", "value": "=[{\"field\":\"emails\",\"operator\":\"in\",\"value\":\"{{ $json.customer_email }}\"}]" } ] } }, "position": [ 832, 32 ] }, { "id": "8e9e52fa-654e-4b14-b72f-8c57b70744f7", "name": "IF Customer Exists", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "85be8afd-6833-43ba-bb7b-305dd91e9a73", "operator": { "type": "number", "operation": "gt" }, "leftValue": "={{ $json.items.length }}", "rightValue": 0 } ] } }, "position": [ 1040, 32 ] }, { "id": "106b531c-143f-4de7-ba98-8ede691a0d01", "name": "PL Create Customer", "type": "http", "params": { "url": "https://app.pennylane.com/api/external/v2/company_customers", "method": "POST", "options": {}, "jsonBody": "={\n \"name\": \"{{ $('Code Validate Payload').item.json.customer_name }}\",\n \"emails\": [\"{{ $('Code Validate Payload').item.json.customer_email }}\"],\n \"billing_address\": {\n \"address\": \"{{ $('Code Validate Payload').item.json.customer_address }}\",\n \"postal_code\": \"{{ $('Code Validate Payload').item.json.customer_postal_code }}\",\n \"city\": \"{{ $('Code Validate Payload').item.json.customer_city }}\",\n \"country_alpha2\": \"{{ $('Code Validate Payload').item.json.customer_country }}\"\n }\n}", "sendBody": true, "specifyBody": "json", "authentication": "genericCredentialType", "genericAuthType": "httpHeaderAuth" }, "position": [ 1248, 128 ] }, { "id": "49c0e376-9f63-4ded-8d0c-917cc7ddf652", "name": "Set Customer ID", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "86d02b7a-27bd-4791-a4aa-02b7429dc7bd", "name": "=customer_id", "type": "string", "value": "={{ $json.id ?? $json.items?.[0]?.id }}" } ] } }, "position": [ 1424, 16 ] }, { "id": "c33bd39f-5043-418c-88f9-0aaa8bc25c9d", "name": "PL Create Invoice", "type": "http", "params": { "url": "https://app.pennylane.com/api/external/v2/customer_invoices", "method": "POST", "options": {}, "jsonBody": "={{ JSON.stringify($json) }}", "sendBody": true, "specifyBody": "json", "authentication": "genericCredentialType", "genericAuthType": "httpHeaderAuth" }, "position": [ 1824, 16 ] }, { "id": "964e6cc9-ff3c-49ab-bda0-ca842e6b380e", "name": "Code Build Invoice Payload", "type": "code", "params": { "jsCode": "// Refs: 'Set Customer ID', 'Code Validate Payload'\nconst data = $('Code Validate Payload').first().json;\nconst customerId = $('Set Customer ID').first().json.customer_id;\n\nconst invoiceLines = data.items.map(item => ({\n label: item.label,\n quantity: item.quantity,\n unit: 'piece',\n raw_currency_unit_price: String(item.unit_price.toFixed(2)),\n vat_rate: item.vat_rate\n}));\n\nconst today = new Date().toISOString().split('T')[0];\n\nconst payload = {\n customer_id: customerId,\n date: today,\n deadline: data.due_date,\n currency: data.currency,\n invoice_lines: invoiceLines,\n draft: false\n};\n\nif (data.reference) {\n payload.external_reference = data.reference;\n}\n\nreturn [{ json: payload }];" }, "position": [ 1648, 16 ] }, { "id": "041e2680-0585-43e8-8df3-4a04b3c32fc3", "name": "IF Send Email", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "de5a2cc8-def5-4777-8369-51caea43256f", "operator": { "type": "boolean", "operation": "true", "singleValue": true }, "leftValue": "={{ $('Code Validate Payload').item.json.send_email }}", "rightValue": "" } ] } }, "position": [ 2064, 16 ] }, { "id": "797f431f-2ffd-42fc-afbc-f76b5806af67", "name": "Code Build Notification", "type": "code", "params": { "jsCode": "// Refs: 'PL Create Invoice', 'Code Validate Payload'\nconst invoice = $('PL Create Invoice').first().json;\nconst data = $('Code Validate Payload').first().json;\n\nconst message = [\n `New invoice created in Pennylane`,\n ``,\n `Customer: ${data.customer_name}`,\n `Invoice: ${invoice.invoice_number}`,\n `Amount: ${invoice.currency_amount_before_tax} EUR HT`,\n `Total TTC: ${invoice.currency_amount} EUR`,\n `Due date: ${data.due_date}`,\n `Status: ${invoice.status}`,\n data.reference ? `Reference: ${data.reference}` : '',\n ``,\n `View: ${invoice.public_file_url || 'N/A'}`\n].filter(Boolean).join('\\n');\n\nreturn [{\n json: {\n message,\n invoice_id: invoice.id,\n invoice_number: invoice.invoice_number,\n amount: invoice.currency_amount,\n customer_name: data.customer_name,\n public_url: invoice.public_file_url || null\n }\n}];" }, "position": [ 2752, 32 ] }, { "id": "d5f88019-04c7-43e7-a813-efbb52b954a5", "name": "SL Send Notification", "type": "integration", "params": { "text": "={{ $json.message }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "", "cachedResultName": "" }, "operation": "read", "otherOptions": {}, "authentication": "oAuth2" }, "position": [ 3296, -112 ] }, { "id": "8d44a126-0a95-4283-ab89-2ebf6e40baa7", "name": "Set Output Response", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "c5fe5a2e-f759-4afd-907f-eacb7251481b", "name": "success", "type": "boolean", "value": true }, { "id": "03e80656-7f61-46cd-98d4-0e7daf6636d3", "name": "invoice_id", "type": "string", "value": "={{ $('Code Build Notification').item.json.invoice_id }}" }, { "id": "0f54ae5d-87d0-473f-9076-3b17bc24ec0d", "name": "invoice_number", "type": "string", "value": "={{ $('Code Build Notification').item.json.invoice_number }}" }, { "id": "878b0587-95ee-4b69-8853-f51c1c356dfa", "name": "amount", "type": "string", "value": "={{ $('Code Build Notification').item.json.amount }}" }, { "id": "ef1c38e7-d845-4604-bb8f-908fcbbe4146", "name": "customer", "type": "string", "value": "={{ $('Code Build Notification').item.json.customer_name }}" }, { "id": "93d69fa3-86ca-4f0b-8db3-94d7177c10cf", "name": "public_url", "type": "string", "value": "={{ $('Code Build Notification').item.json.public_url }}" } ] } }, "position": [ 3648, 32 ] }, { "id": "f12591be-0ef5-4cc5-8232-a9058b77d8b6", "name": "Wait PDF Generation", "type": "passthrough", "params": { "mode": "noOp", "amount": 30 }, "position": [ 2288, -48 ] }, { "id": "892471ed-1b8a-427c-a310-0f40ec49b632", "name": "PL Send Invoice Email", "type": "http", "params": { "url": "=https://app.pennylane.com/api/external/v2/customer_invoices/{{ $('PL Create Invoice').item.json.id }}/send_by_email", "method": "POST", "options": {}, "authentication": "genericCredentialType", "genericAuthType": "httpHeaderAuth" }, "position": [ 2512, -48 ] }, { "id": "b73e78af-3604-4d70-a583-f0074877a411", "name": "GM Send Notification", "type": "integration", "params": { "sendTo": "={{ $('Code Validate Payload').item.json.notification_email }}", "message": "=

New Invoice Created

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Customer	{{ $('Code Build Notification').item.json.customer_name }}
Invoice	{{ $('Code Build Notification').item.json.invoice_number }}
Amount HT	{{ $('PL Create Invoice').item.json.currency_amount_before_tax }} EUR
Total TTC	{{ $('Code Build Notification').item.json.amount }} EUR
Due date	{{ $('Code Validate Payload').item.json.due_date }}
Status	{{ $('PL Create Invoice').item.json.status }}

\n View Invoice PDF\n

Sent automatically by n8n-pennylane-auto-invoicing

", "options": {}, "service": "gmail", "subject": "=[Pennylane] Invoice {{ $('Code Build Notification').item.json.invoice_number }} created for {{ $('Code Build Notification').item.json.customer_name }}", "operation": "read" }, "position": [ 3216, 176 ] }, { "id": "88c6cf59-4ad7-4872-a7b1-116590237115", "name": "IF Has Notification Email", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "94e188dc-d883-4a77-aac1-06b5bed2dbff", "operator": { "type": "string", "operation": "notEmpty", "singleValue": true }, "leftValue": "={{ $('Code Validate Payload').item.json.notification_email }}", "rightValue": "" } ] } }, "position": [ 2992, 96 ] } ] }

Create and send Pennylane invoices from webhook data with Slack and Gmail alerts