If want a simple to understand library for Google Spreadsheets, here ya go:
https://github.com/burnash/gspread
Here is a simple example from the github page:
import gspread
# Login with your Google account
gc = gspread.login('thedude@abid.es','password')
# Open a worksheet from spreadsheet with one shot
wks = gc.open("Where is the money Lebowski?").sheet1
wks.update_acell('B2', "it's down there somewhere, let me take another look.")
Nice an easy!