Dynamic Venue Seating and Layout Generator - n8n Workflow

• Event Managers and Planners needing automated, scalable seating solutions.


• Operations Teams who manage venues and require dynamic layout generation.


• Users looking for advanced examples of custom code scripting within an n8n workflow.


• Developers integrating venue management systems with n8n.

Manually organizing seating for large events is time-consuming and prone to errors, especially when factoring in VIP placement, accessibility requirements, and group seating. This robust n8n workflow solves this by providing a programmatic approach to spatial optimization.

Triggered by a simple webhook, this n8n template instantly retrieves all necessary attendee and venue template data stored in Google Sheets. It then utilizes a powerful custom code n8n node to run complex layout algorithms. The output is a statistically optimized seating plan, complete with calculated dimensions, a visual map (ASCII), and actionable recommendations. Finally, it saves the generated master plan and individual seat assignments back to Google Sheets, ensuring data persistence and easy sharing. This demonstrates the high efficiency achievable using a data-driven n8n workflow approach.

The entire process begins with the n8n trigger, which is a Webhook receiving a POST request containing event criteria (attendee count, layout preference, venue dimensions).

1. Request Validation: The initial Code n8n node validates the input payload, ensuring attendee counts do not exceed capacity.


2. Data Retrieval: Two Google Sheets n8n nodes run in parallel to fetch the current Attendee List and pre-defined Venue Layout Templates from your master spreadsheet.


3. Data Integration: A Code n8n node combines the request data, attendee list, and templates into a single object for processing.


4. Optimization Logic: The core Optimize Seating Layout Code n8n node executes complex JavaScript logic. This logic determines the number of rows and seats per row, assigns VIPs to preferred front sections, places accessible attendees near aisles, and groups general attendees together. It also calculates feasibility metrics and generates a textual visualization map.


5. Formatting and Reporting: The Format Recommendations Code n8n node structures the complex output into a readable format, providing natural language optimization tips and a summary.


6. Data Saving: The finalized master plan summary is saved to Google Sheets using a dedicated Google Sheets n8n node. Concurrently, the workflow splits the master plan into individual assignment records via the Split Seat Assignments n8n node, which are then appended to a separate Google Sheet using another Google Sheets n8n node.


7. Final Response: The workflow concludes by returning the complete, optimized seating plan JSON back through the Webhook n8n node.

To deploy this n8n workflow, follow these steps:

1. Import: Copy the provided n8n workflow JSON code and paste it into your n8n instance via the 'New' -> 'Import from JSON' option.


2. Credentials: You must set up Google Sheets credentials. Locate the Google Sheets n8n nodes (Fetch Attendee Data, Fetch Venue Templates, Save Master Plan, Save Individual Assignments). Update the Google Api credential to your Service Account configuration, ensuring it has read/write access to your designated spreadsheet.


3. Spreadsheet Setup: Replace the placeholder YOURSPREADSHEETID with the actual ID of your Google Sheet document. Ensure the sheets referenced by GID (gid=0 for Attendees, gid=1 for Templates, etc.) exist and are structured correctly.


4. Webhook Activation: The Webhook n8n trigger is configured to use the path seating-planner. Activate the n8n workflow and note the full production URL provided by the webhook for external triggering.

Webhook Trigger: The initial n8n trigger. Configured for a POST request on the path /seating-planner. It serves as the entry point for requesting a new seating plan calculation.
Validate Request Data (Code n8n node): Cleans and validates incoming parameters like venueCapacity, attendeeCount, and layoutPreference. Essential for input hygiene.
Google Sheets n8n node (Fetch Attendee Data & Fetch Venue Templates): Performs a 'Read' operation to retrieve necessary raw data, including attendee details (VIP status, groups, accessibility) and predefined layout rules.
Optimize Seating Layout (Code n8n node): Contains the extensive custom logic. It simulates venue optimization, calculating row counts, seat assignments, and generating the ASCII visual map based on complexity factors.
Format Recommendations (Code n8n node): Standardizes the output structure, wrapping the numerical data and seating assignments with easy-to-read summaries and recommendations.
Split Seat Assignments (Code n8n node): A critical n8n node that transforms the output array of seat assignments into multiple individual items, preparing them for bulk saving to the Google Sheet.
Google Sheets n8n node (Save Master Plan & Save Individual Assignments): Uses the 'Append' or 'Append Or Update' operation to ensure the generated data persists in the specified Google Sheets tabs.
Respond To Webhook n8n node: Ensures the calling system receives the calculated seating plan immediately upon completion of the n8n workflow.