{ "_id": "6a12a368acfb0bcc41d1264d", "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-05-24 06:50:24 UTC", "User": "root" }, "Author": "Jennifer Bryan [cre, aut] (ORCID:\n),\nPosit Software, PBC [cph, fnd]", "Maintainer": "Jennifer Bryan ", "MD5sum": "1ad94966539b05bde62cff41fe78224d", "_user": "tidyverse", "_type": "src", "_file": "googlesheets4_1.1.2.9000.tar.gz", "_fileid": "2bd5f1bafe80657bb9449ac8fdd76b9c8de0aff31860b889b7c7be60269d8335", "_filesize": 492819, "_sha256": "2bd5f1bafe80657bb9449ac8fdd76b9c8de0aff31860b889b7c7be60269d8335", "_created": "2026-05-24T06:50:24.000Z", "_published": "2026-05-24T07:06:16.630Z", "_distro": "noble", "_jobs": [ { "job": 77578446471, "time": 140, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7183024337" }, { "job": 77578446483, "time": 135, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7183023860" }, { "job": 77578446477, "time": 95, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7183104605" }, { "job": 77578446466, "time": 80, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7183098514" }, { "job": 77578277370, "time": 187, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7183008922" }, { "job": 77578446467, "time": 117, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7183021941" }, { "job": 77578446491, "time": 99, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7183020053" }, { "job": 77578446490, "time": 89, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7183019078" }, { "job": 77578446485, "time": 95, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7183019595" } ], "_buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599", "_status": "success", "_host": "GitHub-Actions", "_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" }, "_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": 148, "_updates": [ { "week": "2025-36", "n": 9 }, { "week": "2025-37", "n": 1 } ], "_tags": [ { "name": "v1.1.2", "date": "2025-09-03" } ], "_topics": [ "google-drive", "google-sheets", "spreadsheet" ], "_stars": 373, "_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", "description": "The tidyverse is a collection of R packages that share common principles and are designed to work together seamlessly" }, "_downloads": { "count": 451284, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/googlesheets4" }, "_devurl": "https://github.com/tidyverse/googlesheets4", "_pkgdown": "https://googlesheets4.tidyverse.org", "_searchresults": 10720, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/googlesheets4.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_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.982917769473818, "_indexed": true, "_nocasepkg": "googlesheets4", "_universes": [ "tidyverse", "jennybc" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.1.2.9000", "date": "2026-05-24T06:52:38.000Z", "distro": "noble", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "712335cb843af3344f9649ab52714805f5871f1dcf8e818ded384ff08e249d60", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599" }, { "r": "4.6.0", "os": "linux", "version": "1.1.2.9000", "date": "2026-05-24T06:52:36.000Z", "distro": "noble", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "f355966d48c902d0d15a048f35352c58a6aa7621a5e41e361754d3bc02b284e3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599" }, { "r": "4.5.3", "os": "mac", "version": "1.1.2.9000", "date": "2026-05-24T07:05:37.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "fe16f35b8f83c1a9c1e29232928e7d899ea117f34a6decfab6361c728229813b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599" }, { "r": "4.6.0", "os": "mac", "version": "1.1.2.9000", "date": "2026-05-24T07:04:44.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "910af771706cb47470389d3d65d03239cc4ce1bfc06bc110474c7af9f5b9b5bc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599" }, { "r": "4.6.0", "os": "wasm", "version": "1.1.2.9000", "date": "2026-05-24T06:52:41.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "fcdd06afc82cbff2bfcd73fd22650223b7235530b43fb816f41d5e62407871ff", "status": "success", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599" }, { "r": "4.7.0", "os": "win", "version": "1.1.2.9000", "date": "2026-05-24T06:51:47.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "6b9019f9d6a3903453d9fd12092bed0c187701f89eed7ba65d016d2b884941e8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599" }, { "r": "4.5.3", "os": "win", "version": "1.1.2.9000", "date": "2026-05-24T06:51:39.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "18ff6f44157935756e1d20f3f5a86aa5be4e98bb0ee2d2b47a871d4c44473148", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599" }, { "r": "4.6.0", "os": "win", "version": "1.1.2.9000", "date": "2026-05-24T06:51:44.000Z", "commit": "55cd9fdbf9c74c20de1eeb9ec2629a7d16c76aa4", "fileid": "3180f82b1935563883a6620f9c2afb89353edb15341d55131b6c033cb097089a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354366599" } ] }