gspread_service_account_auth_and_cell_update.py

1import gspread
2
3# Authenticate using a service account JSON file
4gc = gspread.service_account(filename='service_account.json')
5
6# Open a sheet from a spreadsheet in one go
7sh = gc.open("Example spreadsheet")
8
9# Update a cell
10sh.sheet1.update_acell('B1', 'Bingo!')
11
12# Get all values from the first worksheet
13list_of_hashes = sh.sheet1.get_all_records()
14
15# Print the result
16print(list_of_hashes)