SD_Hackathon / src /data_upload.py
com3dian's picture
Create data_upload.py
8456cea verified
raw
history blame
597 Bytes
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])