From Google Sheets to R

The benefit of keeping your data in Google Sheets is that they only exist in one place, and you can set in detail who has access to it (view, comment, edit etc). Then it is a good idea to read the data directly from your Sheets database into R as a csv file. You can do this using a "published link" to a particular table (sheet) in your database (your sheets document).
Creat such a link in Google Sheets using File /Share/Publish to web
Then choose the specific table (instead of Entire Document) and choose Comma separated values .csv instead of Web page
Then copy the link. it is a good idea to have a MetTables table in your database that contains the links to each table, see this example database 

Next, you can read one or more tables from Google Sheets directly into R using:
readr::read_csv("link")
The important thing here is that you do not use intermediate, local files. This important for version management. Only one version of the dataset exists, and all collaborators on a project are using that same dataset in the cloud. 

Next, you can use the functions of the dplyr library to further manage your data in R, such as filtering records, selecting variables, grouping and summarizing or calculating new variables. See the page dplyr for data management