The Scenario
You're two weeks out from a platform migration and your engineering lead has asked for a complete inventory of every RudderStack transformation in the workspace — name, transformation ID, latest version ID, and whether each one is still connected to an active destination. The expectation is an Excel workbook, ready for the architecture review on Thursday.
You open the RudderStack dashboard and count. Forty-three transformations.
The bad version:
- Click into transformation one, copy the name and ID to the workbook, navigate back to the list, click into transformation two.
- Realize midway through that you also need the version ID, which requires a second click inside each transformation to find it.
- Lose track of which row you're on at transformation 31 and have to cross-reference the RudderStack list against the workbook to figure out where you stopped.
That's not the kind of work that makes sense to bill to a migration project. The architecture review needs the inventory, not a record of how long it took to compile it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook, talks to RudderStack Transformation on your behalf, and writes the results where you tell it to. Open the sidebar and paste in the task.
List all published RudderStack transformations and write each transformation's name, ID, and version ID to columns A, B, and C in my Excel workbook.
What You Get
- Column A: transformation name as it appears in RudderStack
- Column B: transformation ID (the unique identifier used in API calls and destination mappings)
- Column C: latest version ID for each transformation
- One row per transformation, no duplicates, no manual cross-referencing required
What If the Data Is Not Quite Ready
The workbook already has headers but rows aren't cleared from a previous export
The headers in row 1 are Name, ID, Version ID — leave those in place, clear any existing data in A2:C200, then list all published RudderStack transformations and write each one starting at row 2.
I also need the version creation date, not just the version ID
List all published RudderStack transformations, fetch the latest version for each, and write the transformation name to column A, the transformation ID to column B, the latest version ID to column C, and the version created date to column D.
I want to split transformations by a naming convention — anything starting with "prod_" goes to Sheet1, everything else to Sheet2
List all published RudderStack transformations. Write transformations whose name starts with "prod_" to columns A–C of Sheet1. Write all others to columns A–C of Sheet2. Same columns in both: name, ID, latest version ID.
Full cleanup and inventory in one shot — deduplicate any rows already in the workbook, add new ones, flag anything with a version older than 60 days
Fetch all RudderStack transformations. Compare against any existing rows in column B (transformation ID). Add any transformations not already listed. For every row, write the latest version created date to column D and flag column E as 'REVIEW' if that date is more than 60 days ago. Leave existing rows that are already current as-is.
The pattern throughout: describe the shape of what you want — the columns, the worksheets, the conditions — and SheetXAI handles the API calls, the comparison logic, and the writes in a single pass.
Try It
Get the 7-day free trial of SheetXAI and open the workbook where you're building your RudderStack migration inventory, then ask it to pull your full transformation list into the columns you've already set up. For related tasks, see Bulk Create RudderStack Transformations From an Excel workbook and the full RudderStack Transformation overview.