The Scenario
You're a hospitality consultant. A client has handed you a Google Sheet with 120 competitor hotels — name in column A, city in column B — and wants TripAdvisor ratings, review counts, addresses, and phone numbers filled in before Thursday's strategy call. The sheet has been sitting in your Drive for two weeks because nobody wanted to do 120 browser lookups.
The bad version:
- Open TripAdvisor, search for "Hotel Monaco Prague," copy the rating and review count, paste into row 2, move to row 3.
- Lose your place at row 38 when a Slack message pulls you away. Start over from row 35 to be safe.
- Finish at row 120, realize column E was supposed to be the address but you put the phone number there, fix 60 cells.
The call is in 36 hours and you're supposed to be preparing the actual analysis — not transcribing data that already exists in a structured API.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data, connects to TripAdvisor Content API on your behalf, and writes results back into the sheet. No scripts, no API keys to manage, no copy-paste.
Open the SheetXAI sidebar and paste this prompt:
Search TripAdvisor for each hotel in column A (city in column B) and fill columns C through F with the matching location name, overall rating, review count, and street address.
What You Get
- Column C: canonical TripAdvisor location name (useful for catching name variants)
- Column D: overall rating (numeric, e.g. 4.5)
- Column E: total review count
- Column F: street address as returned by TripAdvisor
- Rows where no match is found: a note in column C flagging the miss so you can review them manually
What If the Data Is Not Quite Ready
Hotel names are inconsistent — some have "Hotel" prefix, some don't
Search TripAdvisor for each venue in column A (city in column B). Normalize the name before searching by stripping leading "Hotel," "The," or "Boutique" prefixes. Write the matched canonical name, rating, review count, and address to columns C through F.
Phone numbers are missing for some rows but I need them too
For each hotel in column A (city in column B), search TripAdvisor and write the matched location name, overall rating, review count, street address, and phone number to columns C through G. Leave cells blank rather than writing "N/A" for hotels where the phone number is not available.
My sheet has two tabs — one for hotels, one for restaurants — and I need both enriched
Enrich the Hotels tab: search TripAdvisor for each name in column A with city in column B, write rating, review count, and address to columns C, D, E. Then do the same for the Restaurants tab with the same column layout.
I need to clean the data, enrich it, and flag anything below 4.0 in one go
Search TripAdvisor for each hotel in column A (city in column B). Fill columns C through F with matched name, rating, review count, and address. After writing all results, add a column G that says "Below threshold" for any hotel with a rating under 4.0 and "OK" for everything else.
The trick is asking for the enrichment and the conditional annotation in a single prompt — SheetXAI resolves both before writing anything back.
Try It
Get the 7-day free trial of SheetXAI and open that competitor hotel sheet you've been putting off. Ask SheetXAI to fill the rating and review columns in one shot. Then check out the spoke on pulling recent reviews for sentiment analysis or go back to the TripAdvisor Content API overview.