Spaces:
Sleeping
Sleeping
import gspread | |
from oauth2client.service_account import ServiceAccountCredentials | |
def connect_to_sheet(): | |
scope = ["https://spreadsheets.google.com/feeds", | |
"https://www.googleapis.com/auth/spreadsheets", | |
"https://www.googleapis.com/auth/drive"] | |
creds = ServiceAccountCredentials.from_json_keyfile_name("creds.json", scope) | |
client = gspread.authorize(creds) | |
sheet = client.open("leaderboard").sheet1 | |
return sheet | |
def append_score(timestamp, score, filename): | |
sheet = connect_to_sheet() | |
sheet.append_row([timestamp, score, filename]) |