Converts various representations of a Google Sheet into a
sheets_id object. Anticipated inputs:
Spreadsheet id, "a string containing letters, numbers, and some special
characters", typically 44 characters long, in our experience. Example:
A URL, from which we can excavate a spreadsheet or file id. Example: https://docs.google.com/spreadsheets/d/1BzfL0kZUz1TsI5zxJF1WNF01IxvC67FbOJUiiGMZ_mQ/edit#gid=1150108545.
dribble, a "Drive tibble" used by the
googledrive package. In general, a
dribble can represent several
files, one row per file. Since googlesheets4 is not vectorized over
spreadsheets, we are only prepared to accept a one-row
Spreadsheet meta data, as returned by, e.g.,
this is an object of class
This is a generic function.
Other arguments passed down to methods. (Not used.)
as_sheets_id("abc")#> Spreadsheet name: <unknown> #> ID: abc #> Locale: <unknown> #> Time zone: <unknown> #> # of sheets: <unknown> #> #> Unable to get metadata for this Sheet. Error details: #> Can't get Google credentials. #> Are you running googlesheets4 in a non-interactive session? Consider: #> * `gs4_deauth()` to prevent the attempt to get credentials. #> * Call `gs4_auth()` directly with all necessary specifics. #> See gargle's "Non-interactive auth" vignette for more details: #> https://gargle.r-lib.org/articles/non-interactive-auth.html