In nicole-brewer/testsheets: Automating the creation of testthat scripts from Google Drive spreadsheets

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>"
)

Read a Public Testsheet

# Retrieve the google sheet
library(googledrive)
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")

nicole-brewer/testsheets documentation built on Sept. 26, 2021, 6:46 a.m.