Skip to contents

Write Data to a Google Sheet

write_gs.Rd

Specialized methods for writing data created by DO.utils to a specified Google Sheet.

Usage

write_gs(data, ss, hyperlink_curie = NULL, ...)

# S3 method for omim_inventory
write_gs(
  data,
  ss,
  hyperlink_curie = c("omim", "doid"),
  datestamp = "%Y%m%d",
  ...
)

Arguments

data

A specially-classed data.frame with a defined method.

ss

Something that identifies a Google Sheet:

  • its file id as a string or drive_id

  • a URL from which we can recover the id

  • a one-row dribble, which is how googledrive represents Drive files

  • an instance of googlesheets4_spreadsheet, which is what gs4_get() returns

Processed through as_sheets_id().

hyperlink_curie

<tidy-select> The columns with CURIEs to convert to hyperlinks when written in Google Sheets.

...

Arguments passed on to methods.

datestamp

NULL or NA to use the default sheet name ('omim_inventory') or a format recognized by format.Date() to add a date stamp suffix, separated by '-', to the default sheet name.

Value

The data as written to the Google Sheet, invisibly.