Google Sheets read JSON function. Read values from a JSON array in another cell using a key.

Json.gs

function READJSON(input, key) {
  if (input.map) {
    return input.map(function(input) {
      return READJSON(input, key)
    });
  } else {
    if (input || 0 !== input.length) {
      var value = key.split('.').reduce(function(a, b) {
        return a[b] || "";
      }, JSON.parse(input));
      
      if (!isNaN(Number(value)) && value) {
        return Number(value);
      } else {
        return value;
      }
    }
  }
}