The Scenario
Your team has been building a location research automation using TomTom's POI search API, and the developer who knows TomTom's category system just went on sabbatical. You're left with a half-built lookup table that maps category IDs to human-readable names — and it has obvious gaps. The search queries your automation sends are pulling back inconsistent results because some category IDs are wrong. Before you can fix the queries, you need the complete, authoritative list of TomTom's POI categories in a spreadsheet you can reference.
The bad version:
- Find TomTom's category list in the developer documentation, which is a long nested HTML table that doesn't export cleanly
- Manually copy each category name and ID into a spreadsheet, try to preserve the parent-child hierarchy, and get to row 150 before the page freezes and you lose progress
- End up with a partial list that covers the categories you happened to paste before giving up
The developer is on sabbatical for three weeks. The lookup table is broken right now.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It calls TomTom's category endpoint, retrieves the full taxonomy, and writes every category ID and name into the sheet in one operation.
Fetch the full list of TomTom POI categories and write each category's ID and name into this Google Sheet, one row per category
What You Get
- One row per TomTom POI category
- Column A: category ID (the value you pass to the API)
- Column B: category name (human-readable)
- Complete list, not just the categories that happen to appear in the documentation examples
What If the Data Is Not Quite Ready
You also need the parent category hierarchy
Get all TomTom POI categories and write their IDs, names, and parent category IDs into this Excel sheet so I can build a hierarchy reference
You need the list formatted for use in a dropdown validation
Fetch all TomTom POI category IDs and names. Write each name into column A and the corresponding ID into column B. Sort column A alphabetically so the list is ready to use as a data validation source for a dropdown in another tab.
You want to filter to a specific branch of the taxonomy
Fetch the full TomTom POI category list. Write all categories where the name or parent name contains "food" or "restaurant" into this sheet, with category ID in column A and name in column B.
Full hierarchy table with category counts from a recent search
Fetch the full TomTom POI category taxonomy and write category ID, name, and parent category ID into columns A, B, and C. Then for each category, query TomTom POI search using the center of London as a reference point and write the number of results returned within 5km into column D. Sort by column D descending so the most-populated categories appear first.
One prompt builds the complete taxonomy table and adds a result-count column for context.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to export the full TomTom POI category list. Once you have the reference table, see the nearby POI enrichment spoke to put those category IDs to work on your location data.