8
n8n Françaisamn8n.com

Analyseur de participation et de retours des participants en temps réel

Intermédiaire

Ceci est unMarket Research, AI Summarizationworkflow d'automatisation du domainecontenant 14 nœuds.Utilise principalement des nœuds comme If, Set, Slack, Webhook, Aggregate. Analyser les retours de campagnes avec l'analyse des sentiments, Google Sheets, Slack et l'analyse d'e-mails

Prérequis
  • •Token Bot Slack ou URL Webhook
  • •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
  • •Informations d'identification Google Sheets API

Nœuds utilisés (14)

If
Set
Slack
Webhook
Aggregate
EmailSend
StickyNote
GoogleSheets
RespondToWebhook

Catégorie

Étude de marché
Résumé IA
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "id": "EmfkoUHC2bSeoWb4",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "Real-Time Attendee Engagement & Feedback Analyzer",
  "tags": [],
  "nodes": [
    {
      "id": "d1d5d86f-4051-4a37-a530-6eb74cba5ef4",
      "name": "Note adhésive 1",
      "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": "Note adhésive 2",
      "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": "Note adhésive 3",
      "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": "Extraire les Données de Retour",
      "type": "n8n-nodes-base.set",
      "position": [
        -1264,
        64
      ],
      "parameters": {
        "mode": "jsonData",
        "options": {}
      },
      "typeVersion": 3.3
    },
    {
      "id": "89b8c673-faab-405f-84e9-8626bf9508a3",
      "name": "Analyser le Sentiment",
      "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": "Vérifier l'Urgence",
      "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": "Enregistrer dans 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": "Agréger les Retours",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -816,
        256
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "8a190d49-5dd9-40f8-a71f-f7a40fd48355",
      "name": "Calculer les Insights",
      "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": "Alerte Urgente 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": "Résumé vers 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": "Rapport par Email aux Organisateurs",
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Étude de marché, Résumé IA

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Comparaison automatique des prix des hôtels par grattage multiplateforme et rapports par e-mail
Automatiser la comparaison des prix des hôtels avec un web scraping multiplateforme et des rapports par e-mail
If
Set
Code
+
If
Set
Code
19 NœudsOneclick AI Squad
Étude de marché
Automatisation de la conformité des livrables et des contrats pour les influenceurs Instagram
Automatiser la conformité des contrats d'influenceurs Instagram avec Claude AI et des rappels Slack
If
Set
Code
+
If
Set
Code
26 NœudsOneclick AI Squad
Réseaux sociaux
Système de filtrage et de planification d'entretiens pour les candidats par IA
Sélection des candidats et planification des entretiens basées sur l'IA (OpenAI GPT et Google Workspace)
If
Code
Webhook
+
If
Code
Webhook
18 NœudsOneclick AI Squad
Ressources Humaines
Workflow de modération et de défense automatisée contre les commentaires malveillants sur Instagram
Modération automatique des commentaires Instagram avec relecture et alertes Slack via Perspective API
If
Set
Cron
+
If
Set
Cron
15 NœudsOneclick AI Squad
Réseaux sociaux
Transformation des plaintes clients Instagram en tickets de support + automatisation SLA
Automatiser le traitement des réclamations Instagram avec Claude AI, les tickets et la gestion SLA
If
Set
Cron
+
If
Set
Cron
31 NœudsOneclick AI Squad
Gestion des tickets
Détecteur de réservations frauduleuses : identification de transactions de voyage suspects avec l'IA
Détecteur de réservations frauduleuses : identification des transactions de voyage suspectes avec Google Gemini
If
Set
Code
+
If
Set
Code
20 NœudsOneclick AI Squad
Opérations de sécurité
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds14
Catégorie2
Types de nœuds9
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

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

Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34