rr-googlesheets

googlesheets R authentication error


I used to have the googlesheets package in R pulling data off my drive account just fine, but recently when I start up I can't access the data. I've tried using the gs_auth(new_user=TRUE) to reset, but when I get taken to the web browser, I accept that I'm giving permission to access google, but then I get an error message saying the webpage is not available with the message "ERR_CONNECTION_RESET the connection to localhost was interrupted". I recently tried to use the boxR package to access data stored on box.com, did I change some setting that now is preventing googlesheets from working? If so, is there a specific way to fix it, or is a system restore to an earlier date the cleanest solution to getting google sheets to authenticate properly?


Solution

  • uninstalling and reinstalling the httr and googlsheets packages does the trick.