Google Spreadsheets Python API

Official Google Spreadsheet API is flexible but can take a considerable amount of work if your idea is “just” accessing the data of the spreadsheets and doing a few operations on them.

To leverage all the API work and help us all there is gspread, which wraps up the API and makes clear and pragmatic functions sprout.

Using OAuth2 for Authorization

http://gspread.readthedocs.io/en/latest/oauth2.html