/radar-data

Transform Google Spreadsheet data into JSON suitable for the tech radar.

Primary LanguagePythonMIT LicenseMIT

Radar data fetch

Description

Extracts and transforms data within a Google Spreadheet into JSON suitable for using in the Tech Radar.

Installation

pip install -r REQUIREMENTS.txt

Configuration

Generate 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.

Running

python radar.py --spreadsheet "My Radar Data" --worksheet "iOS" > radar.json

or 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.json

License

Refer to LICENSE.