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') }