Connect to Google Sheets in Power BI using R

February 16, 2018

(This article was first published on R on Locke Data Blog, and kindly contributed to R-bloggers)

Hello again everyone! This latest blog post comes from this youtube video that we published a little while ago.
Here’s the step by step instructions for using the ‘googlesheets’ package in R to enable you to get your data from Google Sheets
Step 1 – Preparation Create an authentication token for re-use Run the following:
library(googlesheets) token <- gs_auth(cache = FALSE) gd_token() saveRDS(token, file="googlesheets_token.rds") This springs open a window in your browser, and asks you to choose your prefered google account.

To leave a comment for the author, please follow the link and comment on their blog: R on Locke Data Blog. offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...

If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Search R-bloggers


Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)