title: How can I read a Google spreadsheet in a Team Drive in R?
body: <p>this is probably a really simple question, but I can't seem to figure it out.
  We recently moved a project from a shared folder on Google Drive to a Team Drive. I used to directly access the spreadsheet from R with this code:</p>
  
  <pre><code>library(googlesheets)
  mydir &lt;- gs_ls() #authenticate to google list sheets
  mydir$sheet_title
  mygs &lt;- gs_title(x = "FileName", verbose = F) #read file
  mygs &lt;- gs_read(ss = mygs, ws = "SheetName", skip=1) # get specific worksheet
  </code></pre>
  
  <p>But now that we moved the project, it doesn't work anymore, as the googlesheets package only works on my Google Drive directory. I've found a package for accessing my Team Drive (googledrive) and I've managed to find the file within the directory but I can't seem to figure out how to READ my specific worksheet anymore:</p>
  
  <pre><code>library(googledrive)
  td &lt;- team_drive_find()
  myfile &lt;- drive_find(team_drive = as_id(td$id[td$name=="TDriveName"]),
                       pattern = "FileName")
  myfile &lt;- drive_get(id = as_id(myfile$id), verbose = TRUE)
  </code></pre>
  
  <p>This gives me a tibble with the metadata of the spreadsheet but not the actual spreadsheet like gs_title() does. There has to be a function to do this right?</p>