从 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": "从 Stripe 支付自动交付模板给客户",
"tags": [],
"nodes": [
{
"id": "efc2eba5-5d82-44f0-812c-706e23a06b30",
"name": "Azure OpenAI聊天模型",
"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": "结构化输出解析器",
"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聊天模型1",
"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": "结构化输出解析器1",
"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": "条件判断1",
"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": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
1520
],
"parameters": {
"height": 192,
"content": "## Stripe 数据收集"
},
"typeVersion": 1
},
{
"id": "5490051b-e8df-49df-b7ba-2c08a1f61fd4",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-992,
1168
],
"parameters": {
"height": 176,
"content": "## 筛选 – 成功收费"
},
"typeVersion": 1
},
{
"id": "67c268a3-8f66-440a-9f0b-b1aa78dc9b37",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
2832,
1040
],
"parameters": {
"height": 192,
"content": "## 发送消息（Gmail）"
},
"typeVersion": 1
},
{
"id": "d54a6b39-c931-4b53-96b4-b34583c9bd77",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2464,
1008
],
"parameters": {
"height": 208,
"content": "## AI Agent – 邮件撰写器"
},
"typeVersion": 1
},
{
"id": "d4e83f8c-097e-4ed7-8e71-a5a6a461064d",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
2224,
1568
],
"parameters": {
"height": 208,
"content": "## 循环处理新购买项"
},
"typeVersion": 1
},
{
"id": "4856afcc-8641-441e-92f1-57116d973120",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2048,
1136
],
"parameters": {
"height": 192,
"content": "## 检查自动化是否存在"
},
"typeVersion": 1
},
{
"id": "33dfa14b-73b4-4318-8d03-9befa25b9aff",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1872,
1520
],
"parameters": {
"height": 208,
"content": "## SQL 合并"
},
"typeVersion": 1
},
{
"id": "c319fec4-bf8d-41fc-86e4-07382ff176f3",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
992
],
"parameters": {
"height": 256,
"content": "## 客户匹配"
},
"typeVersion": 1
},
{
"id": "b85be8c6-11f0-4505-b9a7-9a32fa6f65f4",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
1552,
1632
],
"parameters": {
"height": 224,
"content": "## 在表格中获取行 – 购买表格查找"
},
"typeVersion": 1
},
{
"id": "d179d8ba-eef0-44fa-aedf-ccf3b33a9c01",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
1536
],
"parameters": {
"height": 224,
"content": "## 合并 Stripe + 表格数据"
},
"typeVersion": 1
},
{
"id": "c9b30bd0-9bbd-4b47-baca-cac27d5325a5",
"name": "便签16",
"type": "n8n-nodes-base.stickyNote",
"position": [
1056,
1040
],
"parameters": {
"height": 192,
"content": "## 检查是否找到匹配"
},
"typeVersion": 1
},
{
"id": "cde55b8d-7bcd-47ba-8dbe-951379b80421",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
688,
992
],
"parameters": {
"height": 224,
"content": "## AI Agent → Google Sheets 查找"
},
"typeVersion": 1
},
{
"id": "fcae0ff6-e228-4d88-8542-0f5744b565bd",
"name": "便签18",
"type": "n8n-nodes-base.stickyNote",
"position": [
384,
1520
],
"parameters": {
"height": 224,
"content": "## 检查必填字段"
},
"typeVersion": 1
},
{
"id": "b1d8bcf2-3dd1-4a4d-8c22-dbfb9134432e",
"name": "便签19",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
1104
],
"parameters": {
"height": 240,
"content": "## 合并逻辑格式化数据"
},
"typeVersion": 1
},
{
"id": "df357cd7-5b94-4e8c-a92d-2d9193ff996a",
"name": "便签20",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
1568
],
"parameters": {
"height": 240,
"content": "## 合并收费 + 支付意向 + 产品"
},
"typeVersion": 1
},
{
"id": "301434a7-ad34-4353-8c80-cc20088faa1c",
"name": "便签21",
"type": "n8n-nodes-base.stickyNote",
"position": [
-304,
976
],
"parameters": {
"height": 224,
"content": "## 获取产品详情（从支付意向）"
},
"typeVersion": 1
},
{
"id": "28243790-72e7-4d5b-aca5-874656f8d28f",
"name": "便签23",
"type": "n8n-nodes-base.stickyNote",
"position": [
-704,
1488
],
"parameters": {
"height": 224,
"content": "## 获取支付意向（从收费）"
},
"typeVersion": 1
},
{
"id": "4a998670-3a1e-4b28-8455-3dca5114db76",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1568,
1136
],
"parameters": {
"height": 208,
"content": "## 触发器和数据获取"
},
"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 Agent → 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": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3184,
1152
],
"parameters": {
"height": 224,
"content": "## 在表格中追加或更新行用于跟踪"
},
"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 Agent – 邮件撰写器",
"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": {
"If1": {
"main": [
[
{
"node": "Get Product Details (from Payment Intent)",
"type": "main",
"index": 0
}
]
]
},
"SQL Combine": {
"main": [
[
{
"node": "Check Automation Exists",
"type": "main",
"index": 0
}
]
]
},
"Check Match Found": {
"main": [
[
{
"node": "Combine Stripe + Sheet Data",
"type": "main",
"index": 0
}
]
]
},
"Customer matching": {
"main": [
[
{
"node": "SQL Combine",
"type": "main",
"index": 0
}
]
]
},
"Check Required Fields": {
"main": [
[
{
"node": "AI Agent → Google Sheets Lookup",
"type": "main",
"index": 0
},
{
"node": "Combine Stripe + Sheet Data",
"type": "main",
"index": 1
}
]
]
},
"Schedule Trigger Daily": {
"main": [
[
{
"node": "Stripe Data Collection",
"type": "main",
"index": 0
}
]
]
},
"Send a message (Gmail)": {
"main": [
[
{
"node": "Append or update row in sheet For Tracking",
"type": "main",
"index": 0
}
]
]
},
"Stripe Data Collection": {
"main": [
[
{
"node": "Filter – Successful Charges",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent – Email Composer",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Check Automation Exists": {
"main": [
[
{
"node": "Loop Over Items of New Purchases",
"type": "main",
"index": 0
}
]
]
},
"Merge Logic Format Data": {
"main": [
[
{
"node": "Check Required Fields",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "AI Agent → Google Sheets Lookup",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent – Email Composer",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "AI Agent → Google Sheets Lookup",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"AI Agent – Email Composer": {
"main": [
[
{
"node": "Send a message (Gmail)",
"type": "main",
"index": 0
}
]
]
},
"Combine Stripe + Sheet Data": {
"main": [
[
{
"node": "Customer matching",
"type": "main",
"index": 0
},
{
"node": "Get row(s) in sheet – Purchase Sheet Lookup",
"type": "main",
"index": 0
}
]
]
},
"Filter – Successful Charges": {
"main": [
[
{
"node": "Get Payment Intent (From Charge)",
"type": "main",
"index": 0
},
{
"node": "Merge Charge + PaymentIntent + Product",
"type": "main",
"index": 1
}
]
]
},
"Get Payment Intent (From Charge)": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
},
{
"node": "Merge Charge + PaymentIntent + Product",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items of New Purchases": {
"main": [
[],
[
{
"node": "AI Agent – Email Composer",
"type": "main",
"index": 0
}
]
]
},
"AI Agent → Google Sheets Lookup": {
"main": [
[
{
"node": "Check Match Found",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet in Google Sheets": {
"ai_tool": [
[
{
"node": "AI Agent → Google Sheets Lookup",
"type": "ai_tool",
"index": 0
}
]
]
},
"Merge Charge + PaymentIntent + Product": {
"main": [
[
{
"node": "Merge Logic Format Data",
"type": "main",
"index": 0
}
]
]
},
"Get Product Details (from Payment Intent)": {
"main": [
[
{
"node": "Merge Charge + PaymentIntent + Product",
"type": "main",
"index": 2
}
]
]
},
"Append or update row in sheet For Tracking": {
"main": [
[
{
"node": "Loop Over Items of New Purchases",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet – Purchase Sheet Lookup": {
"main": [
[
{
"node": "SQL Combine",
"type": "main",
"index": 1
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客户关系管理, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
提案生成_草稿保存自动化
使用Azure GPT-4o生成商业提案并从Sheets保存为Gmail草稿
If
Code
Gmail
+6
16 节点Rahul Joshi
客户关系管理
使用 Azure OpenAI 和 Google Workspace 自动化 DEI 资格筛选
使用Azure GPT-4o、Google云端硬盘和表格自动进行DEI资格筛选
If
Code
Gmail
+9
19 节点Rahul Joshi
内容创作
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
将服装图片上传到Cloudinary并使用Azure OpenAI (GPT-4o) 记录到工作表
使用GPT-4o、Cloudinary和Google Sheets处理和编目服装图片
Set
Code
Merge
+9
26 节点Rahul Joshi
内容创作
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
基于 YouTube 视频的自主博客发布
使用 ChatGPT、Sheets、Apify、Pexels 和 WordPress 从 YouTube 视频自主发布博客
If
Set
Code
+18
80 节点Oriol Seguí
内容创作
工作流信息
难度等级
高级
节点数量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 查看 →
分享此工作流