googlesheets4: Access Google Sheets using the Sheets API V4
Interact with Google Sheets through the Sheets API v4 <https://developers.google.com/sheets/api>. "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.2 |
| Depends: | R (≥ 3.6) |
| Imports: | cellranger, cli (≥ 3.0.0), curl, gargle (≥ 1.6.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: | 2025-09-03 |
| DOI: | 10.32614/CRAN.package.googlesheets4 |
| Author: | Jennifer Bryan 
[cre, aut],
Posit Software, PBC [cph, fnd] |
| Maintainer: | Jennifer Bryan <jenny at posit.co> |
| BugReports: | https://github.com/tidyverse/googlesheets4/issues |
| License: | MIT + file LICENSE |
| URL: | https://googlesheets4.tidyverse.org, https://github.com/tidyverse/googlesheets4 |
| NeedsCompilation: | no |
| Language: | en-US |
| Materials: | README, NEWS |
| In views: | WebTechnologies |
| CRAN checks: | googlesheets4 results |
Documentation:
| Reference manual: | googlesheets4.html , googlesheets4.pdf |
Downloads:
| Package source: | googlesheets4_1.1.2.tar.gz |
| Windows binaries: | r-devel: googlesheets4_1.1.2.zip, r-release: googlesheets4_1.1.2.zip, r-oldrel: googlesheets4_1.1.2.zip |
| macOS binaries: | r-release (arm64): googlesheets4_1.1.2.tgz, r-oldrel (arm64): googlesheets4_1.1.2.tgz, r-release (x86_64): googlesheets4_1.1.2.tgz, r-oldrel (x86_64): googlesheets4_1.1.2.tgz |
| Old sources: | googlesheets4 archive |
Reverse dependencies:
| Reverse imports: | behaviorchange, bulkreadr, eDNAfuns, gfer, inti, MCOE, metricminer, SqueakR, tidyverse |
| Reverse suggests: | allofus, cloudfs, lares, preregr, psyverse, rangeModelMetadata, rock, whep |
Linking:
Please use the canonical form https://CRAN.R-project.org/package=googlesheets4 to link to this page.