R tricks >

Read data from a Google Sheet

Note that this uses the tidyverse/googlesheets4 package, not the original googlesheets which used the Google Sheet v3 API.

library(googlesheets4)

df <- read_sheet("https://docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxxxxxxxxx")