Construction blueprint to Google Sheets automation with VLM Run and Google Drive

Automatically process Construction Blueprints into structured Google Sheets entries with VLM extraction

What this workflow does

1. Monitors Google Drive for new blueprints in a target folder 2. Downloads the file inside n8n for processing 3. Sends the file to VLM Run for VLM analysis 4. Fetches details from the construction.blueprint domain as JSON 5. Appends normalized fields to a Google Sheet as a new row

Setup

Prerequisites: Google account, VLM Run API credentials, Google Sheets access, n8n. Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows.

Quick Setup:

1. Create the Drive folder you want to watch and copy its Folder ID 2. Create a Google Sheet with headers like: timestamp, filename, fileid, mimetype, sizebytes, uploaderemail, documenttype, documentnumber, issuedate, authorname, drawingtitlenumbers, revisionhistory, jobname, address, drawingnumber, revision, drawnby, checkedby, scaleinformation, agencyname, documenttitle, blueprintid, blueprintstatus, blueprintowner, blueprinturl

3. Configure Google Drive OAuth2 for the trigger and download nodes 4. Add VLM Run API credentials from https://app.vlm.run/dashboard to the VLM Run node 5. Configure Google Sheets OAuth2 and set Spreadsheet ID and target sheet tab 6. Test by uploading a sample file to the watched Drive folder and activate