I'm currently creating a shiny app that uses the googlesheets4 package to simply read in some data from a sheet in my organization. The app works locally and I got my google credentials to work in shinyapps.io. However, this only works when the app is public, not private. When I change the app to Private, it continuously tries to reload itself and nothing happens.. I 100% need the app to be private. Has anyone run into this before? Seems strange the app works publicly but not when it is switched to private...
options(gargle_verbosity = "debug") gs4_auth( email = "myemailhere", path = NULL, scopes = "https://www.googleapis.com/auth/drive", cache = "path_to_cache", use_oob = FALSE, token = NULL)
Log from shiny app:
request_generate, request_make The following object is masked from ‘package:shinyjs’: trying `token_fetch()` trying `credentials_service_account()` Error caught by `token_fetch()`: trying `credentials_external_account()` trying `credentials_byo_oauth()` trying `credentials_app_default()` trying `credentials_gce()` adding "userinfo.email" scope The following objects are masked from ‘package:googlesheets4’: Argument 'txt' must be a JSON string, URL or file. aws.ec2metadata not installed; can't detect whether running on EC2 instance Error caught by `token_fetch()`: inherits(token, "Token2.0") is not TRUE Gargle2.0 initialize loading token from the cache matching token found in the cache attempt to access internal gargle data from: googlesheets4 Listening on http://127... trying `credentials_user_oauth2()`