The Scenario
The marketing director at a hotel group sent you a spreadsheet with 15 property location IDs and one question: which of these have Tripadvisor Travelers Choice Awards, and for which years? She needs it for a press kit going to the agency Friday.
You are the coordinator who handles this research. You open the workbook. You look at the 15 IDs. You open the Tripadvisor API documentation.
The bad version:
- Make an API call for property one, find the award array in the JSON response, note the award names and years
- Paste each award into the correct columns in the workbook, move to property two
- Reach property seven, realize you forgot to capture the badge type for properties two and four, go back and redo those rows
The press kit has a hard 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 Excel workbook. It reads the workbook, reaches the Tripadvisor integration for each location ID, fetches the full award history, and writes results into rows — one award per row, with property ID and name as anchor columns.
Here is the prompt for this task:
Get all TripAdvisor awards for each property ID in column A of my Excel sheet and summarize which properties have a current Travelers Choice Award by writing 'yes' or 'no' into column B with the most recent award year in column C
What You Get
- Column A: Property location ID (as entered)
- Column B: "yes" or "no" indicating whether the property currently holds a Travelers Choice Award
- Column C: Most recent award year for that property
- Properties with no award history receive "no" in column B and a blank in column C
What If the Data Is Not Quite Ready
You want full award history rather than just the Travelers Choice summary
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 workbook
You need property names populated 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 and write it 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 ignore all other award types
For each TripAdvisor location ID in column A, fetch the award history, filter to only "Travelers Choice" awards, and write the property location ID, award name, and year into the Winners worksheet
You want the full award table plus press-ready language for each property
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 worksheet with property name, award name, and year, then in the Summary worksheet write one sentence per property describing its award history in press-ready language
Writing 15 press-ready award summaries by hand would take most of a morning. As part of the same prompt, it is part of the same operation.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook 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 workbook to pull recent reviews or photo URLs for these properties.