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
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...
Auto-classify Gmail emails with AI and apply labels for inbox organization
Who is this for? Professionals and individuals who receive high volumes of emails, those who want to automatically organ...
Generate Product Ad Copy & CTAs with GPT-4 for Slack and Airtable
β‘ AI Copywriter Pro: Instant Ad Copy & CTA Generator Transform product details into compelling marketing copy in second...
π Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments