Templates / Extract expenses from emails and add to Google Sheets

Extract expenses from emails and add to Google Sheets

Ready for 3.0

by Jonathan ✓ · 30,348 views · created 2022-02-17 · 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 6 nodes and runs when a new email arrives over IMAP. Along the way it connects Google Sheets.

How it runs

Trigger: When a new email arrives over IMAP.

  1. Setup Variables (Edit Fields (Set)): sets or maps fields
  2. Check subject (If): checks a condition and branches into true / false
  3. Read Receipts (Mindee): uses Mindee
  4. Set column data (Edit Fields (Set)): sets or maps fields
  5. Add to Google Sheet (Google Sheets): append

Services it uses

Google 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 (5)

From the author

This workflow will check a mailbox for new emails and if the Subject contains Expenses or Reciept it will send the attachment to Mindee for processing then it will update a Google sheet with the values. To use this node you will need to set the Email Read…

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