search

jennybc / googlesheets

Google Spreadsheets R API
Other
783 stars 191 forks source link

I need help with basic gs issues #379

Closed sugottfried closed 5 years ago

sugottfried commented 5 years ago

Hi, I'm brand new to the googlesheets library and it's just what I need.
I am having what appears to be basic issues, I'm sorry to say.

gs_auth(new_user = TRUE) # this command runs without issue gs_ls() # this command returns a list of googlesheets that are in my docs.google.com/spreadsheets/ folder of which one is STG2019 gs_ls("STG2019") # this returns the sheet_title author perm version updated, etc. however the title field in both this one and the previous command gs_ls() there are many leading spaces in the name thus you can't see STG2019. (Could this be a problem?) lstitle <- gs_title('STG2019',verbose = TRUE) # this command returns "Error in gs_lookup(., "sheet_title", verbose) : "STG2019" doesn't match sheet_title of any sheet returned by gs_ls()

What am I missing?

Thanks so much. Susan Gottfried

sugottfried commented 5 years ago

I did try the my_sheets <- gs_ls() my_sheets %>% glimpse()

and that works just fine

but when I say gs_ws_ls(mysheets) I get Error in inherits(ss, "googlesheet") : object 'mysheets' not found

sugottfried commented 5 years ago

OK, last update. I have another R script that reads a googlesheet, but only the first worksheet is of interest. so I followed that exactly.

lstitle <- gs_title('STG2019') lsdetails <- gs_read(lstitle) and that works

but now I need to get a list of all of its worksheets and then read them in

ls_sheets <- gs_ws_ls('STG2019') throws the error: Error in gs_ws_ls("STG2019") : inherits(ss, "googlesheet") is not TRUE

sugottfried commented 5 years ago

I re-installed the package "googlesheets" and things are working now. Sorry.....