Example #1
0
def access_sheet(key):
    json_key = json.load(open('API Project-4af8ab99186b.json'))
    sheet = ['https://spreadsheets.google.com/feeds']
    sheet = SignedJwtAssertionCredentials(json_key['client_email'],
                                          json_key['private_key'], sheet)
    sheet = gspread.authorize(sheet)
    sheet = sheet.open_by_key(key)
    return sheet