The Scenario
The data ops manager sends you a Slack message on a Tuesday: can you pull together a list of all the shared RudderStack libraries and flag any that haven't had a version update in over 90 days? There's a dependency audit happening before the next major pipeline release and no one has looked at the library inventory since the team restructure.
You open RudderStack, navigate to Libraries, and start counting. Seventeen libraries. Each one has a version history you'd have to open individually to find the created date of the latest version.
The bad version:
- Click into library one, open the version list, note the created date of the most recent version, copy library name and date to the sheet, navigate back.
- Repeat for each of the seventeen libraries — each one requiring two to three navigation steps just to surface the date you need.
- Build a formula in column D to calculate whether the date is more than 90 days ago, realize two of the library names got truncated when you copied them, fix those, re-check.
The audit needs to be done before the release planning call on Friday. The issue is that this task — important enough to need a human to request it, specific enough to have a clear answer — takes forty minutes of clicking to answer when it should take forty seconds.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to RudderStack Transformation, fetches every library and its version history, and writes the data into your sheet — including the staleness flag.
List all RudderStack libraries, fetch every version for each, and write library name, version ID, and created date to columns A, B, and C of my Google Sheet. Then flag column D as 'STALE' if the created date in column C is more than 90 days before today.
What You Get
- Column A: library name as it appears in RudderStack
- Column B: latest version ID for each library
- Column C: the created date of that latest version
- Column D: 'STALE' for any library where the latest version is more than 90 days old; blank otherwise
- One row per library, in the order returned by RudderStack
What If the Data Is Not Quite Ready
The 90-day threshold is actually configurable — this quarter they're using 60 days
List all RudderStack libraries, fetch the latest version for each, write the library name to column A, version ID to column B, and created date to column C. Flag column D as 'STALE' if the created date is more than 60 days before today.
I also want to see ALL versions, not just the latest — one row per version, grouped by library
For each RudderStack library, fetch the complete version history. Write library name to column A, version ID to column B, version number to column C, and created date to column D. Include all versions, newest first within each library group.
The sheet already has some libraries listed in column A — only add rows for libraries not already present
Fetch all RudderStack libraries. Compare library names against the existing values in column A. For any library not already in the sheet, add a new row with the library name, latest version ID, and created date in columns A, B, and C. Flag column D as 'STALE' if the created date is more than 90 days ago.
Full staleness triage in one pass — identify stale libraries, note how many versions exist total, and mark anything with only one version ever as a 'DRAFT'
For each RudderStack library, fetch all versions. Write to columns: A = library name, B = version count (total number of versions), C = latest version created date, D = 'STALE' if latest version is over 90 days old, E = 'DRAFT' if the library has only one version ever and that version is over 30 days old.
The pattern is to treat the staleness logic, the version count, and the conditional flags as part of the same single instruction — so the sheet is the final output, not an intermediate one you have to post-process.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet in the workbook you're using for the pipeline dependency audit, then ask it to pull the full RudderStack library version history with staleness flags. See Create RudderStack Shared Libraries From a Google Sheet for the reverse direction, or the full RudderStack Transformation overview.