AI-Powered Document Processing & Organization with Gemini, VLM Run & Google Sheets

Automate multi-document handling with AI-powered extraction that adapts to any format and organizes it instantly.

What this workflow does

Monitors Google Drive for new uploads (receipts, resumes, claims, physician orders, blueprints, or any doc type) Automatically downloads and prepares files for analysis Identifies the document type using Google Gemini Parses structured data via the trusted VLM Run node with OCR + layout parsing Stores records in Google Sheets — AI Agent maps values to the correct sheet dynamically

Setup

Prerequisites: Google Drive & Google Sheets accounts, VLM Run API credentials, n8n instance.

Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can integrate it directly for high-accuracy data extraction.

Quick Setup:

Configure Google Drive OAuth2 and select a folder for uploads

Add VLM Run API credentials

Create a Master Reference Google Sheet with the following structure:

| Document_Name | Spreadsheet_ID | | ---------------------- | ----------------------------- | | Receipt | your-receipt-sheet-id | | Resume | your-resume-sheet-id | | Physician Order | your-physician-order-sheet-id | | Claims Processing | your-claims-sheet-id | | Construction Blueprint | your-blueprint-sheet-id |

The first column holds the document type, and the second column holds the target sheet ID where extracted data should be appended.

In the AI Agent node, edit the agent prompt to:

Analyze the JSON payload from VLM Run Look up the document type in the Master Reference Sheet If a matching sheet exists → fetch headers, then append data accordingly If headers don’t exist → create them from JSON keys, then insert values If no sheet exists → add the new type to the Master Reference with an empty Spreadsheet ID

Test with a sample upload and activate the workflow

How to customize this workflow to your needs

Extend functionality by:

Adjusting the AI Agent prompt to support any new document schema (just update field mappings) Adding support for multi-language OCR or complex layouts in VLM Run Linking Sheets data to BI dashboards or reporting tools Triggering notifications when new entries are stored

This workflow leverages the VLM Run node for flexible, precision extraction and the AI Agent for intelligent mapping, creating a powerful system that adapts to any document type with minimal setup changes.