Extract spend details (template)

This workflow automates the process of extracting financial transaction details from Gmail emails, parsing invoice and payment information, and storing structured data into Google Sheets for bookkeeping. It starts by monitoring specific Gmail labels for new emails, downloading attachments, and distinguishing between invoices and payment notifications. Using HTML and PDF extraction nodes, it captures transaction details, which are then analyzed by language models to extract structured data such as date, amount, merchant, and category. The workflow integrates multiple AI models, including Google Gemini and Groq, for deep content analysis. The parsed data is systematically organized and appended to designated Google Sheets, supporting financial record-keeping and expense tracking. This workflow is highly useful for automated expense management, financial audits, and real-time bookkeeping, reducing manual effort and minimizing errors.