Can shiny app (deployed in shinyapp.io) download and read google sheets data everytime it is being run?
I am using the code as below and works locally, but not when it is being ran at shinnyapp.io.
library(googledrive)
library(readxl)
library(xts)
drive_auth_config(active = FALSE)
drive_download(as_id("id_of_file"),overwrite = TRUE)
data <- read_excel("filename.xlxs")