Google Drive Limitation
Google drive provide option to export spreadsheet as json,but sometimes user need customized structure of json. To generate desirable json, we need to write spreadsheet script which read data from cell and build json object.Consider following Spreadsheet
The original json output for above spreadsheet is here. But we need only data json.
Approach
- First we need to read data from cell, and create Json object
- Make another spreadsheet and dump json data to that, so that it can be download as plain txt
