A simple, professional Python app that reads data from Google Sheets using a Service Account and displays it in a Tkinter GUI.
- Enter Spreadsheet name and optional Worksheet name.
- Connect via gspread + oauth2client.service_account.
- Display data in a scrollable Treeview grid.
- Clean
src/layout, tests, CI, Ruff+Black formatting.
- Create a Service Account & enable APIs
- In Google Cloud Console, enable Google Sheets API and Google Drive API.
- Create a Service Account, generate a JSON key (download it).
- Share your Google Sheet with the Service Account email (Editor or Viewer).
- Clone & install
python -m venv .venv
source .venv/bin/activate # Windows: .venv\Scripts\activate
pip install -e .[dev]