is everything ok with googledrivereader

Can you share the full traceback?

sure, here:

Traceback (most recent call last):
File "D:\heloi\macall_rag\excluir.py", line 4, in <module>
red = reader.load_data(id)
File "C:\Users\heloi\anaconda3\envs\macall_rag_libs\lib\site-packages\llama_index\readers\google\drive\base.py", line 519, in load_data
self._creds = self._get_credentials()
File "C:\Users\heloi\anaconda3\envs\macall_rag_libs\lib\site-packages\llama_index\readers\google\drive\base.py", line 178, in _get_credentials
flow = InstalledAppFlow.from_client_config(self.client_config, SCOPES)
File "C:\Users\heloi\anaconda3\envs\macall_rag_libs\lib\site-packages\google_auth_oauthlib\flow.py", line 159, 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.

Based on the traceback it feels that its something to do with your credentials or on google console side. i would redownload fresh credentials and try again

ok thanks.

@Nehil can you tell me what json structure of credential.json? I just created a service account, as requested, but I think the json fields are not necessary. my new error is:

my credentials.json:
{
"type": "service_account",
"project_id": "",
"private_key_id": ",
"private_key": "-----BEGIN PRIVATE KEY-----\n-----END PRIVATE KEY-----\n",
"client_email": "",
"client_id": "",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "",
"universe_domain": "googleapis.com"
}

My friend tried it too and is having this:

@Logan M can u help me?

Google credentials are a nightmare. I don't think I know the solution here. Probably best to just read the source code and figure what it's doing and what you are missing

Using a service account key worked for me: https://cloud.google.com/iam/docs/keys-create-delete#iam-service-account-keys-create-console