Export data from Google Sheets to R

Question

Hey, guys, what’s up? I’m a beginner in R and I have a question: It is possible, and if possible, which is the way to export data from a table of google Sheets (or Drive) to R. There is some library for this?

Answer 1

You can use the package googlesheets, here will a link demonstrating an example of using this package.

To find other packages with keywords that we don’t know yet, besides searching on google, there are some options direct the environment R:

function findFn() package sos:

sos::findFn('google')
sos::findFm('sheets')

This function returns a web page with a table of possible functions and their respective packages.

function search.cran() package NCmisc:

NCmisc::search.cran('google')
# $google
#  [1] "googleAnalyticsR"        "googleAuthR"
#  [3] "googleCloudStorageR"     "googleComputeEngineR"
#  [5] "googledrive"             "googleformr"
#  [7] "GoogleKnowledgeGraphR"   "googleLanguageR"
#  [9] "googlenlp"               "googlePolylines"
# [11] "googlePrintr"            "googlePublicData"
# [13] "googlesheets"            "googleVis"
# [15] "googleway"               "plotGoogleMaps"
# [17] "RGoogleAnalyticsPremium" "RGoogleFit"
# [19] "RgoogleMaps"             "rgoogleslides"


NCmisc::search.cran('sheets')
# $sheets
# [1] "googlesheets"

If the keyword is common, we can use the function grep() to find a second keyword in the list:

google <- NCmisc::search.cran('google')[[1]]

google[grep('sheet', google)]
# [1] "googlesheets"

Or simply use more than one keyword in the function search.cran():

NCmisc::search.cran(c('google','sheet'))
# [1] "episheet" "googlesheets" "gsheet"

More options for searching packages are available here.