🔬 Generate post-event reports with GPT-4, email delivery & database storage
⚡ 216 views · 🔬 Document Extraction & Analysis
Description
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!
🔗 Nodes Used
Send Email, HTTP Request, Postgres, Webhook, AI Agent, OpenAI Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File