The Scenario
You're a growth analyst and your monthly performance deck is due at end of day. You track 150 campaign short links across three branded domains, and all the Short.io link IDs are already in column A of your Excel table. The only thing missing is the 30-day click count for each one. You've been pulling this data manually every month — opening Short.io, filtering by each link ID, writing down the number, switching back to Excel — and every month it takes most of the afternoon.
The bad version:
- Log into Short.io, search for each link ID individually, read the 30-day click count, switch to Excel, find the corresponding row, type in the number
- A Teams message interrupts you at link 83 and you lose your place in the sort order
- Finish the list, format the numbers, build the chart — and get a reply from your director pointing out that the total at the bottom doesn't match the sum formula because you typed 1,450 instead of 14,500 for one row
The deck goes to leadership at 5 PM. It's 2:30 PM. You still need to write the commentary section.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your link IDs, connects to the Short.io API, retrieves click statistics for each one, and writes the counts back into the table in one pass.
Pull click counts for the 150 link IDs in my Excel table from Short.io and populate column C with each link's total click count
What You Get
- Column C fills with the 30-day click total for each Short.io link ID in column A
- Any link ID that returns no result surfaces a note in column C rather than leaving the cell blank and distorting your totals
- The operation runs across all 150 rows without manual switching between the dashboard and the workbook
What If the Data Is Not Quite Ready
Some link IDs in column A have trailing spaces from a paste operation
The IDs were copied from three different export files and some have invisible whitespace that causes the API to return nothing.
Trim whitespace from all link IDs in column A, then fetch click statistics for the last 30-day window from Short.io and write the click count into column C — note any IDs that still return no result in column D
The workbook mixes link IDs and full short URLs in column A
Some rows have just the numeric ID, others have the full branded short URL.
For any value in column A that looks like a full short URL, extract the path or ID component before calling Short.io — then fetch the 30-day click count for each and write results into column C
You need click counts broken out by individual domain
The 150 links span three different branded domains and you want subtotals per domain in the summary row.
Fetch 30-day click counts from Short.io for each link ID in column A and write the counts into column C, then add a summary section below the data showing total clicks grouped by the domain of each link ID
Full data quality pass plus click retrieval in one prompt
Trim whitespace from all values in column A, extract IDs from any full URLs, fetch the 30-day click count from Short.io for each, write counts into column C, flag missing results in column D, and add a domain subtotal summary below the last data row
The deck is ready on time and the totals are correct.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with Short.io link IDs in column A, then ask it to pull the click stats for the window you need. Also see how to enrich your link inventory with full Short.io metadata, or export domain-level analytics broken down by referrer source.