Description
This smart n8n workflow automatically retrieves event feedback from Google Sheets, analyzes it using GPT-4, and delivers a concise summary to your inbox in a polished HTML email. Ideal for event organizers, educators, or teams who want to make sense of survey data without manual review.
🧠 How It Works:
✅ 📄 Retrieve Data: Connect to your Google Sheets where feedback from a Google Form is stored ✅ 📊 Aggregate Responses: Use the Aggregate node to group answers by question ✅ 🧠 Analyze with GPT-4: Send aggregated data to OpenAI’s GPT-4 with a prompt like: “Summarize feedback sentiment and extract suggestions for improvement” ✅ 📝 Generate Summary Report: GPT-4 returns a structured event summary with tone, sentiment, and key highlights ✅ 🔁 Convert to HTML: Use Markdown → HTML conversion for email-ready formatting ✅ 📧 Send Email: Use Gmail to send the HTML-formatted summary report to stakeholders
🔍 It Automates:
✅ Collecting feedback from a live Google Form ✅ Aggregating long-form answers by category (per question) ✅ AI-powered feedback analysis with GPT-4 ✅ Formatting Markdown to HTML ✅ Sending clean, structured insights via Gmail
💡 Why Choose This Workflow:
✅ Eliminate manual survey analysis ✅ Get consistent, structured insights from open-text feedback ✅ Automatically email reports after every event or meeting ✅ Works for feedback forms, employee reviews, course surveys, etc.
👤 Who Is This For:
✅ Event Organizers looking to improve future events ✅ HR Teams running performance feedback sessions ✅ Educators gathering anonymous student reflections ✅ Community Managers collecting feedback from members
🔗 Integrations:
✅ Google Sheets (store and fetch feedback) ✅ OpenAI GPT-4 (for summarization and sentiment analysis) ✅ Markdown & HTML Conversion (for email formatting) ✅ Gmail (send formatted summary reports) ✅ Optional: Notion, Slack, Make, S3, Webhooks
🔧 Setup Instructions:
🛠️ Connect your Google Sheets and select the right worksheet 📊 Use an Aggregate node to bundle similar questions 🧠 Add OpenAI API key and create a system prompt for summarizing feedback 🧾 Convert markdown to HTML using the Markdown node 📩 Use Gmail credentials to send the final report to a selected email 📅 Trigger manually or on a schedule (e.g. after every event)
📬 Turn Google Form Feedback into Instant Event Insights — With Zero Manual Review This end-to-end workflow is perfect for teams that care about user input but don’t have time for analysis. Plug in your feedback form and let AI give you the story behind the responses—clean, timely, and actionable.
Link : https://lovable.dev/projects/0ac055b3-2ed9-4876-9a76-03cf1ed40cd2
