Skip to main content

Tidyverse Skills for Data Science

Carrie Wright, Shannon E. Ellis, Stephanie C. Hicks, Roger D. Peng

Section 2.15 googledrive

Another really helpful package is the googledrive package which enables users to interact with their Google Drive directly from R. This package, unlike the googlesheets4 package, also allows for users to interact with other file types besides Google Sheets. It however does not allow for as many modifications of these files like the googlesheets4 package allows for Google Sheets files.
🔗
Using googledrive requires having an established Google Drive account. You will be asked to authorize access for the package to interact with your Google Drive.
🔗
Finding files in your drive can be done using drive_find().
🔗
# install.packages("googledrive")
# load package
library("googledrive")
# Files can be found based on file name words like this:
drive_find(pattern ="tidyverse")
# Files can be found based on file type like this:
drive_find(type ="googlesheets")
# Files that have specific types of visibility can be found like this:
files <- drive_find(q = c("visibility = 'anyoneWithLink'"))
Files can be viewed from your default browser by using the drive_browse() function:
🔗
drive_browse("tidyverse")
Files can be uploaded to your Google Drive using the drive_upload() function.
🔗
drive_upload(here::here("tidyverse.txt"))
If we wanted this file to be converted and saved as a Google file, then we would do the following based on the type of Goggle document desired. Only certain types of files can be converted to each type of Google file.
🔗
drive_upload(here::here("tidyverse.txt"), type = "document")
drive_upload(here::here("tidyverse.csv"), type = "spreadsheet")
drive_upload(here::here("tidyverse.pptx"), type = "presentation")
Files can be downloaded using the drive_download() function. Google file types need to be converted to a conventional file type. For example one might save a Google Sheet file to a CSV file. This would download a file called tidyverse.csv to your project directory. This file could then be used in an analysis.
🔗
drive_download("tidyverse", type = "csv")
tidyverse_data <-readr::read_csv(here("tidyverse.csv"))
Files can be moved to trash using the drive_trash() function. This can be undone using the drive_untrash() function.
🔗
The trash can also be emptied using drive_empty_trash().
🔗
drive_trash("tidyverse.txt")
drive_untrash("tidyverse.txt")
drive_empty_trash()
To permanently remove a file you can use the drive_rm() function. This does not keep the file in trash.
🔗
drive_rm("tidyverse.txt")
Files can be shared using the drive_share() function. The sharing status of a file can be checked using drive_reveal().
🔗
drive_share(file = "tidyverse", 
            role = "commenter", 
            type = "user", 
            emailAddress = "someone@example.com",
            emailMessage = "Would greatly appreciate your feedback.")

drove_share_anyone(file = "tidyverse", verbose = TRUE) # anyone with link can read

drive_reveal(file = "tidyverse", what = "permissions")
There are many other helpful functions for interacting with the files in your Google Drive within the googledrive package.
🔗
🔗
PrevTopNext