rgooglesheets4

R can't access googlesheets4, despite API enabled

I use R to connect to Google Analytics and I can sign in, but when trying to connect to Google Sheets it doesn't let me sign in. I tried the following code:

library(googlesheets4)
gs_auth()

And it takes me to the user authentication page, but the message is again:

Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use Google Sign In.

I checked that googlesheets API is enabled. Do you have any advice for this issue? Thank you.

Regards,

Alexis

Solution

  • I had to use sheets_auth() which authenticates and grants access in googlesheets4 library.