I want to publish Rmd as a document with source code that will run every day. I followed gargle documentation on Project-level OAuth cache. My authentication code looks like:
googlesheets4::gs4_auth(cache = ".secrets", email = TRUE)
It works as expected when running on Workbench but I can't publish it because of Can't get Google credentials. error. When I publish the document, there's no possibility to include the .secrets folder although I read here that I should include it.
How do you publish to Rstudio Connect? Which version of Workbench and rsconnect do you use? For me files in a .secret folder are added automatically even when the folder itself is hidden:
Thank you for your reply.
I use rsconnect_0.8.25 and RStudio Connect v2022.03.2 (together with R 4.1). I have 1 Rmd file that I want to publish as "document with source code", like that:
I want to publish it from RStudio Workbench.
Interesting, publishing an R Markdown document is different than publishing a Shiny app, which is what I tried. In addition, the file finder from "Add More ..." does not respect the "Show Hidden Files" setting of the main files pane. I will report this to our developers. As a workaround, you can explicitly navigate to the .secrets folder via "..." in the file finder:
Thank you, it works now!