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

0
Downloads
6
Views
8.26
Quality Score
intermediate
Complexity
Author:Dmitrij Zykovic(View Original β†’)
Created:2/13/2026
Updated:3/19/2026

πŸ”’ Please log in to import templates to n8n and favorite templates

Workflow Visualization

Loading...

Preparing workflow renderer

Comments (0)

Login to post comments