Complex SQL queries are hard to construct and maintain. Using BigQuery scripting you can automate this process.
You need to know only a few lines of code to start using Vagrant.
A few notes about necessary steps for you to be able to write data to Google Sheets from R.
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.