# Retrieve the google sheet
library(googledrive)
#> Warning: package 'googledrive' was built under R version 3.6.2
library(testsheets)
# indicate there is no need for an access token since we are accessing
# a read-only sheet via a public link
googledrive::drive_deauth()
# get document metadata from Google Drive
dribble <- testsheets::testsheets_example("google sheets")
# Load the "sum" sheet into a tibble
sum_testsheet <- read_testsheet(dribble, sheet = "sum")
#> Using an auto-discovered, cached token.
#> To suppress this message, modify your code or options to clearly consent to the use of a cached token.
#> See gargle's "Non-interactive auth" vignette for more details:
#> https://gargle.r-lib.org/articles/non-interactive-auth.html
#> The googlesheets4 package is using a cached token for brewer36@purdue.edu.
#> Reading from "testsheets_example"
#> Range "'sum'"