Learn how to use UrlFetchApp Class to import external data to Goole Sheets or use it otherwise in Google Apps Scripts. This tutorial will also walk though creating UDF (user defined function) in Google Sheets, JSON parse in JavaScript and other related topics.

You can find the final code here
https://www.chicagocomputerclasses.com/google-sheets-import-json-importjson-function/

Google Sheets
https://www.google.com/sheets/about/

Company Page
http://www.chicagocomputerclasses.com/