def reciever():
# use creds to create a client to interact with the Google Drive API
scope = ['https://spreadsheets.google.com/feeds']
creds = ServiceAccountCredentials.from_json_keyfile_name('Lemur-key.json', scope)
client = gspread.authorize(creds)
sheet = client.open("Lemur Responses").sheet1
receipents = filter(None, sheet.col_values(3)[1:])
return receipents
评论列表
文章目录