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 token
of 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
httr
with 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