Other packages > Find by keyword >

googlesheets4  

Access Google Sheets using the Sheets API V4
View on CRAN: Click here


Download and install googlesheets4 package within the R console
Install from CRAN:
install.packages("googlesheets4")

Install from Github:
library("remotes")
install_github("cran/googlesheets4")

Install by package version:
library("remotes")
install_version("googlesheets4", "1.1.2")



Attach the package and use:
library("googlesheets4")
Maintained by
Jennifer Bryan
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2019-11-04
Latest Update: 2025-09-03
Description:
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.
How to cite:
Jennifer Bryan (2019). googlesheets4: Access Google Sheets using the Sheets API V4. R package version 1.1.2, https://cran.r-project.org/web/packages/googlesheets4. Accessed 20 Oct. 2026.
Previous versions and publish date:
(2026-07-09 07:45), 0.1.0 (2019-11-04 22:50), 0.1.1 (2020-03-21 06:40), 0.2.0 (2020-05-08 12:30), 0.3.0 (2021-03-04 18:50), 1.0.0 (2021-07-21 20:50), 1.0.1 (2022-08-13 22:10), 1.1.0 (2023-03-23 23:42), 1.1.1 (2023-06-11 06:00)
Other packages that cited googlesheets4 R package
View googlesheets4 citation profile
Other R packages that googlesheets4 depends, imports, suggests or enhances
Complete documentation for googlesheets4
Functions, R codes and Examples using the googlesheets4 R package
Some associated functions: cell-specification . googlesheets4-configuration . googlesheets4-package . googlesheets4-vctrs . gs4_auth . gs4_auth_configure . gs4_browse . gs4_create . gs4_deauth . gs4_endpoints . gs4_examples . gs4_find . gs4_fodder . gs4_formula . gs4_get . gs4_has_token . gs4_oauth_app . gs4_random . gs4_scopes . gs4_token . gs4_user . pipe . range_autofit . range_delete . range_flood . range_read . range_read_cells . range_speedread . range_write . request_generate . request_make . sheet_add . sheet_append . sheet_copy . sheet_delete . sheet_properties . sheet_relocate . sheet_rename . sheet_resize . sheet_write . sheets_id . spread_sheet . 
Some associated R codes: aaa.R . batch-update-requests.R . cell-specification.R . ctype.R . get_cells.R . googlesheets4-package.R . gs4_auth.R . gs4_browse.R . gs4_create.R . gs4_endpoints.R . gs4_example.R . gs4_find.R . gs4_fodder.R . gs4_formula.R . gs4_get.R . gs4_share.R . make_column.R . range_add_named.R . range_add_protection.R . range_add_validation.R . range_autofit.R . range_delete.R . range_flood.R . range_read.R . range_read_cells.R . range_spec.R . range_speedread.R . range_write.R . rectangle.R . request_generate.R . request_make.R . roxygen.R . schema_CellData.R . schema_GridCoordinate.R . schema_GridRange.R . schema_NamedRange.R . schema_ProtectedRange.R . schema_RowData.R . schema_Sheet.R . schema_SheetProperties.R . schema_Spreadsheet.R . schemas.R . sheet_add.R . sheet_append.R . sheet_copy.R . sheet_delete.R . sheet_freeze.R . sheet_properties.R . sheet_relocate.R . sheet_rename.R . sheet_resize.R . sheet_write.R . sheets_id-class.R . utils-cell-ranges.R . utils-pipe.R . utils-sheet.R . utils-ui.R . utils.R . zzz.R .  Full googlesheets4 package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

bgeva  
Binary Generalized Extreme Value Additive Models
Routine for fitting regression models for binary rare events with linear and nonlinear covariate eff ...
Download / Learn more Package Citations See dependency  
EvalEst  
Dynamic Systems Estimation - Extensions
Provides functions for evaluating (time series) model estimation methods. These facilitate Monte Ca ...
Download / Learn more Package Citations See dependency  
MOTE  
Effect Size and Confidence Interval Calculator
Measure of the Effect ('MOTE') is an effect size calculator, including a wide variety of effect siz ...
Download / Learn more Package Citations See dependency  
ISR  
The Iterated Score Regression-Based Estimation
Algorithm to handle with PCA-based missing data, where ISR is for PCA-based missing data with high c ...
Download / Learn more Package Citations See dependency  
nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
conStruct  
Models Spatially Continuous and Discrete Population Genetic Structure
A method for modeling genetic data as a combination of discrete layers, within each of which relate ...
Download / Learn more Package Citations See dependency  

29,080

R Packages

247,686

Dependencies

76,898

Author Associations

29,081

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA