{ "edges": [ { "to": "c8b9d669-e0a5-4419-a756-d0e750e18be4", "from": "83a2cc67-11c9-46c8-b71a-3aa545ddbc4a", "toPort": "0", "fromPort": "0" }, { "to": "8b348312-b1b8-4e87-96a8-9657e002d6e1", "from": "a741a432-1c7a-4ddd-bef8-17eb6d673f8e", "toPort": "0", "fromPort": "0" }, { "to": "de5d511e-25c2-4672-9994-8080815de004", "from": "6f53a5d6-982b-4f15-9496-b4ce1c744496", "toPort": "0", "fromPort": "0" }, { "to": "4b757337-eebd-407f-aad8-abaa6823337d", "from": "6f53a5d6-982b-4f15-9496-b4ce1c744496", "toPort": "0", "fromPort": "0" }, { "to": "6f53a5d6-982b-4f15-9496-b4ce1c744496", "from": "b49dda17-46e1-48f3-bc0b-7b97d3af1c12", "toPort": "0", "fromPort": "0" }, { "to": "6f53a5d6-982b-4f15-9496-b4ce1c744496", "from": "fc1ffeb4-2126-493d-80ac-a2ae848f744b", "toPort": "1", "fromPort": "0" }, { "to": "b49dda17-46e1-48f3-bc0b-7b97d3af1c12", "from": "c8b9d669-e0a5-4419-a756-d0e750e18be4", "toPort": "0", "fromPort": "0" }, { "to": "fc1ffeb4-2126-493d-80ac-a2ae848f744b", "from": "c8b9d669-e0a5-4419-a756-d0e750e18be4", "toPort": "0", "fromPort": "0" }, { "to": "a741a432-1c7a-4ddd-bef8-17eb6d673f8e", "from": "de5d511e-25c2-4672-9994-8080815de004", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "b49dda17-46e1-48f3-bc0b-7b97d3af1c12", "name": "Get many customers", "type": "integration", "params": { "limit": 1000, "filters": {}, "service": "quickbooks", "operation": "getAll", "__originalType": "n8n-nodes-base.quickbooks" }, "position": [ 400, -64 ] }, { "id": "c8b9d669-e0a5-4419-a756-d0e750e18be4", "name": "Start Both Branches", "type": "passthrough", "params": { "mode": "noOp" }, "position": [ -64, 160 ] }, { "id": "fc1ffeb4-2126-493d-80ac-a2ae848f744b", "name": "Read Old Customers", "type": "integration", "params": { "options": { "dataLocationOnSheet": { "values": { "range": "A:A", "rangeDefinition": "specifyRangeA1" } } }, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1M4AoRTj6XuBiNC1O901ctC5k1b2w0vxwh-nO5WOS7zM/edit#gid=0", "cachedResultName": "Processed IDs" }, "documentId": { "__rl": true, "mode": "", "value": "1M4AoRTj6XuBiNC1O901ctC5k1b2w0vxwh-nO5WOS7zM" } }, "position": [ 400, 336 ] }, { "id": "83a2cc67-11c9-46c8-b71a-3aa545ddbc4a", "name": "Scheduler", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ -368, 160 ] }, { "id": "a741a432-1c7a-4ddd-bef8-17eb6d673f8e", "name": "Email Template", "type": "code", "params": { "jsCode": "// This code works when \"Execute Once\" is ON.\n// 'items' is an array of all customers from the previous node.\n\nfor (const item of items) {\n const customer = item.json;\n\n // --- 1. Dynamic Personalization Logic ---\n const greeting = customer.GivenName ? `Hello ${customer.GivenName},` : `Hello ${customer.DisplayName},`;\n let openingLine = `We are absolutely thrilled to welcome you to our family!`;\n if (customer.CompanyName) {\n openingLine = `We are absolutely thrilled to welcome ${customer.CompanyName} to our family!`;\n }\n const detailsConfirmation = `\n

\n Display Name: ${customer.DisplayName}
\n Email: ${customer.PrimaryEmailAddr.Address}\n ${customer.BillAddr && customer.BillAddr.City ? `
Location: ${customer.BillAddr.City}, ${customer.BillAddr.CountrySubDivisionCode}` : ''}\n

\n `;\n\n // --- 2. Construct the HTML Email Body ---\n const emailHtml = `\n \n \n \n A Warm Welcome!\n \n \n \n \n \n \n

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

\n $\"Company$ \n

${greeting}

${openingLine}

\n To ensure everything is perfect from the start, we've listed the primary details we have on file for you:\n

\n ${detailsConfirmation}\n \n \n \n \n

\n Explore Your Dashboard\n

Questions? Just reply to this email or contact our support team.

\n \n \n `;\n\n // --- 3. Add the generated HTML to the current item ---\n item.json.emailHtml = emailHtml;\n}\n\n// --- 4. Return all the modified items for the next node ---\nreturn items;" }, "position": [ 1984, 64 ] }, { "id": "6f53a5d6-982b-4f15-9496-b4ce1c744496", "name": "Find New Customers", "type": "integration", "params": { "options": {}, "service": "comparedatasets", "operation": "run", "mergeByFields": { "values": [ { "field1": "Id", "field2": "CustomerIds" } ] }, "__originalType": "n8n-nodes-base.compareDatasets" }, "position": [ 880, 80 ] }, { "id": "de5d511e-25c2-4672-9994-8080815de004", "name": "Log New Customer Details", "type": "integration", "params": { "options": {}, "service": "googleSheets", "fieldsUi": { "fieldValues": [ { "fieldId": "Customer_Name", "fieldValue": "={{ $json.GivenName }}" }, { "fieldId": "Company_Name", "fieldValue": "={{ $json.CompanyName }}" }, { "fieldId": "Email_ID", "fieldValue": "={{ $json.PrimaryEmailAddr.Address }}" }, { "fieldId": "Phone_No", "fieldValue": "={{ $json.PrimaryPhone.FreeFormNumber }}" }, { "fieldId": "Customer_ID", "fieldValue": "={{ $json.Id }}" } ] }, "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": 1652724254, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1M4AoRTj6XuBiNC1O901ctC5k1b2w0vxwh-nO5WOS7zM/edit#gid=1652724254", "cachedResultName": "New Customer Logs" }, "documentId": { "__rl": true, "mode": "id", "value": "1M4AoRTj6XuBiNC1O901ctC5k1b2w0vxwh-nO5WOS7zM" } }, "position": [ 1456, 64 ] }, { "id": "4b757337-eebd-407f-aad8-abaa6823337d", "name": "Log New Customer ID for Tracking", "type": "integration", "params": { "options": {}, "service": "googleSheets", "fieldsUi": { "fieldValues": [ { "fieldId": "CustomerIds", "fieldValue": "={{ $json.Id }}" } ] }, "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1M4AoRTj6XuBiNC1O901ctC5k1b2w0vxwh-nO5WOS7zM/edit#gid=0", "cachedResultName": "Processed IDs" }, "documentId": { "__rl": true, "mode": "id", "value": "1M4AoRTj6XuBiNC1O901ctC5k1b2w0vxwh-nO5WOS7zM" } }, "position": [ 1456, 336 ] }, { "id": "8b348312-b1b8-4e87-96a8-9657e002d6e1", "name": "Send Personalized Welcome Email", "type": "integration", "params": { "html": "={{ $json.emailHtml }}", "options": {}, "service": "smtp", "subject": "=A Warm Welcome to [Your Company Name], {{$json.DisplayName}}!", "toEmail": "={{ $json.PrimaryEmailAddr.Address }}", "fromEmail": "user@example.com", "operation": "read" }, "position": [ 2448, 64 ] } ] }

QuickBooks customer welcome emails with Google Sheets tracking