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.

  • gs4_find("YOUR_SHEET_NAME") is another good way to get your hands on a Sheet.

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

This is a generic function.

Usage

Arguments

Examples