Get Best We Hotel rates into Looker Studio.

function refreshData() {
  var url = "https://api.stayapi.com/v1/bestwe/hotel/rooms?property_id=JJ1089&check_in=2026-05-01&check_out=2026-05-03";
  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", "check_in", "check_out", "nights", "currency"]);

  var now = new Date();
  records.forEach(function (r) {
    sheet.appendRow([now, r.check_in, r.check_out, r.nights, r.currency]);
  });
}