Edit/Create Activities via Google Spreadsheet

[SmokyBob]

As discussed in the Montly GDE App Hangout of 20150310:
To ease the edit of the impact on activities, build a Google Sheet with the following features:

1. AutoUpdating sheet with the activities of the last X Month/s (a month, a quarter?)
   • Update data from the backend OnOpen to avoid too many calls to the backend
2. Data pulled from the API are for that GDE only
   • Should be possible to authenticate calls from GAS to the API with the current user
3. Automatically push updates/New activities after validation
   • Check if the minimum required values are present before pushing any update
   • Add a "Status" column to show if the row is Synced/Missing Data/Error Sync, etc...
4. No support to Delete Activity

[SmokyBob]

Some things to consider that I don't have a clear idea how to implement:

1. Support for activities with multiple activity_metadata:
   • By adding different set of columns for each activity based on the number of activity_metadata?
     • maybe using different background columns to highlight the group
2. Activity Creation, should we support it from the Spreadsheet or only Edit?
   • The Main problem is that we might end up trying to create a new activity if the user copy and paste the same activity into a different row or delete the id column (that would be in an hidden column... but happens)

Ideas/feedback/volunteers are more than welcome.

[SmokyBob]

Moved