OCR Document & Receipt Extractor to Google Sheets

📌 Overview This workflow lets users upload documents or images (e.g., receipts, bills, invoices) through a form. It uses Google Gemini OCR + AI extraction to pull out structured details (Date, Reference Number, Supplier, Description, Amount) and automatically saves them into Google Sheets for easy tracking and reporting.

Category: Finance & Operations Trigger: File upload via n8n Form

⚙️ Workflow Steps

1. Form Submission (n8n Form Trigger)
2. • Starts when a user uploads a document or image.
   • Accepts required file input (data).
3. Convert to Binary (Code Node)
4. • Converts uploaded files into binary format for processing.
   • Ensures compatibility with OCR and AI models.
5. Loop Over Items (Batch Processing)
6. • Processes uploaded files one by one.
   • Useful when multiple receipts/documents are submitted at once.
7. Analyze Document (Google Gemini)
8. • Reads the uploaded document/image.
   • Extracts raw text using OCR and AI analysis.
9. Information Extractor (Google Gemini + AI)
10. • Pulls structured fields from text:
    • • Date
      • Reference Number
      • Supplier
      • Description
      • Amount (numbers only)
    • Converts into clean JSON output.
11. Append Row in Google Sheets
12. • Saves extracted details into the connected Google Sheet.
    • Each document = one clean row entry.

🗂️ Data Sources & Tools

• n8n Form → User uploads documents/images.
• Google Gemini API → OCR + AI extraction.
• Google Sheets → Stores structured receipt/bill data.

✅ Key Benefits

• Automates data entry from receipts, invoices, and bills.
• Eliminates manual typing errors.
• Supports multiple file uploads.
• Creates a clean, searchable expense log in Google Sheets.