8
n8n Deutschamn8n.com

Echtzeit-Teilnehmer-Engagement- und Feedback-Analysator

Fortgeschritten

Dies ist ein Market Research, AI Summarization-Bereich Automatisierungsworkflow mit 14 Nodes. Hauptsächlich werden If, Set, Slack, Webhook, Aggregate und andere Nodes verwendet. Feedback-Kampagnen mit Sentiment-Analyse, Google Sheets, Slack und E-Mail-Analyse analysieren

Voraussetzungen
  • •Slack Bot Token oder Webhook URL
  • •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (14)

If
Set
Slack
Webhook
Aggregate
EmailSend
StickyNote
GoogleSheets
RespondToWebhook

Kategorie

Marktforschung
KI-Zusammenfassung
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "id": "EmfkoUHC2bSeoWb4",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "Real-Time Attendee Engagement & Feedback Analyzer",
  "tags": [],
  "nodes": [
    {
      "id": "d1d5d86f-4051-4a37-a530-6eb74cba5ef4",
      "name": "Notizzettel1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1520,
        -160
      ],
      "parameters": {
        "color": 4,
        "width": 368,
        "height": 392,
        "content": "## 📊 DATA COLLECTION\nCollects feedback through:\n- Webhook submissions\n- Live poll responses\n- Session ratings\n- Attendee comments"
      },
      "typeVersion": 1
    },
    {
      "id": "dfc65343-c894-422a-a4f4-52635e612947",
      "name": "Notizzettel2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1104,
        -160
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 392,
        "content": "## 🔍 ANALYSIS ENGINE\nProcesses feedback data:\n- Sentiment analysis\n- Rating aggregation\n- Keyword extraction\n- Trend identification"
      },
      "typeVersion": 1
    },
    {
      "id": "e37ce7a7-09c8-4b4f-aeef-088e5cc27b22",
      "name": "Notizzettel3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        -384
      ],
      "parameters": {
        "width": 720,
        "height": 904,
        "content": "## 📈 INSIGHTS & DELIVERY\nGenerates and distributes:\n- Real-time dashboards\n- Organizer notifications\n- Summary reports\n- Action recommendations"
      },
      "typeVersion": 1
    },
    {
      "id": "856e30ac-16a2-40b2-a058-19be10325285",
      "name": "Webhook Trigger",
      "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": "Feedback-Daten extrahieren",
      "type": "n8n-nodes-base.set",
      "position": [
        -1264,
        64
      ],
      "parameters": {
        "mode": "jsonData",
        "options": {}
      },
      "typeVersion": 3.3
    },
    {
      "id": "89b8c673-faab-405f-84e9-8626bf9508a3",
      "name": "Sentiment analysieren",
      "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": "Dringlichkeit prüfen",
      "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": "In Google Sheets protokollieren",
      "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": "Feedback aggregieren",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -816,
        256
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "8a190d49-5dd9-40f8-a71f-f7a40fd48355",
      "name": "Erkenntnisse berechnen",
      "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": "Dringende Slack-Benachrichtigung",
      "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": "Zusammenfassung an 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": "E-Mail-Bericht an Veranstalter",
      "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 Response",
      "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": {
    "6098e99d-2e3d-438a-be82-aff6f5a20ffd": {
      "main": [
        [
          {
            "node": "b6298b5f-f124-4bab-a3c0-6129871253e2",
            "type": "main",
            "index": 0
          },
          {
            "node": "16349786-ae4a-4332-b52e-c253598ca974",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "16349786-ae4a-4332-b52e-c253598ca974",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "856e30ac-16a2-40b2-a058-19be10325285": {
      "main": [
        [
          {
            "node": "3cc30aeb-a803-43cd-9588-e2510693787d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "89b8c673-faab-405f-84e9-8626bf9508a3": {
      "main": [
        [
          {
            "node": "6098e99d-2e3d-438a-be82-aff6f5a20ffd",
            "type": "main",
            "index": 0
          },
          {
            "node": "ce54e9d6-f662-4b18-9652-80a461f2db0c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ce54e9d6-f662-4b18-9652-80a461f2db0c": {
      "main": [
        [
          {
            "node": "8a190d49-5dd9-40f8-a71f-f7a40fd48355",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8a190d49-5dd9-40f8-a71f-f7a40fd48355": {
      "main": [
        [
          {
            "node": "88e5aa40-65fd-4fcb-a14b-eb69a8ce9981",
            "type": "main",
            "index": 0
          },
          {
            "node": "9268ae4b-be35-473e-b251-abca65efc6d7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "16349786-ae4a-4332-b52e-c253598ca974": {
      "main": [
        [
          {
            "node": "238f1d34-04d8-49ba-aba0-a0118ec51c4a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3cc30aeb-a803-43cd-9588-e2510693787d": {
      "main": [
        [
          {
            "node": "89b8c673-faab-405f-84e9-8626bf9508a3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Marktforschung, KI-Zusammenfassung

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

Automatischer Preisvergleich von Hotels durch Multi-Platform-Crawling und E-Mail-Berichte
Automatisierung des Hotelpreisvergleichs durch Multi-Platform-Scraping und E-Mail-Berichte
If
Set
Code
+
If
Set
Code
19 NodesOneclick AI Squad
Marktforschung
Automatisierung von Instagram-Influencer-Lieferungen und Vertragskonformität
Automatisierte Erinnerungen zur Einhaltung von Instagram-Influencer-Verträgen mit Claude AI und Slack
If
Set
Code
+
If
Set
Code
26 NodesOneclick AI Squad
Soziale Medien
AI-basierendes Kandidaten-Filtering und Bewerbungsmanagement
KI-basierte Kandidatenauswahl und Einarbeitungsterminplanung (OpenAI GPT und Google Suite)
If
Code
Webhook
+
If
Code
Webhook
18 NodesOneclick AI Squad
Personalwesen
Instagram-Kommentarprüfung und automatische Abwehr-Workflow
Automatische Überprüfung von Instagram-Kommentaren mit Perspective API und Slack-Benachrichtigungen
If
Set
Cron
+
If
Set
Cron
15 NodesOneclick AI Squad
Soziale Medien
Instagram-Beschwerden an Support-Tickets übergeben + SLA-Automatisierung
Automatisierte Verwaltung von Instagram-Beschwerden mit Claude AI, Tickets und SLA
If
Set
Cron
+
If
Set
Cron
31 NodesOneclick AI Squad
Ticketverwaltung
Betrugsbuchungsdetektor: Nutzung von KI zur Identifizierung verdächtiger Reisebuchungen
Betrugsbuchungserkennung: Erkennung verdächtiger Reisebuchungen mit Google Gemini
If
Set
Code
+
If
Set
Code
20 NodesOneclick AI Squad
Sicherheitsbetrieb
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes14
Kategorie2
Node-Typen9
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Autor
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.

Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34