中文网

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

中级

这是一个Ticket Management、Miscellaneous、Multimodal AI领域的自动化工作流，包含 7 个节点。主要使用 If、Set、Webhook、EmailSend、GoogleSheets 等节点。 使用 Google Sheets 和自动邮件的 SME 客户支持工单系统

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

使用的节点 (7 个)

If
Set
Webhook
EmailSend
StickyNote
GoogleSheets

分类

Ticket Management
Miscellaneous
Multimodal AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "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
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

这是一个中级难度的工作流，适用于Ticket Management、Miscellaneous、Multimodal AI等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

自动化潜在客户捕获、AI资质鉴定及ElevenLabs个性化语音跟进
基于 OpenAI 和 ElevenLabs 的自动化线索捕获与 AI 个性化语音跟进
If
Set
Code
+10
22 节点Marth
Lead Nurturing
使用 Google Docs、DocuSign 和 Airtable 自动化合同员工生命周期
通过Google Docs、DocuSign和Airtable自动化合同员工生命周期管理
If
Wait
Slack
+7
16 节点Marth
HR
竞争对手内容差距分析器：自动化网站主题映射
使用Gemini AI、Apify和Google Sheets分析竞争对手内容差距
If
Set
Code
+10
30 节点Mychel Garzon
Miscellaneous
使用 Eleven Labs 和 GPT-4 的自动化音频内容
使用Eleven Labs和GPT-4将博客文章转换为音频内容
If
Set
Gmail
+7
12 节点Marth
Content Creation
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
Miscellaneous
使用Claude AI和自动升级生成共情客户回复
使用Claude AI和自动升级生成共情客户回复
If
Set
Code
+10
21 节点Yusuke
Ticket Management
工作流信息
难度等级
中级
节点数量7
分类3
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Marth

Marth

@marth

Simplifying Business with Smart Automation. I create and share user-friendly, highly efficient n8n workflow templates for SMEs, focusing on digital marketing, sales, and operational excellence. Get ready to automate, innovate, and elevate your business. Connect me on Linkedin for custom solutions.

外部链接
在 n8n.io 上查看 →

分享此工作流