search

googlecolab / colabtools

Python libraries for Google Colaboratory
Apache License 2.0
2.19k stars 720 forks source link

Error: Credentials need to be from either oauth2client or from google-auth. --- Did not occur before #2710

Closed dea1n closed 2 years ago

dea1n commented 2 years ago

All of a sudden the authentication process has an error for importing google sheets. A new window does not open to copy and paste authentication code. Once I click "allow" I then get the credential error message.

Please help,

sheilambadi commented 2 years ago

I am having the same issue.

blois commented 2 years ago

What mechanism are you using to authenticate?

Do these instructions work for you? https://colab.research.google.com/notebooks/io.ipynb#scrollTo=6d0xJz3VzLOo&line=7&uniqifier=1

dea1n commented 2 years ago

Thank you for your response Blais.

It always worked since I started to use Colab in January 2022. I last used Colab night-time March 28th and morning of March 29th, then later that day, it gave me the problem.

On Wed, Mar 30, 2022, 11:33 AM blois @.***> wrote:

What mechanism are you using to authenticate?

Do these instructions work for you? https://colab.research.google.com/notebooks/io.ipynb#scrollTo=6d0xJz3VzLOo&line=7&uniqifier=1

— Reply to this email directly, view it on GitHub https://github.com/googlecolab/colabtools/issues/2710#issuecomment-1083297170, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNUR5PEGP2NQPY3CR22LVCRX4FANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.***>

dea1n commented 2 years ago

Problem fixed.

Thank you very much for your concern

On Wed, Mar 30, 2022, 2:40 PM Michael Rosen @.***> wrote:

Thank you for your response Blais.

It always worked since I started to use Colab in January 2022. I last used Colab night-time March 28th and morning of March 29th, then later that day, it gave me the problem.

On Wed, Mar 30, 2022, 11:33 AM blois @.***> wrote:

What mechanism are you using to authenticate?

Do these instructions work for you? https://colab.research.google.com/notebooks/io.ipynb#scrollTo=6d0xJz3VzLOo&line=7&uniqifier=1

— Reply to this email directly, view it on GitHub https://github.com/googlecolab/colabtools/issues/2710#issuecomment-1083297170, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNUR5PEGP2NQPY3CR22LVCRX4FANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.***>

dea1n commented 2 years ago

Hi Sheila, my friend fixed it for me. Let me know if you still need help

On Wed, Mar 30, 2022, 8:37 AM Sheila Mbadi @.***> wrote:

I am having the same issue.

— Reply to this email directly, view it on GitHub https://github.com/googlecolab/colabtools/issues/2710#issuecomment-1083087568, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNUWBLL73ISXTUTLOKGLVCRDJTANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.***>

SUPER-TADORY commented 2 years ago

I have the same issue. Would you tell me how to fix this?

dea1n commented 2 years ago

Hello Ryu, My friend helped me. there was an update to the code. For my application the code is

authenicate with google

from google.colab import auth auth.authenticateuser() import gspread from google.auth import default creds, = default()

gc = gspread.authorize(creds)

def Load3DMatrixFromSheet(worksheetName):

get worksheet from google sheets

worksheet = gc.open(worksheetName) worksheets = worksheet.worksheets()

convert sheet into an array

multiDimensionalMatrix = [] for sheet in worksheets: multiDimensionalMatrix.append(sheet.get_all_values())

return matrix of excel sheet

return np.array(multiDimensionalMatrix).astype(np.float);

Hope this helps

On Wed, Mar 30, 2022 at 10:30 PM Ryu Tadokoro @.***> wrote:

I have the same issue. Would you tell me how to fix this?

— Reply to this email directly, view it on GitHub https://github.com/googlecolab/colabtools/issues/2710#issuecomment-1084007658, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNURAH3KYBJMLFUDS4STVCUE5JANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.***>

dea1n commented 2 years ago

Hi Sheila,

Hello Ryu, My friend helped me. there was an update to the code. For my application the code is

authenicate with google

from google.colab import auth auth.authenticateuser() import gspread from google.auth import default creds, = default()

gc = gspread.authorize(creds)

def Load3DMatrixFromSheet(worksheetName):

get worksheet from google sheets

worksheet = gc.open(worksheetName) worksheets = worksheet.worksheets()

convert sheet into an array

multiDimensionalMatrix = [] for sheet in worksheets: multiDimensionalMatrix.append(sheet.get_all_values())

