в качестве учебного пособия использую
https://habr.com/ru/post/483302/ статью
создаю сервис аккаунт , создаю кей с помощью json
при попsтке запуска quickstart.py
Traceback (most recent call last):
File "D:/python_project/aiogram-bot-googlesheet/1.py", line 12, in <module>
gc = pygsheets.authorize()
File "D:\python_project\aiogram-bot-googlesheet\venv\lib\site-packages\pygsheets\authorization.py", line 129, in authorize
credentials = _get_user_authentication_credentials(client_secret, scopes, credentials_directory, local)
File "D:\python_project\aiogram-bot-googlesheet\venv\lib\site-packages\pygsheets\authorization.py", line 46, in _get_user_authentication_credentials
flow = Flow.from_client_secrets_file(client_secret_file, scopes=scopes,
File "D:\python_project\aiogram-bot-googlesheet\venv\lib\site-packages\google_auth_oauthlib\flow.py", line 206, in from_client_secrets_file
return cls.from_client_config(client_config, scopes=scopes, **kwargs)
File "D:\python_project\aiogram-bot-googlesheet\venv\lib\site-packages\google_auth_oauthlib\flow.py", line 164, in from_client_config
raise ValueError("Client secrets must be for a web or installed app.")
ValueError: Client secrets must be for a web or installed app.
Process finished with exit code 1