The Scenario
You run a tour operator specializing in London experiences, and your product lead just asked for a competitive landscape before next week's pricing review: every bookable activity currently listed on Tripadvisor for London, with prices and descriptions, in a spreadsheet. She wants to see where your tours sit against the field.
You have a Tripadvisor developer account. You know the London location ID. What you do not have is a fast way to get 50-plus activity listings out of the Tripadvisor API and into a sheet without writing code.
The bad version:
- Navigate the Tripadvisor API documentation, find the activities endpoint, construct a test call in a REST client, decode the pagination behavior
- Copy the JSON response, paste it into a JSON-to-CSV converter, import the result into Sheets, realize the columns do not match what you expected, reformat manually
- Repeat for additional pages of results until you have the full activity list, then spend another half hour cleaning up encoding issues and truncated descriptions
The pricing review is in four days. Your job is to bring the analysis, not to spend the week on the data extraction layer.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet and, through the Tripadvisor integration, can fetch all bookable activities for a destination location ID and write each activity's name, description, price range, and booking URL directly into your sheet in one operation.
Here is the prompt for this specific task:
Get all bookable activities for TripAdvisor location ID 186338 (London) and write each activity's name, description, price range, and booking URL into this sheet
What You Get
- Column A: Activity name
- Column B: Full description
- Column C: Price range (lowest to highest, formatted as returned by Tripadvisor)
- Column D: Booking URL for each activity
- One row per activity, continuing until the full list is written
What If the Data Is Not Quite Ready
You need activities for multiple destinations on different tabs
For each destination and location ID in columns A and B of the Destinations tab, fetch all TripAdvisor bookable activities and write activity name, lowest price, description, and booking URL into a new sheet named after the destination
You want to filter to only activities under a certain price point
Get all bookable activities for TripAdvisor location ID 186338 (London), filter to only those with a lowest price under 50, and write activity name, price range, and booking URL into this sheet
Descriptions are too long and you want a truncated version alongside the full text
Fetch all bookable activities for TripAdvisor location ID 186338, write activity name, full description, and price range into columns A through C, and write a one-sentence summary of each description into column D
You want the activity list plus a competitive positioning note for each
Get all bookable activities for TripAdvisor location ID 186338, write name, price range, and description into the Activities tab, then in the Analysis tab write a row for each activity comparing its price range to the median price across all activities and noting whether it is above or below median
Describing the output shape — not just the data pull — in a single prompt means you get a sheet you can use, not a dump you still have to shape.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet 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 competitor analysis sheet combining both.