rnaturalearth
rnaturalearth finished its sp exit and is now optimising how the data actually arrives.
Comparison · Analytics
googlesheets4 vs rgbif
A side-by-side editorial comparison of googlesheets4 and rgbif — release velocity, themes, recent moves, and the top alternatives to consider.
googlesheets4 vs rgbif: at a glance
What is googlesheets4?
googlesheets4's releases track Google's API and gargle's auth, not its own roadmap.
googlesheets4 is the tidyverse client for the Google Sheets API. Its recent history is dominated by authentication: retry logic for quota errors at 0.3.0, a cli-based message and error surface at 1.0.0, then successive rounds of syncing with gargle's OAuth model through the 1.1.x line. The latest release is documentation-only.
What is rgbif?
rgbif is steadily pushing users off paged searching and onto real downloads.
rgbif ships several times a year and the recent releases cluster around downloads. 3.8.1 added `occ_download_sql()` for SQL-based occurrence downloads; 3.8.2 added DOI-to-download-key resolution and institutionKey downloads; 3.8.3 relayed GBIF's new throttling of bulk paging through `occ_search()` with a message pointing users at `occ_download()`; 3.8.5 added a family of `occ_download_stats_*()` functions plus multiple-taxonomy and verbatim-extension downloads. Alongside that, `name_backbone()` moved to GBIF API v2, and 3.8.0 soft-deprecated `occ_data()`.
googlesheets4 vs rgbif: editorial side-by-side
googlesheets4
0.0ANALYTICS
googlesheets4's releases track Google's API and gargle's auth, not its own roadmap.
◆ Current state
googlesheets4 is the tidyverse client for the Google Sheets API. Its recent history is dominated by authentication: retry logic for quota errors at 0.3.0, a cli-based message and error surface at 1.0.0, then successive rounds of syncing with gargle's OAuth model through the 1.1.x line. The latest release is documentation-only.
◆ Where it's heading
Reading and writing sheets is essentially feature-complete, so remaining work concentrates on credential ergonomics — service accounts, user impersonation, explicit scope access — and absorbing Google's own capacity and quota changes as they land.
◆ Prediction
Expect the next substantive release to follow a gargle auth change or a Sheets API limit revision rather than new spreadsheet functionality.
rgbif
0.0ANALYTICS
rgbif is steadily pushing users off paged searching and onto real downloads.
◆ Current state
rgbif ships several times a year and the recent releases cluster around downloads. 3.8.1 added `occ_download_sql()` for SQL-based occurrence downloads; 3.8.2 added DOI-to-download-key resolution and institutionKey downloads; 3.8.3 relayed GBIF's new throttling of bulk paging through `occ_search()` with a message pointing users at `occ_download()`; 3.8.5 added a family of `occ_download_stats_*()` functions plus multiple-taxonomy and verbatim-extension downloads. Alongside that, `name_backbone()` moved to GBIF API v2, and 3.8.0 soft-deprecated `occ_data()`.
◆ Where it's heading
Two things are happening at once. GBIF is discouraging bulk retrieval through the search API, and rgbif is building out the download path fast enough to absorb the traffic — SQL queries, DOI round-tripping, format description, and now statistics about the downloads themselves. Metadata coverage has expanded in parallel, with a dozen `dataset_*()` functions in 3.7.9 and GRSciColl institution search in 3.8.3. The deprecations are consistent: `occ_data()`, `occ_facet()`, `occ_count(type=)` all retired in favour of narrower replacements.
◆ Prediction
The download surface is where the next additions will land — likely more SQL-download tooling and further statistics endpoints, following 3.8.1 and 3.8.5.
Alternatives to googlesheets4 and rgbif
Other Analytics products tracked by Sparkpulse, ranked by recent ship velocity. Each card links to a full editorial trajectory and lets you pivot into a head-to-head comparison with either googlesheets4 or rgbif.
writexl
writexl spent nine years refusing to do formatting, then shipped all of it in 2.0.0.
rstanarm
rstanarm is community-maintained now, tracking Stan and lme4 rather than adding models.
taxa
taxa started a ground-up rewrite in 2021 and has published almost nothing since.
rotl
rotl's whole release history is keeping name matching honest against a moving taxonomy.
taxize
taxize spends its releases absorbing other people's API changes, one dead source at a time.
See all googlesheets4 alternatives → · See all rgbif alternatives →
Recent activity from googlesheets4 and rgbif
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 4mo agorgbifrgbif 3.8.5 adds occurrence download statistics functions
- 8mo agorgbifrgbif 3.8.4 moves name matching to GBIF API v2
- 11mo agorgbifrgbif 3.8.3 adds GRSciColl search, relays GBIF paging throttle
- 11mo agogooglesheets4googlesheets4 1.1.2 ships documentation updates for CRAN
- 1y agorgbifrgbif 3.8.2 resolves download DOIs to keys
- 1y agorgbifrgbif 3.8.1 adds SQL-based occurrence downloads ⚡
- 2y agorgbifrgbif 3.8.0 soft-deprecates occ_data(), adds download describe
- 3y agogooglesheets4googlesheets4 1.1.1 supports service-account user impersonation
- 3y agogooglesheets4googlesheets4 1.1.0 replaces OAuth app with client configuration
- 4y agogooglesheets4googlesheets4 1.0.1 tolerates invalid named ranges, sees 10M cells
- 5y agogooglesheets4googlesheets4 1.0.0 moves to cli messages and classed errors
- 5y agogooglesheets4googlesheets4 0.3.0 retries requests on quota exhaustion
Frequently asked questions
What is the difference between googlesheets4 and rgbif?
They serve adjacent needs but don't currently overlap on shipped themes. googlesheets4 and rgbif are shipping at a similar cadence (velocity 0.0 vs 0.0, both within Sparkpulse's "active" band). See the at-a-glance table above for a side-by-side breakdown of velocity, recent sparks, and editorial themes.
Is googlesheets4 better than rgbif?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. googlesheets4 and rgbif are shipping at a similar cadence (velocity 0.0 vs 0.0, both within Sparkpulse's "active" band). For your specific use case, the alternatives sections above list other Analytics products to evaluate alongside.
What are the best alternatives to googlesheets4?
Top googlesheets4 alternatives in Analytics are ranked by recent ship velocity. Browse the "googlesheets4 alternatives" section above for the current picks, or visit /alternatives/googlesheets4 for the full list with editorial commentary on each.
What are the best alternatives to rgbif?
Top rgbif alternatives in Analytics are ranked by recent ship velocity. Browse the "rgbif alternatives" section above for the current picks, or visit /alternatives/rgbif for the full list with editorial commentary on each.