{"action":"created","issue":{"url":"https://api.github.com/repos/jennybc/googlesheets/issues/166","labels_url":"https://api.github.com/repos/jennybc/googlesheets/issues/166/labels{/name}","comments_url":"https://api.github.com/repos/jennybc/googlesheets/issues/166/comments","events_url":"https://api.github.com/repos/jennybc/googlesheets/issues/166/events","html_url":"https://github.com/jennybc/googlesheets/issues/166","id":105112627,"number":166,"title":"R Markdown, gs_url, private sheet","user":{"login":"hardin47","id":7210585,"avatar_url":"https://avatars.githubusercontent.com/u/7210585?v=3","gravatar_id":"","url":"https://api.github.com/users/hardin47","html_url":"https://github.com/hardin47","followers_url":"https://api.github.com/users/hardin47/followers","following_url":"https://api.github.com/users/hardin47/following{/other_user}","gists_url":"https://api.github.com/users/hardin47/gists{/gist_id}","starred_url":"https://api.github.com/users/hardin47/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hardin47/subscriptions","organizations_url":"https://api.github.com/users/hardin47/orgs","repos_url":"https://api.github.com/users/hardin47/repos","events_url":"https://api.github.com/users/hardin47/events{/privacy}","received_events_url":"https://api.github.com/users/hardin47/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-09-06T19:23:22Z","updated_at":"2015-10-12T18:47:35Z","closed_at":"2015-09-06T21:30:40Z","body":"I'm trying to use the gs_url command to download a googlesheet.  The problem is that I have to interactively authenticate the googlesheet.  But I want to use the command within an R Markdown file (which needs to run independently of any interactivity from the user).  Is there any work around to this?  Thanks for any help!!  It's the second command that won't work.\r\n\r\ndrinks_url = \"https://docs.google.com/spreadsheets/d/1KYMUjrCulPtpUHwep9bVvsBvmVsDEbucdyRZ5uHCDxw/edit?hl=en_GB#gid=0\"\r\n\r\ndrinks = gs_url(drinks_url, visibility=\"private\")"},"comment":{"url":"https://api.github.com/repos/jennybc/googlesheets/issues/comments/147489153","html_url":"https://github.com/jennybc/googlesheets/issues/166#issuecomment-147489153","issue_url":"https://api.github.com/repos/jennybc/googlesheets/issues/166","id":147489153,"user":{"login":"hardin47","id":7210585,"avatar_url":"https://avatars.githubusercontent.com/u/7210585?v=3","gravatar_id":"","url":"https://api.github.com/users/hardin47","html_url":"https://github.com/hardin47","followers_url":"https://api.github.com/users/hardin47/followers","following_url":"https://api.github.com/users/hardin47/following{/other_user}","gists_url":"https://api.github.com/users/hardin47/gists{/gist_id}","starred_url":"https://api.github.com/users/hardin47/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hardin47/subscriptions","organizations_url":"https://api.github.com/users/hardin47/orgs","repos_url":"https://api.github.com/users/hardin47/repos","events_url":"https://api.github.com/users/hardin47/events{/privacy}","received_events_url":"https://api.github.com/users/hardin47/received_events","type":"User","site_admin":false},"created_at":"2015-10-12T18:47:35Z","updated_at":"2015-10-12T18:47:35Z","body":"Another thing I figured out...  if you do gs_auth(new_user=TRUE) in the console, you must do it within the same directory where your markdown file lives."}}