Generate post-event reports with GPT-4, email delivery & database storage

Streamline your post-event analysis with this smart n8n workflow. Triggered by a simple webhook, it instantly gathers attendee and engagement data from your event platform, calculates key metrics, and uses AI to generate a polished, professional report. The final summary is emailed to stakeholders and saved securely in a database — all without manual effort. Perfect for conferences, webinars, and corporate events. 📧📈 Key Features - Webhook triggered – Starts instantly via HTTP POST request - Multi-source data collection – Fetches attendees & engagement metrics - Advanced analytics – Calculates attendance rates, engagement scores, top sessions - AI-powered insights – Uses GPT-4 to generate professional reports - Auto-email delivery – Sends report to stakeholders - Database archiving – Saves reports to PostgreSQL What it Analyzes - Attendance rates & check-ins - Average session time - Engagement scores (polls, Q&A, networking) - Top performing sessions - Attendee breakdown (by role & company) - AI-generated insights & recommendations Workflow Process - The Webhook Trigger node starts the workflow when an HTTP POST request is received with event details. - Get Attendees (GET) pulls the list of registered and checked-in participants from your event system. - Get Engagement Metrics (GET) retrieves interaction data like poll responses, Q&A activity, and session views. - Process Metrics calculates key stats: attendance rate, average session duration, engagement score, and ranks top sessions. - AI Generate Report uses GPT-4 to create a clear, professional summary with insights and recommendations based on the data. - AI Agent coordinates data flow and prepares the final report structure using chat model and memory tools. - Save to Database (Insert) stores the full report and raw metrics in PostgreSQL for future reference. - Send Report Email automatically emails the AI-generated report to the specified recipient. - Send Response returns a confirmation back to the triggering system via webhook. Setup Instructions - Import this JSON into n8n - Configure credentials: - Event API (for GET requests) - OpenAI (GPT-4) - SMTP (for email delivery) - PostgreSQL (for data storage) - Trigger via webhook with event data - Receive comprehensive report via email within minutes! Prerequisites - Event platform with REST API (for attendee & engagement data) - OpenAI API key (GPT-4 access) - SMTP server credentials (Gmail, SendGrid, etc.) - PostgreSQL database with write access Example Webhook Payload Modification Options - Add custom metrics in the Process Metrics node (e.g., NPS score, feedback sentiment) - Change AI tone in AI Generate Report (formal, executive summary, or creative) - Modify email template in Send Report Email with your branding - Connect to different data sources by updating GET nodes - Add Slack or Teams notification after Send Report Email Ready to automate your event reporting? Get in touch with us for custom n8n workflows!