n8n Workflow: Analyze Event Feedback with Gemini, Discord & Gmail

Turn event feedback into prioritized action—automatically

This n8n workflow collects attendee feedback through an n8n Form, analyzes it with Google Gemini (using guardrails for structured, reliable outputs), then sends urgent items to Discord and emails a daily Gmail improvement report.

What this workflow does

• Receives feedback via webhook from an n8n Form submission.
• Normalizes and timestamps fields, removes duplicates using event ID and respondent email, and prepares the payload for analysis.
• Validates and classifies feedback with Gemini: sends the feedback text to Google Gemini to return structured JSON including sentiment, category, priority, and a one-sentence summary—with guardrails applied.
• Validates the generated summary, then enriches and stores results in n8n Data Tables.
• Routes by priority:
  • High priority feedback is sent to Discord as an urgent message.
  • Medium priority feedback is added to a separate review-queue Data Table.
• Runs daily on a schedule to generate and email an event-level improvement report:
  • Avoids resending by checking report status in a report-status Data Table.
  • Aggregates stored feedback rows for the configured event ID.
  • Uses Google Gemini to write an improvement report, converts it to a text file, sends it via Gmail, and records the sent status.

Use cases

• Event organizers who want instant visibility into critical attendee issues (Discord for urgent items).
• SaaS operators running recurring events and needing a daily automated improvement report (Gmail with Gemini-generated insights).
• Automation engineers standardizing a feedback pipeline with structured AI output and deduplication.

Technical details

• Nodes/logic used: if, set, merge, switch, discord, gmail.
• AI integration: Google Gemini (PaLM) via LangChain Google Gemini Chat Model nodes with guardrails.
• Data storage: n8n Data Tables for enriched feedback, review queue, and report-status tracking.
• Scheduling: daily run with resend prevention.

Setup

• Add Google Gemini (PaLM) API credentials for the LangChain Google Gemini Chat Model nodes.
• Add Gmail OAuth credentials and set the recipient email.