Estimate 4D/5D construction costs from Revit BIM models with DDC CWICR
Needs changesWhat this workflow does
This AI workflow has 76 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model, Anthropic Chat Model, OpenRouter Chat Model and xAI Grok Chat Model and 4 more.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Setup - Define file paths (Edit Fields (Set)): sets 5 fields: path_to_converter, project_file, group_by…
- Configure Language & Vector DB (Code): runs custom JavaScript code
- Create - Excel filename (Edit Fields (Set)): sets 10 fields: xlsx_filename, path_to_converter, project_file…
- Check - Does Excel file exist? (Read Binary File): uses Read Binary File
- If: checks a condition and branches into true / false
- Info - Skip conversion (Edit Fields (Set)): sets 2 fields: status, xlsx_filename
- Extract - Run converter (Execute Command): runs a shell command on the n8n host
- Merge: merges the data from its input branches
- Check - Did extraction succeed? (If): checks a condition and branches into true / false
- Set Parameters (Edit Fields (Set)): sets 1 field: path_to_file
…plus 63 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Read Binary File in Read Excel File1, Check - Does Excel file exist?1: replace with Read/Write Files from Disk.
- Write Binary File in Write HTML File, Write XLS File, Write Output File: replace with Read/Write Files from Disk.
- Also check Spreadsheet File: Convert to File / Extract from File.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Read Binary File Read Excel File1, Check - Does Excel file exist?1 | Read/Write Files from Disk |
| Write Binary File Write HTML File, Write XLS File, Write Output File | Read/Write Files from Disk |
Nodes used (20)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Read Binary File
n8n-nodes-base.readBinaryFile - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Execute Command
n8n-nodes-base.executeCommand - Merge
n8n-nodes-base.merge - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Write Binary File
n8n-nodes-base.writeBinaryFile - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - xAI Grok Chat Model
@n8n/n8n-nodes-langchain.lmChatXAiGrok - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - DeepSeek Chat Model
@n8n/n8n-nodes-langchain.lmChatDeepSeek - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Wait
n8n-nodes-base.wait - Qdrant Vector Store
@n8n/n8n-nodes-langchain.vectorStoreQdrant
From the author
A professional BIM-to-cost pipeline that extracts data from Revit models (2015–2026), classifies elements with AI, decomposes them into construction works, and generates detailed cost estimates using the open-source DDC CWICR database. Produces HTML reports…