Extract Spending History from Gmail to Google Sheets

This n8n workflow automates the extraction of spending history by monitoring specific Gmail labels for invoice and payment notification emails. It triggers on new emails in designated labels (e.g., for invoices and payments), downloads attachments, and processes the content. Data is cleaned and structured, then passed through an AI node (Basic LLM Chain) to intelligently categorize transactions into bookkeeping items like date, amount, vendor, and category.

The processed data is appended to a 'raw data' sheet in Google Sheets, providing a centralized log for financial tracking. Users can set up Gmail filters to automatically label relevant emails, ensuring hands-free operation. An example sheet is provided for quick setup.

Benefits include significant time savings on manual data entry, reduced errors from OCR or parsing, and real-time financial visibility. Ideal for personal finance management, freelancers, or small businesses handling invoice/payment tracking without dedicated accounting software.

Use cases: Track credit card statements, vendor invoices, or bank alerts; integrate with further automations like budget alerts or expense reports.