googlesheets4
Google Spreadsheets R API (reboot of the googlesheets package)
googlesheets4 provides an R interface to Google Sheets through the Sheets API v4. It allows you to read from and write to Google Sheets directly from R, treating them like local data frames.
The package handles authentication automatically for reading private sheets and writing data. It supports multiple ways to identify sheets (URL, ID, or file name lookup) and integrates with the tidyverse ecosystem, using similar syntax to readr and readxl for reading data and supporting pipe-friendly workflows. It replaces the older googlesheets package which used the deprecated API v3.
Contributors#
Resources featuring googlesheets4#
Using the Kyber R package to connect Google Sheets, RMarkdown, GitHub, & Agenda docs for open edu
As we work in open data science spaces, we frequently peer-teach coding and collaboration skills. The setup work is often grossly underestimated and unseen. I’ll share how Openscapes automates setup with the Kyber R package that uses googlesheets4 and creates RMarkdown documents that become collaborative Google Doc agendas, and sets up repositories and organizes people on GitHub. Kyber replaces manual steps with R functions while maintaining the ability to edit outputs so we’re not constrained by the automation. It has enabled us to teach workshops repeatedly in less time – in 2022, we led four concurrent learning cohorts with 160 government scientists! Kyber is openly available to fork, reuse, and extend, and other groups are doing just that.
Talk by Stefanie Butland
Slides: https://docs.google.com/presentation/d/1p_EXdYEVGY07VVMGdcvvwjjbwFihHsC_5oXRPW_8tVU/ Kyber GitHub Repo: https://github.com/openscapes/kyber Openscapes: https://openscapes.org/
