dowload/get specific tab in a Google Sheet

Hello!

I cannot seem to find the documentation in the googledrive package about how to read in a specific tab from a Google Sheet. When I use drive_download(), it reads the first tab in the sheet I download.

I see some documentation from the googlesheets package - should I use gs_browse(ws = "name")? If so, how can that be combined with the the googledrive package?

Thanks!

The basic workflows for googlesheets can be found here:
https://rawgit.com/jennybc/googlesheets/master/vignettes/basic-usage.html

If you know the name of the worksheet, you can find it by title with:

 result <- googlesheets::gs_title("the_title_here")

You can then see all of the sheets/tabs in the worksheet with

googlesheets::gs_ws_ls(result)

Then you can read it in with googlesheets::gs_read().

googledrive will authenticate you to access your drive, etc. to allow you to perform the operations aobve.

Thank you very much!

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.