The Scenario
You run a tour operator focused on London experiences and your product lead asked for a competitive landscape before next week's pricing review: every bookable activity listed on Tripadvisor for London, with prices and descriptions, in a workbook. She wants to see where your tours sit against the field.
You have a Tripadvisor developer account and the London location ID. What you do not have is a fast way to get 50-plus activity listings out of the API and into a workbook without writing code.
The bad version:
- Find the Tripadvisor activities endpoint, construct the API call, decode the pagination behavior
- Copy the JSON response into a converter, import the result into Excel, realize the columns are not in the shape you expected, reformat manually
- Repeat for additional pages of results, spend another half hour cleaning encoding issues and truncated descriptions
The pricing review is in four days. Your job is to bring the analysis — not to spend the week building the data pipeline to support it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and, through the Tripadvisor integration, can fetch all bookable activities for a destination location ID and write each one's name, description, price range, and booking URL directly into your workbook in one operation.
Here is the prompt for this specific task:
For each destination location ID in column A of my Excel sheet, fetch the available TripAdvisor activities and write activity name, lowest price, and image URL into new rows in a results tab
What You Get
- Column A: Activity name
- Column B: Lowest price from the price range
- Column C: Image URL for the activity
- One row per activity, organized by destination if multiple IDs are in column A
- Destinations with no bookable activities produce no rows
What If the Data Is Not Quite Ready
You want full descriptions and booking URLs alongside the price data
Get all bookable activities for TripAdvisor location ID 186338 (London) and write each activity's name, description, price range, and booking URL into this workbook — one row per activity
You need activities for multiple destinations on separate worksheets
For each destination and location ID in columns A and B of the Destinations worksheet, fetch all TripAdvisor bookable activities and write activity name, lowest price, description, and booking URL into a new worksheet named after the destination
You want to filter to only activities under a certain price
Get all bookable activities for TripAdvisor location ID 186338, filter to only those with a lowest price under 50, and write activity name, price range, and booking URL into this workbook
You want the activity list plus a positioning note for each against your own offerings
Fetch all bookable activities for TripAdvisor location ID 186338, write name, price range, and description into the Activities worksheet, then in the Analysis worksheet write one row per activity with a note on whether the price is above, below, or within the range of your own tours listed in the OurTours worksheet
Describing both the data pull and the comparison logic in one prompt means you get a positioning sheet, not just a raw list.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook for your next destination competitive review, then ask it to pull the full activity list for your target city. You can also ask it to pull hotel data for the same destination or to build a full competitor analysis combining both in the same workbook.