How to paste a JSON object into Google Sheets:
1) Use convertcsv.com/json-to-csv.htm
2) If you need to transpose the CSV so columns are now rows then use convertcsv.com/transpose-csv.htm
3) Download the result as a CSV file
4) Import into Google Sheets