Get Trip.com reviews into Looker Studio.

function refreshData() {
  var url = "https://api.stayapi.com/v1/tripcom/hotel/reviews/702258";
  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", "id", "rating", "title", "text"]);

  var now = new Date();
  records.forEach(function (r) {
    sheet.appendRow([now, r.id, r.rating, r.title, r.text]);
  });
}