R package googlesheets4 returns Client error: (429) RESOURCE_EXHAUSTED when reading a public sheet

1.5k Views Asked by At
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'.
1

There are 1 best solutions below

1
On

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