The Scenario
IT planning season is next month and your manager has asked for a review of the service catalog before the budget meeting. You need a complete inventory of every catalog item in Freshservice — name, display ID, category, and description — so the team can identify gaps, consolidate duplicates, and propose additions. You've never actually seen a full list. You know there are at least 45 items because someone mentioned it in a Slack thread, but the catalog UI shows twelve per page and there's no obvious way to export it.
The bad version:
- Go to the Freshservice service catalog, open page 1, manually copy item names and IDs into a Google Sheet. Navigate to page 2. Repeat.
- Hit page 4 and realize the category column in your sheet has been inconsistently formatted because you've been typing "Hardware" sometimes and "hardware" other times.
- Finish all 45 items, send the sheet to your manager, and get a reply asking why item 23 has no description — you missed the column because you were copying manually and it wasn't visible without scrolling right.
Forty-five items across multiple pages. Copied by hand. Into a sheet you're going to use for budget planning.
This is the kind of task that gets done wrong once and then silently becomes the source of truth for the next three quarters.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Freshservice and fetches the entire catalog in one pull — all pages, all items, every field you ask for.
Try this yourself — free for 7 days
SheetXAI installs in your Google Sheet in about a minute. Paste the prompt below and watch it run.
Open the SheetXAI sidebar in a blank Google Sheet and paste this prompt:
List all Freshservice service catalog items and write item name, display ID, category, and description into columns A, B, C, and D.
What You Get
- Every service catalog item in Freshservice written into columns A–D in a single operation.
- Item names, display IDs, categories, and descriptions all in consistent, structured format — no pagination, no manual copying.
- A sheet that's immediately useful as a planning document, filterable by category, sortable by name or ID.
- Any items with missing descriptions or blank categories visible at a glance because the structure makes gaps obvious.
What If the Data Is Not Quite Ready
You only want items in a specific category
List all Freshservice service catalog items in the "Hardware" category and write item name, display ID, and description into columns A, B, and C.
You want to flag items with missing descriptions
List all Freshservice service catalog items and write name, display ID, category, and description into columns A through D. In column E, write 'MISSING DESCRIPTION' for any item where column D is blank, and leave column E empty for the rest.
You want to compare the catalog against a list of expected items from another tab
List all Freshservice service catalog items and write name and display ID into columns A and B. Then compare column A against the list of expected catalog items in the "Expected" tab, column A. Write 'PRESENT' or 'MISSING FROM CATALOG' into column C for each expected item.
Full catalog audit for the planning meeting in one shot
Fetch all Freshservice service catalog items and write name, display ID, category, and description into columns A through D. Sort by category (column C) then alphabetically by name (column A). Flag rows with blank descriptions in column E with 'NO DESCRIPTION.' Then in a new tab called "Category Summary," write each unique category and the count of items in that category.
One pull — every item, sorted, flagged, and summarized — ready for the planning document.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before your next IT planning cycle, then ask it to pull the complete Freshservice service catalog for review. When you're done, check out how to look up ticket details by ID or return to the Freshservice hub.