8
n8n 中文网amn8n.com

实时参会者参与度和反馈分析器

中级

这是一个Market Research, AI Summarization领域的自动化工作流，包含 14 个节点。主要使用 If, Set, Slack, Webhook, Aggregate 等节点。 使用情绪分析、Google Sheets、Slack和邮件分析活动反馈

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

使用的节点 (14)

If
Set
Slack
Webhook
Aggregate
EmailSend
StickyNote
GoogleSheets
RespondToWebhook

分类

市场调研
AI 摘要总结
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "EmfkoUHC2bSeoWb4",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "实时参会者参与度和反馈分析器",
  "tags": [],
  "nodes": [
    {
      "id": "d1d5d86f-4051-4a37-a530-6eb74cba5ef4",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1520,
        -160
      ],
      "parameters": {
        "color": 4,
        "width": 368,
        "height": 392,
        "content": "## 📊 数据收集"
      },
      "typeVersion": 1
    },
    {
      "id": "dfc65343-c894-422a-a4f4-52635e612947",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1104,
        -160
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 392,
        "content": "## 🔍 分析引擎"
      },
      "typeVersion": 1
    },
    {
      "id": "e37ce7a7-09c8-4b4f-aeef-088e5cc27b22",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        -384
      ],
      "parameters": {
        "width": 720,
        "height": 904,
        "content": "## 📈 洞察与交付"
      },
      "typeVersion": 1
    },
    {
      "id": "856e30ac-16a2-40b2-a058-19be10325285",
      "name": "Webhook触发器",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1488,
        64
      ],
      "webhookId": "feedback-analyzer",
      "parameters": {
        "path": "feedback-submission",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 1
    },
    {
      "id": "3cc30aeb-a803-43cd-9588-e2510693787d",
      "name": "提取反馈数据",
      "type": "n8n-nodes-base.set",
      "position": [
        -1264,
        64
      ],
      "parameters": {
        "mode": "jsonData",
        "options": {}
      },
      "typeVersion": 3.3
    },
    {
      "id": "89b8c673-faab-405f-84e9-8626bf9508a3",
      "name": "分析情感",
      "type": "n8n-nodes-base.set",
      "position": [
        -1040,
        64
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "sentiment",
              "name": "sentiment",
              "type": "string",
              "value": "={{ $json.feedback_text.toLowerCase().includes('great') || $json.feedback_text.toLowerCase().includes('excellent') || $json.feedback_text.toLowerCase().includes('amazing') ? 'positive' : ($json.feedback_text.toLowerCase().includes('bad') || $json.feedback_text.toLowerCase().includes('poor') || $json.feedback_text.toLowerCase().includes('terrible') ? 'negative' : 'neutral') }}"
            },
            {
              "id": "sentiment_score",
              "name": "sentiment_score",
              "type": "number",
              "value": "={{ $json.feedback_text.toLowerCase().includes('great') || $json.feedback_text.toLowerCase().includes('excellent') || $json.feedback_text.toLowerCase().includes('amazing') ? 1 : ($json.feedback_text.toLowerCase().includes('bad') || $json.feedback_text.toLowerCase().includes('poor') || $json.feedback_text.toLowerCase().includes('terrible') ? -1 : 0) }}"
            },
            {
              "id": "keywords",
              "name": "keywords",
              "type": "string",
              "value": "={{ $json.feedback_text.toLowerCase().split(' ').filter(word => word.length > 5).slice(0, 5).join(', ') }}"
            },
            {
              "id": "overall_score",
              "name": "overall_score",
              "type": "number",
              "value": "={{ ($json.rating * 20 + $json.engagement_score * 10) / 2 }}"
            }
          ]
        }
      },
      "typeVersion": 3.3
    },
    {
      "id": "6098e99d-2e3d-438a-be82-aff6f5a20ffd",
      "name": "检查紧急性",
      "type": "n8n-nodes-base.if",
      "position": [
        -816,
        -128
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": false
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "urgent",
              "operator": {
                "type": "number",
                "operation": "lte"
              },
              "leftValue": "={{ $json.rating }}",
              "rightValue": "2"
            },
            {
              "id": "negative_sentiment",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.sentiment }}",
              "rightValue": "negative"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "16349786-ae4a-4332-b52e-c253598ca974",
      "name": "记录到 Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -592,
        -32
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "1234567890abcdef"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "ce54e9d6-f662-4b18-9652-80a461f2db0c",
      "name": "聚合反馈",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -816,
        256
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "8a190d49-5dd9-40f8-a71f-f7a40fd48355",
      "name": "计算洞察",
      "type": "n8n-nodes-base.set",
      "position": [
        -592,
        256
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "total_responses",
              "name": "total_responses",
              "type": "number",
              "value": "={{ $json.data.length }}"
            },
            {
              "id": "avg_rating",
              "name": "avg_rating",
              "type": "number",
              "value": "={{ $json.data.reduce((sum, item) => sum + item.rating, 0) / $json.data.length }}"
            },
            {
              "id": "positive_feedback",
              "name": "positive_feedback",
              "type": "number",
              "value": "={{ $json.data.filter(item => item.sentiment === 'positive').length }}"
            },
            {
              "id": "negative_feedback",
              "name": "negative_feedback",
              "type": "number",
              "value": "={{ $json.data.filter(item => item.sentiment === 'negative').length }}"
            },
            {
              "id": "neutral_feedback",
              "name": "neutral_feedback",
              "type": "number",
              "value": "={{ $json.data.filter(item => item.sentiment === 'neutral').length }}"
            },
            {
              "id": "avg_overall_score",
              "name": "avg_overall_score",
              "type": "number",
              "value": "={{ $json.data.reduce((sum, item) => sum + item.overall_score, 0) / $json.data.length }}"
            }
          ]
        }
      },
      "typeVersion": 3.3
    },
    {
      "id": "b6298b5f-f124-4bab-a3c0-6129871253e2",
      "name": "紧急Slack警报",
      "type": "n8n-nodes-base.slack",
      "position": [
        -592,
        -224
      ],
      "webhookId": "85cacdc2-d14c-48d4-8f67-cf52130f3830",
      "parameters": {
        "text": "=🚨 **URGENT FEEDBACK ALERT**\n\n**Session:** {{ $json.session_name }}\n**Attendee:** {{ $json.attendee_name }}\n**Rating:** {{ $json.rating }}/5 ⭐\n**Sentiment:** {{ $json.sentiment }}\n\n**Feedback:**\n> {{ $json.feedback_text }}\n\n**Action Required:** Please review and respond immediately.",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "select": "user",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "MQ0fgwuS8AzfwFvy",
          "name": "Slack account - test "
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "88e5aa40-65fd-4fcb-a14b-eb69a8ce9981",
      "name": "摘要发送至Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        -368,
        160
      ],
      "webhookId": "57db30cd-4fe0-4439-9b3c-03c42f638590",
      "parameters": {
        "text": "=📊 **Real-Time Feedback Summary**\n\n**Total Responses:** {{ $json.total_responses }}\n**Average Rating:** {{ $json.avg_rating.toFixed(2) }}/5 ⭐\n**Overall Score:** {{ $json.avg_overall_score.toFixed(1) }}%\n\n**Sentiment Breakdown:**\n✅ Positive: {{ $json.positive_feedback }} ({{ ($json.positive_feedback / $json.total_responses * 100).toFixed(1) }}%)\n❌ Negative: {{ $json.negative_feedback }} ({{ ($json.negative_feedback / $json.total_responses * 100).toFixed(1) }}%)\n➖ Neutral: {{ $json.neutral_feedback }} ({{ ($json.neutral_feedback / $json.total_responses * 100).toFixed(1) }}%)\n\n_Dashboard updated in real-time_",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "select": "user",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "MQ0fgwuS8AzfwFvy",
          "name": "Slack account - test "
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "9268ae4b-be35-473e-b251-abca65efc6d7",
      "name": "邮件报告给组织者",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -368,
        352
      ],
      "webhookId": "75461868-abdb-4b95-9993-d239d5a0954b",
      "parameters": {
        "options": {},
        "subject": "=Event Feedback Report - {{ $now.format('MMMM dd, yyyy') }}",
        "toEmail": "organizers@company.com",
        "fromEmail": "events@company.com"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "238f1d34-04d8-49ba-aba0-a0118ec51c4a",
      "name": "Webhook 响应",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        -368,
        -32
      ],
      "parameters": {
        "options": {},
        "respondWith": "json",
        "responseBody": "={\n  \"status\": \"success\",\n  \"message\": \"Feedback received and analyzed\",\n  \"feedback_id\": \"{{ $json.feedback_id }}\",\n  \"sentiment\": \"{{ $json.sentiment }}\",\n  \"overall_score\": {{ $json.overall_score }},\n  \"thank_you\": \"Thank you for your valuable feedback!\"\n}"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "6a92962e-45cd-4329-9425-dfb4bcc34b6c",
  "connections": {
    "Check Urgency": {
      "main": [
        [
          {
            "node": "Urgent Slack Alert",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook Trigger": {
      "main": [
        [
          {
            "node": "Extract Feedback Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Analyze Sentiment": {
      "main": [
        [
          {
            "node": "Check Urgency",
            "type": "main",
            "index": 0
          },
          {
            "node": "Aggregate Feedback",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Feedback": {
      "main": [
        [
          {
            "node": "Calculate Insights",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Insights": {
      "main": [
        [
          {
            "node": "Summary to Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "Email Report to Organizers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Google Sheets": {
      "main": [
        [
          {
            "node": "Webhook Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Feedback Data": {
      "main": [
        [
          {
            "node": "Analyze Sentiment",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 市场调研, AI 摘要总结

需要付费吗？

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

相关工作流推荐

通过多平台爬取和邮件报告实现酒店价格自动比对
通过多平台爬取和邮件报告自动化酒店价格比较
If
Set
Code
+6
19 节点Oneclick AI Squad
市场调研
Instagram影响者交付物和合同合规性自动化
使用Claude AI和Slack提醒自动化Instagram影响者合同合规性
If
Set
Code
+8
26 节点Oneclick AI Squad
社交媒体
AI候选人筛选与面试安排系统
基于AI的候选人筛选与面试安排（OpenAI GPT与Google套件）
If
Code
Webhook
+6
18 节点Oneclick AI Squad
人力资源
Instagram恶意评论审核与自动防御工作流
使用Perspective API和Slack提醒自动审核Instagram评论
If
Set
Cron
+6
15 节点Oneclick AI Squad
社交媒体
Instagram客户投诉转支持工单+SLA自动化
使用Claude AI、工单和SLA管理自动化Instagram投诉处理
If
Set
Cron
+7
31 节点Oneclick AI Squad
工单管理
欺诈预订检测器：使用AI识别可疑旅行交易
欺诈预订检测器：使用Google Gemini识别可疑旅行交易
If
Set
Code
+8
20 节点Oneclick AI Squad
安全运维
工作流信息
难度等级
中级
节点数量14
分类2
节点类型9
难度说明

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

作者
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

外部链接
在 n8n.io 查看 →

分享此工作流