bot.py 文件源码

def build_arrays():
    json_key = json.load(open('chopped bot-610249be55b6.json'))
    scope = ['https://spreadsheets.google.com/feeds']
    credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'].encode(), scope)
    gc = gspread.authorize(credentials)
    sh = gc.open("choppedbot")
    weird_sheet = sh.worksheet("weird")
    normal_sheet = sh.worksheet("normal")
    weird_array = weird_sheet.col_values(1)
    normal_array = normal_sheet.col_values(1)

    return normal_array, weird_array