🗓️ Step‑by‑Step Project Plan Day 1 – Setup & Gmail API
- Create repo and Python environment
- Install dependencies (fastapi, uvicorn, pandas, sqlalchemy, google-api-python-client)
- Enable Gmail API, fetch credentials
- Print raw order emails to console Day 2 – Parse Orders
- Regex/email parsing for app, item, amount, date
- Save to CSV for testing Day 3 – Database Integration
- Create orders table in Postgres/SQLite
- Insert parsed orders via Python Day 4 – Analytics Functions
- Pandas queries: spend per app, top items, avg spend, weekly trend
- Expose via FastAPI /analysis endpoint Day 5 – Frontend Basics
- Initialize React Native app
- Fetch /analysis API and display results Day 6 – Visualization
- Add charts (pie, bar, list) using react-native-chart-kit or Victory Day 7 – Polish & Portfolio
- Add JWT authentication
- Write README with screenshots
- Optional: PDF monthly report
🎯 Stretch Goals
- Automate daily sync with CRON job
- Push data into Microsoft Fabric + Power BI
- Add notifications (“You spent 20% more this week”