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 Google Sheet, 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 tab of the sheet, note the version ID by clicking into the version history.
- Switch to Libraries, repeat the same process for 17 entries on a second tab.
- Spend the last 30 minutes formatting both tabs 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 Google Sheet. It reads your sheet, talks to both the RudderStack Transformations and Libraries endpoints, and writes both inventories into your sheet in whatever structure you specify.
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 Google Sheet with a 'Type' column indicating Transformation or Library. Put everything on one sheet.
What You Get
- A single sheet with one row per asset — transformations and libraries together
- Columns: asset name, asset ID, latest version ID, latest version created date, Type (Transformation or Library)
- No manual formatting required — the Type column distinguishes asset categories
- Total row count reflects the complete workspace inventory
What If the Data Is Not Quite Ready
The manager wants two tabs instead of one combined view
List all RudderStack transformations and write name, ID, latest version ID to Sheet1, columns A through C. Then list all RudderStack libraries and write name, ID, latest version ID to Sheet2, columns A through C. Label row 1 in both sheets as headers: Name, ID, Latest Version ID.
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. Then do the same for all libraries starting on a new section below, with a blank row between them and "LIBRARIES" as a label in column A.
Some transformations and libraries share naming conventions — I want to flag anything where the name appears in both lists
Fetch all RudderStack transformation names and all library names. Write both inventories to columns A–D (name, ID, latest version ID, type). In column E, write 'DUPLICATE NAME' for any row whose name also appears in the other category's list.
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: 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, tabs, 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 sheet where you're building the RudderStack workspace inventory, then ask it to pull transformations and libraries into the columns you've planned. For related tasks, see Export All RudderStack Transformations Into a Google Sheet for Auditing and the full RudderStack Transformation overview.