Google Spreadsheets R API (reboot of the googlesheets package)
R
googlesheets4 provides an R interface to Google Sheets through the Sheets API v4. It allows you to read from and write to Google Sheets directly from R, treating them like local data frames.
The package handles authentication automatically for reading private sheets and writing data. It supports multiple ways to identify sheets (URL, ID, or file name lookup) and integrates with the tidyverse ecosystem, using similar syntax to readr and readxl for reading data and supporting pipe-friendly workflows. It replaces the older googlesheets package which used the deprecated API v3.
