{
  "_id": "6ad1f27bd3c80a766859c9be",
  "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<https://www.google.com/sheets/about>.",
  "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-10-16 09:16:46 UTC",
    "User": "root"
  },
  "Author": "Max Conway [aut, cre]",
  "Maintainer": "Max Conway <conway.max1@gmail.com>",
  "_user": "maxconway",
  "_type": "src",
  "_file": "gsheet_0.4.5.tar.gz",
  "_fileid": "https://r2.ropensci.org/c22e24c3e79dfdb6997d71bcc8ae7266b901eec1504e0e8a46157ad8ea42dd77",
  "_filesize": 90894,
  "_sha256": "c22e24c3e79dfdb6997d71bcc8ae7266b901eec1504e0e8a46157ad8ea42dd77",
  "_expires": "2027-01-24T09:46:34.000Z",
  "_created": "2026-10-16T09:16:46.000Z",
  "_published": "2026-10-16T09:46:35.688Z",
  "_buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 116902150442,
      "time": 107,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12037185457"
    },
    {
      "job": 116902150375,
      "time": 107,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12036428714"
    },
    {
      "job": 116902150256,
      "time": 178,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12037808897"
    },
    {
      "job": 116902150319,
      "time": 139,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12037783991"
    },
    {
      "job": 116900833720,
      "time": 204,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12036493239"
    },
    {
      "job": 116902150222,
      "time": 86,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12036533436"
    },
    {
      "job": 116902150304,
      "time": 83,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12036717867"
    },
    {
      "job": 116902150462,
      "time": 72,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12036064763"
    },
    {
      "job": 116902150324,
      "time": 68,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12037140540"
    }
  ],
  "_upstream": "https://github.com/maxconway/gsheet",
  "_commit": {
    "id": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
    "author": "Max Conway <conway.max1@gmail.com>",
    "committer": "Max Conway <conway.max1@gmail.com>",
    "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": 21
  },
  "_downloads": {
    "count": 2017,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/gsheet"
  },
  "_devurl": "https://github.com/maxconway/gsheet",
  "_searchresults": 1572,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/gsheet.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_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.741707688198754,
  "_indexed": true,
  "_nocasepkg": "gsheet",
  "_universes": [
    "maxconway"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.5",
      "date": "2026-10-16T09:18:32.000Z",
      "distro": "resolute",
      "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
      "fileid": "https://r2.ropensci.org/4a46313604d02c792db9813447948fc34cc638897ff983ffe5fd7cadf5b104c8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4.5",
      "date": "2026-10-16T09:18:33.000Z",
      "distro": "resolute",
      "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
      "fileid": "https://r2.ropensci.org/733f234ea2f88b7cf9f131e10b72cfd20b238e9120548ecc28e6b8d5e25993f0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.5",
      "date": "2026-10-16T09:45:34.000Z",
      "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
      "fileid": "https://r2.ropensci.org/f04150af030593493bd42149a75b0c8de93355f3d2f1da98aee8073f9c054272",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4.5",
      "date": "2026-10-16T09:45:15.000Z",
      "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
      "fileid": "https://r2.ropensci.org/2bbc5624728246b5329448d1fd0c7b6970f9fcfb8e12186101f13c4e7d6e2081",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4.5",
      "date": "2026-10-16T09:18:25.000Z",
      "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
      "fileid": "https://r2.ropensci.org/3e27392018c3b3c455b13d4acc360b720f2e8ad0fb7ffddaf54bf5984aa871b8",
      "status": "success",
      "buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.5",
      "date": "2026-10-16T09:18:05.000Z",
      "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
      "fileid": "https://r2.ropensci.org/512b211c6824433a95661d6345cb35eaceb46eff45586073d8d4430fbe403ad8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4.5",
      "date": "2026-10-16T09:17:52.000Z",
      "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
      "fileid": "https://r2.ropensci.org/78c0039772e7a47d0a237f1e4d852eb75a252d66da5ee254a46beb733b54122b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4.5",
      "date": "2026-10-16T09:17:47.000Z",
      "commit": "9c43f3df891986006fca2f14cff99a0d5ae65abc",
      "fileid": "https://r2.ropensci.org/b8081133b857b432f44c74bd1f0381bb5d6229905be9b7c180211779e0e0bbfe",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/maxconway/actions/runs/38878943008"
    }
  ]
}