tidyverse / googlesheets4

Google Spreadsheets R API (reboot of the googlesheets package)
https://googlesheets4.tidyverse.org
Other
360 stars 53 forks source link

sheet_write fails to execute. #229

Closed rhamo closed 2 years ago

rhamo commented 3 years ago

sheet_write fails to execute. I constantly receive this error below. If I change my required sheet_write spreadsheet to a blank new spreadsheet the sheet_write command will execute correctly. Does anyone have any advice what I'm doing wrong?

Writing to "datasheetfinal"
Writing to sheet "datastore"
Error: Server error: (503) UNAVAILABLE
* Service unavailable. Typically the server is down.
* The service is currently unavailable.
Run `rlang::last_error()` to see where the error occurred.
> rlang::last_error()
<error/gargle_error_request_failed>
Server error: (503) UNAVAILABLE
* Service unavailable. Typically the server is down.
* The service is currently unavailable.
Backtrace:
 1. googlesheets4::sheet_write(...)
 2. gargle::response_process(resp_raw)
 3. gargle:::gargle_abort_request_failed(error_message(resp), resp)
 4. gargle:::gargle_abort(...)
Run `rlang::last_trace()` to see the full context.
jennybc commented 3 years ago

I would take this at face value:

Error: Server error: (503) UNAVAILABLE
* Service unavailable. Typically the server is down.
* The service is currently unavailable.