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

install.packages('gsheet')

Getting started

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

library(gsheet)
gsheet2tbl('docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo')

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

  Fant du det du lette etter? Did you find this helpful?
[Average: 0]