tidyverse / googlesheets4

Google Spreadsheets R API (reboot of the googlesheets package)
https://googlesheets4.tidyverse.org
Other
360 stars 53 forks source link

Access blocked: Tidyverse API Packages’s request is invalid #287

Closed quantumlinguist closed 1 year ago

quantumlinguist commented 1 year ago

I am using Colab with R for the first time (always used R studio) and I got stuck in the authentication step.

I run drive_auth(use_oob = TRUE, cache = TRUE)

and when I click on the link to get the code, I get Access blocked: Tidyverse API Packages’s request is invalid

Anyone know how to fix this?

Thanks

jennybc commented 1 year ago

Better Colab support is coming in a near-term gargle release. It is already possible to auth there, in various ways, but they are all clunky. It's not the easy experience one gets when working on a local computer, but I believe it soon will be.

In the meantime, you can install gargle (which powers googledrive's auth) from a branch to test it the new solution out.

More details are here: https://github.com/r-lib/gargle/issues/140

quantumlinguist commented 1 year ago

Thanks! I used the code below and it worked 😊

@.***") install.packages("googledrive")

library(googledrive)

drive_auth(cache = FALSE) drive_find(n_max = 5)

Gustavo Guajardo, PhD LinkedIn Profile https://www.linkedin.com/in/guajardogustavo/ Research Gate Profile https://www.researchgate.net/profile/Gustavo-Guajardo

On Tue, Mar 28, 2023 at 5:19 PM Jennifer (Jenny) Bryan < @.***> wrote:

Better Colab support is coming in a near-term gargle release. It is already possible to auth there, in various ways, but they are all clunky. It's not the easy experience one gets when working on a local computer, but I believe it soon will be.

In the meantime, you can install gargle (which powers googledrive's auth) from a branch to test it the new solution out.

More details are here: r-lib/gargle#140 https://github.com/r-lib/gargle/issues/140

— Reply to this email directly, view it on GitHub https://github.com/tidyverse/googlesheets4/issues/287#issuecomment-1487093870, or unsubscribe https://github.com/notifications/unsubscribe-auth/APV733CXMK4ZAABGN3XLLXDW6L6RBANCNFSM6AAAAAAWKQHJTY . You are receiving this because you authored the thread.Message ID: @.***>