This blog is a how-to guide for leveraging R Markdown output files to create a basic ETL process that feeds other data products also hosted on RStudio Connect.
This is what I built to demonstrate the workflow:
Here is a link to the code template: https://gist.github.com/kellobri/f026e30f672b1ab8d6eb2c2f2b91deeb
More information about R Markdown output files can be found in the RStudio Connect user guide here
Please let me know if you try building something similar, I'd love to hear about it!