Hello again everyone! Here’s the step by step instructions for using the
googlesheets package in R to enable you to get your data from Google Sheets. This latest blog post comes from this video we published a little while ago.
Step 1 - Preparation
Create an authentication token for re-use
Run the following:
This springs open a window in your browser, and asks you to choose your preferred google account. You’ll have to choose one, and allow ‘tidyverse-googlesheets’ access to continue.
You should now see a page stating “Authentication complete. Please return to R.”
Step 2 - Add R Script into Power BI using token
Click through the following: + Get data + More + Other + R Script
Into the pop up window, paste the following: (Without wanting to state the obvious…change the relevant file paths to something you want to look at…OR open up that link for a sheet we compiled with loads more great R resources!)
You will then be able to navigate through your google docs and load them into your Power BI workspace!
If you want to read and combine all your sheets, here’s a handy bit of code to do just that, simply switch it out with the corresponding code in the block above. (Keep all four packages!)