Skip to content

← Back to projects

Google Sheets Report Automation

Overview

A system for automatically preparing management reports in Google Sheets.

A reusable client manages spreadsheet operations and formatting, while a desktop interface lets the user select the period, business area and currency.

Focus

How to turn a Google Sheets integration into a reusable user-facing tool rather than a one-off script.

Technologies

  • Python
  • Google Sheets API
  • Tkinter
  • OAuth
  • Automated testing