0

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

zx8754
  • 52,746
  • 12
  • 114
  • 209
Alexis
  • 2,104
  • 2
  • 19
  • 40
  • 1
    Try following this guide: https://googlesheets4.tidyverse.org/articles/articles/drive-and-sheets.html. Otherwise tell us exactly what steps you followed to enable the API. – MrFlick Dec 04 '19 at 21:43
  • 1
    Does this answer your question? [R Googlsheets: Unable to use \`gs\_auth()\` in googlesheets package - Sign In With Google Temporarily Disabled App Not Verified Issue](https://stackoverflow.com/questions/58869050/r-googlsheets-unable-to-use-gs-auth-in-googlesheets-package-sign-in-with) – camille Dec 04 '19 at 22:32
  • Hello @MrFlick and camille, I have solved this problem, the wrong part of the code was using gs_auth(), which is not recognized by the googlesheets4 library. I had to use sheets_auth() which authenticates and grants access to google sheets. Thank you very much for being patient and give me your advice. – Alexis Dec 05 '19 at 22:48

1 Answers1

0

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

Alexis
  • 2,104
  • 2
  • 19
  • 40