Google SpreadSheet JSON processing

JsonData.gs

// Based on: https://stackoverflow.com/a/76915043/1828241
// 1. Open Spread Sheet
// 2. Go Menu → Extensions → App Scripts
// 3. Create new script, rename it to JsonData.gs
// 4. Put this code, save
// 5. Return back to Spread Sheet, entry formula as usial: `=JsonData(A1; "field_name")`
// For compres JSON and nested fields script must be adjusted
function JsonData(jsonText, key) {
  try {
    var data = JSON.parse(jsonText);
    return data[key] || "";
  } catch (error) {
    return "";
  }
}