Get Booking.com rates into Looker Studio.

One endpoint call, the Looker Studio setup steps, and a field-to-column map. Then keep it refreshing on a schedule.

Start free with 50 requests

50 free requests on signup No credit card

Trusted by hospitality teams at

The pieces

One source, one destination.

Booking.com

Booking.com carries the largest structured review corpus in hospitality: numeric sub-scores, reviewer country, stay type, and dated text on every property. Rates and rooms sit behind the same hotel_id. Below, those nightly rates land in Looker Studio as sortable rows.

Looker Studio

Looker Studio reads best from a data source that refreshes itself. The reliable pattern is a Google Sheet in the middle: a script fills it on a schedule, Looker Studio treats it as a live table. In this guide it reads Booking.com rates straight from the StayAPI endpoint.

The call

One endpoint returns Booking.com rates.

The Hotel Prices endpoint returns clean JSON for one hotel. Send your key in the X-API-Key header. See the endpoint docs for every parameter.

GET Hotel Prices /v1/booking/hotel/prices https://api.stayapi.com/v1/booking/hotel/prices?hotel_id=346648&check_in=2026-05-01&check_out=2026-05-03

Setup

Wire Looker Studio to the endpoint.

01

Create a StayAPI account and copy your API key from the dashboard.
02

Load the API response into a Google Sheet with the Apps Script below, on a time-driven trigger.
03

In Looker Studio, add that sheet as a data source.
04

Build your report; it re-reads the sheet on each refresh.

Config

Apps Script: fill the bridge sheet.

This uses the real endpoint URL with the example Angsana Laguna Phuket id. Swap in your hotel id and your API key.

refresh.gs

function refreshData() {
  var url = "https://api.stayapi.com/v1/booking/hotel/prices?hotel_id=346648&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", "block_id", "room_name", "is_refundable", "total_price"]);

  var now = new Date();
  records.forEach(function (r) {
    sheet.appendRow([now, r.block_id, r.room_name, r.is_refundable, r.total_price]);
  });
}