Export CSV spreadsheets from Google docs and convert to JSON with formatting

export-csv-to-json.js

#!/bin/bash

DOC_ID=''
SHEET_ID=0
TMP_FILE='temp.csv'
OUTPUT_FILE='result.json'

# export csv
curl -L "https://docs.google.com/spreadsheets/d/$DOC_ID/export?format=csv&gid=$SHEET_ID" -o $TMP_FILE

# replace first line (optional)
#sed -i '' '1 s/^.*$/name,id/' $TMP_FILE

# convert to json
cat $TMP_FILE | python3 -c 'import csv, json, sys; print(json.dumps([r for r in csv.DictReader(sys.stdin)], ensure_ascii=False, indent=2))' > $OUTPUT_FILE

# cleanup
rm $TMP_FILE