Templates / Analyze invoices from Google Drive with AI and store data in Google Sheets

Analyze invoices from Google Drive with AI and store data in Google Sheets

Ready for 3.0

by Stefan Joulien ✓ · 268 views · created 2026-02-27 · 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 AI workflow has 19 nodes and runs on Google Drive events (file created) (plus 1 other trigger). Along the way it connects Telegram, Google Drive, OpenAI and Google Gemini and 1 more.

How it runs

Trigger: On Google Drive events (file created) (plus 1 other trigger).

  1. Mapeo (Edit Fields (Set)): sets 7 fields: Name, Url , Email…
  2. Save_drive (Google Drive): uses Google Drive
  3. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  4. Switch: routes items into 3 branches
  5. download image (Google Drive): download
  6. Download PDF (Google Drive): download
  7. Download image (Google Drive): download
  8. analyze image (OpenAI): analyze (image)
  9. analyze document (Google Gemini): work with document
  10. analyze image (OpenAI): analyze (image)

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

Services it uses

TelegramGoogle DriveOpenAIGoogle GeminiGoogle Sheets

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 (10)

From the author

Who this template is for This workflow is designed for teams and businesses that receive invoices in Google Drive and want to automatically extract structured financial data without manual processing. It is ideal for finance teams, operators, and founders who…

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