r - How to change Google Accounts using library(googlesheets)? -
i experience problems. use r-script on 1 machine successfully. same script used on different computer causes problems:
# here register sheet browser <- gs_title("funnel daily")
browser<-gs_edit_cells(ws="classic browser", browser, input = classicbrowser, anchor = "a1",byrow = false, col_names = null, trim = f,verbose = true)
auto-refreshing stale oauth token. error in gs_lookup(., "sheet_title", verbose) : "funnel daily" doesn't match sheet_title of sheet returned gs_ls() (which should reflect user's google sheets home screen). > browser <- gs_title("funnel daily") error in gs_lookup(., "sheet_title", verbose) : "funnel daily" doesn't match sheet_title of sheet returned gs_ls() (which should reflect user's google sheets home screen).` if using gl_ls() message google account use. there way maybe via token or differentiate between accounts or how can solve issue. mean how can force googlesheets access specific account? i'm using tokenof account corresponds funnel daily. possibility can think of may have caused issue browser-authentification done account not included funnel daily..i confused them. tried remove googlesheets httrwith dependencies. when running library(googlesheets) , asking gs_user googlesheets refers account doesnt include specific sheet.
include credentials , confirm browser authentication via funnel daily google account:
options(googlesheets.client_id = "", googlesheets.client_secret = "", googlesheets.httr_oauth_cache = false) gs_auth(token = null, new_user = false, key = getoption("googlesheets.client_id"), secret = getoption("googlesheets.client_secret"), cache = getoption("googlesheets.httr_oauth_cache"), verbose = true) cheers
Comments
Post a Comment