return matrix of excel sheet

return np.array(multiDimensionalMatrix).astype(np.float);

Hope this helps

On Wed, Mar 30, 2022 at 8:37 AM Sheila Mbadi @.***> wrote:

I am having the same issue.

— Reply to this email directly, view it on GitHub https://github.com/googlecolab/colabtools/issues/2710#issuecomment-1083087568, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNUWBLL73ISXTUTLOKGLVCRDJTANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.***>

SUPER-TADORY commented 2 years ago

Thank you for reply dea1n! It helped me a lot.

Hello Ryu, My friend helped me. there was an update to the code. For my application the code is #authenicate with google from google.colab import auth auth.authenticateuser() import gspread from google.auth import default creds, = default() gc = gspread.authorize(creds) … ___ def Load3DMatrixFromSheet(worksheetName): #get worksheet from google sheets worksheet = gc.open(worksheetName) worksheets = worksheet.worksheets() #convert sheet into an array multiDimensionalMatrix = [] for sheet in worksheets: multiDimensionalMatrix.append(sheet.get_all_values()) #return matrix of excel sheet return np.array(multiDimensionalMatrix).astype(np.float); ____ Hope this helps On Wed, Mar 30, 2022 at 10:30 PM Ryu Tadokoro @.> wrote: I have the same issue. Would you tell me how to fix this? — Reply to this email directly, view it on GitHub <#2710 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNURAH3KYBJMLFUDS4STVCUE5JANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.>

cperry-goog commented 2 years ago

We've rolled out a new, more secure method to authenticate in Colab. This requires using the same account to auth.authenticate_user() as you use for notebook code execution.

lcvidelam commented 2 years ago

Muchas gracias, esta solución funcionó para mi

Hi Sheila, Hello Ryu, My friend helped me. there was an update to the code. For my application the code is #authenicate with google from google.colab import auth auth.authenticateuser() import gspread from google.auth import default creds, = default() gc = gspread.authorize(creds) … ___ def Load3DMatrixFromSheet(worksheetName): #get worksheet from google sheets worksheet = gc.open(worksheetName) worksheets = worksheet.worksheets() #convert sheet into an array multiDimensionalMatrix = [] for sheet in worksheets: multiDimensionalMatrix.append(sheet.get_all_values()) #return matrix of excel sheet return np.array(multiDimensionalMatrix).astype(np.float); ____ Hope this helps On Wed, Mar 30, 2022 at 8:37 AM Sheila Mbadi @.> wrote: I am having the same issue. — Reply to this email directly, view it on GitHub <#2710 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNUWBLL73ISXTUTLOKGLVCRDJTANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.>

Mu

dea1n commented 2 years ago

Wonderful to hear. Glad I could be helpful.

On Thu, Mar 31, 2022, 2:54 AM Ryu Tadokoro @.***> wrote:

Thank you for reply dea1n! It helped me a lot.

Hello Ryu, My friend helped me. there was an update to the code. For my application the code is #authenicate with google from google.colab import auth auth.authenticateuser() import gspread from google.auth import default creds, = default() gc = gspread.authorize(creds) … <#m-134170563059764218> ___ def Load3DMatrixFromSheet(worksheetName): #get worksheet from google sheets worksheet = gc.open(worksheetName) worksheets = worksheet.worksheets() #convert sheet into an array multiDimensionalMatrix = [] for sheet in worksheets: multiDimensionalMatrix.append(sheet.get_all_values()) #return matrix of excel sheet return np.array(multiDimensionalMatrix).astype(np.float); ____ Hope this helps On Wed, Mar 30, 2022 at 10:30 PM Ryu Tadokoro @.> wrote: I have the same issue. Would you tell me how to fix this? — Reply to this email directly, view it on GitHub <#2710 (comment) https://github.com/googlecolab/colabtools/issues/2710#issuecomment-1084007658>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNURAH3KYBJMLFUDS4STVCUE5JANCNFSM5SA6GIKA https://github.com/notifications/unsubscribe-auth/AYPFNURAH3KYBJMLFUDS4STVCUE5JANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.>

— Reply to this email directly, view it on GitHub https://github.com/googlecolab/colabtools/issues/2710#issuecomment-1084166921, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYPFNUXWSVBECIXLSRRUL7TVCVD23ANCNFSM5SA6GIKA . You are receiving this because you authored the thread.Message ID: @.***>