OCR Invoices & Receipts from Google Drive to Google Sheets

This n8n workflow monitors a specified Google Drive folder for new invoices or receipts in PDF, PNG, or JPG formats. Upon detection—via manual 'Test workflow' trigger or automatic new file event—it retrieves the file, sends it to a RapidAPI OCR service for text recognition and data extraction (like amounts, dates, vendors), and appends the parsed data into a pre-formatted Google Sheets document.

Key benefits include eliminating manual data entry, reducing errors in expense tracking, and enabling scalable document processing without custom coding. It's ideal for small businesses, accountants, or teams handling high volumes of receipts, saving hours weekly on bookkeeping.

Setup requires fixing a potential import glitch by reconnecting triggers, configuring RapidAPI credentials for OCR, Google OAuth for Drive/Sheets access, and copying a template Sheet. Advanced users can customize for specific formats via the provider's support. Use cases: automated expense reports, audit trails, or integrating with accounting software.