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: 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps.

  • A URL, from which we can excavate a spreadsheet or file id. Example: "".

  • A one-row 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 dribble.

  • Spreadsheet meta data, as returned by, e.g., gs4_get(). Literally, this is an object of class googlesheets4_spreadsheet.

This is a generic function.

as_sheets_id(x, ...)



Something that uniquely identifies a Google Sheet: a sheets_id, a drive_id, a URL, a one-row dribble, or a googlesheets4_spreadsheet.


Other arguments passed down to methods. (Not used.)


#> 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.