Цитата: credentials = ServiceAccountCredentials.from_json_keyfile_name(CREDENTIALS_FILE, ['https://www.googleapis.com/auth/spreadsheets', 'https://www.googleapis.com/auth/drive'])
Так должно работать:
CODE:link1 = 'https://www.googleapis.com/auth/spreadsheets'
link2 = 'https://www.googleapis.com/auth/drive'
credentials = ServiceAccountCredentials.from_json_keyfile_name(CREDENTIALS_FILE, [link1, link2]) |