json_key = json.load(open('gspread-8891908f3793.json')) scope = ['https://spreadsheets.google.com/feeds'] credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'], scope) gc = gspread.authorize(credentials) gc.login() sht1 = gc.openall() val = sht1[0].cell(1, 2).value