Automated Revit BIM Wall Quantity and HTML Report Generation

This n8n workflow automates the process of extracting wall data from Revit BIM files, analyzing the quantities, and generating a professional HTML report. It begins with manual trigger to start the process, where paths to the Revit file and converter are set. The workflow then executes a command to run a Revit-to-Excel converter, checks for success, and reads the generated Excel file. It filters the data to isolate wall elements, cleans and processes this data to compute totals and averages grouped by wall type, and then creates a detailed, styled HTML report. The report visualizes the data with summary cards, bar charts, and structured wall type breakdowns, including total volume, count, and percentage contributions. Finally, it saves the HTML report for viewing. This workflow is useful for BIM managers and construction analysts who need quick, automated insights into wall quantities directly from Revit models, facilitating better project planning, cost estimation, and reporting.