Templates / Auto invoice & receipt OCR to Google Sheets – Drive, Gmail, & Telegram triggers

Auto invoice & receipt OCR to Google Sheets – Drive, Gmail, & Telegram triggers

Ready for 3.0

by Daniel Ng ✓ · 4,945 views · created 2025-04-19 · Invoice Processing, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 21 nodes and runs on Google Drive events (plus 2 other triggers). Along the way it connects Google Sheets, Google Drive, Telegram and Gmail.

How it runs

Trigger: On Google Drive events (plus 2 other triggers).

  1. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  2. Loop Over Emails (Loop Over Items (Split in Batches)): loops over the items in batches
  3. Create File Name For Telegram (Code): runs custom JavaScript code
  4. Google Drive: uses Google Drive
  5. Loop Over Attachments (Loop Over Items (Split in Batches)): loops over the items in batches
  6. If: checks a condition and branches into true / false
  7. Google Save Files (Google Drive): uses Google Drive
  8. Move file to base64 string (Extract from File): extracts data from a file
  9. Create File Name (Code): runs custom JavaScript code
  10. Split Out Binary Files (Code): runs custom JavaScript code

…plus 8 more steps. See the full node list below.

Services it uses

Google SheetsGoogle DriveTelegramGmail

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

  • Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Gmail Trigger).

Nodes used (12)

From the author

The Best Invoice & Receipt OCR Automation - FREE (for a limited time) Automatically process invoices and receipts using Gemini OCR, extracting data directly into Google Sheets from multiple sources including Google Drive, Gmail, and Telegram. This powerful…

Excerpt from Daniel Ng's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.