Blueprint Data Extraction to Excel using VLM Run - n8n Workflow

Construction project managers needing automated compliance tracking.
Architects or engineering firms that must log and track document revisions.
Teams looking for ready-to-use n8n templates to handle high-volume document processing.
Anyone needing to extract complex data points from large files using a specialized n8n node and store it in a structured Microsoft Office environment.

Managing construction documentation—especially blueprints, drawings, and schematics—is a data-intensive and time-consuming process. This solution offers a highly efficient automation for this critical task. This specific n8n workflow eliminates manual review by combining the robust cloud storage capabilities of Microsoft OneDrive with the specialized Visual Large Model (VLM) capabilities of VLM Run.

When a new blueprint (PDF, JPG, or other supported file type) is dropped into a monitored OneDrive folder, the n8n automation pipeline immediately activates. It uses a custom n8n node to analyze the document under the specific construction.blueprint domain, extracting metadata such as project names, revision histories, drawing numbers, and author details. The final, structured output is then seamlessly appended as a new row in a Microsoft Excel sheet, providing a clean, accessible database for tracking and reporting. Using this n8n template ensures accuracy, compliance, and significant time savings in high-stakes construction environments.

This comprehensive n8n workflow operates entirely automatically, beginning with a file upload event and culminating in a structured database entry.

1. Triggering the Workflow: The process starts with the Microsoft OneDrive Trigger n8n node. This specific n8n trigger continuously monitors a predefined folder within your OneDrive account for new file uploads. This ensures the n8n workflow is initiated the moment a new blueprint is available.


2. File Retrieval: Once a file is detected, a subsequent Microsoft OneDrive n8n node (Download a file) retrieves the binary content of the newly uploaded document, preparing it for AI processing.


3. VLM Data Extraction: The binary file is passed to the VLM Run Parsing n8n node. This powerful n8n node uses the dedicated construction.blueprint domain setting. VLM Run specializes in analyzing complex visual and textual layouts common in architectural and engineering plans, converting the entire document into structured, machine-readable JSON data.


4. Data Logging: The final step involves the Microsoft Excel n8n node (Append data to sheet). The highly structured JSON output from VLM Run is mapped meticulously to specific columns in the target Excel workbook. The mapping includes complex expressions to handle potentially missing or array-formatted data for fields like 'REVISION HISTORY,' 'PROJECT DETAILS,' and 'ANNOTATIONS MARKUPS,' ensuring a robust and clean dataset in your final Excel sheet. This completes the fully automated n8n workflow.

To deploy this powerful n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and import it directly into your n8n instance via the 'Workflows' section using the 'New' -> 'Import from JSON' option. This instantly sets up the core logic of this n8n template.


2. Set up OneDrive Credentials: The Microsoft OneDrive Trigger and Download n8n nodes require OAuth2 credentials to connect to your Microsoft account. You must set up a credential that grants n8n access to the relevant Drive folder.


3. Set up VLM Run Credentials: The VLM Run Parsing n8n node requires an API key credential. Obtain this key from your VLM Run account and configure the credential in n8n.


4. Configure OneDrive Trigger: In the 'Microsoft OneDrive Trigger' n8n node, specify the exact folder ID or path that contains the blueprints you want to monitor.


5. Configure Excel Node: In the 'Append data to sheet' n8n node, select the appropriate Microsoft Excel workbook and worksheet where the extracted blueprint data should be logged. Ensure the column names in your Excel sheet match the fields being mapped in the n8n node (e.g., 'PROJECT DETAILS', 'DOCUMENT NUMBER').


6. Activate: Save the n8n workflow and toggle it to 'Active' to start monitoring the OneDrive folder.

Microsoft OneDrive Trigger
Function: Serves as the initial n8n trigger, starting the automation whenever a new file is uploaded to the specified OneDrive folder.
Key Configuration: Monitors a specific Folder ID and is set to poll for new files every minute (mode: everyMinute).
Download a file (Microsoft OneDrive)
Function: Downloads the blueprint file detected by the n8n trigger, making the binary data available for the VLM Run n8n node.
Key Configuration: operation: download; uses the expression ={{ $json.id }} to dynamically fetch the ID of the new file.
VLM Run Parsing (VLM Run n8n node)
Function: Performs specialized extraction of structured data from the complex visual blueprint document.
Key Configuration: domain: construction.blueprint. This setting directs the VLM to use its model optimized for construction documents, generating comprehensive JSON output.
Append data to sheet (Microsoft Excel)
Function: Takes the highly detailed JSON output from the AI step and appends it to a target Excel sheet, creating a structured data log.
Key Configuration: operation: append. Includes complex mapping for over 15 columns (e.g., DOCUMENT TYPE, REVISION HISTORY, DRAWING TITLE NUMBERS). The n8n node utilizes custom JavaScript functions within expressions to robustly handle object-to-string conversion and empty values, ensuring data integrity in Excel.