Finds your Google Sheets. This is a very thin wrapper around
googledrive::drive_find()
, that specifies you want to list Drive files
where type = "spreadsheet"
. Therefore, note that this will require auth for
googledrive! See the article Using googlesheets4 with googledrive
if you want to coordinate auth between googlesheets4 and googledrive. This
function will emit an informational message if you are currently logged in
with both googlesheets4 and googledrive, but as different users.
gs4_find(...)
... | Arguments (other than |
---|
An object of class dribble
, a tibble with one row per item.
if (gs4_has_token()) { # see all your Sheets gs4_find() # see 5 Sheets, prioritized by creation time x <- gs4_find(order_by = "createdTime desc", n_max = 5) x # hoist the creation date, using other packages in the tidyverse # x %>% # tidyr::hoist(drive_resource, created_on = "createdTime") %>% # dplyr::mutate(created_on = as.Date(created_on)) }#> # A tibble: 5 x 3 #> name id drive_resource #> * <chr> <chr> <list> #> 1 sheet-resize-demo 1nvKGlHsDujFLeCCP3sXfTfax0fhbu2vR-x-YLCXZ… <named list [34… #> 2 fiery-hart 18KiiL2AGkL9nTkjHdOXGmeUQzqnOLqWnnOIEnWY6… <named list [34… #> 3 chicken-sheet 1StV8oqHa0SVo58ztLGPH5mDMMHIBsiF6VO5GUJjM… <named list [34… #> 4 releasable-rooster 1cMnXxJE-B55ZSyPzvv3yyXv2hZ0vu45Tp8LJV24e… <named list [34… #> 5 eonian-atlasmoth 1BMEsbT_kSfV4zBl6si7HZXuda6kThG27vHuYc4Bv… <named list [34…