What is the workflow if the Google spreadsheet will remain definitive "master" data?

[jennybc]

Think about this scenario and make sure package and/or its documentation is up to the challenge:

Data somehow gets into a Google spreadsheet. Maybe from a Google form or a non-R-using collaborator.

Analyst works with that data in R, potentially learning that some changes need to be made, e.g. cleaning or corrections. What if that needs to be effected on the Google spreadsheet, as opposed to, say, a local data file? Maybe it's absolute best practice to create a new Google spreadsheet but what if there are external reasons for NOT doing so? What if you want to write back into the same spreadsheet?

This increases my interest in the functions for writing to a Google spreadsheet. Implemented.

What are the pros / cons of editing piecemeal vs. replacing the contents wholesale, I wonder?

How well do we support using worksheets for this? I.e. keeping raw data untouched in one sheet, then writing a cleaned or wrangled version to a different worksheet?

For that matter, does the API give any access to whatever form of version control is happening for the Google spreadsheet?