> For the complete documentation index, see [llms.txt](https://www.rforseo.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.rforseo.com/export-data/send-and-read-seo-data-to-google-sheet.md).

# Send and read  SEO data to Google Sheet x

```
install.packages("googlesheets4")
library(googlesheets4)



gs4_auth()
(demo <- gs4_create("demo", sheets = list(flowers = head(iris))))


class(demo)

read_sheet(demo)

gs4_get(demo)


```

This package is also interesting to reach public google sheets.&#x20;

```

gs4_deauth()

salary <- read_sheet("https://docs.google.com/spreadsheets/d/1rGCKXIKt-7l5gX06NAwO3pjqEHh-oPXtB8ihkp0vGWo/view", skip = 1)


```