googlesheets4 (version 0.1.0)

as_sheets_id: Coerce to a sheets_id object

Description

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: https://docs.google.com/spreadsheets/d/1BzfL0kZUz1TsI5zxJF1WNF01IxvC67FbOJUiiGMZ_mQ/edit#gid=1150108545.

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

  • googledrive::drive_get("YOUR SHEET NAME") is a great way to look up a Sheet via its name.

This is a generic function.

Usage

as_sheets_id(x, ...)

Arguments

x

Something that uniquely identifies a Google Sheet: a sheets_id, URL, or dribble.

...

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

Examples

# NOT RUN {
as_sheets_id("abc")
# }