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.