R Observatory: Metrics for gsheet version 0.4.6

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

gsheet

0.4.6Package record

Download Google Sheets Using Just the URL

2packages dependsuggested by 5

22.1Kdownloads / year

88.9%test coverage

13/13flavors OK

Overview

About

Maintained by Max ConwayCRAN page ↗GitHub ↗Issues ↗

Simple package to download Google Sheets using just the sharing link. Spreadsheets can be downloaded as a data frame, or as plain text to parse manually. Google Sheets is the new name for Google Docs Spreadsheets https://www.google.com/sheets/about.

Changes in 0.4.6

Fixed typos documentation
Moved from travis to github CI

From NEWS.md in the release

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("gsheet", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("maxconway/gsheet")

Development version from maxconway/gsheet. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-gsheet

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-gsheet

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-gsheet

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

Slowest check: 1.0 min · r-devel-windows-x86_64

Status changes

OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK14 OK2026-03-22
ERROR13 OK, 1 ERROR2026-03-20
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.4.6

READMEYes · 169 wordsVignettesNoNEWSYes · 100% structured · mentions 0.4.6Citation fileNoWebsitenot declared in DESCRIPTION

Help pages: 3
Examples that run: 100%3 run in a plain check
Exported functions with examples: 100%
Documented parameters: 100%
Return-value docs: 0%
Help pages citing references: 0%

How these are measured

Downloads

22.1K

CRAN downloads in the past year

Rank #3,166 · ~60/day · ~1.8K/mo

Releases R versions

Daily download trend is not available in this view yet.

1.9K30 days

3.8K90 days

22.1K1 year

Compare downloads with other packages →

Also on394 r2u2 autocran139 c2d4u

How downloads are counted

Repository

maxconway/gsheet ↗Account: maxconway

58Stars

4Forks

2Open issues

0Open PRs

4Releases

87Commits

2Commit identities

87 commits · Last activity 2020-04-07 · 0% stars, 30d · The default branch showed an older version (0.4.5) than CRAN on 2026-10-18

Responsiveness

How these are sampled

PRs merged (all time): 100%
Median days to close, 50 most recently updated closed issues: 2
Median days to close, 50 most recently updated closed PRs: 0

Stars over time

2025-06-11 · 572026-07-07 · 58

How these are measured

PracticesBeta

4 development-tooling and community-health practices detected across 4 families in the upstream repository

Checks run against github.com/maxconway/gsheet on 2026-10-18.

Continuous integration (1)

Travis CI (config file)

Docs source (1)

README.Rmd

CRAN release process (1)

cran-comments.md

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

Dependencies

Declared dependencies

4 external dependencies (excludes base and recommended)

Installing gsheet adds 16 packages (12 with compiled code, 17 MB of source tarballs). Heaviest: stringi 11 MB, openssl 1.1 MB, jsonlite 1.0 MB.

Depends (0)

none

Imports (2)

httr stringr

LinkingTo (0)

none

Suggests (2)

testthat readr

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

2direct

0indirect

Imports 2

Suggested by 5

Depends, Imports or LinkingTo, most downloaded first

gfer odk

Suggests, most downloaded first

inti rdwd GerminaR huito geoflow

How these are counted

Code & Tests

People & History

People (1)

Max Conway

Author, Maintainer since 0.1.0 (2015)

Releases (6)

Pick two releases to compare their code metrics.

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
0.4.6Latest
record
2024-12-14 · current release · diff ↗
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
R
R 4.0.0 released · 2020-04-24
0.4.5
record
2020-04-07 · diff ↗
R
R 3.6.0 released · 2019-04-26
R
R 3.5.0 released · 2018-04-23
R
R 3.4.0 released · 2017-04-21
0.4.2
record
2016-12-30 · diff ↗ ·
added 1 export
construct_download_url
0.3.0
record
2016-05-19 · diff ↗
R
R 3.3.0 released · 2016-05-03
0.2.1
record
2016-01-06 · diff ↗

Show 3 earlier eventsHide 3 earlier events

R
R 3.2.0 released · 2015-04-16
0.1.0
record
2015-03-10
R
R 3.1.0 released · 2014-04-10

Package metadata

First published: 2015-03-10
Total releases: 6 / 11 yrs
License: GPL-3 OSI
Download size: 4.7 KB

Appears in task views

Web Technologies and Services

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("gsheet")

Format

Conway, M. (2024). gsheet: Download Google Sheets Using Just the URL (Version 0.4.6) [Computer software]. https://doi.org/10.32614/CRAN.package.gsheet

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for gsheet version 0.4.6 [Data set]. HJJB, LLC. Data release v2026-10-22. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-22, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →