面向中小企业的简单客户支持自动化（使用 Google Sheets）

• •HTTP Webhook 端点（n8n 会自动生成）
• •Google Sheets API 凭证

{
  "id": "YHlm9XjboxWLxTtn",
  "meta": {
    "instanceId": "a287613f1596da776459594685fbf4e2b4a12124f80ab8c8772f5e37bff103ae"
  },
  "name": "面向中小企业的简单客户支持自动化（使用 Google Sheets）",
  "tags": [],
  "nodes": [
    {
      "id": "3fe2461a-e9d2-4639-b964-e48bd47b0674",
      "name": "提取消息",
      "type": "n8n-nodes-base.set",
      "position": [
        -272,
        -48
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "message",
              "value": "={{$json.message}}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "b5629989-ecee-4602-99a0-8fa6beea24cd",
      "name": "检查分类",
      "type": "n8n-nodes-base.if",
      "position": [
        -80,
        -48
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 1,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "eb30ad70-9456-4ee9-a3b5-71aa16f10c95",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{$json.message}}",
              "rightValue": "refund"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "671017c8-a541-4f89-98c3-b46495bf6901",
      "name": "保存工单",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "range = \"Tickets!A:C\"\nfields = \"Name,Email,Message\"",
      "position": [
        128,
        -144
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "id",
          "value": "\"YOUR_SHEET_ID\""
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "\"YOUR_SHEET_ID\""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": null,
          "name": "YOUR_CREDENTIAL_ID"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "b071a224-8eab-4aad-8520-1857530c77e5",
      "name": "发送确认通知",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        128,
        64
      ],
      "webhookId": "eb75f3dc-1e5c-4c02-a300-70305b1e86be",
      "parameters": {
        "text": "Hello {{$json.name}},\n\nYour ticket has been received. Our team will get back to you shortly.\n\nMessage: {{$json.message}}",
        "options": {},
        "subject": "Support Ticket Received",
        "toEmail": "={{$json.email}}",
        "fromEmail": "support@yourcompany.com"
      },
      "credentials": {
        "smtp": {
          "id": null,
          "name": "YOUR_CREDENTIAL_ID"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "597a8964-4f14-444e-b7a4-c5f5ae70ad3e",
      "name": "捕获工单",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -480,
        -48
      ],
      "webhookId": "00d5cb79-1e2a-4708-a043-b29b8c546d9e",
      "parameters": {
        "path": "customer-support",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "1a71c690-bd4a-4f08-98f0-be34b6216463",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        -176
      ],
      "parameters": {
        "color": 3,
        "width": 912,
        "height": 400,
        "content": "## 流程概览"
      },
      "typeVersion": 1
    },
    {
      "id": "6dacaf8d-cd80-4567-a6ec-b3774ca01b5c",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 912,
        "height": 1856,
        "content": "# 📝 面向中小企业的简化客户支持自动化"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1ceecd9d-caa3-4157-a373-9cf23513e019",
  "connections": {
    "Capture Ticket": {
      "main": [
        [
          {
            "node": "Extract Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Category": {
      "main": [
        [
          {
            "node": "Save Ticket",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Acknowledgement",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Message": {
      "main": [
        [
          {
            "node": "Check Category",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}