This n8n workflow automates the process of extracting data from receipts and invoices stored in Google Drive, recognizing their text content using an OCR API, and logging the structured data into Google Sheets for easy management and analysis. It is designed to streamline manual data entry tasks, especially useful for managing large volumes of receipts or invoices.
The workflow begins with two triggers: a manual trigger for testing purposes and a Google Drive event that detects new files added to a specific folder. When activated, the workflow loads files from the designated Google Drive folder, filtering out files that have already been processed to avoid duplication.
For each new file detected, the workflow downloads the file and sends it via an HTTP request to a third-party OCR API (RapidAPI), configured with an API key. The OCR API recognizes the document content, such as invoice details, and returns the result as JSON.
The returned JSON data is then parsed and unserialized. The extracted information—like company name, invoice total, currency, and line items—is finally appended into a Google Sheets document, updating existing entries or adding new ones. This process enables automatic, real-time data entry from receipts which is highly beneficial for accounting, expense tracking, or business automation.
This workflow is practical in scenarios such as businesses automating receipt management, accountants automating invoice processing, or small enterprises reducing manual data entry for financial documents, saving time and reducing errors.
Reviews
There are no reviews yet.