I wrote up notes on connecting to Google Sheets with Python recently.