8
n8n 中文网amn8n.com

客户反馈循环分析器

中级

这是一个Miscellaneous, AI Summarization, Multimodal AI领域的自动化工作流，包含 11 个节点。主要使用 Code, Gmail, Slack, Switch, FormTrigger 等节点。 使用AI、Google表格和Slack提醒自动分类客户反馈

前置要求
  • •Google 账号和 Gmail API 凭证
  • •Slack Bot Token 或 Webhook URL
  • •Google Sheets API 凭证
  • •Google Gemini API Key

使用的节点 (11)

Code
Gmail
Slack
Switch
StickyNote
FormTrigger
GmailTrigger
GoogleSheets
LmChatGoogleGemini
InformationExtractor

分类

杂项
AI 摘要总结
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "bAczIXMBSsZulax7",
  "meta": {
    "instanceId": "14e4c77104722ab186539dfea5182e419aecc83d85963fe13f6de862c875ebfa",
    "templateCredsSetupCompleted": true
  },
  "name": "客户反馈循环分析器",
  "tags": [],
  "nodes": [
    {
      "id": "0aeba1ed-f179-4a69-ad06-23bdf6ed1c4d",
      "name": "表单提交时",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        220,
        100
      ],
      "webhookId": "",
      "parameters": {
        "options": {},
        "formTitle": "Customer Review",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Name",
              "requiredField": true
            },
            {
              "fieldLabel": "Review",
              "requiredField": true
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "1e5cb96f-9467-47ab-b060-8600ee901582",
      "name": "Google Gemini 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        528,
        220
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-1.5-flash"
      },
      "credentials": {
        "googlePalmApi": {}
      },
      "typeVersion": 1
    },
    {
      "id": "0c13ebb7-14ba-4c3b-aa44-b2b22ea72c3f",
      "name": "发送报告",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1256,
        100
      ],
      "webhookId": "8d5fae6b-280c-4286-bf3a-d7355617f013",
      "parameters": {
        "sendTo": "",
        "message": "=Your monthly energy report is as follows  {{ $json.url }}",
        "options": {
          "appendAttribution": true
        },
        "subject": "Energy Report",
        "emailType": "text"
      },
      "credentials": {},
      "typeVersion": 2.1
    },
    {
      "id": "d0abc9c5-7591-4f63-b097-f1682ffaa006",
      "name": "Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        1256,
        -100
      ],
      "webhookId": "af63d3d7-1280-4774-b539-2edbf5d0588a",
      "parameters": {
        "text": "=User  {{ $json.candidate_name }} has already applied for {{ $json.role_applied }}",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "select": "user",
        "otherOptions": {}
      },
      "typeVersion": 2.3
    },
    {
      "id": "9151ff73-9062-4bb3-8776-1e299636b9ef",
      "name": "接收评论/反馈",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        0,
        -100
      ],
      "parameters": {
        "filters": {
          "labelIds": [
            "Label_536806471971916762"
          ]
        },
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        }
      },
      "credentials": {},
      "typeVersion": 1.2
    },
    {
      "id": "c4312796-7756-4a1a-bad8-5af5f2377b69",
      "name": "提取详细信息",
      "type": "n8n-nodes-base.code",
      "position": [
        220,
        -100
      ],
      "parameters": {
        "jsCode": "    const fromEmail = $input.first().json.From // Assuming 'from' field holds the full \"From\" string\n    let name = '';\n\n    // Check if the name is enclosed in angle brackets\n    if (fromEmail.includes('<') && fromEmail.includes('>')) {\n        name = fromEmail.substring(0, fromEmail.indexOf('<')).trim();\n    } else {\n        // If no angle brackets, assume the whole \"From\" field is the name\n        name = fromEmail.trim();\n    }\n\n    return { json: { name: name ,Review : $input.first().json.snippet} };"
      },
      "typeVersion": 2
    },
    {
      "id": "e1525399-3ac3-4dc0-8b9b-79261b2f9c63",
      "name": "转换与总结",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        440,
        0
      ],
      "parameters": {
        "text": "={{ $json.Review }}",
        "options": {
          "systemPromptTemplate": "=You are a feedback analyst. Categorize the following user feedback into one of:\n- Bug\n- Feature Request\n- UX Issue\n- Other\n\nAlso extract the core complaint or suggestion in a concise sentence.\n\nFeedback:  {{ $json.Review }}"
        },
        "schemaType": "fromJson",
        "jsonSchemaExample": "{\n  \"category\": \"Feature Request\",\n  \"summary\": \"User wants dark mode support\",\n  \"sentiment\": \"Positive\",\n  \"Feedback text\": \"Original review\"\n\n}"
      },
      "typeVersion": 1.1
    },
    {
      "id": "13155178-e7b0-4329-95b5-eddd560d0fe5",
      "name": "审查数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        816,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "summary": "={{ $json.output.summary }}",
            "category": "={{ $json.output.category }}",
            "Timestamp": "={{ $json.output.Timestamp }}",
            "sentiment": "={{ $json.output.sentiment }}",
            "Feedback text": "={{ $json.output[\"Feedback text\"] }}"
          },
          "schema": [
            {
              "id": "category",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "category",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "summary",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "sentiment",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "sentiment",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Feedback text",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Feedback text",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Timestamp",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "output"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {},
        "documentId": {}
      },
      "credentials": {},
      "typeVersion": 4.6
    },
    {
      "id": "66b9626b-dd32-4e12-8eda-1a85f8436a40",
      "name": "分类",
      "type": "n8n-nodes-base.switch",
      "position": [
        1036,
        0
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "f245286d-696d-43c2-9717-838befcc4064",
                    "operator": {
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.category }}",
                    "rightValue": "Bug"
                  }
                ]
              }
            },
            {
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "394c07bc-9828-4d4d-a434-33cb4a96cddb",
                    "operator": {
                      "name": "filter.operator.equals",
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.category }}",
                    "rightValue": "Feature Request"
                  }
                ]
              }
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 3.2
    },
    {
      "id": "a8490c26-d635-4a74-9c90-04d33e94f85e",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        380
      ],
      "parameters": {
        "width": 1520,
        "height": 420,
        "content": "**目的：**"
      },
      "typeVersion": 1
    },
    {
      "id": "a57683e3-5304-4a50-8aec-0ac86427b929",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -82,
        -240
      ],
      "parameters": {
        "color": 5,
        "width": 1520,
        "height": 600,
        "content": "## 客户反馈循环分析器"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1277749b-2809-4280-a59e-17998a61a482",
  "connections": {
    "Categories": {
      "main": [
        [
          {
            "node": "Slack",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Review data": {
      "main": [
        [
          {
            "node": "Categories",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract details": {
      "main": [
        [
          {
            "node": "Transform and summarise",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Transform and summarise",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Receive review/feedbak": {
      "main": [
        [
          {
            "node": "Extract details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Transform and summarise": {
      "main": [
        [
          {
            "node": "Review data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Transform and summarise",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 杂项, AI 摘要总结, 多模态 AI

需要付费吗？

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

相关工作流推荐

使用Gemini AI和Google Workspace将每日邮件和日历摘要发送到Slack
使用Gemini AI和Google Workspace将每日邮件和日历摘要发送到Slack
Code
Cron
Gmail
+7
20 节点Sayone Technologies
杂项
基于AI的潜在客户资格评定与个性化触达（使用Relevance AI）
基于AI的潜在客户资格评定与个性化触达：使用Relevance AI
Set
Code
Gmail
+11
34 节点Diptamoy Barman
内容创作
竞争对手内容差距分析器：自动化网站主题映射
使用Gemini AI、Apify和Google Sheets分析竞争对手内容差距
If
Set
Code
+10
30 节点Mychel Garzon
杂项
使用 HTTP Last-Modified 检查从 Google Sheets 获取职位发布过期和刷新提醒
通过 Google Sheets、HTTP 检查和 Gmail 实现职位发布过期提醒的自动化
If
Set
Code
+6
19 节点WeblineIndia
人力资源
每日申请人摘要
使用Gemini AI提取的按职位分类每日申请人摘要，供招聘经理使用
Code
Gmail
Schedule Trigger
+3
10 节点WeblineIndia
AI 摘要总结
使用Gemini总结Gmail支持邮件并发布到Slack
使用Gemini总结Gmail支持邮件并发布到Slack
Slack
Gmail Trigger
Chain Llm
+2
6 节点WeblineIndia
AI 摘要总结
工作流信息
难度等级
中级
节点数量11
分类3
节点类型10
难度说明

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

作者
WeblineIndia

WeblineIndia

@weblineindia

A Leading Software Engineering, Consulting & Outsourcing Services Company in USA & India serving Clients Globally since 1999.

外部链接
在 n8n.io 查看 →

分享此工作流