Read / access a google sheet from a Google team drive

read_team_sheet reads (and finds) a google sheet on a team drive

get_team_sheet finds a google sheet on a team drive. You can use the returned

read_team_sheet(path = NULL, id = NULL, team_drive = NULL, ws = 1,
  ...)

get_team_sheet(path = NULL, id = NULL, team_drive = NULL)

Arguments

path	File name or other path specifier
id	File id (quicker than using the name)
team_drive	Anything that specifies the team drive
ws	positive integer or character string specifying index or title, respectively, of the worksheet. The special value of Inf means all sheets.
...	Additional arguments passed to gs_read_csv

Value

A tibble or, when ws specifies more that one sheet, a list of tibbles nammed by the sheet name. For get_team_sheet a googlesheet object.

Details

Google sheet objects on team drives are not simply accessible by the googlesheets package.

Examples

if (FALSE) {
pns<-read_team_sheet('AL_fragments_spreadsheet', team_drive='flyconnectome',ws=1:2)
gs <- get_team_sheet(id='1QMCbGXmJqxIm2K-IvNivN3od9QKzZCb5kA_Dqn9xjNs')
}