🎯 Extract and process healthcare claims with VLM Run, Google Drive and Sheets
⚡ 694 views · 🎯 AI Summarization & Classification
Description
Automatically process healthcare claims into structured Google Sheets entries with VLM Run extraction
What this workflow does
- Monitors Google Drive for new files in a target folder
- Downloads the file inside n8n for processing
- Sends the file to VLM Run for AI transcription or analysis
- Fetches extra details from the healthcare.claims-processing domain as JSON
- 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:
- Create the Drive folder you want to watch and copy its Folder ID
- Create a Google Sheet with headers like: timestamp, file_name, file_id, mime_type, size_bytes, uploader_email, form_type, carrier_name, patient_name, patient_birth_date, patient_sex, patient_address, insurance_type, insurance_id, insured_name, total_charge, amount_due, amount_paid, hospitalization_from, hospitalization_to, referring_physician_name, processing_notes, …other claim fields as needed
- Configure Google Drive OAuth2 for the trigger and download nodes
- Add VLM Run API credentials from https://app.vlm.run/dashboard to the VLM Run node
- Configure Google Sheets OAuth2 and set Spreadsheet ID and target sheet tab
- Test by uploading a sample file to the watched Drive folder and activate
Perfect for
- Centralized intake of healthcare claim documents with instant AI summaries
- Claims and operations teams collecting structured claim insights
- Customer support attachments that need quick triage to a Sheet
- Compliance and audit logs for claim documents
Key Benefits
- End to end automation from Drive to Sheets
- Accurate AI output via VLM Run with optional timestamps
- Domain enrichment from healthcare.claims-processing JSON
- Clean, searchable logs in Google Sheets
- No manual steps after activation
How to customize
Extend by adding:
- OCR tuning and field validation for claim forms
- Per type routing for PDFs, images, or scanned forms
- Slack notifications on each new Sheet append
- Keyword extraction and auto tagging for claim categories
- Error branch that records failures to a second Sheet
🔗 Nodes Used
Google Sheets, Google Drive, Google Drive Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File