Convert Google Spreadsheet contents to JSON.
Also update Google spreadsheet from JSON data.
install
% npm install ss2json
help
% ss2json --helpUsage: ss2json [options] [command]Options: -V, --version output the version number -h, --help output usage informationCommands: get [options] update [options]
get
% ss2json get --helpUsage: get [options]Options: -a, --auth [AUTH_JSON_FILE_PATH] JSON path for Google's authentication -i, --id [SPREADSHEET_ID] Google Spreadsheet ID -n, --name [SHEET_NAME] Sheet name in Google Spreadsheet -h, --help
update
% ss2json update --helpUsage: ss2json update [options]Options: -a, --auth [AUTH_JSON_FILE_PATH] JSON path for Google's authentication -i, --id [SPREADSHEET_ID] Google Spreadsheet ID -n, --name [SHEET_NAME] Sheet name in Google Spreadsheet -d, --data [DATA_JSON_FILE_PATH] JSON file path for update data --autoAddSheet Add when there was no sheet. -h, --help output usage information
Command example
Get the data from the spreadsheet and write it to data.json.
% ss2json get \ -a AUTH_JSON_FILE_PATH \ -i SPREADSHEET_ID \ -n SHEET_NAME > ./data.json
You can also edit data.json to update the spreadsheet.