Reading Google Sheets

- The first argument to read_sheet() is the URL of the file to read, and it returns a tibble:

gs4_deauth()
students_url <- "https://docs.google.com/spreadsheets/d/1V1nPp1tzOuutXFLb3G9Eyxi3qxeEhnOXUzL5_BcCQ0w"

read_sheet(students_url)

## # A tibble: 6 × 5
##   `Student ID` `Full Name`      favourite.food     mealPlan            AGE      
##          <dbl> <chr>            <chr>              <chr>               <list>   
## 1            1 Sunil Huffmann   Strawberry yoghurt Lunch only          <dbl [1]>
## 2            2 Barclay Lynn     French fries       Lunch only          <dbl [1]>
## 3            3 Jayendra Lyne    N/A                Breakfast and lunch <dbl [1]>
## 4            4 Leon Rossini     Anchovies          Lunch only          <NULL>   
## 5            5 Chidiegwu Dunkel Pizza              Breakfast and lunch <chr [1]>
## 6            6 Güvenç Attila    Ice cream          Lunch only          <dbl [1]>