LoginSign Up
← Back to all sparks
G

googlesheets4

ANALYTICS
Velocity0.0

Read from and write to Google Sheets from R using the Sheets API

github.com/tidyverse/googlesheets4 ↗

googlesheets4's releases track Google's API and gargle's auth, not its own roadmap.

rgoogle-sheetsoauthgargleapi-client
◆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.

◆Recent moves

  1. 11mo ago

    googlesheets4 1.1.2 ships documentation updates for CRAN

    A documentation release cut to support HTML reference manuals on CRAN, with no significant user-facing change. The same CRAN-maintenance pattern visible across the tidyverse packages of this vintage.

    View source ↗
  2. 3y ago

    googlesheets4 1.1.1 supports service-account user impersonation

    Service-account setups gain a subject argument so a service account can impersonate a normal user, and gs4_scopes() exposes the scopes relevant to the Sheets and Drive APIs. Both target automated and server-side deployments rather than interactive analysts.

    View source ↗
  3. 3y ago

    googlesheets4 1.1.0 replaces OAuth app with client configuration

    Follows gargle 1.3.0's OAuth rework: gs4_oauth_client() replaces the deprecated gs4_oauth_app(), and gs4_auth_configure() takes a client argument instead of app. A rename on the surface, but it redefines the documented path for bringing your own OAuth client.

    View source ↗
  4. 4y ago

    googlesheets4 1.0.1 tolerates invalid named ranges, sees 10M cells

    A single invalid named range no longer blocks all interaction with a Sheet, and the package learns that Sheets now hold ten million cells rather than five. Both are cases of reality moving underneath a client library.

    View source ↗
  5. 5y ago

    googlesheets4 1.0.0 moves to cli messages and classed errors

    The 1.0.0 milestone routes all messages, warnings and errors through cli and rlang conditions, introduces a googlesheets4_error class, and adds a quiet option. Turning errors into catchable classed conditions is what makes the package usable inside larger programs.

    View source ↗
  6. 5y ago

    googlesheets4 0.3.0 retries requests on quota exhaustion

    All requests gain retry capability, backing off and repeating when Google returns 429 RESOURCE_EXHAUSTED. The documentation is careful to distinguish shared-quota exhaustion from personally exceeding 100 requests per 100 seconds, which instead signals you need your own OAuth client.

    View source ↗