# string with invalid character is rejected

    Code
      as_sheets_id("abc&123")
    Condition
      Error in `validate_drive_id()`:
      ! A <drive_id> must match this regular expression: `^[a-zA-Z0-9_-]+$`
      Invalid input:
      x 'abc&123'

# invalid inputs are caught

    Code
      as_sheets_id(letters[1:2])
    Condition
      Error in `validate_sheets_id()`:
      ! A <sheets_id> object can't have length greater than 1.
      x Actual input has length 2.

# multi-row dribble is rejected

    Code
      as_sheets_id(d)
    Condition
      Error in `as_sheets_id()`:
      ! <dribble> input must have exactly 1 row.
      x Actual input has 2 rows.

# dribble with non-Sheet file is rejected

    Code
      as_sheets_id(d)
    Condition
      Error in `as_sheets_id()`:
      ! <dribble> input must refer to a Google Sheet, i.e. a file with MIME type 'application/vnd.google-apps.spreadsheet'.
      i File name: "chicken.txt"
      i File id: '1wOLeWVRkTb6lDmLRiOhg9iKM7DlN762Y'
      x MIME TYPE: 'text/plain'

# sheets_id print method reveals metadata

    Code
      print(gs4_example("gapminder"))
    Output
      
      -- <googlesheets4_spreadsheet> -------------------------------------------------
       Spreadsheet name: "gapminder"                                 
                     ID: 1U6Cf_qEOhiR9AZqTqS3mbMF3zt2db48ZP5v3rkrAEJY
                 Locale: en_US                                       
              Time zone: America/Los_Angeles                         
            # of sheets: 5                                           
      # of named ranges: 1                                           
      
      -- <sheets> --------------------------------------------------------------------
      (Sheet name): (Nominal extent in rows x columns)
          'Africa': 625 x 6
        'Americas': 301 x 6
            'Asia': 397 x 6
          'Europe': 361 x 6
         'Oceania': 25 x 6
      
      -- <named ranges> --------------------------------------------------------------
      (Named range): (A1 range)        
           'canada': 'Americas'!A38:F49

# sheets_id print method doesn't error for nonexistent ID

    Code
      as_sheets_id("12345")
    Output
      
      -- <googlesheets4_spreadsheet> -------------------------------------------------
      Spreadsheet name: "<unknown>"
                    ID: 12345      
                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.

# can print public sheets_id if deauth'd

    Code
      print(gs4_example("mini-gap"))
    Output
      
      -- <googlesheets4_spreadsheet> -------------------------------------------------
      Spreadsheet name: "mini-gap"                                  
                    ID: 1k94ZVVl6sdj0AXfK9MQOuQ4rOhd1PULqpAu2_kr9MAU
                Locale: en_US                                       
             Time zone: America/Los_Angeles                         
           # of sheets: 5                                           
      
      -- <sheets> --------------------------------------------------------------------
      (Sheet name): (Nominal extent in rows x columns)
          'Africa': 6 x 6
        'Americas': 6 x 6
            'Asia': 6 x 6
          'Europe': 6 x 6
         'Oceania': 6 x 6

# sheets_id print does not error for lack of cred

    Code
      print(gs4_example("mini-gap"))
    Output
      
      -- <googlesheets4_spreadsheet> -------------------------------------------------
      Spreadsheet name: "<unknown>"                                 
                    ID: 1k94ZVVl6sdj0AXfK9MQOuQ4rOhd1PULqpAu2_kr9MAU
                Locale: <unknown>                                   
             Time zone: <unknown>                                   
           # of sheets: <unknown>                                   
      
      Unable to get metadata for this Sheet. Error details:
      Can't get Google credentials.
      i Are you running googlesheets4 in a non-interactive session? Consider:
      * Call `gs4_deauth()` to prevent the attempt to get credentials.
      * Call `gs4_auth()` directly with all necessary specifics.
      i See gargle's "Non-interactive auth" vignette for more details:
      i <https://gargle.r-lib.org/articles/non-interactive-auth.html>