Integrating R & Google Drive or Collaborative Research
summary
Workflow uses Google Drive, Google Docs and Google Sheets plus the googlesheets R package to read and write sheets by key so no intermediate CSVs are saved. Upstream data validation rules, protected columns and sheet-level access enforce consistent entry from 15+ undergraduates across a 5+ year project. Markdown scripts and linked docs store metadata and field protocols; result is fewer cleaning steps, reproducible reads/writes from R, and collaborators without Git can view and edit required materials.
AI-written summary · about
related talks
16mDo It For Yourself: Creating a data input platform using R
22mRMarkdown Driven Development
32mWork Less and Do More: Google Sheets for JavaScript Developers
15mR Markdown + RStudio Connect + R Shiny
24mLet's play together: Collaborative Data Science
11mField Guide to Writing Your First R Package
43mHow to Simplify Business Processes with G Suite
33mWork Less and Do More: Sheets for Node.js Developers