HolidayCheck ![Google Sheets](/assets/logos/sheets_logo-c7c6275932e794009779d23c7065243b122919ef86e112d9365c57c97f83e64b.png) 

# Get HolidayCheck 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](/users/sign_up)

50 free requests on signupNo credit card

Trusted by hospitality teams at

 ![EHL](/assets/logos/ehl-51e6ac832bd7a1b8c1f3c17ea48e7f7464f2aaead02a54b7cab2f2ee05b06c86.png) ![Skyscanner](/assets/logos/skyscanner-47f9fed400d4f828b0499892968e393aa1435240b8a573988d36fceb7f0433ae.png) ![Mews](/assets/logos/mews-e52288ca26c3e8d5e3878b522b92b521916a7df9c07556910102ad7bebbd216b.svg) ![CBRE](/assets/logos/cbre-f38211cf61a47f45d021ab25957f592fb2043bcff716539e3f2f54fd7fde91be.png) ![Ripe](/assets/logos/ripe-9fec989e25c3a18f2fec0357610bc743f12bf0e96cfa4824f457c4aa2c95db60.svg)

The pieces
## One source, one destination.

 HolidayCheck HolidayCheck

Find hotels by name, then read hotel details or guest reviews by UUID. Search pages contain up to 10 matches from the available result set; available\_count is not a global total. Details include published descriptions and amenity groups, with star classification separate from six-point guest ratings. No dates, prices, photo gallery, or destination search are provided. Review language and page size cannot be requested. Response examples are illustrative. Here the reviews endpoint pours that text into Google Sheets as sortable rows.

  ![Google Sheets](/assets/logos/sheets_logo-c7c6275932e794009779d23c7065243b122919ef86e112d9365c57c97f83e64b.png) 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. On this page it holds HolidayCheck reviews, refreshed from one endpoint call.

The call
## One endpoint returns HolidayCheck reviews.

The Hotel Reviews endpoint returns clean JSON for one hotel. Send your key in the `X-API-Key` header. See the [endpoint docs](/docs/endpoints/holidaycheck/hotel-reviews) for every parameter.

[GET Hotel Reviews /v1/holidaycheck/hotel/reviews https://api.stayapi.com/v1/holidaycheck/hotel/reviews?hotel\_id=c6b63919-17b1-317d-a9e7-e69dbe195f2e](/docs/endpoints/holidaycheck/hotel-reviews)

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 Alexa Hotel id. Swap in your hotel id and your API key.

refresh.gs

```
function refreshData() {
  var url = "https://api.stayapi.com/v1/holidaycheck/hotel/reviews?hotel_id=c6b63919-17b1-317d-a9e7-e69dbe195f2e";
  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", "hotel_name", "url", "rating", "rating_scale"]);

  var now = new Date();
  records.forEach(function (r) {
    sheet.appendRow([now, r.hotel_name, r.url, r.rating, r.rating_scale]);
  });
}
```

[Grab your API key](/users/sign_up)

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 fieldColumn

hotel\_idhotel\_id

hotel\_namehotel\_name

urlurl

ratingrating

rating\_scalerating\_scale

recommendation\_percentrecommendation\_percent

total\_reviewstotal\_reviews

idid

titletitle

texttext

text\_sectionstext\_sections

keykey

labellabel

review\_datereview\_date

stay\_datestay\_date

original\_languageoriginal\_language

languagelanguage

reviewer\_namereviewer\_name

traveler\_typetraveler\_type

recommendedrecommended

verified\_stayverified\_stay

pagepage

per\_pageper\_page

total\_counttotal\_count

has\_morehas\_more

Result
## What it looks like in Google Sheets.

The fields from the mapping above land as columns: hotel\_id, hotel\_name, url, rating. 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
- hotel\_name
- url
- rating
- rating\_scale
- recommendation\_percent

Screenshot: Google Sheets showing HolidayCheck reviews

Keep going
## More HolidayCheck pipelines.

Build with the API

[Hotel Reviews endpoint docs](/docs/endpoints/holidaycheck/hotel-reviews)[The full HolidayCheck API](/apis/holidaycheck)

## Get your key.

Sign up, copy your key into the snippet above, and pull live HolidayCheck 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](/users/sign_up)
- 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](/book-demo)
- Quote on the call, not after
- Engineering, not sales
- No deck, no slides