Package: googlesheets4 1.1.1.9000

Jennifer Bryan

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.

Authors:Jennifer Bryan [cre, aut], Posit Software, PBC [cph, fnd]

googlesheets4_1.1.1.9000.tar.gz
googlesheets4_1.1.1.9000.zip(r-4.5)googlesheets4_1.1.1.9000.zip(r-4.4)googlesheets4_1.1.1.9000.zip(r-4.3)
googlesheets4_1.1.1.9000.tgz(r-4.4-any)googlesheets4_1.1.1.9000.tgz(r-4.3-any)
googlesheets4_1.1.1.9000.tar.gz(r-4.5-noble)googlesheets4_1.1.1.9000.tar.gz(r-4.4-noble)
googlesheets4_1.1.1.9000.tgz(r-4.4-emscripten)googlesheets4_1.1.1.9000.tgz(r-4.3-emscripten)
googlesheets4.pdf |googlesheets4.html✨
googlesheets4/json (API)
NEWS

# Install 'googlesheets4' in R:
install.packages('googlesheets4', repos = c('https://tidyverse.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/tidyverse/googlesheets4/issues

On CRAN:

google-drivegoogle-sheetsspreadsheet

53 exports 357 stars 14.95 score 30 dependencies 139 dependents 6.2k scripts 538.7k downloads

Last updated 2 months agofrom:3d5ec2864a. Checks:OK: 5 NOTE: 2. Indexed: yes.

TargetResultDate
Doc / VignettesOKSep 20 2024
R-4.5-winNOTESep 20 2024
R-4.5-linuxNOTESep 20 2024
R-4.4-winOKSep 20 2024
R-4.4-macOKSep 20 2024
R-4.3-winOKSep 20 2024
R-4.3-macOKSep 20 2024

Exports:%>%anchoredas_sheets_idcell_colscell_limitscell_rowsgs4_api_keygs4_authgs4_auth_configuregs4_browsegs4_creategs4_deauthgs4_endpointsgs4_examplegs4_examplesgs4_findgs4_foddergs4_formulags4_getgs4_has_tokengs4_oauth_appgs4_oauth_clientgs4_randomgs4_scopesgs4_tokengs4_userlocal_gs4_quietrange_autofitrange_clearrange_deleterange_floodrange_readrange_read_cellsrange_speedreadrange_writeread_sheetrequest_generaterequest_makesheet_addsheet_appendsheet_copysheet_deletesheet_namessheet_propertiessheet_relocatesheet_renamesheet_resizesheet_writespread_sheetvec_cast.googlesheets4_formulavec_ptype2.googlesheets4_formulawith_gs4_quietwrite_sheet

Dependencies:askpasscellrangerclicurlfansifsgarglegluegoogledrivehttridsjsonlitelifecyclemagrittrmimeopensslpillarpkgconfigpurrrR6rappdirsrematchrematch2rlangsystibbleutf8uuidvctrswithr

Readme and manuals

Help Manual

Help pageTopics
Specify cellsanchored cell-specification cell_cols cell_limits cell_rows
googlesheets4 configurationgooglesheets4-configuration local_gs4_quiet with_gs4_quiet
Authorize googlesheets4gs4_auth
Edit and view auth configurationgs4_api_key gs4_auth_configure gs4_oauth_client
Visit a Sheet in a web browsergs4_browse
Create a new Sheetgs4_create
Suspend authorizationgs4_deauth
List Sheets endpointsgs4_endpoints
Example Sheetsgs4_example gs4_examples
Find Google Sheetsgs4_find
Create useful spreadsheet fillergs4_fodder
Class for Google Sheets formulasgs4_formula
Get Sheet metadatags4_get
Is there a token on hand?gs4_has_token
Generate a random Sheet namegs4_random
Produce scopes specific to the Sheets APIgs4_scopes
Produce configured tokengs4_token
Get info on current usergs4_user
Auto-fit columns or rows to the datarange_autofit
Delete cellsrange_delete
Flood or clear a range of cellsrange_clear range_flood
Read a Sheet into a data framerange_read read_sheet
Read cells from a Sheetrange_read_cells
Read Sheet as CSVrange_speedread
(Over)write new data into a rangerange_write
Generate a Google Sheets API requestrequest_generate
Make a Google Sheets API requestrequest_make
Add one or more (work)sheetssheet_add
Append rows to a sheetsheet_append
Copy a (work)sheetsheet_copy
Delete one or more (work)sheetssheet_delete
Get data about (work)sheetssheet_names sheet_properties
Relocate one or more (work)sheetssheet_relocate
Rename a (work)sheetsheet_rename
Change the size of a (work)sheetsheet_resize
(Over)write new data into a Sheetsheet_write write_sheet
'sheets_id' classas_sheets_id sheets_id
Spread a data frame of cells into spreadsheet shapespread_sheet