Description
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>.
Downloads
2.2K
Last 30 days
2626th
6.1K
Last 90 days
31.1K
Last year
Trend: -2% (30d vs prior 30d)
4
Last 30 days
52
Last 90 days
344
Last year
Trend: -63.6% (30d vs prior 30d)
10
Last 7 days
14
Last 30 days
0
All-time
autoCRAN-only: this name is served only by autoCRAN, so the count is exact.
CRAN Check Status
Show all 13 flavors
| Flavor | Status |
|---|---|
| r-devel-linux-x86_64-debian-clang | OK |
| r-devel-linux-x86_64-debian-gcc | OK |
| r-devel-linux-x86_64-fedora-clang | OK |
| r-devel-linux-x86_64-fedora-gcc | OK |
| r-devel-windows-x86_64 | OK |
| r-oldrel-macos-arm64 | OK |
| r-oldrel-macos-x86_64 | OK |
| r-oldrel-windows-x86_64 | OK |
| r-patched-linux-x86_64 | OK |
| r-release-linux-x86_64 | OK |
| r-release-macos-arm64 | OK |
| r-release-macos-x86_64 | OK |
| r-release-windows-x86_64 | OK |
Check History
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 21, 2026
ERROR 13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 19, 2026
tests
Running 'testthat.R' [265s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
> library(gsheet)
>
> test_check("gsheet")
Saving _problems/test-gsheet2tbl-15.R
[ FAIL 1 | WARN 1 | SKIP 0 | PASS 4 ]
...[truncated]...
CatchList(expr, classes, parentenv, handlers)
10. └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]])
11. └─value[[3L]](cond)
[ FAIL 1 | WARN 1 | SKIP 0 | PASS 4 ]
Error:
! Test failures.
Execution halted
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
Code & tests
Open call graph →Line coverage
–
Expression
–
Tests / Examples
–
Functions
3 3 exported
Complexity
2.3 avg / 3 max
Call network
3 nodes / 3 edges
Test coverage has not been measured for this package yet; nodes fall back to a neutral fill.
Lowest coverage
Per-function coverage is not measured for this package yet.
Code
Structure
Lines of code
310
Files
14
Compiled share
0%
Has compiled src
No
Language breakdown
API
Exported functions
3
Internal functions
0
Recent export changes
Testing & CI
Has tests
Yes
Test-to-code ratio
0.26
testthat edition
–
CI present
No
CI type
[]
PR gated
No
Docs
Return-value doc rate
0%
\dontrun example ratio
0%
Roxygen coverage
100%
Has pkgdown
No
NEWS present
Yes
Health & Security signals
Informational signals; not verdicts.
on.exit coverage
–
Unsafe pattern score
0
Dep constraint coverage
0%
Secret pattern count
0
Bundled 3rd-party code
2 items
Portability & License
Min R version
–
System requirements
–
C++ standard
–
License
GPL-3
License flags
SPDX valid, OSI approved
History
Versions
6
First release
2015-03-10
Latest release
2024-12-14
Avg cadence
302 days
Cold removal rate
–
Dep drift
7
LOC over versions
Per-file churn detail lives in the source pipeline: https://github.com/r-observatory/cran-code-metrics.