Extracts and transforms data within a Google Spreadheet into JSON suitable for using in the Tech Radar.
pip install -r REQUIREMENTS.txtGenerate a Google Service Account Client ID JSON credential file, see Using OAuth 2.0 for Server to Server Applications.
Rename the downloaded JSON key to credentials.json and place along side the radar.py script.
python radar.py --spreadsheet "My Radar Data" --worksheet "iOS" > radar.jsonor you can specify multiple worksheets in a json formatted input file (see example file input.json)
python radar-multi.py --inputfile input.json > radar-data.jsonRefer to LICENSE.