The Scenario
You are a revenue manager at a boutique hotel in Amsterdam. Your general manager is presenting at the ownership meeting on Friday and she wants a competitor set slide: the top 10 hotels in Amsterdam on Tripadvisor, with ratings, review counts, price levels, and links — something the ownership group can actually look at and compare.
She sent the request at 4 PM Thursday. The meeting is at 9 AM Friday.
The bad version:
- Search "top hotels Amsterdam Tripadvisor" in a browser, start clicking into individual property pages, find the rating and review count on each
- Copy the data into a sheet, property by property, tabbing between the browser and Sheets for each of ten hotels
- Get to hotel eight, realize you have been capturing the total review count from the summary page rather than from the detailed reviews section and the numbers do not match your GM's expectations — restart
The ownership deck is already 80% done. This one table should not be the thing that keeps you at the office past 7.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, calls the Tripadvisor search and details endpoints in sequence, and writes a complete competitor table — hotel name, rating, review count, price level, and URL — in one operation.
Here is the prompt for this specific task:
Find the top 10 TripAdvisor hotels near location ID 188633 (Amsterdam) and for each one write the hotel name, rating, number of reviews, price level, and TripAdvisor URL into this sheet — one row per hotel
What You Get
- Column A: Hotel name
- Column B: Overall Tripadvisor rating
- Column C: Total review count
- Column D: Price level
- Column E: Direct Tripadvisor URL for each property
- Ten rows, sorted by Tripadvisor's default ranking for the location
What If the Data Is Not Quite Ready
You need competitor sets for multiple cities on separate tabs
For each city and its TripAdvisor location ID in columns A and B of my sheet, find the 5 nearest hotels and write their names, ratings, and review counts into a results tab organized by city
You want the competitor set filtered to only 4-star and 5-star properties
Find the top 10 TripAdvisor hotels near location ID 188633, filter to only properties with a rating above 4.0, and write hotel name, rating, review count, price level, and TripAdvisor URL into this sheet
You want to add your own property as a benchmark row at the bottom
Find the top 10 TripAdvisor hotels near location ID 188633, write hotel name, rating, review count, price level, and URL into rows 2 through 11, then in row 12 fetch the details for TripAdvisor location ID 12345 (our property) and write the same fields so we can compare directly
You want the full competitor table plus a positioning summary for the deck
Find the top 10 TripAdvisor hotels near location ID 188633, write name, rating, review count, price level, and URL into the Competitors tab — one row per hotel — then in cell A1 of the Summary tab write three bullet points describing where the midpoint falls on rating and price level and where the highest-reviewed property sits relative to the group
Three bullets for an ownership deck, pulled from live data, in the same prompt as the table itself.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before your next revenue review, then ask it to pull the top 10 competitor hotels for your destination with ratings, review counts, price levels, and links. You can also ask it to pull the most recent reviews for each competitor or to check which properties hold current Travelers Choice Awards.