Meetup Registration and Interactive Giveaway System with PostgreSQL - n8n Workflow

• Event Organizers: Needing a simple, self-hosted registration and giveaway tool.


• n8n Developers: Interested in advanced n8n node usage, combining Form Triggers, database management, and custom HTML output.


• Community Managers: Seeking a dynamic way to run raffles or prize draws during live events.


• Users exploring n8n templates for full-stack event management solutions.

This comprehensive n8n workflow solves the dual challenge of event management: capturing participant data reliably and then providing a secure, engaging tool for selecting prize winners live. The entire solution is hosted within n8n, eliminating the need for external form builders or complex giveaway software.

It leverages an n8n Form Trigger to collect detailed participant information, ensuring data integrity by saving it instantly via an 'upsert' operation in a PostgreSQL database (e.g., Neon). Crucially, a separate endpoint, triggered by an n8n Webhook, fetches this data, processes it—including redacting sensitive information like WhatsApp numbers using a custom n8n node—and renders a fully functional HTML/JavaScript giveaway application. This is an excellent example of building a sophisticated, front-end-enabled application using only native n8n features.

This n8n workflow operates in two distinct, yet interconnected, sequences:

1. Participant Registration Flow

1. The n8n Trigger (Participant Form): The process begins when a user submits the custom-styled registration form (an n8n node of type formTrigger). This form collects essential details like name, email, WhatsApp, and social media usernames.


2. Data Mapping (Set node): The data received from the form is standardized and mapped to match the column names in the PostgreSQL database structure.


3. Database Storage (PostgreSQL n8n node): The workflow performs an upsert operation on the n8nmeetupparticipants table, ensuring that if a participant submits the form multiple times (identified by a generated unique ID based on Event and WhatsApp), their record is updated, preventing duplicates.


4. Confirmation (Thank you screen): The participant is redirected to a confirmation page (another n8n node) with a custom message after successful submission.

2. Live Giveaway Application Flow

1. Giveaway n8n Trigger (Webhook node): An external request (e.g., opening the URL in a browser) hits the Webhook endpoint, initiating the giveaway data retrieval process.


2. Fetch Participants (PostgreSQL n8n node): A select operation queries the database, retrieving all registered participants for the specified event.


3. Data Preparation (Code n8n node): The custom Format participant list n8n node uses JavaScript to loop through the participants. It redacts the middle section of the WhatsApp number (e.g., 1234****5678) for display privacy and formats the output into a simple list of names and redacted contact info, ready for the front-end script.


4. Application Delivery (Respond to Webhook node): The n8n workflow finally renders and returns a dynamic HTML page, complete with embedded JavaScript logic and the formatted list of names. This page allows the event host to select the number of winners and initiate a live, visual raffle using the prepared data.

To deploy this powerful n8n workflow and start managing your event registrations, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and import it directly into your n8n instance.


2. Set up PostgreSQL Credentials: This n8n template requires a PostgreSQL connection. You must create or configure a credential named Neon N8N Community Indonesia (or update the PostgreSQL n8n node connections to use your chosen credential).


3. Database Setup: Ensure you have a table named n8nmeetupparticipants in your PostgreSQL database with columns matching those expected by the 'Mapping form to database' n8n node (e.g., id, nama_lengkap, whatsapp, email, event, etc.).


4. Activate the n8n Workflow: Once credentials are set up, activate the entire n8n workflow.


5. Access Points: Use the URL generated by the Participant Form n8n trigger for registration, and the URL generated by the Giveaway App Webhook n8n trigger to launch the winner selection tool.

Participant Form (n8n trigger): Serves as the primary entry point for attendees, collecting necessary registration data using a built-in, highly customizable n8n Form interface with custom CSS styling.
Mapping form to database (Set node): Transforms the human-readable form field names (e.g., 'Nama Lengkap') into database column keys (e.g., nama_lengkap), ensuring data consistency before insertion.
Save Participant to Database (PostgreSQL n8n node): Manages persistence using an 'Upsert' operation. It ensures the registration is recorded, or updated if the user re-registers, preventing duplicate entries in the database.
Giveaway App (Webhook n8n trigger): Creates a dedicated public API path (/giveaway) that, when accessed, initiates the process of generating the front-end application.
Get all participants (PostgreSQL n8n node): Executes a targeted SQL SELECT query to retrieve only the participants relevant to the event ID defined in the workflow parameters.
Format participant list (Code n8n node): A critical n8n node that runs custom JavaScript logic. Its main function is data privacy, redacting sensitive contact numbers (WhatsApp) before passing the list to the final application front-end.

• Respond to Giveaway App (Respond to Webhook n8n node): This is where the interactive application lives. It returns the raw HTML/JavaScript code, dynamically injecting the participant data prepared by the previous n8n node, thus serving a fully functional giveaway interface directly from your n8n instance.