Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

sheets_id

sheets_id object


Description

A sheets_id is a spreadsheet identifier, i.e. a string. This is what the Sheets and Drive APIs refer to as spreadsheetId and fileId, respectively. When you print a sheets_id, we attempt to reveal its current metadata (via gs4_get()). This can fail for a variety of reasons (e.g. if you're offline), but the sheets_id is always revealed and is returned, invisibly.

Any object of class sheets_id will also have the drive_id class, which is used by googledrive for the same purpose. This means you can pipe a sheets_id object straight into googledrive functions for all your Google Drive needs that have nothing to do with the file being a spreadsheet. Examples: examine or change file name, path, or permissions, copy the file, or visit it in a web browser.

See Also

Examples

if (gs4_has_token()) {
  gs4_example("mini-gap")
}

googlesheets4

Access Google Sheets using the Sheets API V4

v0.3.0
MIT + file LICENSE
Authors
Jennifer Bryan [cre, aut] (<https://orcid.org/0000-0002-6983-2759>), RStudio [cph, fnd]
Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.