What This Workflow Does
This n8n workflow automates the entire conference feedback lifecycle, eliminating manual data collection and entry. It captures attendee responses from Microsoft Forms, organizes them in an Excel spreadsheet stored on OneDrive, and sends real-time notifications via Outlook when new feedback arrives.
The system transforms chaotic post-event feedback into structured, actionable data. Event organizers gain immediate visibility into attendee satisfaction without waiting for manual compilation. All feedback is timestamped, categorized, and securely stored for future analysis and reporting.
How It Works
1. Feedback Submission
Attendees complete a Microsoft Form with conference evaluation questions. The form can include rating scales, multiple choice, and open-ended questions tailored to your event's specific needs.
2. Automated Data Capture
The workflow triggers immediately when a form is submitted. It extracts all response data including timestamps, attendee information (if collected), and detailed feedback across all question types.
3. Excel Logging
Each submission appends a new row to a designated Excel file in OneDrive. The system maintains data integrity by mapping form fields to specific spreadsheet columns, ensuring consistent formatting.
4. Notification Alert
Outlook sends an email notification to designated organizers containing key feedback highlights and a direct link to the updated Excel file. Critical feedback can trigger immediate alerts while routine responses generate periodic summaries.
Pro tip: Add conditional logic to flag exceptionally positive or negative feedback for urgent review, helping you address critical issues while memories are fresh.
Who This Is For
This workflow benefits event professionals, conference organizers, and corporate training teams who need to:
- Measure attendee satisfaction quantitatively
- Gather speaker and session evaluations
- Collect suggestions for future events
- Demonstrate event ROI to stakeholders
- Improve subsequent conferences iteratively
What You'll Need
- An n8n instance (cloud or self-hosted)
- Microsoft 365 account with Forms, OneDrive, and Outlook access
- Pre-configured feedback form with your desired questions
- Excel template in OneDrive for data logging
- Notification recipient email addresses
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Connect your Microsoft 365 credentials
- Map your form fields to the Excel columns
- Configure notification recipients and frequency
- Test with sample form submissions
- Activate the workflow for your live event
Key Benefits
Save 10+ hours per event by eliminating manual feedback compilation and data entry. The system handles everything automatically from collection to organization.
Improve response rates with seamless mobile-friendly forms that attendees can complete anytime, anywhere - during sessions or after the event.
Gain real-time insights instead of waiting weeks for manual analysis. Spot trends and issues while they're still relevant to your attendees.
Ensure data accuracy by removing human transcription errors. Every response is recorded exactly as submitted, with automatic timestamps.
Create audit-ready records with properly stored, version-controlled feedback that demonstrates your commitment to continuous improvement.