{ "edges": [ { "to": "63a47401-9647-4fdb-a8ed-457c23fd9e6a", "from": "b85971cf-b0de-482f-aec4-21c1fb5725ea", "toPort": "0", "fromPort": "1" }, { "to": "5432f11d-e880-489f-928c-987215922205", "from": "63a47401-9647-4fdb-a8ed-457c23fd9e6a", "toPort": "0", "fromPort": "0" }, { "to": "40da5167-6e26-4d1a-9de2-7c866738bc7a", "from": "c8a66438-5763-4eda-9084-76c55f921256", "toPort": "0", "fromPort": "0" }, { "to": "4a32e11b-0b14-40d7-aa64-c3a9ca56835c", "from": "ba84ac7c-da4e-452c-9241-190ff673bb78", "toPort": "0", "fromPort": "0" }, { "to": "83e3c23e-3f20-4993-b5b7-d87f0dcfaabc", "from": "00374acb-792e-44cc-80dd-5928fe83be20", "toPort": "0", "fromPort": "0" }, { "to": "5cd6110c-df5b-40f4-a463-7f7f0496c139", "from": "abc44bb7-175c-4a3b-a216-609fb0b0db5e", "toPort": "0", "fromPort": "0" }, { "to": "00374acb-792e-44cc-80dd-5928fe83be20", "from": "b48ab0b4-1747-48a3-8562-807169094255", "toPort": "0", "fromPort": "0" }, { "to": "ba84ac7c-da4e-452c-9241-190ff673bb78", "from": "40da5167-6e26-4d1a-9de2-7c866738bc7a", "toPort": "0", "fromPort": "0" }, { "to": "b85971cf-b0de-482f-aec4-21c1fb5725ea", "from": "5432f11d-e880-489f-928c-987215922205", "toPort": "0", "fromPort": "0" }, { "to": "5432f11d-e880-489f-928c-987215922205", "from": "4a32e11b-0b14-40d7-aa64-c3a9ca56835c", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "4a32e11b-0b14-40d7-aa64-c3a9ca56835c", "name": "Wait until product get deliver", "type": "passthrough", "params": { "mode": "noOp", "unit": "days", "amount": 7 }, "position": [ 1248, 320 ] }, { "id": "83e3c23e-3f20-4993-b5b7-d87f0dcfaabc", "name": "Wait for 2 weeks", "type": "passthrough", "params": { "mode": "noOp", "unit": "days", "amount": 14 }, "position": [ 2688, 240 ] }, { "id": "b48ab0b4-1747-48a3-8562-807169094255", "name": "Format AI response", "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": [ 2336, 240 ] }, { "id": "ba84ac7c-da4e-452c-9241-190ff673bb78", "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": [ 1040, 320 ] }, { "id": "923fc1a9-f06c-41c8-acca-d1f6976b6380", "name": "Get Product Usage Tips", "type": "llm", "params": { "prompt": "", "provider": "openai", "approximated": true }, "position": [ 2032, 240 ] }, { "id": "00374acb-792e-44cc-80dd-5928fe83be20", "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": [ 2512, 240 ] }, { "id": "5a26b805-5130-4de6-b852-91e5e6c48229", "name": "Get Complementary Products", "type": "llm", "params": { "prompt": "", "provider": "openai", "approximated": true }, "position": [ 2864, 240 ] }, { "id": "abc44bb7-175c-4a3b-a216-609fb0b0db5e", "name": "Code in JavaScript", "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": [ 3168, 240 ] }, { "id": "5cd6110c-df5b-40f4-a463-7f7f0496c139", "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": [ 3360, 240 ] }, { "id": "c8a66438-5763-4eda-9084-76c55f921256", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "minutes", "minutesInterval": 2 } ] } }, "position": [ 656, 320 ] }, { "id": "40da5167-6e26-4d1a-9de2-7c866738bc7a", "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, 320 ] }, { "id": "b85971cf-b0de-482f-aec4-21c1fb5725ea", "name": "If", "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": [ 1616, 320 ] }, { "id": "5432f11d-e880-489f-928c-987215922205", "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": [ 1440, 320 ] }, { "id": "63a47401-9647-4fdb-a8ed-457c23fd9e6a", "name": "Wait for a day", "type": "passthrough", "params": { "mode": "noOp", "unit": "days", "amount": 1 }, "position": [ 1808, 416 ] }, { "id": "074ed9a7-b999-44c3-9175-ec15843f8134", "name": "Groq Chat Model", "type": "llm", "params": { "model": "llama-3.3-70b-versatile", "options": {}, "provider": "openai" }, "position": [ 2080, 464 ] }, { "id": "31682f41-9d9f-44c6-8305-e80e0c4e8d6c", "name": "Groq Chat Model1", "type": "llm", "params": { "model": "llama-3.3-70b-versatile", "options": {}, "provider": "openai" }, "position": [ 2912, 448 ] } ] }

Send post-purchase emails from Postgres with Gmail and Groq AI