Proposal - ${item.proposalNumber}

{ "edges": [ { "to": "ef43aebf-942b-4a5d-ae55-9647c0a6f690", "from": "18e667ce-b6fa-45b5-afcc-4e39a406850e", "toPort": "0", "fromPort": "0" }, { "to": "1ec57955-95af-4a2d-a53c-0b4b594762a9", "from": "828c5819-e669-4427-8411-91bb506f335a", "toPort": "0", "fromPort": "0" }, { "to": "140d0a87-165f-466b-91d9-faa01147bbf5", "from": "d9a7710c-0502-40a5-9eb7-ba487e50c859", "toPort": "0", "fromPort": "0" }, { "to": "5f8f7b8e-cdf1-4401-be04-e162bcf118c9", "from": "140d0a87-165f-466b-91d9-faa01147bbf5", "toPort": "0", "fromPort": "0" }, { "to": "828c5819-e669-4427-8411-91bb506f335a", "from": "ef43aebf-942b-4a5d-ae55-9647c0a6f690", "toPort": "0", "fromPort": "0" }, { "to": "1bc12998-5f3a-4dd0-afb7-2f8a6fccd8cc", "from": "5f8f7b8e-cdf1-4401-be04-e162bcf118c9", "toPort": "0", "fromPort": "0" }, { "to": "18e667ce-b6fa-45b5-afcc-4e39a406850e", "from": "1bc12998-5f3a-4dd0-afb7-2f8a6fccd8cc", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "d9a7710c-0502-40a5-9eb7-ba487e50c859", "name": "Webhook Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "proposal-generator", "options": {}, "httpMethod": "POST" }, "position": [ -1088, 64 ] }, { "id": "140d0a87-165f-466b-91d9-faa01147bbf5", "name": "Validate Input Data", "type": "code", "params": { "jsCode": "// Validate incoming data\nconst item = $input.first().json;\n\n// Required fields validation\nconst requiredFields = ['clientName', 'clientEmail', 'clientCompany', 'projectTitle'];\nconst missingFields = requiredFields.filter(field => !item[field] || 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.clientEmail)) {\n throw new Error('Invalid email format for clientEmail');\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 item.items[i].amount = lineItem.amount || (lineItem.quantity * lineItem.rate);\n}\n\n// Calculate totals\nitem.subtotal = item.subtotal || item.items.reduce((sum, lineItem) => sum + lineItem.amount, 0);\nitem.discount = item.discount || 0;\nitem.tax = item.tax || 0;\nitem.total = item.total || (item.subtotal - item.discount + item.tax);\n\n// Generate proposal number if not provided\nif (!item.proposalNumber) {\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() * 1000).toString().padStart(3, '0');\n item.proposalNumber = `PROP-${year}${month}-${random}`;\n}\n\n// Add defaults\nitem.currency = item.currency || 'USD';\nitem.currencySymbol = item.currencySymbol || '$';\nitem.proposalDate = item.proposalDate || new Date().toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' });\nitem.validUntil = item.validUntil || new Date(Date.now() + 30*24*60*60*1000).toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' });\n\nreturn { json: item };" }, "position": [ -864, 64 ] }, { "id": "5f8f7b8e-cdf1-4401-be04-e162bcf118c9", "name": "Enrich with Company Data", "type": "code", "params": { "jsCode": "// Add company branding and additional details\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 // Proposal terms\n paymentTerms: item.paymentTerms || '50% upfront, 50% upon completion',\n deliveryTimeline: item.deliveryTimeline || '4-6 weeks from project kickoff',\n terms: item.terms || 'This proposal is valid for 30 days. Upon acceptance, a detailed contract will be provided. All work will be completed according to agreed specifications and timelines.',\n \n // Client defaults\n clientPhone: item.clientPhone || '',\n clientAddress: item.clientAddress || '',\n clientCity: item.clientCity || ''\n};\n\nreturn { json: { ...item, ...companyDefaults } };" }, "position": [ -656, 64 ] }, { "id": "1bc12998-5f3a-4dd0-afb7-2f8a6fccd8cc", "name": "Generate Professional HTML", "type": "code", "params": { "jsCode": "// Generate professional HTML proposal\nconst item = $input.first().json;\n\nconst html = `\n\n\n\n \n \n Proposal - ${item.proposalNumber}\n \n\n\n

\n \n\n

Prepared For

${item.clientName}

${item.clientCompany}

${item.clientEmail}

\n ${item.clientPhone ? `

${item.clientPhone}

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

${item.clientAddress}

` : ''}\n

Proposal Details

Proposal #: ${item.proposalNumber}

Date: ${item.proposalDate}

Valid Until: ${item.validUntil}

\n\n

${item.projectTitle}

${item.projectDescription || 'Professional services as discussed.'}

\n\n

Investment Breakdown

\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.discount > 0 ? `

Discount:-${item.currencySymbol}${item.discount.toFixed(2)}

` : ''}\n ${item.tax > 0 ? `

Tax:${item.currencySymbol}${item.tax.toFixed(2)}

` : ''}\n

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

\n\n

Terms & Conditions

\n Payment Terms:\n

${item.paymentTerms}

\n Delivery Timeline:\n

${item.deliveryTimeline}

\n Additional Terms:\n

${item.terms}

\n\n \n

\n\n\n`;\n\nreturn {\n json: {\n html: html,\n proposalNumber: item.proposalNumber,\n clientName: item.clientName,\n clientEmail: item.clientEmail,\n clientCompany: item.clientCompany,\n total: item.total,\n currency: item.currency,\n fileName: `Proposal_${item.proposalNumber}_${item.clientCompany.replace(/[^a-zA-Z0-9]/g, '_')}.pdf`,\n ...item\n }\n};" }, "position": [ -432, 64 ] }, { "id": "ef43aebf-942b-4a5d-ae55-9647c0a6f690", "name": "Save to Google Drive", "type": "integration", "params": { "name": "={{ $('Generate Professional 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": [ -16, 64 ] }, { "id": "1ec57955-95af-4a2d-a53c-0b4b594762a9", "name": "Notify Team (Slack)", "type": "http", "params": { "url": "https://hooks.slack.com/services/YOUR/SLACK/WEBHOOK", "options": {}, "jsonBody": "={\n \"text\": \"✅ New Proposal Sent!\",\n \"blocks\": [\n {\n \"type\": \"section\",\n \"text\": {\n \"type\": \"mrkdwn\",\n \"text\": \"*📨 Proposal Successfully Sent*\\n\\n*Proposal #:* {{ $('Generate Professional HTML').item.json.proposalNumber }}\\n*Client:* {{ $('Generate Professional HTML').item.json.clientCompany }}\\n*Contact:* {{ $('Generate Professional HTML').item.json.clientName }}\\n*Total:* {{ $('Generate Professional HTML').item.json.currency }} {{ $('Generate Professional HTML').item.json.total }}\\n\\n<{{ $('Save to Google Drive').item.json.webViewLink }}|View PDF in Drive>\"\n }\n ]\n ]\n}", "sendBody": true, "specifyBody": "json" }, "position": [ 528, 64 ] }, { "id": "18e667ce-b6fa-45b5-afcc-4e39a406850e", "name": "HTML to PDF", "type": "integration", "params": { "service": "htmlcsstopdf", "operation": "run", "__originalType": "n8n-nodes-htmlcsstopdf.htmlcsstopdf" }, "position": [ -224, 64 ] }, { "id": "828c5819-e669-4427-8411-91bb506f335a", "name": "Send to Client", "type": "integration", "params": { "options": {}, "service": "gmail", "operation": "read" }, "position": [ 208, 64 ] } ] }

${item.companyName}

Prepared For

Proposal Details

${item.projectTitle}

Investment Breakdown

Terms & Conditions

Thank You for Considering Our Proposal!

CRM to professional PDF Proposals with Gmail, Drive & Slack notifications