3. How to read data from Google sheets

With the gsheet R package you can download Google Sheets using a sharing link. You can download the data from the google sheet as a data frame or plain text.

Installation

[code language=”r”]
install.packages(‘gsheet’)
[/code]

Getting started

To download a google sheet, use the following code. The link can be copied while you are on the google sheet.

[code language=”r”]
library(gsheet)
gsheet2tbl(‘docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo’)
[/code]

Reference: https://github.com/maxconway/gsheet