Invoice - ${item.invoiceNumber}

{ "edges": [ { "to": "268db052-2990-4760-8cc0-457aa25b3fdc", "from": "fa21eb40-1c81-4c0c-8517-6b3305ba136f", "toPort": "0", "fromPort": "0" }, { "to": "969158b3-3974-4206-a232-f52304683a09", "from": "c14e603f-a354-4d88-acf1-9add2a915a6c", "toPort": "0", "fromPort": "0" }, { "to": "eaa80439-09ea-4ccc-91b1-030cc0b1e149", "from": "3d20247f-67bf-40de-a517-591f63408bcd", "toPort": "0", "fromPort": "0" }, { "to": "f05925be-b9d1-428b-8e0a-a55c29854209", "from": "eaa80439-09ea-4ccc-91b1-030cc0b1e149", "toPort": "0", "fromPort": "0" }, { "to": "bed6dcd1-1c79-4fa9-8ac3-7f65e6168505", "from": "eaa80439-09ea-4ccc-91b1-030cc0b1e149", "toPort": "0", "fromPort": "1" }, { "to": "3d20247f-67bf-40de-a517-591f63408bcd", "from": "268db052-2990-4760-8cc0-457aa25b3fdc", "toPort": "0", "fromPort": "0" }, { "to": "fa21eb40-1c81-4c0c-8517-6b3305ba136f", "from": "232fc78f-fbfd-444e-9a8a-ee9639d9e10d", "toPort": "0", "fromPort": "0" }, { "to": "2624ead6-7e79-4b13-80ba-0a753d39d17b", "from": "969158b3-3974-4206-a232-f52304683a09", "toPort": "0", "fromPort": "0" }, { "to": "232fc78f-fbfd-444e-9a8a-ee9639d9e10d", "from": "2624ead6-7e79-4b13-80ba-0a753d39d17b", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "c14e603f-a354-4d88-acf1-9add2a915a6c", "name": "Webhook Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "invoice-generator", "options": {}, "httpMethod": "POST" }, "position": [ -944, -80 ] }, { "id": "969158b3-3974-4206-a232-f52304683a09", "name": "Validate Invoice Data", "type": "code", "params": { "jsCode": "// Validate incoming invoice data\nconst item = $input.first().json;\n\n// Required fields validation\nconst requiredFields = ['customerName', 'customerEmail', 'items', 'paymentStatus'];\nconst missingFields = requiredFields.filter(field => !item[field] || (typeof item[field] === 'string' && item[field].trim() === ''));\n\n// Validate items array\nif (!item.items || !Array.isArray(item.items) || item.items.length === 0) {\n missingFields.push('items (must be array with at least one item)');\n}\n\nif (missingFields.length > 0) {\n throw new Error(`Missing required fields: ${missingFields.join(', ')}`);\n}\n\n// Validate email format\nconst emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\nif (!emailRegex.test(item.customerEmail)) {\n throw new Error('Invalid email format for customerEmail');\n}\n\n// Validate payment status\nconst validStatuses = ['paid', 'unpaid', 'partial'];\nif (!validStatuses.includes(item.paymentStatus.toLowerCase())) {\n throw new Error('Invalid paymentStatus. Must be: paid, unpaid, or partial');\n}\n\n// Validate and calculate items\nfor (let i = 0; i < item.items.length; i++) {\n const lineItem = item.items[i];\n if (!lineItem.description || !lineItem.quantity || !lineItem.rate) {\n throw new Error(`Item ${i + 1} missing required fields (description, quantity, rate)`);\n }\n \n // Ensure numeric values\n lineItem.quantity = parseFloat(lineItem.quantity);\n lineItem.rate = parseFloat(lineItem.rate);\n \n // Calculate amount\n item.items[i].amount = lineItem.quantity * lineItem.rate;\n}\n\n// Generate invoice number if not provided\nif (!item.invoiceNumber) {\n const date = new Date();\n const year = date.getFullYear();\n const month = String(date.getMonth() + 1).padStart(2, '0');\n const random = Math.floor(Math.random() * 10000).toString().padStart(4, '0');\n item.invoiceNumber = `INV-${year}${month}-${random}`;\n}\n\n// Set invoice date if not provided\nif (!item.invoiceDate) {\n item.invoiceDate = new Date().toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' });\n}\n\n// Calculate due date if not provided (default 30 days)\nif (!item.dueDate) {\n const dueDays = item.paymentTermsDays || 30;\n const dueDate = new Date();\n dueDate.setDate(dueDate.getDate() + dueDays);\n item.dueDate = dueDate.toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' });\n}\n\n// Calculate subtotal\nitem.subtotal = item.items.reduce((sum, lineItem) => sum + lineItem.amount, 0);\n\n// Apply discount if provided\nitem.discountAmount = parseFloat(item.discountAmount) || 0;\nconst afterDiscount = item.subtotal - item.discountAmount;\n\n// Calculate tax (default 18% if not provided)\nitem.taxRate = parseFloat(item.taxRate) || 18;\nitem.taxAmount = (afterDiscount * item.taxRate) / 100;\n\n// Calculate total\nitem.total = afterDiscount + item.taxAmount;\n\n// Set currency defaults\nitem.currency = item.currency || 'USD';\nitem.currencySymbol = item.currencySymbol || '$';\n\n// Payment terms\nitem.paymentTerms = item.paymentTerms || 'Payment due within 30 days';\n\nreturn { json: item };" }, "position": [ -784, -32 ] }, { "id": "2624ead6-7e79-4b13-80ba-0a753d39d17b", "name": "Enrich with Company Data", "type": "code", "params": { "jsCode": "// Add company information and branding\nconst item = $input.first().json;\n\n// Company information (customize these)\nconst companyDefaults = {\n companyName: item.companyName || 'Media Jade',\n companyAddress: item.companyAddress || '456 Company Street',\n companyCity: item.companyCity || 'San Francisco, CA 94105',\n companyEmail: item.companyEmail || 'user@example.com',\n companyPhone: item.companyPhone || '+1234567890',\n companyWebsite: item.companyWebsite || 'www.mediajde.com',\n companyLogo: item.companyLogo || '',\n \n // Tax registration numbers\n taxId: item.taxId || 'TAX-123456789',\n gstNumber: item.gstNumber || 'GST-987654321',\n \n // Bank details for payment\n bankName: item.bankName || 'Chase Bank',\n accountNumber: item.accountNumber || '****1234',\n routingNumber: item.routingNumber || '****5678',\n swiftCode: item.swiftCode || 'CHASUS33',\n \n // Payment links\n paymentLink: item.paymentLink || '',\n \n // Customer defaults\n customerCompany: item.customerCompany || '',\n customerAddress: item.customerAddress || '',\n customerCity: item.customerCity || '',\n customerPhone: item.customerPhone || '',\n \n // Invoice notes\n notes: item.notes || 'Thank you for your business!',\n termsConditions: item.termsConditions || 'Payment is due within the specified terms. Late payments may incur additional charges.'\n};\n\nreturn { json: { ...item, ...companyDefaults } };" }, "position": [ -624, -80 ] }, { "id": "232fc78f-fbfd-444e-9a8a-ee9639d9e10d", "name": "Generate Invoice HTML", "type": "code", "params": { "jsCode": "// Generate professional invoice HTML\nconst item = $input.first().json;\n\n// Payment status styling\nconst getStatusColor = (status) => {\n const colors = {\n 'paid': { bg: '#10b981', text: 'PAID' },\n 'unpaid': { bg: '#ef4444', text: 'UNPAID' },\n 'partial': { bg: '#f59e0b', text: 'PARTIALLY PAID' }\n };\n return colors[status.toLowerCase()] || colors['unpaid'];\n};\n\nconst statusStyle = getStatusColor(item.paymentStatus);\n\nconst html = `\n\n\n\n \n \n Invoice - ${item.invoiceNumber}\n \n\n\n

\n \n\n

Bill To

${item.customerName}

\n ${item.customerCompany ? `

${item.customerCompany}

` : ''}\n

${item.customerEmail}

\n ${item.customerPhone ? `

${item.customerPhone}

` : ''}\n ${item.customerAddress ? `

${item.customerAddress}

` : ''}\n ${item.customerCity ? `

${item.customerCity}

` : ''}\n

Invoice Details

Invoice Date: ${item.invoiceDate}

Due Date: ${item.dueDate}

Payment Terms: ${item.paymentTerms}

\n ${item.purchaseOrderNumber ? `

PO Number: ${item.purchaseOrderNumber}

` : ''}\n

\n\n \n \n \n \n \n \n \n \n \n \n ${item.items.map(lineItem => `\n \n \n \n \n \n \n `).join('')}\n \n

Description	Quantity	Rate	Amount
${lineItem.description}	${lineItem.quantity}	${item.currencySymbol}${lineItem.rate.toFixed(2)}	${item.currencySymbol}${lineItem.amount.toFixed(2)}

\n\n

\n Subtotal:\n ${item.currencySymbol}${item.subtotal.toFixed(2)}\n

\n ${item.discountAmount > 0 ? `\n

\n Discount:\n -${item.currencySymbol}${item.discountAmount.toFixed(2)}\n

\n ` : ''}\n

\n Tax (${item.taxRate}%):\n ${item.currencySymbol}${item.taxAmount.toFixed(2)}\n

\n Total Amount:\n ${item.currencySymbol}${item.total.toFixed(2)}\n

\n\n

💳 Payment Information

Bank Name: ${item.bankName}

Account Number: ${item.accountNumber}

Routing Number: ${item.routingNumber}

\n ${item.swiftCode ? `

SWIFT Code: ${item.swiftCode}

` : ''}\n ${item.taxId ? `

Tax ID: ${item.taxId}

` : ''}\n ${item.gstNumber ? `

GST Number: ${item.gstNumber}

` : ''}\n ${item.paymentLink ? `

💰 Pay Online: ${item.paymentLink}

` : ''}\n

\n\n ${item.notes ? `\n

📝 Notes

${item.notes}

\n ` : ''}\n\n \n

\n\n\n`;\n\nreturn {\n json: {\n html: html,\n invoiceNumber: item.invoiceNumber,\n customerName: item.customerName,\n customerEmail: item.customerEmail,\n total: item.total,\n currency: item.currency,\n paymentStatus: item.paymentStatus,\n fileName: `Invoice_${item.invoiceNumber}_${item.customerName.replace(/[^a-zA-Z0-9]/g, '_')}.pdf`,\n ...item\n }\n};" }, "position": [ -432, -80 ] }, { "id": "fa21eb40-1c81-4c0c-8517-6b3305ba136f", "name": "HTML to PDF", "type": "integration", "params": { "service": "htmlcsstopdf", "operation": "run", "__originalType": "n8n-nodes-htmlcsstopdf.htmlcsstopdf" }, "position": [ -256, -80 ] }, { "id": "268db052-2990-4760-8cc0-457aa25b3fdc", "name": "Save to Google Drive", "type": "integration", "params": { "name": "={{ $('Generate Invoice HTML').item.json.fileName }}", "driveId": { "__rl": true, "mode": "list", "value": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "list", "value": "root" }, "operation": "read" }, "position": [ -96, -80 ] }, { "id": "eaa80439-09ea-4ccc-91b1-030cc0b1e149", "name": "Is Payment Received?", "type": "if", "params": { "conditions": { "string": [ { "value1": "={{ $('Generate Invoice HTML').item.json.paymentStatus }}", "value2": "paid", "operation": "equals" } ] } }, "position": [ 432, -80 ] }, { "id": "f05925be-b9d1-428b-8e0a-a55c29854209", "name": "Notify Team - Paid", "type": "http", "params": { "url": "https://hooks.slack.com/services/YOUR/SLACK/WEBHOOK", "options": {}, "jsonBody": "={\n \"text\": \"✅ Invoice Paid & Delivered!\",\n \"blocks\": [\n {\n \"type\": \"section\",\n \"text\": {\n \"type\": \"mrkdwn\",\n \"text\": \"*💰 Payment Received*\\n\\n*Invoice:* {{ $('Generate Invoice HTML').item.json.invoiceNumber }}\\n*Customer:* {{ $('Generate Invoice HTML').item.json.customerName }}\\n*Amount:* {{ $('Generate Invoice HTML').item.json.currency }} {{ $('Generate Invoice HTML').item.json.total }}\\n*Status:* PAID\\n\\n<{{ $('Save to Google Drive').item.json.webViewLink }}|View Invoice in Drive>\"\n }\n }\n ]\n}", "sendBody": true, "specifyBody": "json" }, "position": [ 656, -176 ] }, { "id": "bed6dcd1-1c79-4fa9-8ac3-7f65e6168505", "name": "Notify Team - Unpaid", "type": "http", "params": { "url": "https://hooks.slack.com/services/YOUR/SLACK/WEBHOOK", "options": {}, "jsonBody": "={\n \"text\": \"⏳ Invoice Sent - Payment Pending\",\n \"blocks\": [\n {\n \"type\": \"section\",\n \"text\": {\n \"type\": \"mrkdwn\",\n \"text\": \"*📤 Invoice Sent*\\n\\n*Invoice:* {{ $('Generate Invoice HTML').item.json.invoiceNumber }}\\n*Customer:* {{ $('Generate Invoice HTML').item.json.customerName }}\\n*Amount:* {{ $('Generate Invoice HTML').item.json.currency }} {{ $('Generate Invoice HTML').item.json.total }}\\n*Status:* {{ $('Generate Invoice HTML').item.json.paymentStatus }}\\n*Due Date:* {{ $('Generate Invoice HTML').item.json.dueDate }}\\n\\n<{{ $('Save to Google Drive').item.json.webViewLink }}|View Invoice in Drive>\"\n }\n }\n ]\n}", "sendBody": true, "specifyBody": "json" }, "position": [ 656, 32 ] }, { "id": "3d20247f-67bf-40de-a517-591f63408bcd", "name": "Send to Customer", "type": "integration", "params": { "options": {}, "service": "gmail", "operation": "read" }, "position": [ 144, -80 ] } ] }

${item.companyName}

Bill To

Invoice Details

💳 Payment Information

📝 Notes

Generate & track invoices with Google Drive, PDF Converter & Gmail