The Scenario
You're a marketing ops specialist. A legacy team left you a sheet of 200 Short.io link IDs exported months ago from a system that no one fully documented. You need to know the original destination URL, the current title, any tags that were applied, and the UTM parameters for each one — so you can audit which links are still valid and which campaigns they belong to.
The bad version:
- Open Short.io and search for each link ID individually, copy the destination URL, title, tags, and UTM values, paste them into the sheet across four columns
- Do that 200 times, keeping careful track of which row you're currently on as you switch between the dashboard and the sheet
- Get to row 120 and realize that some of the links have no UTM parameters at all, and you haven't been noting that consistently — now you have to go back and audit the rows you already filled in
You've been asked to have this inventory complete before Thursday's audit call. It's Tuesday afternoon and you haven't found a fast path through it yet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the link IDs in column A, calls the Short.io API for each one, and writes the full metadata back into the adjacent columns — all in one operation.
For each link ID in column A, call Short.io to retrieve the full metadata and write the original URL into column B, title into column C, tags into column D, and UTM parameters into columns E through G
What You Get
- Column B: the original destination URL for each link ID
- Column C: the Short.io link title
- Column D: all tags associated with the link, joined as a comma-separated list
- Columns E, F, G: UTM source, UTM medium, and UTM campaign respectively
- Rows where the link ID is expired or not found surface a note in column H rather than leaving cells blank and creating an invisible gap in the audit
What If the Data Is Not Quite Ready
Some IDs in column A belong to archived links
Archived links still exist in Short.io but may return different fields than active ones. You need to know which is which.
For each link ID in column A, retrieve the destination URL into column B, title into column C, tags into column D, and UTM values into columns E through G from Short.io — also write the link's archived status into column H so the audit can distinguish active from archived entries
The UTM values across rows use different key naming conventions
Historical links were created by different people and some use utm_campaign, some use Campaign, some have nothing. You need them normalized before the audit.
After retrieving UTM metadata from Short.io for each link ID in column A, normalize all UTM key names to lowercase (utm_source, utm_medium, utm_campaign) before writing values into columns E through G — flag rows where UTM data is missing or inconsistently structured in column H
Some rows in column A are duplicates from the original export
The legacy export ran twice and you're not sure which rows are duplicate IDs.
Identify duplicate link IDs in column A and flag them in a new column before fetching metadata — then retrieve destination URL, title, tags, and UTM parameters from Short.io for the first occurrence of each ID only, writing results into columns B through G
Full audit prep plus enrichment in one pass
Remove duplicate link IDs in column A keeping the first occurrence, trim any whitespace from remaining IDs, retrieve full Short.io metadata for each (destination URL to B, title to C, tags to D, UTM values to E through G, archived status to H), and flag any IDs that return no result in column I
One prompt, one pass, a complete audit-ready inventory.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of Short.io link IDs you need to understand — then ask it to fill in the metadata for the whole batch. Also see how to bulk-tag the links you find, or pull click stats to add performance context alongside the metadata.