How to automate reports, web scrape data using Rstudio

Since it sounds like you're still in the phase of your project of 'how do I even approach this kinds of problems with R?', I'd also like to encourage you to check out Garret and Hadley's book, It contains a nice collection of chapters on various tools useful to project a project like this, and is a nice onboard to R and the Tidyverse generally.

When you do get to the point where you are looking for help with a specific coding question, I'd encourage you to check out FAQ: Tips for writing R-related questions. It's a nice guide to improve the probability folks who want to help can understand your problem, and quickly reply with useful suggestions.