google-sheet-python.example

import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ['https://spreadsheets.google.com/feeds']
credentials = ServiceAccountCredentials.from_json_keyfile_name('client_secret.json', scope)

gc = gspread.authorize(credentials)

# Open a worksheet from spreadsheet with one shot
wks = gc.open("sheetname").sheet1

wks.update_acell('B2', "SellValue")

# Fetch a cell range
cell_list = wks.range('A1:B7')