gspread-test.py

import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope = ['https://spreadsheets.google.com/feeds',
        'https://www.googleapis.com/auth/drive']
 
credentials = ServiceAccountCredentials.from_json_keyfile_name('client_secret.json', scope)
 
gc = gspread.authorize(credentials)
 
sh = gc.create("Test Sheet")
worksheet = sh.add_worksheet(title="A worksheet", rows="100", cols="20")
worksheet.update_acell('A1', 'Bingo!')
 
print(worksheet.acell('A1'))