Do It For Yourself: Creating a data input platform using R

on YouTube ↗16m

" summary

Moves a lab from Microsoft Access to Google Sheets automated from R, replacing emailed files and single-user bottlenecks with simultaneous entry and reproducible templates. Uses tidyverse/dplyr for shaping, googlesheets4 + googledrive for drive_mkdir, gs4_create, drive_cp, sheet_copy, range_write and drive_share automation, and gs4_browse for cloud setup. Stores data as relational trip→site→transect→observation, iterates templates for new projects, runs as a one-line deployment, and runs reliably for two years with easier user-oriented forms and fewer entry errors.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 4:28LET YOUR NEEDS GUIDE YOU
3. 7:18ADJUST
4. 10:02BE CREATIVE

" related talks

• 05mIntegrating R & Google Drive or Collaborative ResearchHannah Rempel · satRday Los Angeles 2019
• 32mWork Less and Do More: Google Sheets for JavaScript DevelopersFranziska Hinkelmann, Leah Cole · Node+JS Interactive 2019
• 22mAutomating Custom Reports from JIRA to GoogleSheetsVladymyr Prymakov · QA Fest 2015
• 16mEXCELsioR!Cesaire Tobias · satRday Johannesburg 2019
• 20mBuilding a Flexible, Scaleable Self-Serve Reporting System with ShinyNatalie O'Shea · posit::conf(2023)
• 51m30 Ways Google Sheets Can Help Your Company Uncover and Share Data InsightsDaniel Gundrum, Ryan Weber · Google Cloud Next '18
• 43mHow to Simplify Business Processes with G SuiteAllen Yang · Google Cloud Next '18
• 33mWork Less and Do More: Sheets for Node.js DevelopersFranziska Hinkelmann, Anu Srivastava · Google I/O 2019