library(googlesheets4)
url_rls <- "https://docs.google.com/spreadsheet/d/17eJ05pg6fkzKlwwiWn0ztdMvzBX9pGx3q6w7h3_vJw4/"
gs4_deauth()
read_sheet(url_rls)
Returns this error sometimes, but not always. Do I need to login just to read a public file?
Error: Client error: (429) RESOURCE_EXHAUSTED
* Either out of resource quota or reaching rate limiting. The client should look for google.rpc.QuotaFailure error detail for more information.
* Quota exceeded for quota group 'ReadGroup' and limit 'Read requests per 100 seconds' of service 'sheets.googleapis.com' for consumer 'project_number:603366585132'.
When I get this error message to either knit my RMD or to process a graphic I have a workaround (because I do not know how to do the API fix).
Normally I input on the console gs4_auth() & to knit I input rmarkdown::render("file.Rmd").
And that error does not appear anymore and I´m able to render everything