Analyze event feedback with Google Gemini, Discord, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (17)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Guardrails
@n8n/n8n-nodes-langchain.guardrails - Remove Duplicates
n8n-nodes-base.removeDuplicates - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Data table
n8n-nodes-base.dataTable - Switch
n8n-nodes-base.switch - Discord
n8n-nodes-base.discord - Summarize
n8n-nodes-base.summarize - Convert to File
n8n-nodes-base.convertToFile - Gmail
n8n-nodes-base.gmail - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Merge
n8n-nodes-base.merge - Aggregate
n8n-nodes-base.aggregate - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if
What it does
Quick overview This workflow collects attendee feedback via an n8n Form, uses Google Gemini with guardrails to classify sentiment, category, priority, and a summary, stores results in n8n Data Tables, sends urgent items to Discord, and emails a scheduled improvement report via Gmail. How it works 1. Receives an event feedback submission through an n8n Form webhook. 2. Normalizes the submitted fields, timestamps the response, and removes duplicate submissions based on event ID and respondent email. 3. Validates the raw feedback text with guardrails and sends it to Google Gemini to return structured JSON (sentiment, category, priority, and one-sentence summary). 4. Validates the generated summary with guardrails, saves the enriched response to an n8n Data Table, and routes it by priority. 5. Sends High-priority feedback to Discord as an urgent message and adds Medium-priority feedback to a separate review-queue Data Table. 6. Runs daily on a schedule, checks an n8n Data Table to avoid resending the same event report, and then pulls all stored feedback rows for the configured event ID. 7. Calculates event-level statistics and aggregates feedback fields, uses Google Gemini to write an improvement report, converts it to a text file, emails it with Gmail, and records the sent status in the report-status Data Table. Setup 1. Add Google Gemini (PaLM) API credentials for the LangChain Google Gemini Chat Model nodes. 2. Add Gmail OAuth credentials and set the recipient email address and event ID used for report generation in the workflow’s report-recipient configuration. 3. Create or select the required n8n Data Tables for eventfeedback, eventreviewqueue, and eventreportstatus (and ensure their column schemas match the fields being written). 4. If you want urgent alerts, add Discord credentials and fill in the Discord server (guild) ID and channel ID for the notification message. 5. Configure the schedule time for report generation and publish the n8n Form URL path (event-feedback) wherever attendees submit feedback.