Stripe 결제에서 고객에게 템플릿 자동 전달
고급
이것은CRM, Multimodal AI분야의자동화 워크플로우로, 44개의 노드를 포함합니다.주로 If, Code, Gmail, Merge, Filter 등의 노드를 사용하며. 사용Stripe、GPT-4o및Gmail의자동화模板交付系统
사전 요구사항
- •Google 계정 및 Gmail API 인증 정보
- •Stripe API Key
- •대상 API의 인증 정보가 필요할 수 있음
- •Google Sheets API 인증 정보
- •OpenAI API Key
사용된 노드 (44)
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"id": "9CwyEVbg21ZQratp",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "Automate Template Delivery to Customers from Stripe Payments",
"tags": [],
"nodes": [
{
"id": "efc2eba5-5d82-44f0-812c-706e23a06b30",
"name": "Azure OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
2512,
1472
],
"parameters": {
"model": "gpt-4o-mini",
"options": {}
},
"credentials": {
"azureOpenAiApi": {
"id": "C3WzT18XqF8OdVM6",
"name": "Azure Open AI account"
}
},
"typeVersion": 1
},
{
"id": "9ea2dde1-5ace-4dbb-8e9c-6303f05fee4b",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2672,
1472
],
"parameters": {
"jsonSchemaExample": "{\n\t\"Subject\": \"\",\n\t\"Body\": \"\"\n}"
},
"typeVersion": 1.3
},
{
"id": "c32e339f-f9f6-4d9a-bce0-dff7d4d9f07f",
"name": "Azure OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
688,
1472
],
"parameters": {
"model": "gpt-4o-mini",
"options": {}
},
"credentials": {
"azureOpenAiApi": {
"id": "C3WzT18XqF8OdVM6",
"name": "Azure Open AI account"
}
},
"typeVersion": 1
},
{
"id": "10aa26f0-0725-495f-89bc-2a10da48df23",
"name": "Structured Output Parser1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
944,
1472
],
"parameters": {
"jsonSchemaExample": "{\n \"row_number\":\"\",\n \"Name\":\"\",\n \"Google Drive Link\":\"\",\n \"Password\":\"\"\n}\n"
},
"typeVersion": 1.3
},
{
"id": "a4c6fb7f-36b1-4d8d-b6dc-008f806306a9",
"name": "Google Sheets에서 시트 행 가져오기",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
816,
1472
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/16RTZT1Hp7CW_kK455DZz1EtGjZ1aDNmOVmIo2jKrlrg/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "16RTZT1Hp7CW_kK455DZz1EtGjZ1aDNmOVmIo2jKrlrg",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/16RTZT1Hp7CW_kK455DZz1EtGjZ1aDNmOVmIo2jKrlrg/edit?usp=drivesdk",
"cachedResultName": "n8n Automations - Zip Files"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "s4dP1fNuVZ2gWvs3",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9152cb4e-8636-4313-aa52-f551c8a9d42b",
"name": "결제 의도 가져오기(청구 기준)",
"type": "n8n-nodes-base.httpRequest",
"position": [
-656,
1296
],
"parameters": {
"url": "=https://api.stripe.com/v1/payment_intents/{{ $json[\"payment_intent\"] }}",
"options": {},
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/x-www-form-urlencoded"
}
]
},
"nodeCredentialType": "stripeApi"
},
"credentials": {
"stripeApi": {
"id": "nsMKPaLthyR80OZO",
"name": "Stripe account Techdome"
}
},
"typeVersion": 4.1
},
{
"id": "32405012-4ca8-496c-89ea-086c3f980e21",
"name": "제품 상세 정보 가져오기(결제 의도 기준)",
"type": "n8n-nodes-base.httpRequest",
"position": [
-208,
1216
],
"parameters": {
"url": "=https://api.stripe.com/v1/products/{{ $json[\"payment_details\"][\"order_reference\"] }}",
"options": {},
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/x-www-form-urlencoded"
}
]
},
"nodeCredentialType": "stripeApi"
},
"credentials": {
"stripeApi": {
"id": "nsMKPaLthyR80OZO",
"name": "Stripe account Techdome"
}
},
"typeVersion": 4.1
},
{
"id": "67670bdd-0ca6-404e-9127-d57d3d44f606",
"name": "If1",
"type": "n8n-nodes-base.if",
"position": [
-432,
1216
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7fe75739-2112-47bb-80b0-e6559db651af",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json[\"payment_details\"][\"order_reference\"] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "fdcc6c45-3d67-4e21-8c3b-dbcafe8ff891",
"name": "고객 매칭",
"type": "n8n-nodes-base.code",
"position": [
1600,
1264
],
"parameters": {
"jsCode": "// For n8n Code Node\n// This matches automations with charges based on product name\ntry {\n // Get all input items\n const items = $input.all();\n \n // Initialize arrays\n let automationsList = [];\n let chargesList = [];\n \n // Separate automations and charges from all items\n items.forEach(item => {\n const data = item.json;\n \n // Check if it's an automation (has output with Name)\n if (data.output && data.output.Name) {\n automationsList.push(data.output);\n }\n // Check if it's a charge (has customer_name and payment_intent)\n else if (data.customer_name && data.payment_intent) {\n chargesList.push(data);\n }\n });\n \n // Filter successful charges only\n const successfulCharges = chargesList.filter(charge => {\n return charge && charge.status === \"succeeded\";\n });\n \n // Match automations with charges based on product name\n const matchedResults = [];\n \n successfulCharges.forEach(charge => {\n // Find matching automation by comparing names\n // Remove [n8n] suffix and trim for comparison\n const chargeProdName = (charge.product_name || \"\").replace(/\\s*\\[n8n\\]\\s*$/i, \"\").trim();\n \n const matchingAutomation = automationsList.find(automation => {\n const autoName = (automation.Name || \"\").replace(/\\s*\\[n8n\\]\\s*$/i, \"\").trim();\n return autoName === chargeProdName;\n });\n \n if (matchingAutomation) {\n matchedResults.push({\n // Automation Info\n automationName: matchingAutomation.Name || \"Unknown\",\n automationRow: matchingAutomation.row_number || \"\",\n googleDriveLink: matchingAutomation[\"Google Drive Link\"] || \"\",\n password: matchingAutomation.Password || \"\",\n \n // Customer Info\n customerName: charge.customer_name || \"Unknown\",\n customerEmail: charge.email || \"\",\n \n // Payment Info\n amount: charge.amount ? (charge.amount / 100).toFixed(2) : \"0.00\",\n currency: (charge.currency || \"usd\").toUpperCase(),\n paymentIntent: charge.payment_intent || \"\",\n orderReference: charge.order_reference || \"\",\n productName: charge.product_name || \"\",\n purchaseDate: charge.created ? \n new Date(charge.created * 1000).toLocaleDateString() : \"\",\n status: charge.status || \"unknown\",\n receiptUrl: charge.receipt_url || \"\"\n });\n }\n });\n \n // Return results\n if (matchedResults.length > 0) {\n return matchedResults;\n } else {\n return [{\n error: \"No matching data found\",\n automations_found: automationsList.length,\n charges_found: successfulCharges.length,\n automation_names: automationsList.map(a => a.Name),\n charge_product_names: successfulCharges.map(c => c.product_name)\n }];\n }\n \n} catch (error) {\n return [{\n error: error.message,\n stack: error.stack\n }];\n}"
},
"typeVersion": 2
},
{
"id": "5f3a1fc9-950c-430a-adbb-c52c3cf09001",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
1520
],
"parameters": {
"height": 192,
"content": "## Stripe Data Collection\n\n💳 Get many charges (Stripe)\nFetches all charge data from Stripe; later filtered to keep only completed payments."
},
"typeVersion": 1
},
{
"id": "5490051b-e8df-49df-b7ba-2c08a1f61fd4",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-992,
1168
],
"parameters": {
"height": 176,
"content": "## Filter – Successful Charges\n\n🔍 Status check = succeeded\nRemoves failed/pending charges so only paid orders continue."
},
"typeVersion": 1
},
{
"id": "67c268a3-8f66-440a-9f0b-b1aa78dc9b37",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
2832,
1040
],
"parameters": {
"height": 192,
"content": "## Send a message (Gmail)\n\n📨 Email dispatch\nSends the AI-generated subject and HTML body to the customer’s email."
},
"typeVersion": 1
},
{
"id": "d54a6b39-c931-4b53-96b4-b34583c9bd77",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2464,
1008
],
"parameters": {
"height": 208,
"content": "## AI Agent – Email Composer\n\n🧩 Personalized HTML email\nUses Azure OpenAI (GPT-4o-mini) to craft thank-you emails with access link, password, onboarding tip, and sign-off."
},
"typeVersion": 1
},
{
"id": "d4e83f8c-097e-4ed7-8e71-a5a6a461064d",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
2224,
1568
],
"parameters": {
"height": 208,
"content": "## Loop Over Items of New Purchases\n\n🔁 Batch sender\nIterates through each new purchase record for email generation & delivery."
},
"typeVersion": 1
},
{
"id": "4856afcc-8641-441e-92f1-57116d973120",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2048,
1136
],
"parameters": {
"height": 192,
"content": "## Check Automation Exists\n\n⚡ Final guard\nVerifies automation data is present before generating and sending emails."
},
"typeVersion": 1
},
{
"id": "33dfa14b-73b4-4318-8d03-9befa25b9aff",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1872,
1520
],
"parameters": {
"height": 208,
"content": "## SQL Combine\n\n🧮 Exclude already-logged customers\nSQL logic filters out rows already present in the purchase sheet."
},
"typeVersion": 1
},
{
"id": "c319fec4-bf8d-41fc-86e4-07382ff176f3",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
992
],
"parameters": {
"height": 256,
"content": "## Customer Matching \n\n🧠 Product-name matcher\nMatches successful Stripe charges to automation rows (handles “[n8n]” suffix and trims). Outputs final, ready-to-email JSON."
},
"typeVersion": 1
},
{
"id": "b85be8c6-11f0-4505-b9a7-9a32fa6f65f4",
"name": "Sticky Note14",
"type": "n8n-nodes-base.stickyNote",
"position": [
1552,
1632
],
"parameters": {
"height": 224,
"content": "## Get row(s) in sheet – Purchase Sheet Lookup\n\n🧾 De-dup check\nReads existing entries in “Automation Purchase Sheet” to avoid logging duplicates."
},
"typeVersion": 1
},
{
"id": "d179d8ba-eef0-44fa-aedf-ccf3b33a9c01",
"name": "Sticky Note15",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
1536
],
"parameters": {
"height": 224,
"content": "## Combine Stripe + Sheet Data\n\n🔄 Stripe × Sheet join\nBrings together payment info and automation metadata for a complete record."
},
"typeVersion": 1
},
{
"id": "c9b30bd0-9bbd-4b47-baca-cac27d5325a5",
"name": "Sticky Note16",
"type": "n8n-nodes-base.stickyNote",
"position": [
1056,
1040
],
"parameters": {
"height": 192,
"content": "## Check Match Found\n\n🧮 Sheet match gate\nOnly proceeds when a valid row is found for the purchased automation."
},
"typeVersion": 1
},
{
"id": "cde55b8d-7bcd-47ba-8dbe-951379b80421",
"name": "Sticky Note17",
"type": "n8n-nodes-base.stickyNote",
"position": [
688,
992
],
"parameters": {
"height": 224,
"content": "## AI Agent → Google Sheets Lookup\n\n🔍 Automation metadata lookup\nFinds matching automation by product/Name in “n8n Automations – Zip Files” sheet."
},
"typeVersion": 1
},
{
"id": "fcae0ff6-e228-4d88-8542-0f5744b565bd",
"name": "Sticky Note18",
"type": "n8n-nodes-base.stickyNote",
"position": [
384,
1520
],
"parameters": {
"height": 224,
"content": "## Check Required Fields\n\n🚦 Field validation\nEnsures order_reference, product_name, customer_name, and email are present before moving on."
},
"typeVersion": 1
},
{
"id": "b1d8bcf2-3dd1-4a4d-8c22-dbfb9134432e",
"name": "Sticky Note19",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
1104
],
"parameters": {
"height": 240,
"content": "## Merge Logic Format Data\n\n🧠 Normalize fields\nBuilds clean JSON (customer_name, email, product_name, amount, currency, status, receipt_url, created)."
},
"typeVersion": 1
},
{
"id": "df357cd7-5b94-4e8c-a92d-2d9193ff996a",
"name": "Sticky Note20",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
1568
],
"parameters": {
"height": 240,
"content": "## Merge Charge + PaymentIntent + Product\n\n🔄 Data merge hub\nCombines charge + payment_intent + product into one unified record per purchase."
},
"typeVersion": 1
},
{
"id": "301434a7-ad34-4353-8c80-cc20088faa1c",
"name": "Sticky Note21",
"type": "n8n-nodes-base.stickyNote",
"position": [
-304,
976
],
"parameters": {
"height": 224,
"content": "## Get Product Details (from Payment Intent)\n\n🧾 Stripe Product fetch\nUses order reference from payment_intent to get product name/description/image."
},
"typeVersion": 1
},
{
"id": "28243790-72e7-4d5b-aca5-874656f8d28f",
"name": "Sticky Note23",
"type": "n8n-nodes-base.stickyNote",
"position": [
-704,
1488
],
"parameters": {
"height": 224,
"content": "## Get Payment Intent (from Charge)\n\n🔗 Stripe Payment Intent lookup\nExpands each charge with its payment_intent details for richer context."
},
"typeVersion": 1
},
{
"id": "4a998670-3a1e-4b28-8455-3dca5114db76",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1568,
1136
],
"parameters": {
"height": 208,
"content": "## Trigger & Data Fetch\n\n🟢 Schedule Trigger\nTriggers every morning (7 AM IST) to fetch latest successful Stripe purchases."
},
"typeVersion": 1
},
{
"id": "c9c2f539-2480-443b-abaa-51a6702d8002",
"name": "Stripe 데이터 수집",
"type": "n8n-nodes-base.stripe",
"position": [
-1104,
1360
],
"parameters": {
"resource": "charge",
"operation": "getAll",
"returnAll": true
},
"credentials": {
"stripeApi": {
"id": "nsMKPaLthyR80OZO",
"name": "Stripe account Techdome"
}
},
"typeVersion": 1
},
{
"id": "07376dc3-6cc0-4d66-9642-a014a71288a7",
"name": "필터 – 성공한 청구",
"type": "n8n-nodes-base.filter",
"position": [
-896,
1392
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e593f4e0-b1e2-4e6b-b4d0-9a1a6e6495bd",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "succeeded"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c72504e0-b292-4a92-9a8f-27c58fe3f525",
"name": "AI 에이전트 → Google Sheets 조회",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
752,
1248
],
"parameters": {
"text": "=This is the input:{{ $json.product_name }}",
"options": {
"systemMessage": "=You are an AI assistant with access to a Google Sheets tool. Your task is as follows: • You will receive an input phrase. This phrase represents a name. • Use the Google Sheets tool to search for a row in the spreadsheet where the value in the “Name” column exactly matches the input phrase. • If a matching row is found, return the entire row as a JSON object, including all columns and their values. • If no matching row is found, respond with: “No matching row found for the provided name.” • If there are multiple matches, return all matching rows as a list of JSON objects. • Do not return any extra commentary or explanation—only the result. • If there is an error accessing the spreadsheet, respond with: “Error accessing the spreadsheet.” Return ONLY a single JSON object with this exact structure: { \"row_number\": \"\", \"Name\": \"\", \"Google Drive Link\": \"\", \"Password\": \"\", \"Date\": \"\" } No additional keys such as “response”, “action”, “output”, or text outside the JSON."
},
"promptType": "define",
"hasOutputParser": true
},
"retryOnFail": true,
"typeVersion": 2.1
},
{
"id": "0e2b02cc-42da-464c-9d18-4423587bc95a",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3184,
1152
],
"parameters": {
"height": 224,
"content": "## Append or update row in sheet For Tracking\n\n📊 Audit & reporting\nLogs each processed purchase and email outcome into “Automation Purchase Sheet”."
},
"typeVersion": 1
},
{
"id": "7e940abd-2bb0-495a-9f34-85705154e90b",
"name": "일일 스케줄 트리거",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1328,
1360
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7
}
]
}
},
"typeVersion": 1.2
},
{
"id": "b8b682e2-af1a-42cc-b373-cadcb5bf46eb",
"name": "청구 + 결제의도 + 제품 병합",
"type": "n8n-nodes-base.merge",
"position": [
16,
1344
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3.2
},
{
"id": "63679dc6-60d4-4057-bd67-01d64787284e",
"name": "병합 로직 데이터 형식화",
"type": "n8n-nodes-base.code",
"position": [
240,
1360
],
"parameters": {
"jsCode": "// Get all combined items\nconst all = $input.all().map(i => i.json);\n\n// Separate by type\nconst charges = all.filter(i => i.object === 'charge');\nconst intents = all.filter(i => i.object === 'payment_intent');\nconst products = all.filter(i => i.object === 'product');\n\n// Merge logic\nconst merged = [];\n\nfor (const charge of charges) {\n const intent = intents.find(i => i.id === charge.payment_intent);\n if (!intent) continue;\n\n const orderRef = intent?.payment_details?.order_reference;\n const product = products.find(p => p.id === orderRef);\n\n merged.push({\n customer_name: charge.billing_details?.name || null,\n email: charge.billing_details?.email || intent.receipt_email || null,\n amount: charge.amount / 100,\n currency: charge.currency,\n status: charge.status,\n payment_intent: charge.payment_intent,\n order_reference: orderRef,\n product_name: product?.name || null,\n product_description: product?.description || null,\n product_image: product?.images?.[0] || null,\n receipt_url: charge.receipt_url,\n created: charge.created\n });\n}\n\nreturn merged.map(item => ({ json: item }));\n"
},
"typeVersion": 2
},
{
"id": "4a9a5f11-44f9-4d5a-b66c-68689384f15d",
"name": "필수 필드 확인",
"type": "n8n-nodes-base.if",
"position": [
464,
1360
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f75a52cc-4555-429f-9edb-f363857eb379",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.order_reference }}",
"rightValue": ""
},
{
"id": "19d2ffe7-b8f7-45db-aa88-ad2aa3124f1c",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.product_name }}",
"rightValue": ""
},
{
"id": "a57d1ffe-7f55-4dee-add1-f314a6cc7dcd",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.customer_name }}",
"rightValue": ""
},
{
"id": "f57743ac-2dd9-44bf-911b-0b1f1e63c17a",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a5a425d6-8c3c-4a2d-a51d-bcfe75706097",
"name": "매칭 결과 확인",
"type": "n8n-nodes-base.if",
"position": [
1152,
1248
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5d49d25f-c987-41c6-bfcb-1eca70253a85",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.output.Name }}",
"rightValue": "="
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f2983b5e-2896-4cd4-867a-04a328d4f797",
"name": "Stripe + 시트 데이터 결합",
"type": "n8n-nodes-base.merge",
"position": [
1376,
1360
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "533a5564-3e14-4c3f-9f1f-47b13141b6d9",
"name": "시트 행 가져오기 – 구매 시트 조회",
"type": "n8n-nodes-base.googleSheets",
"position": [
1600,
1456
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1978602406,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/142qqLXiISod9EzNvulhTOD1eQNOvRw85MtRHP8xcVD4/edit#gid=1978602406",
"cachedResultName": "Automation purchase sheet"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "142qqLXiISod9EzNvulhTOD1eQNOvRw85MtRHP8xcVD4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/142qqLXiISod9EzNvulhTOD1eQNOvRw85MtRHP8xcVD4/edit?usp=drivesdk",
"cachedResultName": "BDE Team Assignee"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "kpPEOLCGn963qpoh",
"name": "automations@techdome.ai"
}
},
"executeOnce": true,
"typeVersion": 4.7
},
{
"id": "8a9d79a9-e004-4fba-b4fa-f12dc5da1d6b",
"name": "SQL 결합",
"type": "n8n-nodes-base.merge",
"position": [
1824,
1360
],
"parameters": {
"mode": "combineBySql",
"query": "SELECT input1.*\nFROM input1\nLEFT JOIN input2\n ON LOWER(TRIM(input1.customerEmail)) = LOWER(TRIM(input2.email))\n OR LOWER(TRIM(input1.customerName)) = LOWER(TRIM(input2.name))\nWHERE input2.email IS NULL\n",
"options": {}
},
"typeVersion": 3.2
},
{
"id": "06de9fee-3f8e-4941-ad12-ddf8f862b9ff",
"name": "자동화 존재 여부 확인",
"type": "n8n-nodes-base.if",
"position": [
2048,
1360
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c882466b-ec98-4ab4-be9e-851cf99a81a7",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.automationName }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "92464fd8-4bda-4c18-a04d-543eb5fd3e72",
"name": "신규 구매 항목 반복 처리",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2272,
1360
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "64adf0d3-1460-4848-90ee-81684b24d7ef",
"name": "AI 에이전트 – 이메일 작성기",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2496,
1248
],
"parameters": {
"text": "=Customer Details: \nName of customer: {{ $json.customerName }}\nEmail of the customer: {{ $json.customerEmail }}\n\nName of the Automation:{{ $json.automationName }}\nGoogle Drive Link: {{ $json.googleDriveLink }}\nPassword: {{ $json.password }} \nPurchase Date:{{ $json.purchaseDate }}",
"options": {
"systemMessage": "=You are an AI email writing assistant specialized in crafting personalized, professional, and heartfelt thank-you emails for customers who have purchased automation templates from Techdome.\n\nYou will receive structured input with the following details:\n- Customer name\n- Customer email\n- Name of the automation purchased\n- Google Drive link to the files\n- Password to access the files\n- Date of purchase\n\nYour goal is to create a beautifully formatted HTML email that:\n1. **Feels human and genuine** — use warm, conversational, and appreciative language.\n2. **Highlights the automation name naturally** — make it feel special, not mechanical.\n3. **Shows gratitude clearly** — thank the customer sincerely for trusting Techdome.\n4. **Includes clear access details**:\n - Add a visible and styled hyperlink to the Google Drive link.\n - Display the password prominently but professionally (bold or highlighted).\n - Add a note to keep it confidential.\n5. **Gives a short onboarding tip** — 1–2 lines about importing or using the automation.\n6. **Encourages further engagement** — invite them to explore other automations or reach out for help.\n7. **Signs off gracefully** from Rahul Joshi (CEO & Co-Founder, Techdome) — include his name and title at the end.\n\n**Tone:** Friendly, confident, and professional — sounding like Rahul personally wrote it.\n\n**Formatting Rules (HTML)**:\n- Use `<p>` for paragraphs, `<b>` for bold, `<a>` for links.\n- Avoid unnecessary line breaks or raw URLs.\n- Keep spacing clean and make it easy to read.\n- Do not use Markdown — only valid HTML.\n\n**Example style:**\n```html\n<p>Dear <b>{{ $json.customerName }}</b>,</p>\n<p>Thank you so much for purchasing the <b>{{ $json.automationName }}</b> automation! We truly appreciate your trust in Techdome.</p>\n<p>You can access your automation files here: <a href=\"{{ $json.googleDriveLink }}\">Access Your Automation Files</a></p>\n<p>Use the password <b>{{ $json.password }} </b> to open the files. Please keep it confidential for your security.</p>\n<p>Once you open the folder, follow the included documentation to import and start using your automation instantly.</p>\n<p>If you need help or wish to explore other automations, feel free to reply to this email — we’d love to assist.</p>\n<p>Warm regards,<br>\n<b>Rahul Joshi</b><br>\nCEO & Co-Founder, Techdome</p>\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "d5d8b09a-306f-4fe1-9773-182f9d62136e",
"name": "메시지 전송(Gmail)",
"type": "n8n-nodes-base.gmail",
"position": [
2848,
1248
],
"webhookId": "b5df4377-15a0-44ba-a55c-92eac22b7a0b",
"parameters": {
"sendTo": "={{ $('Loop Over Items of New Purchases').item.json.customerEmail }}",
"message": "={{ $json.output.Body }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $json.output.Subject }}"
},
"credentials": {
"gmailOAuth2": {
"id": "gEIaWCTvGfYjMSb3",
"name": "Gmail credentials"
}
},
"typeVersion": 2.1
},
{
"id": "1fa862b0-51be-4abb-ac4b-12a6a0ab4000",
"name": "추적을 위한 시트 행 추가 또는 업데이트",
"type": "n8n-nodes-base.googleSheets",
"position": [
3072,
1360
],
"parameters": {
"columns": {
"value": {
"name": "={{ $('Loop Over Items of New Purchases').item.json.customerName }}",
"email": "={{ $('Loop Over Items of New Purchases').item.json.customerEmail }}",
"price": "={{ $('Loop Over Items of New Purchases').item.json.amount }}",
"status": "={{ $('Loop Over Items of New Purchases').item.json.status }}",
"template purchased": "={{ $('Loop Over Items of New Purchases').item.json.automationName }}"
},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "template purchased",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "template purchased",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "price",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "price",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1978602406,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/142qqLXiISod9EzNvulhTOD1eQNOvRw85MtRHP8xcVD4/edit#gid=1978602406",
"cachedResultName": "Automation purchase sheet"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "142qqLXiISod9EzNvulhTOD1eQNOvRw85MtRHP8xcVD4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/142qqLXiISod9EzNvulhTOD1eQNOvRw85MtRHP8xcVD4/edit?usp=drivesdk",
"cachedResultName": "BDE Team Assignee"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "kpPEOLCGn963qpoh",
"name": "automations@techdome.ai"
}
},
"typeVersion": 4.7
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "f4f89bc1-ba79-4144-bf4c-74fe2fe76204",
"connections": {
"67670bdd-0ca6-404e-9127-d57d3d44f606": {
"main": [
[
{
"node": "32405012-4ca8-496c-89ea-086c3f980e21",
"type": "main",
"index": 0
}
]
]
},
"8a9d79a9-e004-4fba-b4fa-f12dc5da1d6b": {
"main": [
[
{
"node": "06de9fee-3f8e-4941-ad12-ddf8f862b9ff",
"type": "main",
"index": 0
}
]
]
},
"a5a425d6-8c3c-4a2d-a51d-bcfe75706097": {
"main": [
[
{
"node": "f2983b5e-2896-4cd4-867a-04a328d4f797",
"type": "main",
"index": 0
}
]
]
},
"fdcc6c45-3d67-4e21-8c3b-dbcafe8ff891": {
"main": [
[
{
"node": "8a9d79a9-e004-4fba-b4fa-f12dc5da1d6b",
"type": "main",
"index": 0
}
]
]
},
"4a9a5f11-44f9-4d5a-b66c-68689384f15d": {
"main": [
[
{
"node": "c72504e0-b292-4a92-9a8f-27c58fe3f525",
"type": "main",
"index": 0
},
{
"node": "f2983b5e-2896-4cd4-867a-04a328d4f797",
"type": "main",
"index": 1
}
]
]
},
"7e940abd-2bb0-495a-9f34-85705154e90b": {
"main": [
[
{
"node": "c9c2f539-2480-443b-abaa-51a6702d8002",
"type": "main",
"index": 0
}
]
]
},
"d5d8b09a-306f-4fe1-9773-182f9d62136e": {
"main": [
[
{
"node": "1fa862b0-51be-4abb-ac4b-12a6a0ab4000",
"type": "main",
"index": 0
}
]
]
},
"c9c2f539-2480-443b-abaa-51a6702d8002": {
"main": [
[
{
"node": "07376dc3-6cc0-4d66-9642-a014a71288a7",
"type": "main",
"index": 0
}
]
]
},
"efc2eba5-5d82-44f0-812c-706e23a06b30": {
"ai_languageModel": [
[
{
"node": "64adf0d3-1460-4848-90ee-81684b24d7ef",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"06de9fee-3f8e-4941-ad12-ddf8f862b9ff": {
"main": [
[
{
"node": "92464fd8-4bda-4c18-a04d-543eb5fd3e72",
"type": "main",
"index": 0
}
]
]
},
"63679dc6-60d4-4057-bd67-01d64787284e": {
"main": [
[
{
"node": "4a9a5f11-44f9-4d5a-b66c-68689384f15d",
"type": "main",
"index": 0
}
]
]
},
"c32e339f-f9f6-4d9a-bce0-dff7d4d9f07f": {
"ai_languageModel": [
[
{
"node": "c72504e0-b292-4a92-9a8f-27c58fe3f525",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"9ea2dde1-5ace-4dbb-8e9c-6303f05fee4b": {
"ai_outputParser": [
[
{
"node": "64adf0d3-1460-4848-90ee-81684b24d7ef",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"10aa26f0-0725-495f-89bc-2a10da48df23": {
"ai_outputParser": [
[
{
"node": "c72504e0-b292-4a92-9a8f-27c58fe3f525",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"64adf0d3-1460-4848-90ee-81684b24d7ef": {
"main": [
[
{
"node": "d5d8b09a-306f-4fe1-9773-182f9d62136e",
"type": "main",
"index": 0
}
]
]
},
"f2983b5e-2896-4cd4-867a-04a328d4f797": {
"main": [
[
{
"node": "fdcc6c45-3d67-4e21-8c3b-dbcafe8ff891",
"type": "main",
"index": 0
},
{
"node": "533a5564-3e14-4c3f-9f1f-47b13141b6d9",
"type": "main",
"index": 0
}
]
]
},
"07376dc3-6cc0-4d66-9642-a014a71288a7": {
"main": [
[
{
"node": "9152cb4e-8636-4313-aa52-f551c8a9d42b",
"type": "main",
"index": 0
},
{
"node": "b8b682e2-af1a-42cc-b373-cadcb5bf46eb",
"type": "main",
"index": 1
}
]
]
},
"9152cb4e-8636-4313-aa52-f551c8a9d42b": {
"main": [
[
{
"node": "67670bdd-0ca6-404e-9127-d57d3d44f606",
"type": "main",
"index": 0
},
{
"node": "b8b682e2-af1a-42cc-b373-cadcb5bf46eb",
"type": "main",
"index": 0
}
]
]
},
"92464fd8-4bda-4c18-a04d-543eb5fd3e72": {
"main": [
[],
[
{
"node": "64adf0d3-1460-4848-90ee-81684b24d7ef",
"type": "main",
"index": 0
}
]
]
},
"c72504e0-b292-4a92-9a8f-27c58fe3f525": {
"main": [
[
{
"node": "a5a425d6-8c3c-4a2d-a51d-bcfe75706097",
"type": "main",
"index": 0
}
]
]
},
"a4c6fb7f-36b1-4d8d-b6dc-008f806306a9": {
"ai_tool": [
[
{
"node": "c72504e0-b292-4a92-9a8f-27c58fe3f525",
"type": "ai_tool",
"index": 0
}
]
]
},
"b8b682e2-af1a-42cc-b373-cadcb5bf46eb": {
"main": [
[
{
"node": "63679dc6-60d4-4057-bd67-01d64787284e",
"type": "main",
"index": 0
}
]
]
},
"32405012-4ca8-496c-89ea-086c3f980e21": {
"main": [
[
{
"node": "b8b682e2-af1a-42cc-b373-cadcb5bf46eb",
"type": "main",
"index": 2
}
]
]
},
"1fa862b0-51be-4abb-ac4b-12a6a0ab4000": {
"main": [
[
{
"node": "92464fd8-4bda-4c18-a04d-543eb5fd3e72",
"type": "main",
"index": 0
}
]
]
},
"533a5564-3e14-4c3f-9f1f-47b13141b6d9": {
"main": [
[
{
"node": "8a9d79a9-e004-4fba-b4fa-f12dc5da1d6b",
"type": "main",
"index": 1
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급 - 고객관계관리, 멀티모달 AI
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
제안 생성_드래프트 저장 자동화
Azure GPT-4o를 사용하여 비즈니스 제안 생성하고 Sheets에서 Gmail 초안으로 저장
If
Code
Gmail
+
If
Code
Gmail
16 노드Rahul Joshi
고객관계관리
Azure OpenAI 및 Google Workspace를 사용한 DEI 자격 심사 자동화
Azure GPT-4o, Google 드라이브 및 스프레드시트를 사용한 DEI 자격 심사 자동화
If
Code
Gmail
+
If
Code
Gmail
19 노드Rahul Joshi
콘텐츠 제작
시각화 참조 라이브러리에서 n8n 노드를 탐색
可视化 참조 라이브러리에서 n8n 노드를 탐색
If
Ftp
Set
+
If
Ftp
Set
113 노드I versus AI
기타
WordPress 블로그 자동화 프로페셔널 에디션(심층 연구) v2.1 마켓
GPT-4o, Perplexity AI 및 다국어 지원을 사용한 SEO 최적화 블로그 생성 자동화
If
Set
Xml
+
If
Set
Xml
125 노드Daniel Ng
콘텐츠 제작
YouTube 비디오 기반 자율 블로그 게시
ChatGPT, Sheets, Apify, Pexels, WordPress를 사용하여 YouTube 비디오를 자동으로 블로그에 게시합니다.
If
Set
Code
+
If
Set
Code
80 노드Oriol Seguí
콘텐츠 제작
GoHighLevel에서 Gmail 및 Slack으로의 고객 갱신 알림 자동 발송
GoHighLevel에서 고객 갱신 알림을 Gmail, Slack, Google Sheets로 자동 발송
If
Code
Gmail
+
If
Code
Gmail
19 노드Rahul Joshi
고객관계관리
워크플로우 정보
난이도
고급
노드 수44
카테고리2
노드 유형15
저자
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
외부 링크
n8n.io에서 보기 →
이 워크플로우 공유