Analizador de participación y retroalimentación de asistentes en tiempo real
Este es unMarket Research, AI Summarizationflujo de automatización del dominio deautomatización que contiene 14 nodos.Utiliza principalmente nodos como If, Set, Slack, Webhook, Aggregate. Analizar retroalimentación de campañas con análisis de sentimientos, Google Sheets, Slack y análisis de correos
- •Bot Token de Slack o URL de Webhook
- •Punto final de HTTP Webhook (n8n generará automáticamente)
- •Credenciales de API de Google Sheets
Nodos utilizados (14)
{
"id": "EmfkoUHC2bSeoWb4",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "Real-Time Attendee Engagement & Feedback Analyzer",
"tags": [],
"nodes": [
{
"id": "d1d5d86f-4051-4a37-a530-6eb74cba5ef4",
"name": "Nota Adhesiva 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": "Nota Adhesiva 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": "Nota Adhesiva 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": "Extraer Datos de Retroalimentación",
"type": "n8n-nodes-base.set",
"position": [
-1264,
64
],
"parameters": {
"mode": "jsonData",
"options": {}
},
"typeVersion": 3.3
},
{
"id": "89b8c673-faab-405f-84e9-8626bf9508a3",
"name": "Analizar Sentimiento",
"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": "Verificar Urgencia",
"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": "Registrar en 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": "Agregar Retroalimentación",
"type": "n8n-nodes-base.aggregate",
"position": [
-816,
256
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "8a190d49-5dd9-40f8-a71f-f7a40fd48355",
"name": "Calcular Perspectivas",
"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": "Alerta Urgente en 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": "Resumen a 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": "Reporte por Correo a Organizadores",
"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": "Respuesta 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": {
"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
}
]
]
}
}
}¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Intermedio - Investigación de mercado, Resumen de IA
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Oneclick AI Squad
@oneclick-aiThe 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.
Compartir este flujo de trabajo