{ "edges": [ { "to": "c1c7d91e-fba6-4889-9c59-9f6ebea9fbe2", "from": "c8ddfdd5-3799-431c-a8ad-935956bc6c29", "toPort": "0", "fromPort": "0" }, { "to": "6faf7eea-642f-4895-9006-4eae25dd3b86", "from": "595e2868-a63c-4b14-abe1-24f145570ac6", "toPort": "0", "fromPort": "0" }, { "to": "3750061f-b38b-4f3f-894a-ae1ffa1bc385", "from": "595e2868-a63c-4b14-abe1-24f145570ac6", "toPort": "0", "fromPort": "0" }, { "to": "c94a4cbd-8729-455c-902a-12140c5b2a71", "from": "922a11d6-8e04-46a6-8543-a95503462e3e", "toPort": "0", "fromPort": "0" }, { "to": "595e2868-a63c-4b14-abe1-24f145570ac6", "from": "c1c7d91e-fba6-4889-9c59-9f6ebea9fbe2", "toPort": "0", "fromPort": "0" }, { "to": "922a11d6-8e04-46a6-8543-a95503462e3e", "from": "56aceb31-a772-4d06-930e-e9a0ecc0589c", "toPort": "0", "fromPort": "0" }, { "to": "c8ddfdd5-3799-431c-a8ad-935956bc6c29", "from": "c94a4cbd-8729-455c-902a-12140c5b2a71", "toPort": "0", "fromPort": "0" }, { "to": "ef828708-bc98-4797-a8a8-5fc14336d654", "from": "6faf7eea-642f-4895-9006-4eae25dd3b86", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "56aceb31-a772-4d06-930e-e9a0ecc0589c", "name": "Quote Generation Webhook", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "generate-quote", "options": {}, "httpMethod": "POST" }, "position": [ 1424, 144 ] }, { "id": "922a11d6-8e04-46a6-8543-a95503462e3e", "name": "Configure Settings", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "config-1", "name": "airtableBaseId", "type": "string", "value": "YOUR_AIRTABLE_BASE_ID" }, { "id": "config-2", "name": "airtableTableName", "type": "string", "value": "Quotes" }, { "id": "config-3", "name": "businessName", "type": "string", "value": "Your Business Name" }, { "id": "config-4", "name": "businessEmail", "type": "string", "value": "user@example.com" }, { "id": "config-5", "name": "businessAddress", "type": "string", "value": "123 Main Street, City, State 12345" }, { "id": "config-6", "name": "businessPhone", "type": "string", "value": "+1234567890" }, { "id": "config-7", "name": "brandColor", "type": "string", "value": "#2563eb" }, { "id": "config-8", "name": "googleDriveFolderId", "type": "string", "value": "YOUR_GOOGLE_DRIVE_FOLDER_ID" }, { "id": "config-9", "name": "recordId", "type": "string", "value": "={{ $json.body.recordId || $json.query.recordId }}" } ] } }, "position": [ 1712, 144 ] }, { "id": "c94a4cbd-8729-455c-902a-12140c5b2a71", "name": "Read Quote from Airtable", "type": "integration", "params": { "id": "={{ $json.recordId }}", "base": { "__rl": true, "mode": "list", "value": "" }, "table": { "__rl": true, "mode": "name", "value": "={{ $json.airtableTableName }}" }, "options": {}, "service": "airtable", "operation": "read" }, "position": [ 2032, 144 ] }, { "id": "c8ddfdd5-3799-431c-a8ad-935956bc6c29", "name": "Build HTML Quote", "type": "code", "params": { "jsCode": "const config = $('Configure Settings').first().json;\nconst record = $input.first().json;\n\nconst clientName = record['Client Name'] || 'Client';\nconst clientEmail = record['Client Email'] || '';\nconst lineItemsRaw = record['Line Items'] || '';\nconst taxRate = parseFloat(record['Tax Rate'] || '0') / 100;\nconst notes = record['Notes'] || '';\nconst quoteRef = `Q-${Date.now().toString(36).toUpperCase()}`;\nconst today = new Date().toISOString().split('T')[0];\nconst validDays = 30;\nconst validUntil = new Date(Date.now() + validDays * 86400000).toISOString().split('T')[0];\n\n// Parse line items: \"Description | Qty | Price\" per line\nconst lineItems = lineItemsRaw.split('\\n').filter(l => l.trim()).map(line => {\n const parts = line.split('|').map(p => p.trim());\n const description = parts[0] || 'Item';\n const qty = parseInt(parts[1] || '1');\n const price = parseFloat(parts[2] || '0');\n return { description, qty, price, total: qty * price };\n});\n\nconst subtotal = lineItems.reduce((sum, item) => sum + item.total, 0);\nconst tax = subtotal * taxRate;\nconst grandTotal = subtotal + tax;\n\nconst itemRows = lineItems.map((item, i) =>\n `\n ${i + 1}\n ${item.description}\n ${item.qty}\n $${item.price.toFixed(2)}\n $${item.total.toFixed(2)}\n `\n).join('');\n\nconst html = `\n\n\n\n \n\n

Prepared for

${clientName}

${clientEmail}

\n\n \n \n \n \n ${itemRows}\n

#	Description	Qty	Unit Price	Total

\n\n

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

\n Tax (${(taxRate * 100).toFixed(0)}%)\n $${tax.toFixed(2)}\n

\n Total\n $${grandTotal.toFixed(2)}\n

\n\n ${notes ? `

Notes

${notes}

` : ''}\n\n

Thank you for considering ${config.businessName}.

\n\n`;\n\nreturn [{\n json: {\n html,\n clientName,\n clientEmail,\n quoteRef,\n grandTotal: grandTotal.toFixed(2),\n today,\n recordId: config.recordId,\n airtableBaseId: config.airtableBaseId,\n airtableTableName: config.airtableTableName,\n googleDriveFolderId: config.googleDriveFolderId,\n businessName: config.businessName\n }\n}];" }, "position": [ 2336, 144 ] }, { "id": "c1c7d91e-fba6-4889-9c59-9f6ebea9fbe2", "name": "Convert HTML to PDF", "type": "http", "params": { "url": "https://api.pdf.co/v1/pdf/convert/from/html", "method": "POST", "options": { "response": { "response": { "responseFormat": "json" } } }, "jsonBody": "={{ JSON.stringify({ html: $json.html, name: $json.quoteRef + '.pdf', margins: '20px', paperSize: 'A4' }) }}", "sendBody": true, "specifyBody": "json", "authentication": "predefinedCredentialType", "nodeCredentialType": "httpHeaderAuth" }, "position": [ 2656, 144 ] }, { "id": "595e2868-a63c-4b14-abe1-24f145570ac6", "name": "Download PDF File", "type": "http", "params": { "url": "={{ $json.url }}", "options": { "response": { "response": { "responseFormat": "file" } } } }, "position": [ 2880, 144 ] }, { "id": "6faf7eea-642f-4895-9006-4eae25dd3b86", "name": "Save PDF to Google Drive", "type": "integration", "params": { "name": "={{ $('Build HTML Quote').first().json.quoteRef }}.pdf", "driveId": { "__rl": true, "mode": "list", "value": "My Drive" }, "options": {}, "service": "googleDrive", "folderId": { "__rl": true, "mode": "id", "value": "={{ $('Build HTML Quote').first().json.googleDriveFolderId }}" }, "operation": "read" }, "position": [ 3104, 80 ] }, { "id": "3750061f-b38b-4f3f-894a-ae1ffa1bc385", "name": "Email Quote to Client", "type": "integration", "params": { "sendTo": "={{ $('Build HTML Quote').first().json.clientEmail }}", "message": "=

Hi {{ $('Build HTML Quote').first().json.clientName }},

Please find your quote ({{ $('Build HTML Quote').first().json.quoteRef }}) attached. The total is ${{ $('Build HTML Quote').first().json.grandTotal }}.

This quote is valid for 30 days. Please let us know if you have any questions.

Best regards,
{{ $('Build HTML Quote').first().json.businessName }}

", "options": { "attachmentsUi": { "attachmentsBinary": [ {} ] } }, "service": "gmail", "subject": "=Quote {{ $('Build HTML Quote').first().json.quoteRef }} from {{ $('Build HTML Quote').first().json.businessName }}", "operation": "read" }, "position": [ 3104, 288 ] }, { "id": "ef828708-bc98-4797-a8a8-5fc14336d654", "name": "Update Airtable Status", "type": "integration", "params": { "base": { "__rl": true, "mode": "list", "value": "" }, "table": { "__rl": true, "mode": "name", "value": "={{ $('Build HTML Quote').first().json.airtableTableName }}" }, "columns": { "value": { "Status": "Sent", "PDF Link": "={{ $('Save PDF to Google Drive').first().json.webViewLink || '' }}", "Sent Date": "={{ $('Build HTML Quote').first().json.today }}" }, "mappingMode": "defineBelow" }, "options": {}, "service": "airtable", "operation": "update" }, "position": [ 3344, 144 ] } ] }

QUOTE

Generate and email PDF quotes from Airtable via Gmail and Google Drive