Project Goal

This tool was built to reduce the manual effort of downloading monthly reports from marketing APIs.

Features

  • Multi-API Support: Integrates with Google Sheets and Stripe APIs.
  • Validation: Automated data validation checks for null values and data types.
  • CLI Interface: Easy-to-use command line prompts.

Technical Details

  • Built with Python 3.10+.
  • Libraries used: pandas, requests, sqlalchemy.
  • Fully tested with pytest.