I 'm trying to use Shiny with Google Sheets.
I've created a Service Count for the API Google Sheet.
I've got the JSON file with this Service Count that I've used in my code.
drive_auth(path = "/Users/nahandove/Documents/PROJET R VISUALISATION/TEST_CONNECTION_SHINY_APP/ConnectionGoogleSheet/singular-glow-XXXXXXXXXXX.json") testLectureSheet<-read_sheet("https://docs.google.com/spreadsheets/dxxxxxxxxx/edit?usp=sharing") View(testLectureSheet)
I' ve got this issue
**An error has occurred** The application failed to start (exited with code 1). Attachement du package : ‘googlesheets4’ The following objects are masked from ‘package:googledrive’: request_generate, request_make Error in value[[3L]](cond) : Can't get Google credentials. Are you running googledrive in a non-interactive session? Consider: * `drive_deauth()` to prevent the attempt to get credentials. * Call `drive_auth()` directly with all necessary specifics. * Read more in: https://gargle.r-lib.org/articles/non-interactive-auth.html Calls: local ... tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous> Exécution arrêtée
Do you ave an idea to help me on this subject ? Thanks.