This brings me to a google page where I can click on my email account it asks for me to grant gmail scraping with R permission (see, edit, create, etc.) and you need to click 'Allow' three times. Then you click Go to Gmail Scraping with R (unsafe). After running gs_auth() with my generated key/secret I see the 'Advanced' tab (like what you see at the top of this issue and what you see when using googlesheets4) - so that's good. If that's a case, I get an error at Step 4. The thing that has stopped working in googlesheets it the built-in 'oauth app'.ĭid you mean that neither httr::oauth_app() or gargle::oauth_app_from_json() func from 'Gargle's 'How to Get your own API credentials'' work anymore and that we should instead use gs_auth(key =, secret = )? Hi Jenny, those are some excellent steps you've outlined. Provide YOUR 'client ID' (google's vocabulary) = key (httr's and googlesheets's vocabulary) and secret as arguments to gs_auth(): Step 4 / actual googlesheets (this package) usage: At any time, you can navigate to a particular client ID and click “Download JSON”. You can capture the client ID and secret via clipboard right away.

Do Create credentials > OAuth client ID.

From the Developers Console, in the target GCP Project, go to APIs & Services > Credentials.

The basic steps are described in the Prerequisites section for doing Google OAuth 2.0 for Mobile & Desktop Apps: Another reason to switch to newer packages unless you absolutely need to write into specific cells or worksheets. So auth is going to be much easier through those packages than through googlesheets (this package). Note that googlesheets4 and googledrive use a different app, that has gone through the verification process. And now it appears this will be mandatory from now until its end of life in March 2020, when the v3 Sheets API shuts down. Note that googlesheets (this package) has always been able to accept an OAuth app from a user. They are aggressively shutting down apps that are not verified. Google, for better or worse, seems to want individual users to go through this. It's very hard and has been getting harder for tools like googlesheets to include a built-in app. The thing that has stopped working in googlesheets it the built-in 'oauth app'.

This is called three-legged OAuth, where the 3 legs are the app or client, the user, and Google.

A regular user will generally need to send an OAuth2 token, which is obtained under the auspices of an OAuth “app” or “client”. Most APIs are used to create and modify resources on behalf of the user and these requests must include the user’s token. Step 3: Get an OAuth app = client ID and secret To make googlesheets (this package work), enable Drive and Sheets. Step 1: Get a Google Cloud Platform Project: I am quoting heavily from / linking to the page I linked to above.

Lol client has stopped working