Track invoice spending vs budget from Google Drive with GPT-4o and Telegram alerts
Invoice Budget Tracker
Drop invoices to Google Drive and let AI handle the rest - OCR extraction, automatic categorization, budget tracking, and Telegram alerts when spending reaches thresholds.
β¨ Key Features
π Invoice OCR** - Extracts data from PDF/image invoices automatically π€ AI Categorization** - Detects document type (skips contracts, delivery acts) and categorizes real invoices π° Budget Tracking** - Set monthly budgets per category, track spending in real-time π Smart Alerts** - Get notified when category spending reaches 80%+ of budget π Auto-Organization** - Files renamed and sorted into monthly folders π Deduplication** - SHA256 hash prevents duplicate processing π Scheduled Reports** - Weekly progress (Fridays) and monthly summaries (10th) π¬ Telegram Control** - Manage budgets via natural language chat
π― How It Works
Drop invoice to Google Drive watched folder: PDF invoices Image scans (JPG, PNG)
AI processes automatically (hourly): OCR extracts text via Ainoflow AI detects if it's actually an invoice (skips contracts, receipts, etc.) Extracts: vendor, amount, date, invoice number Categorizes based on service provided Checks for duplicates
Get organized: File renamed: [2026-01-15] - Vendor (INV-123, 150.00 EUR).pdf Moved to monthly folder: /Invoices/2026-01/ Budget updated, alerts sent if threshold reached
Manage budgets via Telegram: "Set budget Software 500" "Show budgets" "Budget status"
π Expense Categories
Software, Marketing, Travel, Office, Professional Services, Infrastructure, Vehicle, Other
π§ Setup Requirements
Google Drive** β OAuth setup for file operations Telegram Bot** β Create bot for notifications and budget management OpenRouter** β Get API key for AI processing Ainoflow** β Sign up for OCR and JSON storage
ποΈ Workflow Architecture
| Section | Description | |---------|-------------| | Document Processing | Hourly scan β OCR β AI categorization β Budget tracking β File organization | | Budget Management | Telegram bot for budget CRUD via AI Agent with MCP storage | | Weekly Report | Friday summary of current month progress | | Monthly Report | 10th of month detailed report for previous month | | Data Reset | Manual trigger to delete all invoice data (requires approval) |
π¬ Usage Examples
Invoice Processing π Drop "invoice_aws.pdf" to /Invoices/ β β AWS | 150.00 EUR | Software β File: [2026-01-15] - AWS (INV-2026-01, 150.00 EUR).pdf β Moved to: /Invoices/2026-01/
π Drop "contract.pdf" to /Invoices/ β β οΈ Skipped: This is a service agreement, not an invoice β File renamed: [REVIEW] - contract.pdf
Budget Management (Telegram) "Set budget Software 500" β β Budget set: Software - β¬500/month
"Show budgets" β π Monthly Budgets: β’ Software: β¬500 β’ Marketing: β¬1000 Total: β¬1500/month
"Budget status" β π January 2026: β’ Software: β¬150/β¬500 (30%) β β’ Marketing: β¬850/β¬1000 (85%) β οΈ
Scheduled Reports π Weekly (Friday): β π Week Summary: Processed: 12 invoices Total: β¬2,450 Top: Software β¬800, Marketing β¬650
π Monthly (10th): β π January 2026 Report: Total: β¬4,200 (28 invoices) [ββββββββββ] Software 80% [ββββββββββ] Marketing 60%
π¦ Data Storage
Invoices stored in Ainoflow JSON Storage by month (key = SHA256 hash): { "vendor": "Amazon Web Services", "vendor_normalized": "AWS", "amount": 150.00, "currency": "EUR", "date": "2026-01-15", "invoice_number": "INV-2026-01", "category": "Software", "file_id": "1BxiMVs0XRA5nFMd...", "processed_at": "2026-01-15T10:30:00Z" }
β οΈ Important Notes
Run /start first** - Registers your chat_id, locks bot to you Document type detection** - Contracts, delivery acts, receipts are skipped automatically Budget alerts at 80%** - Only triggers if budget is set for category Duplicates detected** - Same file won't be processed twice (SHA256 hash) Data Reset is permanent** - Requires manual approval Single currency** - All invoices assumed same currency (no conversion)
π οΈ Customization
Categories Edit SetDefaults node β allowed_categories Then send /start to re-register with new categories
Processing Thresholds Edit WorkflowConfig node: alert_threshold - Budget alert % (default: 0.8) review_prefix - Failed files prefix (default: "[REVIEW] - ") duplicate_prefix - Duplicate prefix (default: "[DUPLICATE] - ")
AI Models Swap OpenRouter models in Gpt4oCategorizer and Gpt4oBudgetAgent nodes
πΌ Need Customization?
Want to adapt this template for your business? Custom integrations, multi-user support, or enterprise deployment?
Contact us at Ainova Systems - We build AI automation solutions for businesses.
Tags: google-drive, invoice-processing, budget-tracking, ai-agent, ocr, telegram, openrouter, mcp-tools, business-automation
Related Templates
AI Email Classifier & Auto-Delete for Gmail (SPAM/OFFER Cleaner)
This workflow is designed for freelancers, solopreneurs, and business owners who receive a high volume of irrelevant mes...
Automatic News Summarization & Email Digest with GPT-4, NewsAPI and Gmail
π° AI News Digest Agent: Auto News Summarizer & Email Newsletter Create an intelligent news curation system that automat...
Generate Food Recipes from Gmail & Form Requests with Ollama & Llama 3.2
This n8n template demonstrates how to create an intelligent food recipe assistant that accepts requests via Gmail and we...
π Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments