The Scenario
The marketing director at a hotel group sent you a spreadsheet with 15 property location IDs and a single question: which of these have Tripadvisor Travelers Choice Awards, and for which years? She needs it for a press kit that goes to the agency on Friday.
You are the coordinator who handles this kind of research. You open the sheet. You look at the 15 IDs. You open the Tripadvisor API documentation.
The bad version:
- Make an API call for property one, parse the award array from the JSON response, note the award names and years somewhere
- Paste that into the sheet, format it correctly, move to property two
- Reach property eight, realize you forgot to capture the badge type for properties three and four, go back and redo those rows
The press kit has a deadline. This task does not deserve three hours of your Thursday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, reaches the Tripadvisor integration for each location ID, fetches the full award history, and writes the results into rows — one award per row, with property ID and name as anchor columns.
Here is the prompt for this task:
For each TripAdvisor location ID in column A, fetch the full award history and write each award's name, year, and badge type into new rows in this sheet
What You Get
- Column A: Tripadvisor location ID (repeated for each award row belonging to that property)
- Column B: Award name (e.g., Travelers Choice, Certificate of Excellence)
- Column C: Award year
- Column D: Badge type or award subcategory where available
- Properties with no award history produce no rows — the list self-filters
What If the Data Is Not Quite Ready
You want one row per property with a summary of awards rather than one row per award
For each TripAdvisor location ID in column A, get the award history and write into column B a comma-separated list of all award years, and into column C whether the property currently holds a Travelers Choice Award — yes or no
You need property names alongside the IDs before you can build the press kit table
For each location ID in column A, fetch the TripAdvisor location details to get the property name, write the name into column B, then fetch the full award history and write award name, year, and badge type into columns C, D, and E
You want to filter to only Travelers Choice winners and exclude all other award types
For each TripAdvisor location ID in column A, fetch the award history, filter to only awards with "Travelers Choice" in the name, and write the property location ID, award name, and year into the Winners tab
You want the full award history plus a ready-to-paste press kit summary
For each location ID in column A, fetch the property name and full award history from TripAdvisor, write each award as its own row in the Awards tab with property name, award name, and year, then in the Summary tab write one sentence per property describing its award history in press-ready language
Asking for the research and the output format together means you hand the press kit table to the director, not another raw data dump.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your property location IDs live, then ask it to pull the full award history and flag current Travelers Choice holders. You can also use the same sheet to pull photo URLs for these properties or to enrich the IDs with full location details.