Quick overview
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 Receives an event feedback submission through an n8n Form webhook. Normalizes the submitted fields, timestamps the response, and removes duplicate submissions based on event ID and respondent email. Validates the raw feedback text with guardrails and sends it to Google Gemini to return structured JSON (sentiment, category, priority, and one-sentence summary). Validates the generated summary with guardrails, saves the enriched response to an n8n Data Table, and routes it by priority. Sends High-priority feedback to Discord as an urgent message and adds Medium-priority feedback to a separate review-queue Data Table. 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. 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 Add Google Gemini (PaLM) API credentials for the LangChain Google Gemini Chat Model nodes. Add Gmail OAuth credentials and set the recipient email address and event ID used for report generation in the workflow’s report-recipient configuration. Create or select the required n8n Data Tables for event_feedback, event_review_queue, and event_report_status (and ensure their column schemas match the fields being written). If you want urgent alerts, add Discord credentials and fill in the Discord server (guild) ID and channel ID for the notification message. Configure the schedule time for report generation and publish the n8n Form URL path (event-feedback) wherever attendees submit feedback. An n8n automation workflow template by TOMOYA TOEI.
TOMOYA TOEI
web
free
Others in the same category, ranked by how often they are opened.
