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

# Get Otelpuan 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.

 Otelpuan Otelpuan

Search Otelpuan hotel suggestions by name, or resolve a public hotel URL. Use the returned hotel\_id to read reviews directly. Search is not exhaustive city inventory. Stay months use YYYY-MM; publication dates are unavailable. Use the canonical hotel URL for rooms and prices with stay dates and guests; reviews continue to use hotel\_id. 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 Otelpuan reviews, refreshed from one endpoint call.

The call
## One endpoint returns Otelpuan 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/otelpuan/hotel-reviews) for every parameter.

[GET Hotel Reviews /v1/otelpuan/hotel/reviews https://api.stayapi.com/v1/otelpuan/hotel/reviews?hotel\_id=25322](/docs/endpoints/otelpuan/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 Türkler Otel id. Swap in your hotel id and your API key.

refresh.gs

```
function refreshData() {
  var url = "https://api.stayapi.com/v1/otelpuan/hotel/reviews?hotel_id=25322";
  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", "rating", "text", "reviewer_name", "stay_date"]);

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

[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

ratingrating

texttext

reviewer\_namereviewer\_name

stay\_datestay\_date

stay\_date\_textstay\_date\_text

review\_datereview\_date

idid

titletitle

travel\_typetravel\_type

room\_typeroom\_type

rating\_scalerating\_scale

review\_countreview\_count

totaltotal

page\_infopage\_info

Result
## What it looks like in Google Sheets.

The fields from the mapping above land as columns: rating, text, reviewer\_name, stay\_date. 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:

- rating
- text
- reviewer\_name
- stay\_date
- stay\_date\_text
- review\_date

Screenshot: Google Sheets showing Otelpuan reviews

Keep going
## More Otelpuan pipelines.

Build with the API

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

## Get your key.

Sign up, copy your key into the snippet above, and pull live Otelpuan 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