How to import JSON data into Google Spreadsheets?
  1. Create a new Google Spreadsheet.
  2. Click on Tools -> Script Editor.
  3. Click Create script for Spreadsheet.
  4. Delete the placeholder content and paste the code from this script.
  5. Rename the script to ImportJSON.gs and click the save button.
  6. Back in the spreadsheet, in a cell, you can type “=ImportJSON()” and begin filling out it’s parameters.


Example:
=ImportJSON(“http://date.jsontest.com", “/date”, “noInherit, noTruncate”)

with the following raw JSON from date.jsontest.com:
{
“time”: “05:27:57 AM”,
“milliseconds_since_epoch”: 1394774877499,
“date”: “03-14-2014"

}

 will yield: