Automated Email Spend and Transaction Data Extraction

This n8n workflow automates the process of extracting, parsing, and recording financial transaction details from Gmail emails into Google Sheets, enhancing expense tracking and bookkeeping. It triggers on new inbox emails with specific labels, then extracts content from invoices and payment notifications, handling multiple email formats (single or multiple payments per email). The workflow uses HTML parsing, language models for detailed analysis, and structured data parsing to identify transaction date, amount, merchant, category, currency, and card information.

In practical scenarios, this workflow is useful for individuals or small businesses that receive frequent transaction notifications via email. It consolidates all expense data into a Google Sheet, enabling easier financial management, automated expense logging, and record-keeping for audits or personal finance reviews.