Templates / Recognize invoices / receipts from Google Drive and put them into Google Sheets

Recognize invoices / receipts from Google Drive and put them into Google Sheets

Ready for 3.0

by Anthony ✓ · 10,030 views · created 2024-08-23 · 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 9 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Drive and Google Sheets. It also calls receipt-and-invoice-ocr-api.p.rapidapi.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

  1. Load files from Google Drive folder (Google Drive): work with file folder
  2. Get already processed rows from Sheets (Google Sheets): uses Google Sheets
  3. Filter processed files (Merge): merges the data from its input branches
  4. Download file for OCR (Google Drive): download
  5. OCR recognize (HTTP Request): calls receipt-and-invoice-ocr-api.p.rapidapi.com (POST)
  6. Unserialize response JSON (Code): runs custom JavaScript code
  7. Save OCR result into Sheets (Google Sheets): append or update

Services it uses

Google DriveGoogle Sheets

HTTP calls to: receipt-and-invoice-ocr-api.p.rapidapi.com

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.

Nodes used (7)

From the author

This workflow allows you to recognize a folder with receipts or invoices (make sure your files are in .pdf, .png, or .jpg format). The workflow can be triggered via the "Test workflow" button, and it also monitors the folder for new files, automatically…

Excerpt from Anthony'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.