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: #> Client error: (404) NOT_FOUND #> * A specified resource is not found, or the request is rejected by undisclosed reasons, such as whitelisting. #> * Requested entity was not found.