Read Google Sheets Data — read_googlesheets • ohcleandat

For a given sheet id, this handles authentication and reads in a specified sheet, or all sheets.

Usage

read_googlesheets(
  key_path,
  sheet = "all",
  ss,
  add_primary_key_field = FALSE,
  primary_key = "primary_key",
  ...
)

Arguments

key_path: character path to Google authentication key json file
sheet: Sheet to read, in the sense of "worksheet" or "tab".
ss: Something that identifies a Google Sheet such as drive id or URL
add_primary_key_field: Logical. Should a primary key field be added?
primary_key: character. The column name for the unique identifier to be added to the data.
...: other arguments passed to googlesheets4::range_read()

Value

tibble

See also

googlesheets4::range_read()

Examples

if (FALSE) { # \dontrun{
read_googlesheets(ss = kzn_animal_ship_sheets, sheet = "all",)
} # }