Generate post-event reports with GPT-4, email delivery & database storage
Ready for 3.0What this workflow does
This AI workflow has 9 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model and Postgres. It also calls oneclick.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Get Attendees (HTTP Request): calls oneclick.com
- Get Engagement Metrics (HTTP Request): calls oneclick.com
- Process Metrics (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: AI Generate Report
- Send Report Email (Send Email): sends an email over SMTP
- Save to Database (Postgres): uses Postgres
- Send Response (Respond to Webhook): sends the response back to the webhook caller
Services it uses
HTTP calls to: oneclick.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Webhook
n8n-nodes-base.webhook - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Send Email
n8n-nodes-base.emailSend - Postgres
n8n-nodes-base.postgres - Respond to Webhook
n8n-nodes-base.respondToWebhook - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
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…