{ "_id": "6a49f2539a8f074f74205bb7", "Package": "gsheet", "Type": "Package", "Title": "Download Google Sheets Using Just the URL", "Version": "0.4.5", "Date": "2020-04-07", "Authors@R": "person(\"Max\", \"Conway\", email = \"conway.max1@gmail.com\",\nrole = c(\"aut\", \"cre\"))", "Description": "Simple package to download Google Sheets using just the\nsharing link. Spreadsheets can be downloaded as a data frame,\nor as plain text to parse manually. Google Sheets is the new\nname for Google Docs Spreadsheets\n.", "License": "GPL-3", "URL": "https://github.com/maxconway/gsheet", "BugReports": "https://github.com/maxconway/gsheet/issues", "Language": "en-GB", "RoxygenNote": "7.1.0", "Config/pak/sysreqs": "libicu-dev libssl-dev", "Repository": "https://maxconway.r-universe.dev", "Date/Publication": "2020-04-07 13:35:14 UTC", "RemoteUrl": "https://github.com/maxconway/gsheet", "RemoteRef": "HEAD", "RemoteSha": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-05 05:45:53 UTC", "User": "root" }, "Author": "Max Conway [aut, cre]", "Maintainer": "Max Conway ", "_user": "maxconway", "_type": "src", "_file": "gsheet_0.4.5.tar.gz", "_fileid": "https://r2.ropensci.org/1ac7af4b113ec22e701fe52afb334e75f03611eee0163949e3b0dc9707c6b6be", "_filesize": 91270, "_sha256": "1ac7af4b113ec22e701fe52afb334e75f03611eee0163949e3b0dc9707c6b6be", "_expires": "2026-10-13T05:57:38.000Z", "_created": "2026-07-05T05:45:53.000Z", "_published": "2026-07-05T05:57:39.872Z", "_jobs": [ { "job": 85196634638, "time": 127, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8088753719" }, { "job": 85196634627, "time": 119, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8088752861" }, { "job": 85196634630, "time": 129, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8088805899" }, { "job": 85196634634, "time": 80, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8088811595" }, { "job": 85196482075, "time": 165, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8088741706" }, { "job": 85196634626, "time": 108, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8088752056" }, { "job": 85196634628, "time": 78, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8088749332" }, { "job": 85196634624, "time": 81, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8088749592" }, { "job": 85196634629, "time": 72, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8088748742" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354", "_status": "success", "_upstream": "https://github.com/maxconway/gsheet", "_commit": { "id": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "author": "Max Conway ", "committer": "Max Conway ", "message": "Merge branch 'release-v0.4.5'\n", "time": 1586266514 }, "_maintainer": { "name": "Max Conway", "email": "conway.max1@gmail.com", "login": "maxconway", "description": "", "uuid": 1148951 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "httr", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "readr", "role": "Suggests" } ], "_owner": "maxconway", "_selfowned": true, "_usedby": 2, "_updates": [], "_tags": [], "_stars": 58, "_contributors": [ { "user": "maxconway", "count": 86, "uuid": 1148951 }, { "user": "adarn", "count": 1, "uuid": 7052048 } ], "_userbio": { "uuid": 1148951, "type": "user", "name": "Max Conway", "followers": 22 }, "_downloads": { "count": 2238, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/gsheet" }, "_devurl": "https://github.com/maxconway/gsheet", "_searchresults": 1520, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/gsheet.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/maxconway/gsheet", "_realowner": "maxconway", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2015-03-10" }, { "version": "0.2.1", "date": "2016-01-06" }, { "version": "0.3.0", "date": "2016-05-18" }, { "version": "0.4.2", "date": "2016-12-30" }, { "version": "0.4.5", "date": "2020-04-07" }, { "version": "0.4.6", "date": "2024-12-14" } ], "_exports": [ "construct_download_url", "gsheet2tbl", "gsheet2text" ], "_help": [ { "page": "construct_download_url", "title": "Construct a google sheet download url from the sheet's viewing url", "topics": [ "construct_download_url" ] }, { "page": "gsheet2tbl", "title": "Download Google sheet as a table", "topics": [ "gsheet2tbl" ] }, { "page": "gsheet2text", "title": "Download Google sheet as text.", "topics": [ "gsheet2text" ] } ], "_readme": "https://github.com/maxconway/gsheet/raw/HEAD/README.md", "_rundeps": [ "askpass", "cli", "curl", "glue", "httr", "jsonlite", "lifecycle", "magrittr", "mime", "openssl", "R6", "rlang", "stringi", "stringr", "sys", "vctrs" ], "_score": 7.772252918419703, "_indexed": true, "_nocasepkg": "gsheet", "_universes": [ "maxconway" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.5", "date": "2026-07-05T05:47:59.000Z", "distro": "resolute", "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "fileid": "https://r2.ropensci.org/9584d43ea97c7455d143d148e2cf26eebc27d652e759abc70a2371ab5709736c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354" }, { "r": "4.6.1", "os": "linux", "version": "0.4.5", "date": "2026-07-05T05:47:50.000Z", "distro": "resolute", "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "fileid": "https://r2.ropensci.org/632ade32e323562a76e6c43580c02070349313692612e19fdc778ac8bb5cfd0d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354" }, { "r": "4.5.3", "os": "mac", "version": "0.4.5", "date": "2026-07-05T05:56:10.000Z", "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "fileid": "https://r2.ropensci.org/bcd5b399a285a569b28003fc815153d2d8ece7d38d4885b271c5912890d20b51", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354" }, { "r": "4.6.1", "os": "mac", "version": "0.4.5", "date": "2026-07-05T05:57:01.000Z", "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "fileid": "https://r2.ropensci.org/b128270900031a58b2759c70faae1e20c210fe6f01ebcfae309558d9236d610c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.5", "date": "2026-07-05T05:47:53.000Z", "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "fileid": "https://r2.ropensci.org/0a1cde0f20943d32c2cc608adb4ce1e55b886a21ed0511b94b3cb405cecd2fb9", "status": "success", "buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354" }, { "r": "4.7.0", "os": "win", "version": "0.4.5", "date": "2026-07-05T05:47:05.000Z", "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "fileid": "https://r2.ropensci.org/d44da01fce436f1cbe59029287dd93363e4e7d2457a5d0f84f9f05b08a682a38", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354" }, { "r": "4.5.3", "os": "win", "version": "0.4.5", "date": "2026-07-05T05:47:08.000Z", "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "fileid": "https://r2.ropensci.org/6bea8256de0e085435e85e3a8dbec1b80a78edbaa445bd326e1a21a48e3f6538", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354" }, { "r": "4.6.1", "os": "win", "version": "0.4.5", "date": "2026-07-05T05:46:57.000Z", "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc", "fileid": "https://r2.ropensci.org/c974d13e410cd56b701b33198eb8f653fd0f57edc67f0785bc60701e3f1f09cb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/maxconway/actions/runs/28731009354" } ] }