Using R and Google Sheets
Today, I meet a big problem about my ERP system built in Google Sheets, and I don’t want to shape a too complicated one such as WordPress or Django.
In that, inspired by gspread, a python package, I am trying googlesheets package, a counterpart of another R package.
Firstly, download the git repository and install.
If you’re network blocked, you could download manually.
$git clone $firstname.lastname@example.org:jennybc/googlesheets.git
$R CMD INSTALL googlesheets
Now, we could manipulate googlesheets with R.
the more method you can see the official manual and shiny exampl!
Reference:Jennifer in UsingR Conference 2015
Related Shiny Examples