The Scenario
It's the end of Q2 and the data engineering manager is preparing the quarterly documentation package. One line item: a complete inventory of every RudderStack asset in the workspace — every transformation and every library — with the ID and latest version info for each. The output needs to go into a single Excel workbook with two worksheets, and the request came in this morning with a Friday deadline.
The manager opens the RudderStack dashboard. Transformations: 43. Libraries: 17.
The bad version:
- Navigate to the Transformations list, open each one, copy the name and ID to one worksheet, note the version ID by clicking into the version history.
- Switch to Libraries, repeat the same process for 17 entries on a second worksheet.
- Spend the last 30 minutes formatting both worksheets consistently and adding a "Type" column so the two inventories can be compared.
An hour and a half of extracting data that already exists in a structured API. The documentation is important. The data entry is not the work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook, talks to both the RudderStack Transformations and Libraries endpoints, and writes both inventories into your workbook in whatever structure you specify.
List all RudderStack transformations and write name, ID, latest version ID to Sheet1, then list all libraries and write name, ID, latest version ID to Sheet2 of my Excel workbook.
What You Get
- Sheet1: one row per transformation — name, ID, latest version ID
- Sheet2: one row per library — name, ID, latest version ID
- Both worksheets populated in a single pass, no manual formatting required
- Total row count in each sheet reflects the complete workspace inventory for that asset type
What If the Data Is Not Quite Ready
The manager wants everything on one sheet with a Type column instead of two separate worksheets
Fetch every RudderStack transformation with its version count and latest version date, then do the same for all libraries, and write both inventories side by side in my Excel workbook with a 'Type' column indicating Transformation or Library. Put everything on Sheet1.
I need to include a version count — how many published versions exist for each asset
Fetch every RudderStack transformation. For each, get the count of all versions and the created date of the most recent one. Write name to column A, ID to column B, version count to column C, and latest version date to column D in Sheet1. Then do the same for all libraries in Sheet2.
Some transformations and libraries share naming conventions — flag anything where the name appears in both lists
Fetch all RudderStack transformation names and all library names. Write transformations to Sheet1 and libraries to Sheet2, each with name, ID, latest version ID. In column E of each sheet, write 'DUPLICATE NAME' for any row whose name also appears in the other sheet.
Full quarterly audit doc in one shot — both inventories, staleness flags, version counts, and a summary row
Fetch all RudderStack transformations and libraries. Write each asset to a row in Sheet1: name in column A, ID in column B, type in column C (Transformation or Library), version count in column D, latest version created date in column E. Flag column F as 'STALE' if the latest version date is more than 90 days ago. After all asset rows, add a summary row at the bottom: total transformations, total libraries, total stale assets.
The pattern: describe the full shape of the document you need — columns, worksheets, flags, summaries — in one instruction, and SheetXAI assembles it from the API without intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open the quarterly documentation workbook where you're building the RudderStack workspace inventory, then ask it to pull transformations and libraries into the worksheets you've planned. For related tasks, see Export All RudderStack Transformations Into an Excel workbook for Auditing and the full RudderStack Transformation overview.