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": "[email protected]"
}

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!