[Case Study] Subscription Management

The Challenge: Digital professionals manage multiple subscriptions across different currencies and billing cycles, making it difficult to track total expenses and identify cost-saving opportunities.

The Solution: Built an automated financial monitoring system using Google Sheets, Apps Script, and Data Studio that:

• Tracks subscription services across multiple currencies

• Automatically updates exchange rates daily via API integration

• Provides interactive visualizations of spending trends and category breakdowns

• Projects annual expenses with dynamic calculations