"Google Client Login Error: Login Failed" since 2015/5/26

[ArxArcher]

Hi, all
I have encountered error message "Google Client Login Error: Login Failed" since 2015/5/26.

I use "Username and Password" authentication, the google account & password are not misspelled, I can use them to login and retrieve spreadsheet data normally before 2015/5/26.

Any help will be greatly appreciated :)

[jpillora]

Uh ohhhh https://developers.google.com/api-client-library/java/google-api-java-client/client-login

Important: Do not use ClientLogin for new applications. Instead, use the more secure OAuth 2.0 authentication protocol. ClientLogin is a deprecated authentication protocol, which is being turned down on April 20, 2015. At that time, ClientLogin requests will no longer be answered. If you have existing applications that use ClientLogin, you must migrate to OAuth 2.0. The ClientLogin support in this library will be removed in the next major release.

[jpillora]

Seems like Google is killing client logins, this will need a documentation fix

[cosmicscr]

I'm seeing the same 'login failed' error today. I just started using this library so I thought there was something wrong with my credentials. Can this module be used with OAuth 2.0?

[jpillora]

I think you can use the Google API Console to generate a static token where you can use it like this https://github.com/jpillora/node-edit-google-spreadsheet#basic-usage

[jpillora]

Would be good if someone could confirm this process so the docs can be updated

[cosmicscr]

cool thanks for the tip. I'll be looking into this in the next few days and I'll let you know if I come up with anything valuable.

[RamonGebben]

Same problem here. People at my desk asking why apps don't work anymore.
Let's work on a fix that works with oAuth.

Anybody wanna make a tasklist?

[dimitrydeclercq]

The easiest way I found to fix this:

1. Go to https://console.developers.google.com
2. Create a project
3. In the project, go to 'APIs & Auth' -> 'Credentials' and 'Create New Client ID'
4. Select 'Service Account' as the type and p12 as your container
5. Convert the downloaded p12 to PEM with 'openssl pkcs12 -in [the pem file] -out google-oauth.pem -nocerts -nodes
6. In your code, where you do the login via user/pass change it to:

oauth : {
  email: '[mail address stated next to your created client id]', // something like 'random-string-123abc@developer.gserviceaccount.com'
  keyFile: 'google-oauth.pem' // make sure the path is correct
}

1. Share documents with the above mail address

I think that's about all I did to get it back working

[jpillora]

@Dredalious thanks, though I'm wondering if there's a way to create a static access key

[dimitrydeclercq]

I tried finding that as well, but didn't come up with something that worked. I'm guessing the static thing is for when you have another process that retrieved the oauth token, so you can reuse it without requesting a new/other one.

[cosmicscr]

I managed to get OAuth 2 working independently, the result of which is an access token (a string) that needs to be passed along in the API urls. It seems that perhaps all we need to do is add a new authentication path in the library that just takes an OAuth 2 access token (which you obtain separately) then the library is perfectly usable again... just choose to pass in an access token. I won't be able to look into this for a few days but thought I would share this thought right away.