KAYAK Google Sheets

Get KAYAK reviews into Google Sheets.

One endpoint call, the Google Sheets 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.

KAYAK KAYAK

Read published hotel details, photos, and amenities with a public KAYAK property URL. Resolve the URL to a hotel ID, find city IDs, or compare qualitative daily city price bands. No live hotel prices or availability. Read paginated reviews by hotel_id, up to 10 per page, with 0–100 scores and source labels. The review source total can differ from the Details aggregate; follow has_more. This guide points those reviews at Google Sheets, refreshed on your schedule.

Google Sheets Google Sheets

Google Sheets is still the fastest way to get data in front of people who do not write code. One Apps Script function turns a sheet into a live feed your whole team can read, filter, and chart. Below you wire it to the KAYAK reviews endpoint in a few steps.

The call

One endpoint returns KAYAK reviews.

The Hotel Reviews 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 Reviews /v1/kayak/hotel/reviews https://api.stayapi.com/v1/kayak/hotel/reviews?hotel_id=118305
Setup

Wire Google Sheets to the endpoint.

  1. 01

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

  2. 02

    Open your sheet, then Extensions > Apps Script.

  3. 03

    Paste the fetch script below and set your API key.

  4. 04

    Run it once to authorize, then add a time-driven trigger to refresh on a schedule.

Config

Apps Script: fetch and write rows.

This uses the real endpoint URL with the example Four Seasons Resort Bali at Sayan id. Swap in your hotel id and your API key.

refresh.gs 
function refreshData() {
  var url = "https://api.stayapi.com/v1/kayak/hotel/reviews?hotel_id=118305";
  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", "total_review_count", "returned", "id", "author"]);

  var now = new Date();
  records.forEach(function (r) {
    sheet.appendRow([now, r.total_review_count, r.returned, r.id, r.author]);
  });
}
Grab your API key

50 free requests on signup, no card.

Field mapping

Response fields to columns.

Each field from the Hotel Reviews response, and a suggested column name.

Response field Column
hotel_id hotel_id
page page
page_size page_size
total_review_count total_review_count
returned returned
has_more has_more
id id
author author
date_text date_text
score score
score_scale score_scale
positive_comment positive_comment
negative_comment negative_comment
source source
Result

What it looks like in Google Sheets.

The fields from the mapping above land as columns: hotel_id, page, page_size, total_review_count. Refreshed on the schedule you set.

The columns you get

Every row is one hotel record from the Hotel Reviews response. These fields become columns:

  • hotel_id
  • page
  • page_size
  • total_review_count
  • returned
  • has_more
Keep going

More KAYAK pipelines.

Build with the API
Hotel Reviews endpoint docs The full KAYAK API

Get your key.

Sign up, copy your key into the snippet above, and pull live KAYAK reviews into Google Sheets.

01 · the fast path

Try it free

50 free requests on signup. Fastest way to see if the schema fits.

Start free
  • Live API key in 30 seconds
  • No credit card required
  • Same schema as paid
02 · talk to us

Talk through your pipeline

15 minutes. Volume, endpoint mix, and where the data lands. Walk out with a quote.

Book a demo
  • Quote on the call, not after
  • Engineering, not sales
  • No deck, no slides