Sheets

Overview

sheets is a CLI and Library that allows for the downloading and uploading of google sheets via csv files.

Usage

In order to use this program, you must setup a google cloud project if you seek to have this operate on spreadsheets you have access to. It may be useful to check out the Google Python Quickstart for relevant information.

Specifically, you want to create a Google Cloud Project, so you can copy over the project credentials to associate this program with and get authentication and authorization to work for you.

1. Create Google Cloud Project
2. Enable the Google Sheets API
3. Configure OAuth Consent Screen
4. Create OAuth Credentials
5. Copy Credentials Over to Project
6. Add Yourself As a Test User to Your Cloud Project

sheets -h

sheets --url "your_spreadsheet_url_here"

Development

prek install
uv sync
. .venv/bin/activate
sheets -h