Skip to content

Instantly share code, notes, and snippets.

@jwaage

jwaage/googlesheet.R

Created February 3, 2016 12:55
Show Gist options
  • Save jwaage/e11cf80f8ff8ba11613f to your computer and use it in GitHub Desktop.
Save jwaage/e11cf80f8ff8ba11613f to your computer and use it in GitHub Desktop.
Download ZIP
Get data from google sheet
Raw
googlesheet.R
library("googlesheets")
# Forbind til google. Efter denne kommando åbner browseren, og du skal logge ind på google.
gs_ls()
# Herefter registerer du det pågældende ark med enten ark-navnet, eller som her, ark-nøglen (står i URLen)
sheet_key <- "15WDkfscZ-3xuSE33WRmj5PIpC-q5Eto8wUlWqlv-x2w"
sheet_object <- gs_key(sheet_key)
sheet_csv <- gs_read_csv(sheet_object, "Fanenavn")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment