Update read_team_sheet() to use googlesheets4

[mmc46]

I think read_team_sheet() needs to be updated to use the new googlesheets4 package.

Currently it throws an error at the authentication stage.

Sign in with Google temporarily disabled for this app This app has not yet been verified by Google in order to use Google Sign in.

[jefferis]

@SridharJagannathan if you have a moment to look at this one, would be useful. We are e.g. using these google sheets to store annotation for FIB papers.

[mmc46]

fib_pns=read_team_sheet(id='1P-ITJs9JdexIahOaU5teKaQ7fi0t5G0QOtTrAfRGwGM', team_drive = 'flyconnectome', ws = "PNs")

[SridharJagannathan]

Closed by #53

[mmc46]

This requires the dev version of googlesheets4
devtools::install_github("tidyverse/googlesheets4")

Otherwise it throws the error

fib_pns<-read_team_sheet(id = '1P-ITJs9JdexIahOaU5teKaQ7fi0t5G0QOtTrAfRGwGM', team_drive='flyconnectome',ws='PNs')
The googlesheets4 package is requesting access to your Google account. Select a pre-authorised account or enter '0' to obtain a new token. Press Esc/Ctrl + C to abort.
1: dascyllus3@gmail.com
2: mmc46@cam.ac.uk
Selection: 2
Error: Don't know how to coerce an object of class 'sheets_meta/list' into a 'sheets_id' 

[jefferis]

So @SridharJagannathan if that version is essential to your fix, then you need to specify a Remote pointing to the dev version.

[SridharJagannathan]

@mmc46 I have decided to follow an alternate strategy after discussing with @jefferis based on tidyverse/googlesheets4#74. Can you please test this after uninstalling the dev version of googlesheets4