8
n8n 中文网amn8n.com

电商运营中心 AI 系统

高级

这是一个CRM领域的自动化工作流,包含 16 个节点。主要使用 If, Gmail, Slack, Webhook, Function 等节点。 使用 Slack、Sheets 和 Gmail 自动化电商订单、库存与反馈

前置要求
  • Google 账号和 Gmail API 凭证
  • Slack Bot Token 或 Webhook URL
  • HTTP Webhook 端点(n8n 会自动生成)
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "ghoRWysWbgmx4gpJ",
  "meta": {
    "instanceId": "a287613f1596da776459594685fbf4e2b4a12124f80ab8c8772f5e37bff103ae",
    "templateCredsSetupCompleted": true
  },
  "name": "电商运营中心 AI 系统",
  "tags": [],
  "nodes": [
    {
      "id": "31e40064-5de4-424d-babe-62a8e83b1738",
      "name": "1. Webhook:新订单",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -144,
        32
      ],
      "webhookId": "641a9127-bd00-405a-a451-87a1d308f5c9",
      "parameters": {},
      "description": "Triggered by a new customer order (e.g., from Shopify/WooCommerce webhook). Copy this Webhook URL into your e-commerce platform's webhook settings for new orders.",
      "typeVersion": 1
    },
    {
      "id": "f0e9c946-a940-4b56-9149-b3179c919c7f",
      "name": "2. 提取订单数据",
      "type": "n8n-nodes-base.function",
      "position": [
        128,
        32
      ],
      "parameters": {},
      "description": "Extracts relevant details from the incoming order data.",
      "typeVersion": 1
    },
    {
      "id": "74cc983a-9289-4ffc-8a97-ea89d9f91321",
      "name": "3. 发送履约通知 (Slack)",
      "type": "n8n-nodes-base.slack",
      "position": [
        368,
        32
      ],
      "parameters": {},
      "description": "Notifies your fulfillment team about the new order.",
      "typeVersion": 1
    },
    {
      "id": "3c46ccbf-17c0-4b49-8242-9c130443a53e",
      "name": "4. 计划触发器 (每日库存检查)",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -144,
        320
      ],
      "parameters": {},
      "description": "Triggers daily to check for low stock products.",
      "typeVersion": 1
    },
    {
      "id": "47c27927-d61d-46b3-b07d-a2ea8cee2c1a",
      "name": "5. 读取库存数据 (Google Sheets)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        128,
        320
      ],
      "parameters": {},
      "description": "Reads product inventory levels from your Google Sheet. Ensure columns like: ProductID, ProductName, StockLevel.",
      "typeVersion": 2
    },
    {
      "id": "15e53d99-ae89-4ebc-b31a-1c55241e01bd",
      "name": "6. 过滤低库存",
      "type": "n8n-nodes-base.function",
      "position": [
        368,
        320
      ],
      "parameters": {},
      "description": "Identifies products with stock levels below a defined threshold.",
      "typeVersion": 1
    },
    {
      "id": "4c2fd977-e174-4e29-8def-9b1e8a8564ea",
      "name": "7. 是否有低库存商品?",
      "type": "n8n-nodes-base.if",
      "position": [
        624,
        320
      ],
      "parameters": {},
      "description": "Checks if any products are low on stock.",
      "typeVersion": 1
    },
    {
      "id": "2dacc683-b5dc-4509-9859-4fa48c9707a2",
      "name": "8. 发送低库存警报 (Slack)",
      "type": "n8n-nodes-base.slack",
      "position": [
        912,
        192
      ],
      "parameters": {},
      "description": "Sends a notification to your inventory/purchasing team.",
      "typeVersion": 1
    },
    {
      "id": "c652fd91-bfe9-4d9a-8ac2-a04231816a4b",
      "name": "9. 无低库存",
      "type": "n8n-nodes-base.noOp",
      "position": [
        912,
        464
      ],
      "parameters": {},
      "description": "Path if no low stock items are found.",
      "typeVersion": 1
    },
    {
      "id": "68d07443-6eec-4f0d-ac35-21b3bc3c0d09",
      "name": "10. Webhook:订单已完成 (延迟)",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -144,
        624
      ],
      "webhookId": "c2cd741a-ee23-4f56-9b0f-f11287c12bd2",
      "parameters": {},
      "description": "Triggered when an order is marked as fulfilled, ideally after a delay (e.g., 3-7 days after delivery). Copy this Webhook URL into your system that tracks order fulfillment status.",
      "typeVersion": 1
    },
    {
      "id": "d0880eff-35a7-4613-8719-49e6fe301ec4",
      "name": "11. 提取客户数据 (反馈)",
      "type": "n8n-nodes-base.function",
      "position": [
        128,
        624
      ],
      "parameters": {},
      "description": "Extracts customer details for sending feedback requests.",
      "typeVersion": 1
    },
    {
      "id": "e13e32a5-a6f5-489c-b049-237f972bb544",
      "name": "12. 发送反馈请求 (Gmail)",
      "type": "n8n-nodes-base.gmail",
      "position": [
        368,
        624
      ],
      "parameters": {},
      "description": "Sends a personalized email to the customer asking for feedback.",
      "typeVersion": 1
    },
    {
      "id": "f4567995-2ffe-47c0-8fe3-c4413bfe0af1",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        272
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "847f36ce-2038-4ece-a5f7-1ddb8fc5639d",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        560
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "e6a18ab0-1702-4cf3-b2b6-bffcde008ebe",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        -48
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "1bc849ca-7ca4-45a4-a40e-ce657c5ccfaa",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        -48
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "ce0e3232-caec-4e57-bf0a-ff8a9badd7c7",
  "connections": {
    "6. Filter Low Stock": {
      "main": [
        [
          {
            "node": "7. If Low Stock Items?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1. Webhook: New Order": {
      "main": [
        [
          {
            "node": "2. Extract Order Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2. Extract Order Data": {
      "main": [
        [
          {
            "node": "3. Send Fulfillment Notification (Slack)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7. If Low Stock Items?": {
      "main": [
        [
          {
            "node": "8. Send Low Stock Alert (Slack)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "9. No Low Stock",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "11. Extract Customer Data (Feedback)": {
      "main": [
        [
          {
            "node": "12. Send Feedback Request (Gmail)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "10. Webhook: Order Fulfilled (Delayed)": {
      "main": [
        [
          {
            "node": "11. Extract Customer Data (Feedback)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5. Read Inventory Data (Google Sheets)": {
      "main": [
        [
          {
            "node": "6. Filter Low Stock",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4. Schedule Trigger (Daily Inventory Check)": {
      "main": [
        [
          {
            "node": "5. Read Inventory Data (Google Sheets)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 客户关系管理

需要付费吗?

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

工作流信息
难度等级
高级
节点数量16
分类1
节点类型9
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
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 查看

分享此工作流