# import gspread
# from oauth2client.service_account import ServiceAccountCredentials

# scope = ['https://spreadsheets.google.com/feeds']

# ## local
# key = "/Users/glinch/Downloads/spreadsheetreader-78cfe4680c5b.json"

# credentials = ServiceAccountCredentials.from_json_keyfile_name(key, scope)

# gc = gspread.authorize(credentials)

# gdoc_url = https://docs.google.com/spreadsheets/d/1SMplBOdm7IaK7SICwAYqRLtm9RRELTmTUK78pEelAXA/edit#gid=0

# wks = gc.open(gdoc_url).sheet1
# import gspread
# from oauth2client.service_account import ServiceAccountCredentials

# scope = ['https://spreadsheets.google.com/feeds']

# ## local
# key = "/Users/glinch/Downloads/spreadsheetreader-78cfe4680c5b.json"

# credentials = ServiceAccountCredentials.from_json_keyfile_name(key, scope)

# gc = gspread.authorize(credentials)

# gdoc_url = https://docs.google.com/spreadsheets/d/1SMplBOdm7IaK7SICwAYqRLtm9RRELTmTUK78pEelAXA/edit#gid=0

# wks = gc.open(gdoc_url).sheet1
# import gspread # from oauth2client.service_account import ServiceAccountCredentials # scope = ['https://spreadsheets.google.com/feeds'] # ## local # key = "/Users/glinch/Downloads/spreadsheetreader-78cfe4680c5b.json" # credentials = ServiceAccountCredentials.from_json_keyfile_name(key, scope) # gc = gspread.authorize(credentials) # gdoc_url = https://docs.google.com/spreadsheets/d/1SMplBOdm7IaK7SICwAYqRLtm9RRELTmTUK78pEelAXA/edit#gid=0 # wks = gc.open(gdoc_url).sheet1