This package enables the use of Google Sheets as a collabrative data and meta- data entry tool for researchers of different skill sets, automated validation of the data using standarized rules, and to tracking all changes to data using git
Components
Workflow Overview:
- read metadata
- schema (column definitions) from google sheets
- list of data sheet URLs
- validation rules (from Rdata file)
- read data files (from Google Sheets)
- validate
- data format against schema
- data values against rules
- report errors
- save all sheets as CSV and for commit to git
- combine to master list(s)