Automate Receipt & Invoice OCR from Google Drive with n8n
detail.loadingPreview
Streamline your bookkeeping and data entry by automatically extracting information from receipts and invoices stored in Google Drive. This n8n workflow leverages AI-powered OCR to convert scanned documents into structured JSON data, ready for analysis or import.
About This Workflow
Say goodbye to manual data entry! This powerful n8n workflow automates the process of recognizing and extracting key information from your receipts and invoices. Simply upload your documents (PDF, PNG, JPG) to a designated Google Drive folder, and let the workflow do the rest. Using the OakPDF OCR API (accessible via RapidAPI), it intelligently parses your files, identifying crucial details like vendor names, addresses, invoice amounts, and currencies. The extracted data is then neatly structured into JSON format, making it easy to integrate with your existing systems, spreadsheets, or databases. This solution is ideal for businesses looking to improve efficiency, reduce errors, and gain faster insights from their financial documents.
Key Features
- Automated OCR Processing: Directly process documents from a Google Drive folder.
- Multi-Format Support: Handles PDF, PNG, and JPG files.
- Structured Data Output: Converts scanned text into clean JSON format.
- Key Information Extraction: Captures vendor details, amounts, currencies, and more.
- Flexible Triggering: Works with both manual testing and automatic folder monitoring.
How To Use
- Sign Up for OakPDF OCR API: Obtain your API key from RapidAPI.
- Import the n8n Workflow: Import the provided JSON snippet into your n8n instance.
- Fix Trigger Connections: After import, reconnect the "When clicking ‘Test workflow’" node to the "Google Sheets1" and "Google Drive" nodes as indicated in the workflow's sticky note.
- Set Up HTTP Header Credential: Create a new "HTTP header" n8n credential and paste your RapidAPI key into it. Ensure the "OCR recognize" node uses this credential.
- Configure Google Authentication: Set up your Google OAuth2 credentials in n8n to access your Google Drive and Google Sheets.
- Specify Google Drive Folder: Update the Google Drive nodes (specifically the
folderToWatchandfolderIdparameters) with the ID of the Google Drive folder where you will place your receipts and invoices. - (Optional) Copy Google Sheet Template: If you wish to save the results directly to a Google Sheet, copy the provided Google Sheets document and update the relevant node in the workflow with its ID.
- Test and Run: Trigger the workflow manually using the "Test workflow" button or by adding new files to your designated Google Drive folder.
Apps Used
Workflow JSON
{
"id": "7c1f17fb-e6cf-4d94-8449-e26c70bd0982",
"name": "Automate Receipt & Invoice OCR from Google Drive with n8n",
"nodes": 19,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 7c1f17fb-e6cf...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.