Meetup Registration System with PostgreSQL Database & Interactive Giveaway Tool

Description

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

🎉 n8n Workflow: Meetup Registration & Giveaway Picker

This n8n workflow is designed to handle both participant registration and giveaway winner selection, fully integrated with a frontend experience.

📋 Participant Registration Flow

This part of the workflow automates the registration process for meetup attendees.

🔄 Steps:
📝 Participant Form (Webhook Trigger)
Triggered when a user submits the form.
Captures fields like nama_lengkap, email, whatsapp, discord_username, and more.

🛠️ Data Mapping
Maps raw form inputs into a structured format.
Supports trimming, validation, and transformation as needed.

💾 Save to Database
Performs an upsert operation to store participant info in PostgreSQL.
Prevents duplicate entries based on unique ID (e.g., WhatsApp or email).

✅ Confirmation Screen
Returns a success message or thank-you page after registration is complete.

🎁 Giveaway App

This section serve frontend app to display and select random winners.

🔄 Steps:
🌐 Webhook GET (Giveaway App)
Exposes a public endpoint that delivers a ready-to-use HTML app.
Can be opened in a browser or projected during the event.

📥 Fetch Participants
Executes a SQL query to retrieve all participant records from the database.

🧮 Format Participant Data
Redacts personal details (e.g., masks WhatsApp numbers).
Encodes the id using Base64 for privacy and uniqueness.

📤 Render Giveaway App
Returns an HTML-based Single Page Application with the participant list included.
Allows the host to click a button to pick random winners live.

✅ Use Case Highlights

Streamlined participant collection and storage using n8n workflows
Secure data handling with redaction and ID encoding
Frontend integration for a fun, interactive giveaway experience
Reusable for other community events, workshops, or internal team draws