The Scenario
You've just inherited a project from a colleague who left the company. There's an Excel workbook on SharePoint with 200 Short.io link IDs in column A — no destination URLs, no titles, no tags, no UTM data. The handoff notes say "these are all the links for the Q3 product campaign" and nothing else. Your manager wants a complete link inventory by Friday for the campaign review.
The bad version:
- Open Short.io, search for each link ID one at a time using the dashboard's search bar
- For each result, manually copy the destination URL, title, tags, and UTM parameters into the appropriate columns in the Excel table
- At link 140, realize you've been pasting the tags column into the UTM source column because the fields in Short.io appear in a different order than your Excel columns
The campaign review is Friday. You found out about this task Thursday morning. There is no graceful way to fill in 200 rows of metadata manually in one day alongside your other work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the link IDs from column A, calls the Short.io API for each one, and writes the full metadata into the adjacent columns.
Look up every Short.io link ID in my Excel table (column A) and fill in the destination URL, creation date, and tag list in the adjacent columns
What You Get
- Column B: the original destination URL for each link ID
- Column C: the creation date for each link
- 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 so the audit doesn't have invisible gaps
What If the Data Is Not Quite Ready
Some IDs in column A belong to archived links and need to be flagged
Archived links still exist in Short.io but may not be active redirects — the review needs to separate active from archived.
For each link ID in column A, retrieve the destination URL into column B, creation date into column C, tags into column D, UTM values into columns E through G from Short.io — also write the link's archived status into column H so the campaign review can separate active from archived entries
The UTM values across rows use inconsistent key casing from historical link creation
Some links used utm_campaign, some used Campaign, some have no UTM data at all.
After retrieving UTM metadata from Short.io for each link ID in column A, normalize all UTM key names to lowercase 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 export script ran twice before the handoff and some IDs appear more than once.
Identify duplicate link IDs in column A and flag them in a helper column before fetching metadata — then retrieve destination URL, creation date, 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, creation date 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
Friday's campaign review has a complete, audit-ready inventory.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook 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 data alongside the metadata.