A few notes about necessary steps for you to be able to write data to Google Sheets from R.
There are a lot of websites that let you scrape content without any complicated software so Google Chrome would be enough to do that.
A story about hidden costs in free Google Data Studio and a simple way to reduce the costs of Google Data Studio and Google BigQuery connection.