AI-Powered Receipt Extraction and Expense Logging to Google Sheets - n8n Workflow

Business owners and employees requiring automated expense report generation.
Accounting professionals looking to minimize manual data entry from receipts.
Users seeking robust n8n templates for integrating AI with file storage and spreadsheets.
Anyone needing to process a high volume of receipts automatically using an n8n workflow.

Managing expenses often involves manually transcribing data from countless physical or digital receipts. This highly effective n8n workflow eliminates that inefficiency entirely. It leverages a specialized n8n trigger that constantly monitors a Google Drive folder for new receipt uploads (images or PDFs). Once triggered, the automation uses the powerful VLM Run AI service to instantly parse crucial information like the merchant name, total amount, currency, and transaction date. The final structured data is then automatically appended to a Google Sheets document, creating a centralized, analysis-ready expense database. Implementing this n8n workflow provides real-time tracking, minimizes human error, and accelerates financial reporting, making it one of the most valuable n8n templates for finance automation.

The entire process is initiated by an active n8n trigger. The Monitor Receipt Uploads n8n node acts as the starting point, polling a designated Google Drive folder for any new files (receipts). Upon detection, the n8n workflow proceeds to the Download Receipt File n8n node, which securely retrieves the binary data of the uploaded receipt. This binary file is then passed to the VLM Run Receipt Parser n8n node. This dedicated AI n8n node uses Visual Language Models (VLM) for precise data extraction, focusing on receipt fields. The intermediate Format Receipt Data n8n node ensures the AI output is transformed into a clean, standardized format suitable for logging. Finally, the Save to Expense Database n8n node automatically appends the fully structured expense entry (Customer, Merchant, Amount, Date) to the specified Google Sheets file. This seamless sequence defines a high-performance n8n workflow.

To deploy this specialized n8n workflow, follow these setup steps:

1. Import: Copy the provided JSON and import it directly into your n8n instance using the 'New' > 'Import from JSON' option.


2. Google Drive Setup: Configure the Monitor Receipt Uploads n8n trigger node and the Download Receipt File n8n node using your Google Drive OAuth2 credentials. Ensure you specify the exact Google Drive folder ID where your receipts will be uploaded.


3. VLM Run Credentials: Configure the VLM Run Receipt Parser n8n node with your VLM Run API credentials. This service handles the core AI extraction.


4. Google Sheets Setup: Configure the Save to Expense Database n8n node. Select the appropriate Google Sheets document ID and the specific sheet name where the extracted expense data should be logged. Ensure the spreadsheet columns match the fields defined in the Format Receipt Data n8n node (Date, Amount, Currency, Customer, Merchant).


5. Activation: Save the n8n workflow and set it to 'Active' to start monitoring Google Drive uploads automatically.

Monitor Receipt Uploads (Google Drive Trigger):
Function: Serves as the primary n8n trigger, initiating the n8n workflow when a new file (fileCreated event) appears in the configured Google Drive folder.
Key Configuration: triggerOn: specificFolder; event: fileCreated.
Download Receipt File (Google Drive n8n node):
Function: Downloads the receipt file based on the ID provided by the previous n8n trigger event, preparing it for AI processing.
Key Configuration: operation: download; Stores output in the binary property data.
VLM Run Receipt Parser (VLM Run n8n node):
Function: The core intelligence step. It utilizes the VLM Run AI service to perform OCR and extract structured expense data (Merchant, Total, Date) from the binary receipt file.
Key Configuration: domain: document.receipt.
Format Receipt Data (Set n8n node):
Function: Maps the raw JSON output from the AI service into clean, user-defined fields (Customer, Merchant, Amount, Currency, Date), essential for clean storage in the final spreadsheet.
Key Configuration: keepOnlySet: true; Defines output mapping using expressions like ={{ $json.response.total }}.
Save to Expense Database (Google Sheets n8n node):
Function: The final action in this n8n workflow. It appends the structured data generated by the Set n8n node as a new row into the designated Google Sheet, creating the centralized expense database.
* Key Configuration: operation: append; Configured columns match the Set node output.