Get WeHotel (Jin Jiang) reviews into Google Sheets.

function refreshData() {
  var url = "https://api.stayapi.com/v1/bestwe/hotel/reviews?property_id=JJ1089";
  var response = UrlFetchApp.fetch(url, {
    method: "get",
    headers: { "X-API-Key": "YOUR_API_KEY" },
    muteHttpExceptions: true
  });

  var body = JSON.parse(response.getContentText());
  var records = (body.data && body.data.reviews) || body.reviews || body.rooms || [];

  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.clear();
  sheet.appendRow(["retrieved_at", "rating", "total", "filter", "filter_counts"]);

  var now = new Date();
  records.forEach(function (r) {
    sheet.appendRow([now, r.rating, r.total, r.filter, r.filter_counts]);
  });
}