.env.example

# GOOGLE GMAIL SETUP (Account A - for fetching invoices)
GOOGLE_GMAIL_CLIENT_ID=your-gmail-client-id.apps.googleusercontent.com
GOOGLE_GMAIL_CLIENT_SECRET=your-gmail-client-secret

# GOOGLE DRIVE SETUP (Account B - for storing invoices)
GOOGLE_DRIVE_CLIENT_ID=your-drive-client-id.apps.googleusercontent.com
GOOGLE_DRIVE_CLIENT_SECRET=your-drive-client-secret
GOOGLE_DRIVE_FOLDER_LOCATION=billing/all-expenses/2025

# SCHEDULING
# Day of month to automatically fetch invoices (1-31)
FETCH_INVOICES_DAY=5

# KEYWORDS
# Comma-separated keywords to search for in emails
# The tool will search for emails containing ANY of these keywords with attachments
# Include bank-related keywords to automatically detect and organize bank statements
TARGET_KEYWORDS_TO_FETCH_AND_DOWNLOAD="invoice, fatura, statement, bank, extrato, movimientos, fiscal, tributary"

# FINANCIAL INSTITUTION DETECTION
# The tool automatically detects bank statements, brokerages, exchanges, and financial documents from emails containing:
# - Digital Banks: Wise, Revolut, Nubank, Bunq, Monzo, Starling, Chime, etc.
# - Traditional Banks: Santander, BBVA, CaixaBank, ING, Deutsche Bank, HSBC, Barclays, etc.
# - Brokerages & Trading Platforms: Interactive Brokers, Charles Schwab, E*TRADE, TD Ameritrade, Fidelity, Robinhood, Webull
# - Cryptocurrency Exchanges: Coinbase, Binance, Kraken, Coinbase Pro, Binance US
# - Payment Processors: Stripe, PayPal, Adyen, Mollie
# - European Banks: All major banks from Spain, Portugal, Italy, France, Germany, Netherlands, Poland, Czech Republic, Austria, Switzerland, Nordic countries
# - Keywords: "bank", "banco", "statement", "extrato", "movimientos", "financial", "fintech", "fiscal", "tributary"
# Combined with TARGET_KEYWORDS_TO_FETCH_AND_DOWNLOAD
# No additional configuration needed - works automatically
# Detected institutions are organized in folders with proper capitalization (e.g., "Stripe", "Interactive Brokers", "Coinbase")

# POSTGRES DATABASE
POSTGRES_USERNAME=invoicepilot_user
POSTGRES_PASSWORD=your_secure_password_here
DATABASE_URL=postgresql://invoicepilot_user:your_secure_password_here@localhost:57552/invoicepilot

# WISE API SETTINGS (optional - for Wise bank integration)
WISE_API_KEY=your-wise-api-key
WISE_PROFILE_ID=your-wise-profile-id
WISE_PRIVATE_KEY_PATH=/path/to/private_pkcs8.pem

# DEBUG
DEBUG_LOGS_ENABLED=false