Hi @kieran, in short, a simple R script, coupled with a scheduler should work. If this is a Linux server, then you just need R, a cron job and the R script.
Going a bit beyond, instead of downloading the resulting CSVs, I would leave them in a folder inside the server that my shiny app can access, so I can see the trends and insights without moving files.