2

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?

Rentrop
  • 20,979
  • 10
  • 72
  • 100
tlyons253
  • 83
  • 8
  • How long ago was it working? The Sheets api changed last year and only "old" sheets could still be accessed. Recently I noticed that the have been forcibly converting old format sheets to new sheets. You could see if this script helps https://github.com/elinw/ShinyGoogleSheets/blob/nodata/scripts/readGoogleSheet.R if it does I will make it an answer. – Elin Jun 25 '15 at 02:41
  • I had it working two weeks ago. I'll check it out – tlyons253 Jun 25 '15 at 12:20

2 Answers2

1

There is maybe a more trivial reason: You must "publish" every google sheet "as web page" (you can select the entire worksheet or a particular sheet). After that, you must "share" the sheet. Hope that helps!

Agile Bean
  • 6,437
  • 1
  • 45
  • 53
0

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

tlyons253
  • 83
  • 8