{ "_id": "6acac68cfe5cc25786e8c154", "Package": "googlesheets4", "Title": "Access Google Sheets using the Sheets API V4", "Version": "1.1.2.9000", "Authors@R": "c(\nperson(\"Jennifer\", \"Bryan\", , \"jenny@posit.co\", role = c(\"cre\", \"aut\"),\ncomment = c(ORCID = \"0000-0002-6983-2759\")),\nperson(\"Posit Software, PBC\", role = c(\"cph\", \"fnd\"))\n)", "Description": "Interact with Google Sheets through the Sheets API v4\n. \"API\" is an acronym\nfor \"application programming interface\"; the Sheets API allows\nusers to interact with Google Sheets programmatically, instead\nof via a web browser. The \"v4\" refers to the fact that the\nSheets API is currently at version 4. This package can read and\nwrite both the metadata and the cell data in a Sheet.", "License": "MIT + file LICENSE", "URL": "https://googlesheets4.tidyverse.org,\nhttps://github.com/tidyverse/googlesheets4", "BugReports": "https://github.com/tidyverse/googlesheets4/issues", "ByteCompile": "true", "Config/Needs/website": "tidyverse, tidyverse/tidytemplate", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Language": "en-US", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2.9000", "Config/pak/sysreqs": "cmake make libuv1-dev libssl-dev", "Repository": "https://tidyverse.r-universe.dev", "Date/Publication": "2025-09-08 20:08:34 UTC", "RemoteUrl": "https://github.com/tidyverse/googlesheets4", "RemoteRef": "HEAD", "RemoteSha": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-10 22:58:08 UTC", "User": "root" }, "Author": "Jennifer Bryan [cre, aut] (ORCID:\n),\nPosit Software, PBC [cph, fnd]", "Maintainer": "Jennifer Bryan ", "_user": "tidyverse", "_type": "src", "_file": "googlesheets4_1.1.2.9000.tar.gz", "_fileid": "https://r2.ropensci.org/49c7c7ac35d3b0ae2d104d392904b2d55ce507b7123f5c0b5da5f4f3c18a67d3", "_filesize": 492434, "_sha256": "49c7c7ac35d3b0ae2d104d392904b2d55ce507b7123f5c0b5da5f4f3c18a67d3", "_expires": "2027-01-18T23:13:14.000Z", "_created": "2026-10-10T22:58:08.000Z", "_published": "2026-10-10T23:13:16.697Z", "_buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 114334209563, "time": 133, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "11684881830" }, { "job": 114334209576, "time": 141, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "11684394868" }, { "job": 114334209555, "time": 116, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "11685227051" }, { "job": 114334209587, "time": 97, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "11685955288" }, { "job": 114333582790, "time": 218, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11684806939" }, { "job": 114334209589, "time": 99, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11684991455" }, { "job": 114334209623, "time": 84, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "11684822002" }, { "job": 114334209662, "time": 91, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "ERROR", "artifact": "11685161302" }, { "job": 114334209568, "time": 91, "config": "windows-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "11684174969" } ], "_upstream": "https://github.com/tidyverse/googlesheets4", "_commit": { "id": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "author": "Jennifer (Jenny) Bryan ", "committer": "GitHub ", "message": "Re-ingest the Discovery Document (#323)\n\n", "time": 1757362114 }, "_maintainer": { "name": "Jennifer Bryan", "email": "jenny@posit.co", "login": "jennybc", "mastodon": "@jennybryan@fosstodon.org", "bluesky": "@jennybryan.bsky.social", "twitter": "@jennybryan", "description": "Software engineer @posit-dev, humane #rstats", "uuid": 599454, "orcid": "0000-0002-6983-2759" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.6", "role": "Depends" }, { "package": "cellranger", "role": "Imports" }, { "package": "cli", "version": ">= 3.0.0", "role": "Imports" }, { "package": "curl", "role": "Imports" }, { "package": "gargle", "version": ">= 1.6.0", "role": "Imports" }, { "package": "glue", "version": ">= 1.3.0", "role": "Imports" }, { "package": "googledrive", "version": ">= 2.1.0", "role": "Imports" }, { "package": "httr", "role": "Imports" }, { "package": "ids", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "rematch2", "role": "Imports" }, { "package": "rlang", "version": ">= 1.0.2", "role": "Imports" }, { "package": "tibble", "version": ">= 2.1.1", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "vctrs", "version": ">= 0.2.3", "role": "Imports" }, { "package": "withr", "role": "Imports" }, { "package": "readr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "spelling", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.1.7", "role": "Suggests" } ], "_owner": "tidyverse", "_selfowned": true, "_usedby": 141, "_updates": [], "_tags": [], "_topics": [ "google-drive", "google-sheets", "spreadsheet" ], "_stars": 378, "_contributors": [ { "user": "jennybc", "count": 843, "uuid": 599454 }, { "user": "robitalec", "count": 1, "uuid": 16324625 }, { "user": "averiperny", "count": 1, "uuid": 17169253 }, { "user": "csnardi", "count": 1, "uuid": 5530739 }, { "user": "chrowe", "count": 1, "uuid": 240115 }, { "user": "florisvdh", "count": 1, "uuid": 19164640 }, { "user": "moohan", "count": 1, "uuid": 5982260 }, { "user": "jcheng5", "count": 1, "uuid": 129551 }, { "user": "batpigandme", "count": 1, "uuid": 831732 }, { "user": "monkmanmh", "count": 1, "uuid": 3461616 }, { "user": "michaelchirico", "count": 1, "uuid": 7606389 }, { "user": "mine-cetinkaya-rundel", "count": 1, "uuid": 5965649 }, { "user": "mitchelloharawild", "count": 1, "uuid": 16127127 } ], "_userbio": { "uuid": 22032646, "type": "organization", "name": "tidyverse", "followers": 1890, "description": "The tidyverse is a collection of R packages that share common principles and are designed to work together seamlessly" }, "_downloads": { "count": 460814, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/googlesheets4" }, "_devurl": "https://github.com/tidyverse/googlesheets4", "_pkgdown": "https://googlesheets4.tidyverse.org", "_searchresults": 11328, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/googlesheets4.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/tidyverse/googlesheets4", "_realowner": "tidyverse", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2019-11-04" }, { "version": "0.1.1", "date": "2020-03-21" }, { "version": "0.2.0", "date": "2020-05-08" }, { "version": "0.3.0", "date": "2021-03-04" }, { "version": "1.0.0", "date": "2021-07-21" }, { "version": "1.0.1", "date": "2022-08-13" }, { "version": "1.1.0", "date": "2023-03-23" }, { "version": "1.1.1", "date": "2023-06-11" }, { "version": "1.1.2", "date": "2025-09-03" } ], "_exports": [ "%>%", "anchored", "as_sheets_id", "cell_cols", "cell_limits", "cell_rows", "gs4_api_key", "gs4_auth", "gs4_auth_configure", "gs4_browse", "gs4_create", "gs4_deauth", "gs4_endpoints", "gs4_example", "gs4_examples", "gs4_find", "gs4_fodder", "gs4_formula", "gs4_get", "gs4_has_token", "gs4_oauth_app", "gs4_oauth_client", "gs4_random", "gs4_scopes", "gs4_token", "gs4_user", "local_gs4_quiet", "range_autofit", "range_clear", "range_delete", "range_flood", "range_read", "range_read_cells", "range_speedread", "range_write", "read_sheet", "request_generate", "request_make", "sheet_add", "sheet_append", "sheet_copy", "sheet_delete", "sheet_names", "sheet_properties", "sheet_relocate", "sheet_rename", "sheet_resize", "sheet_write", "spread_sheet", "vec_cast.googlesheets4_formula", "vec_ptype2.googlesheets4_formula", "with_gs4_quiet", "write_sheet" ], "_help": [ { "page": "cell-specification", "title": "Specify cells", "topics": [ "anchored", "cell-specification", "cell_cols", "cell_limits", "cell_rows" ] }, { "page": "googlesheets4-configuration", "title": "googlesheets4 configuration", "topics": [ "googlesheets4-configuration", "local_gs4_quiet", "with_gs4_quiet" ] }, { "page": "gs4_auth", "title": "Authorize googlesheets4", "concept": [ "auth functions" ], "topics": [ "gs4_auth" ] }, { "page": "gs4_auth_configure", "title": "Edit and view auth configuration", "concept": [ "auth functions" ], "topics": [ "gs4_api_key", "gs4_auth_configure", "gs4_oauth_client" ] }, { "page": "gs4_browse", "title": "Visit a Sheet in a web browser", "topics": [ "gs4_browse" ] }, { "page": "gs4_create", "title": "Create a new Sheet", "concept": [ "write functions" ], "topics": [ "gs4_create" ] }, { "page": "gs4_deauth", "title": "Suspend authorization", "concept": [ "auth functions" ], "topics": [ "gs4_deauth" ] }, { "page": "gs4_endpoints", "title": "List Sheets endpoints", "topics": [ "gs4_endpoints" ] }, { "page": "gs4_examples", "title": "Example Sheets", "topics": [ "gs4_example", "gs4_examples" ] }, { "page": "gs4_find", "title": "Find Google Sheets", "topics": [ "gs4_find" ] }, { "page": "gs4_fodder", "title": "Create useful spreadsheet filler", "topics": [ "gs4_fodder" ] }, { "page": "gs4_formula", "title": "Class for Google Sheets formulas", "concept": [ "write functions" ], "topics": [ "gs4_formula" ] }, { "page": "gs4_get", "title": "Get Sheet metadata", "topics": [ "gs4_get" ] }, { "page": "gs4_has_token", "title": "Is there a token on hand?", "concept": [ "low-level API functions" ], "topics": [ "gs4_has_token" ] }, { "page": "gs4_random", "title": "Generate a random Sheet name", "topics": [ "gs4_random" ] }, { "page": "gs4_scopes", "title": "Produce scopes specific to the Sheets API", "concept": [ "auth functions" ], "topics": [ "gs4_scopes" ] }, { "page": "gs4_token", "title": "Produce configured token", "concept": [ "low-level API functions" ], "topics": [ "gs4_token" ] }, { "page": "gs4_user", "title": "Get info on current user", "topics": [ "gs4_user" ] }, { "page": "range_autofit", "title": "Auto-fit columns or rows to the data", "concept": [ "formatting functions" ], "topics": [ "range_autofit" ] }, { "page": "range_delete", "title": "Delete cells", "concept": [ "write functions" ], "topics": [ "range_delete" ] }, { "page": "range_flood", "title": "Flood or clear a range of cells", "concept": [ "write functions" ], "topics": [ "range_clear", "range_flood" ] }, { "page": "range_read", "title": "Read a Sheet into a data frame", "topics": [ "range_read", "read_sheet" ] }, { "page": "range_read_cells", "title": "Read cells from a Sheet", "topics": [ "range_read_cells" ] }, { "page": "range_speedread", "title": "Read Sheet as CSV", "topics": [ "range_speedread" ] }, { "page": "range_write", "title": "(Over)write new data into a range", "concept": [ "write functions" ], "topics": [ "range_write" ] }, { "page": "request_generate", "title": "Generate a Google Sheets API request", "concept": [ "low-level API functions" ], "topics": [ "request_generate" ] }, { "page": "request_make", "title": "Make a Google Sheets API request", "concept": [ "low-level API functions" ], "topics": [ "request_make" ] }, { "page": "sheet_add", "title": "Add one or more (work)sheets", "concept": [ "worksheet functions" ], "topics": [ "sheet_add" ] }, { "page": "sheet_append", "title": "Append rows to a sheet", "concept": [ "worksheet functions", "write functions" ], "topics": [ "sheet_append" ] }, { "page": "sheet_copy", "title": "Copy a (work)sheet", "concept": [ "worksheet functions" ], "topics": [ "sheet_copy" ] }, { "page": "sheet_delete", "title": "Delete one or more (work)sheets", "concept": [ "worksheet functions" ], "topics": [ "sheet_delete" ] }, { "page": "sheet_properties", "title": "Get data about (work)sheets", "concept": [ "worksheet functions" ], "topics": [ "sheet_names", "sheet_properties" ] }, { "page": "sheet_relocate", "title": "Relocate one or more (work)sheets", "concept": [ "worksheet functions" ], "topics": [ "sheet_relocate" ] }, { "page": "sheet_rename", "title": "Rename a (work)sheet", "concept": [ "worksheet functions" ], "topics": [ "sheet_rename" ] }, { "page": "sheet_resize", "title": "Change the size of a (work)sheet", "concept": [ "worksheet functions" ], "topics": [ "sheet_resize" ] }, { "page": "sheet_write", "title": "(Over)write new data into a Sheet", "concept": [ "worksheet functions", "write functions" ], "topics": [ "sheet_write", "write_sheet" ] }, { "page": "sheets_id", "title": "'sheets_id' class", "topics": [ "as_sheets_id", "sheets_id" ] }, { "page": "spread_sheet", "title": "Spread a data frame of cells into spreadsheet shape", "topics": [ "spread_sheet" ] } ], "_pkglogo": "https://github.com/tidyverse/googlesheets4/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/tidyverse/googlesheets4/raw/HEAD/README.md", "_rundeps": [ "askpass", "cellranger", "cli", "curl", "fs", "gargle", "glue", "googledrive", "httr", "ids", "jsonlite", "lifecycle", "magrittr", "mime", "openssl", "pillar", "pkgconfig", "purrr", "R6", "rappdirs", "rematch", "rematch2", "rlang", "sys", "tibble", "utf8", "uuid", "vctrs", "withr" ], "_score": 14.699662322867145, "_indexed": true, "_nocasepkg": "googlesheets4", "_universes": [ "tidyverse", "jennybc" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.1.2.9000", "date": "2026-10-10T23:00:18.000Z", "distro": "resolute", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "https://r2.ropensci.org/47e85f904b11b9ebc0aed2eb3d0e5d65f05a02eee7dda582714b0ad8db5a6de3", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792" }, { "r": "4.6.1", "os": "linux", "version": "1.1.2.9000", "date": "2026-10-10T23:00:27.000Z", "distro": "resolute", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "https://r2.ropensci.org/a448d378576d5b966de5fb8609dc467861e24ff5cdf23531c9ea8e0b2b00a724", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792" }, { "r": "4.5.3", "os": "mac", "version": "1.1.2.9000", "date": "2026-10-10T23:12:29.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "https://r2.ropensci.org/6e09635d2238633fd20d15a9062afae52893bed8c5a7d6a41c7df1079974c887", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792" }, { "r": "4.6.1", "os": "mac", "version": "1.1.2.9000", "date": "2026-10-10T23:12:26.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "https://r2.ropensci.org/c2ef3d949bddb845aac3be8ff862e134a406c19c0f5933a4bb347f24b6f79b8a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792" }, { "r": "4.6.0", "os": "wasm", "version": "1.1.2.9000", "date": "2026-10-10T23:00:12.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "https://r2.ropensci.org/147d98c3efc17e6973a540f7d58367c1c6739def53d748f4661caf48b057e587", "status": "success", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792" }, { "r": "4.7.0", "os": "win", "version": "1.1.2.9000", "date": "2026-10-10T22:59:29.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "https://r2.ropensci.org/c71b47951aad38e731114457fc7b1b7d1ae271dd8df65f2efa911a4d43d521e7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792" }, { "r": "4.5.3", "os": "win", "version": "1.1.2.9000", "date": "2026-10-10T22:59:27.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "https://r2.ropensci.org/c3bec2df10f196f55a9036880c0b33694c9fde21def0f6936a3e4f540297b0fa", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792" }, { "r": "4.6.1", "os": "win", "version": "1.1.2.9000", "date": "2026-10-10T22:59:36.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "https://r2.ropensci.org/99f2286541030fc09e9264aaf9c47c952a22edb88f1ebd67d987bbf0f2a5b6ad", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/38093149792" } ] }