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])