Communication
Extract expense data from emails and log to Google Sheets
6 nodes
120
83
Manual trigger
Workflow Description
Automated workflow that reads incoming emails, uses AI-powered document recognition (Mindee) to extract expense details from receipts and invoices, applies conditional validation, and automatically inserts structured data into Google Sheets for centralized expense tracking.
How it works
- 1.Manually trigger to read incoming email messages
- 2.Send email attachments to Mindee API for invoice and receipt data extraction
- 3.Apply conditional logic to validate required fields (amount, date, category)
- 4.Map and format extracted fields with appropriate data types
- 5.Insert validated expense records into target Google Sheets tab
- 6.Log transaction details for audit and compliance purposes
Use cases
- Automate employee expense reporting without manual data entry
- Centralize receipt documentation across distributed teams
- Reduce processing time and human error in expense reconciliation
Requirements
- Active IMAP email account with read permissions enabled
- Mindee API credentials and valid subscription plan
- Editor or owner access to target Google Sheets document
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Email Read Imap
Mindee
Google Sheets
Details
Trigger
Manual trigger
Nodes
6
Apps
3
Views
120
Downloads
83
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (6)
Check subject
If
Setup Variables
Set
Check for new emails
Email Read Imap
Read Receipts
Mindee
Set column data
Set
Add to Google Sheet
Google Sheets