R Notebook

`

# 1. Install and load the gsheet library
if (!require("gsheet")) install.packages("gsheet")

## Loading required package: gsheet

library(gsheet)

# 2. Use your shared Google Sheet URL
url <- "https://docs.google.com/spreadsheets/d/1d8O9SFO6rTehRGrl6aahHpXo45z_fVl48xyHLardnf4/edit?usp=sharing"

# 3. Import the data directly into a dataframe
gis_data <- gsheet2tbl(url)

## No encoding supplied: defaulting to UTF-8.

# 4. Preview the data to make sure it's loaded
head(gis_data)