Automated expense tracking with AI receipt analysis & Google Sheets

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Your Pocket Bookkeeper is workflow designed to automate expense tracking for freelancers and small businesses. It transforms your favorite chat app into a smart financial assistant, eliminating tedious manual data entry and ensuring your records are always organized, up-to-date, and secure. Just send a photo or a text, and let AI handle the rest. Why Your Pocket Bookkeeper? 🤔 For a freelancer or small business owner, time is money. Administrative tasks like logging receipts and updating spreadsheets steal valuable hours that could be spent on billable work. This workflow solves these critical problems: Saves Significant Time: Drastically reduces the hours spent on manual bookkeeping. Eliminates Human Error: AI-powered data extraction is more accurate than manual entry, preventing costly mistakes. Ensures Audit-Readiness: Creates a secure, digital archive of every receipt, linked directly to its corresponding transaction. Provides Real-Time Financial Clarity: Your expense log is always current, giving you an accurate snapshot of your business spending at any moment. Simplifies Tax Season: With perfectly organized records, preparing your tax return becomes a straightforward, stress-free process. Core Features & Automations 🧩 This workflow bundle is built around a simple yet powerful "Capture > Process > Log" model: 🧾 Multi-Modal Expense Capture: Photo Capture: Snap a photo of a receipt. The workflow automatically extracts the text using Optical Character Recognition (OCR). Text Capture: Send a simple text message describing an expense (e.g., "Software subscription for $15"). 🤖 AI-Powered Processing: Intelligent Data Extraction: An advanced AI Agent (powered by Mistral) analyzes the text from your photo or message to identify and structure key financial data. Structured Output: The AI formats the extracted information into a clean JSON object, identifying fields like: storename, date, time, totalprice, currency, itemdescription, category, and more. Smart Validation: A built-in check flags potential errors, like a transaction with a total of zero, and prompts you to double-check. 🗄️ Automated Logging & Archiving: Google Sheets Integration: Every valid expense is automatically appended as a new, neatly organized row in a designated Google Sheet. Google Drive Archiving: If a photo was submitted, the original receipt image is automatically saved to a specified Google Drive folder. Linked Records: The Google Sheet entry includes a direct hyperlink to the corresponding receipt image in Google Drive, creating a seamless, interconnected record. User Confirmation: The system sends a summary of the logged expense or a success/error message back to you via Telegram, closing the loop on every transaction. Getting Started: Setup & Customization 🛠️ Setting up your Pocket Bookkeeper is designed to be quick and easy: 1. Import the Workflow: Add the provided .json file to your n8n instance. 2. Configure Credentials: Telegram: Create a new bot via @BotFather on Telegram to get a Bot Token. Add this token to the Telegram Trigger and all Telegram sender nodes. Mistral AI: Obtain an API key from your Mistral AI console and create a Mistral Cloud API credential. Assign this to the Mistral Cloud Chat Model nodes. Google Drive & Google Sheets: Set up OAuth 2.0 credentials for the Google Drive and Google Sheets APIs in your Google Cloud Console. Create the corresponding credentials in n8n and assign them to the Google Drive and Google Sheets nodes. 3. Personalize Your Setup (Crucial!): Google Drive Folder: In the Save Receipt (Google Drive) node, specify the Folder ID where you want your receipt images to be saved. Google Sheet: In the Google Sheets node, enter your Spreadsheet ID and Sheet Name. Ensure your sheet has columns matching the data fields (e.g., storename, date, totalprice, etc.). (Optional) AI Prompting: Fine-tune the system messa