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
{ "eventId": "evt_123", "eventName": "Tech Summit 2025", "eventDate": "2025-10-29", "email": "manager@company.com" }

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!