Best We Hotel Google Sheets

Get Best We Hotel rates 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.

Best We Hotel Best We Hotel

Best We Hotel adds Jin Jiang's China-focused hotel catalogue, bilingual property content, guest reviews, and direct CNY room rates for teams that need stronger mainland coverage. Here the rates endpoint streams nightly prices into Google Sheets.

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. On this page it holds Best We Hotel rates, refreshed from one endpoint call.

The call

One endpoint returns Best We Hotel rates.

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

GET Best We Hotel Rooms /v1/bestwe/hotel/rooms https://api.stayapi.com/v1/bestwe/hotel/rooms?property_id=JJ1089&check_in=2026-05-01&check_out=2026-05-03
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 Jin Jiang Tower Shanghai id. Swap in your hotel id and your API key.

refresh.gs 
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]);
  });
}
Grab your API key

50 free requests on signup, no card.

Field mapping

Response fields to columns.

Each field from the Best We Hotel Rooms response, and a suggested column name.

Response field Column
property_id property_id
check_in check_in
check_out check_out
nights nights
currency currency
code code
name name
available_rooms available_rooms
per_night per_night
stay_total stay_total
bookable bookable
breakfast_included breakfast_included
cancellation_policy cancellation_policy
member_rate member_rate
total total
Result

What it looks like in Google Sheets.

The fields from the mapping above land as columns: property_id, check_in, check_out, nights. Refreshed on the schedule you set.

The columns you get

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

  • property_id
  • check_in
  • check_out
  • nights
  • currency
  • code
Keep going

More Best We Hotel pipelines.

Other destinations
Best We Hotel rates to Looker Studio Best We Hotel rates to Power BI Best We Hotel rates to BigQuery
More Best We Hotel pipelines
Best We Hotel reviews to Google Sheets Best We Hotel reviews to Looker Studio Best We Hotel reviews to Power BI Best We Hotel reviews to BigQuery
Build with the API
Best We Hotel Rooms endpoint docs The full Best We Hotel API

Get your key.

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