{ "edges": [ { "to": "dffda946-f2d4-440b-b401-d2ae9013a203", "from": "f2e95170-467e-43b7-86b3-5b443b67f789", "toPort": "0", "fromPort": "0" }, { "to": "3cd9eb5f-0f9f-4946-a996-d7a54fc34f51", "from": "f2e95170-467e-43b7-86b3-5b443b67f789", "toPort": "0", "fromPort": "1" }, { "to": "690aca95-d69a-4e96-89fb-68c92da121a1", "from": "3cd9eb5f-0f9f-4946-a996-d7a54fc34f51", "toPort": "0", "fromPort": "0" }, { "to": "7bb156f5-ed86-49f5-9512-38d552a41f98", "from": "dffda946-f2d4-440b-b401-d2ae9013a203", "toPort": "0", "fromPort": "0" }, { "to": "8ba50f01-d769-4f65-ba3f-e23ee07c90b1", "from": "2c54f67f-4f7e-4cd8-8647-9079007a1ce9", "toPort": "0", "fromPort": "0" }, { "to": "9d16a835-0279-4404-93ae-def9a202fb28", "from": "823df403-fb23-4ec1-bae5-014a17fd9b3e", "toPort": "0", "fromPort": "0" }, { "to": "2c54f67f-4f7e-4cd8-8647-9079007a1ce9", "from": "adea234b-a3ec-4389-a447-aae6f0da6f4c", "toPort": "0", "fromPort": "0" }, { "to": "e7a7d230-8eb4-45b8-8cc4-4756af647e3d", "from": "ee34d1d3-8db9-4c38-a247-8643da4a8c6f", "toPort": "0", "fromPort": "0" }, { "to": "adea234b-a3ec-4389-a447-aae6f0da6f4c", "from": "8947ca5e-3169-4f57-a612-202237dd6f4c", "toPort": "0", "fromPort": "0" }, { "to": "06d92300-d3bc-4dd7-a492-685ee0b8db77", "from": "8ba50f01-d769-4f65-ba3f-e23ee07c90b1", "toPort": "0", "fromPort": "0" }, { "to": "ee34d1d3-8db9-4c38-a247-8643da4a8c6f", "from": "9d16a835-0279-4404-93ae-def9a202fb28", "toPort": "0", "fromPort": "0" }, { "to": "8947ca5e-3169-4f57-a612-202237dd6f4c", "from": "7bb156f5-ed86-49f5-9512-38d552a41f98", "toPort": "0", "fromPort": "0" }, { "to": "f2e95170-467e-43b7-86b3-5b443b67f789", "from": "690aca95-d69a-4e96-89fb-68c92da121a1", "toPort": "0", "fromPort": "0" }, { "to": "690aca95-d69a-4e96-89fb-68c92da121a1", "from": "e7a7d230-8eb4-45b8-8cc4-4756af647e3d", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "e7a7d230-8eb4-45b8-8cc4-4756af647e3d", "name": "Wait until product get deliver", "type": "passthrough", "params": { "mode": "noOp", "unit": "days", "amount": 7 }, "position": [ -448, 2832 ] }, { "id": "adea234b-a3ec-4389-a447-aae6f0da6f4c", "name": "Wait for 2 weeks", "type": "passthrough", "params": { "mode": "noOp", "unit": "days", "amount": 14 }, "position": [ 992, 2752 ] }, { "id": "ee34d1d3-8db9-4c38-a247-8643da4a8c6f", "name": "Order Placed Ack.", "type": "integration", "params": { "sendTo": "={{ $json.email }}", "message": "=\n\n\n\n

\n \n

Your Order Is Confirmed

\n\n

Hi {{ $json.client_name }},

\n\n

\n Thank you for your purchase! \n We’re happy to let you know that your order for\n {{ $json.product_name }} has been successfully placed.\n

\n\n

\n Estimated Delivery Date: {{ $json.estimated_delivery_date.split('T')[0] }}\n\n

\n\n

\n We’ll notify you once your order is on the way.\n

\n\n

\n If you have any questions, just reply to this email — we’re here to help!\n

\n\n

\n Best regards,
\n Customer Support Team\n

\n\n

\n\n\n\n", "options": {}, "service": "gmail", "subject": "Your Order Is Confirmed ", "operation": "read" }, "position": [ -656, 2832 ] }, { "id": "8947ca5e-3169-4f57-a612-202237dd6f4c", "name": "Send Tips to User", "type": "integration", "params": { "sendTo": "={{ $('Execute a SQL query').item.json.email }}", "message": "=\n\n \n\n

\n\n

\n Get the Best Out of Your {{ $('Execute a SQL query').item.json.product_name }}\n

\n\n

\n Hi Devansh,\n

\n Here are a few practical tips to help you get the most out of your\n {{ $('Execute a SQL query').item.json.product_name }}:\n

\n\n \n

\n {{$json.formattedOutput}}\n

\n\n

\n If you have any questions, just reply to this email — we’re happy to help.\n

\n\n

\n Best regards,
\n Customer Success Team\n

\n\n

\n\n \n\n", "options": {}, "service": "gmail", "subject": "=Getting Started with Your {{ $('Execute a SQL query').item.json.product_name }}", "operation": "read" }, "position": [ 816, 2752 ] }, { "id": "06d92300-d3bc-4dd7-a492-685ee0b8db77", "name": "Send Tips to User1", "type": "integration", "params": { "sendTo": "={{ $('Execute a SQL query').item.json.email }}", "message": "=\n\n\n\n

\n\n

A Perfect Match for Your {{ $('Execute a SQL query').item.json.product_name }}

\n\n

Hi {{ $('Execute a SQL query').item.json.client_name }},

\n\n

\n We hope you’ve been loving your {{ $('Execute a SQL query').item.json.product_name }}! \n

\n\n

\n Based on your purchase, we thought you might find this helpful:\n

\n\n

\n {{$json.formattedOutput}}\n

\n\n

\n Many customers use this together with your current product to get even better results.\n

\n\n

\n If you’d like to know more, just reply to this email — we’d be happy to help!\n

\n\n

\n Warm regards,
\n Product Recommendations Team\n

\n\n

\n\n\n\n", "options": {}, "service": "gmail", "subject": "=You Might Love This with Your {{ $('Execute a SQL query').item.json.product_name }}\n", "operation": "read" }, "position": [ 1664, 2752 ] }, { "id": "823df403-fb23-4ec1-bae5-014a17fd9b3e", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "minutes", "minutesInterval": 2 } ] } }, "position": [ -1040, 2832 ] }, { "id": "9d16a835-0279-4404-93ae-def9a202fb28", "name": "Execute a SQL query", "type": "integration", "params": { "query": "SELECT *\nFROM orders\nWHERE created_at >= NOW() - INTERVAL '2 minute'\nORDER BY created_at ASC;\n", "options": {}, "service": "postgres", "operation": "executeQuery" }, "position": [ -848, 2832 ] }, { "id": "690aca95-d69a-4e96-89fb-68c92da121a1", "name": "Select rows from a table", "type": "integration", "params": { "table": { "__rl": true, "mode": "list", "value": "orders", "cachedResultName": "orders" }, "where": { "values": [ { "value": "={{ $('Execute a SQL query').item.json.order_id }}", "column": "order_id" } ] }, "schema": { "__rl": true, "mode": "list", "value": "public" }, "options": {}, "service": "postgres", "operation": "select" }, "position": [ -256, 2832 ] }, { "id": "3cd9eb5f-0f9f-4946-a996-d7a54fc34f51", "name": "Wait for a day", "type": "passthrough", "params": { "mode": "noOp", "unit": "days", "amount": 1 }, "position": [ 112, 2928 ] }, { "id": "7bb156f5-ed86-49f5-9512-38d552a41f98", "name": "Format AI response3", "type": "code", "params": { "jsCode": "return $input.all().map(item => {\n const original = item.json;\n\n const text = original.output || \"\";\n\n // Split by \"* \" and clean items\n const items = text\n .split(\"* \")\n .map(i => i.trim())\n .filter(i => i.length > 0);\n\n // Build proper HTML list\n const html =\n \"

${i}

\";\n\n // IMPORTANT: merge old data + new field\n return {\n json: {\n ...original,\n formattedOutput: html\n }\n };\n});\n" }, "position": [ 640, 2752 ] }, { "id": "8ba50f01-d769-4f65-ba3f-e23ee07c90b1", "name": "Code in JavaScript1", "type": "code", "params": { "jsCode": "return $input.all().map(item => {\n const original = item.json;\n\n const rawText = original.output || \"\";\n\n // Split on \"* \" bullet\n const items = rawText\n .split('* ')\n .map(i => i.trim())\n .filter(i => i.length > 0);\n\n // Convert to HTML list\n const listItems = items.map(i => `

${i}

`).join('');\n\n return {\n json: {\n ...original, // 👈 preserve email, product_name, etc.\n formattedOutput: `

${listItems}`\n }\n };\n});\n" }, "position": [ 1472, 2752 ] }, { "id": "f2e95170-467e-43b7-86b3-5b443b67f789", "name": "If2", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "0c24df6c-7ff0-4612-8076-7877b8eee733", "operator": { "type": "boolean", "operation": "equals" }, "leftValue": "={{ $json.delivered }}", "rightValue": true } ] } }, "position": [ -80, 2832 ] }, { "id": "dffda946-f2d4-440b-b401-d2ae9013a203", "name": "Message a model", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "" }, "options": {}, "provider": "openai", "responses": { "values": [ { "content": "=You are a customer onboarding assistant.\nYour job is to write concise product usage tips for email.\nFollow these rules strictly:\nDo NOT add any introduction or closing sentence\nDo NOT start with phrases like \"Here is\", \"Here are\", or similar\nMaximum 5 bullet points\nUse \"*\" buttet only\nEach bullet must be one short sentence\nFriendly, clear, and simple tone\nNo emojis\nNo markdown headings\nNo new line chars\nAnd Product is : {{ $('Execute a SQL query').item.json.product_name }}" } ] }, "builtInTools": {} }, "position": [ 336, 2752 ] }, { "id": "2c54f67f-4f7e-4cd8-8647-9079007a1ce9", "name": "Message a model1", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "" }, "options": {}, "provider": "openai", "responses": { "values": [ { "content": "=You are a customer onboarding assistant.\nYour job is to write concise product usage tips for email.\nFollow these rules strictly:\nDo NOT add any introduction or closing sentence\nDo NOT start with phrases like \"Here is\", \"Here are\", or similar\nMaximum 5 bullet points\nUse \"*\" buttet only\nEach bullet must be one short sentence\nFriendly, clear, and simple tone\nNo emojis\nNo markdown headings\nNo new line chars\nAnd Product is : {{ $('Execute a SQL query').item.json.product_name }}" } ] }, "builtInTools": {} }, "position": [ 1184, 2752 ] } ] }

Send post-purchase email sequences with Postgres, Gmail and OpenAI