googlesheets4: Access Google Sheets using the Sheets API V4

Interact with Google Sheets through the Sheets API v4 <>. "API" is an acronym for "application programming interface"; the Sheets API allows users to interact with Google Sheets programmatically, instead of via a web browser. The "v4" refers to the fact that the Sheets API is currently at version 4. This package can read and write both the metadata and the cell data in a Sheet.

Version: 1.1.1
Depends: R (≥ 3.6)
Imports: cellranger, cli (≥ 3.0.0), curl, gargle (≥ 1.5.0), glue (≥ 1.3.0), googledrive (≥ 2.1.0), httr, ids, lifecycle, magrittr, methods, purrr, rematch2, rlang (≥ 1.0.2), tibble (≥ 2.1.1), utils, vctrs (≥ 0.2.3), withr
Suggests: readr, rmarkdown, spelling, testthat (≥ 3.1.7)
Published: 2023-06-11
DOI: 10.32614/CRAN.package.googlesheets4
Author: Jennifer Bryan ORCID iD [cre, aut], Posit Software, PBC [cph, fnd]
Maintainer: Jennifer Bryan <jenny at>
License: MIT + file LICENSE
NeedsCompilation: no
Language: en-US
Materials: README NEWS
In views: WebTechnologies
CRAN checks: googlesheets4 results


Reference manual: googlesheets4.pdf


Package source: googlesheets4_1.1.1.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
macOS binaries: r-release (arm64): googlesheets4_1.1.1.tgz, r-oldrel (arm64): googlesheets4_1.1.1.tgz, r-release (x86_64): googlesheets4_1.1.1.tgz, r-oldrel (x86_64): googlesheets4_1.1.1.tgz
Old sources: googlesheets4 archive

Reverse dependencies:

Reverse imports: behaviorchange, bulkreadr, gfer, inti, MCOE, metricminer, SqueakR, tidyverse
Reverse suggests: allofus, cloudfs, lares, preregr, psyverse, rangeModelMetadata, rock, shiny.reglog


Please use the canonical form to link to this page.