The Scenario
You're a growth analyst tracking 150 campaign short links across three branded domains. Every month you need to compare click performance across campaigns, and the sheet already has all the Short.io link IDs in column A. But pulling the click data means logging into Short.io, filtering by each link, writing down the 30-day total, switching back to the sheet, finding the right row, and entering the number. For 150 links. The last time you ran this report it took three hours and you still found a transcription error in the final version.
The bad version:
- Open Short.io and use the search to find each link ID one at a time, note the 30-day click count, flip back to the sheet, and enter it in column B
- Lose track of which row you were on after a Slack message interrupts you at link 67
- Finish the report, send it to the VP of Marketing, and get a reply pointing out that two rows have the same number — you pasted the same click count twice during the interruption
The monthly performance review starts in 45 minutes and the VP specifically asked for this comparison. There's no graceful way to explain that the data is off because you lost your place in a list.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your link IDs, connects to the Short.io API, retrieves click statistics for each one, and writes the results back into your sheet in a single operation.
Fetch click statistics for all short link IDs listed in column A of my sheet from Short.io and write the click counts for the last 30-day window into column B
What You Get
- Column B fills with the 30-day click total for each Short.io link ID in column A
- Rows where the link ID is invalid or no longer exists surface a note in column B rather than silently leaving the cell blank
- The operation runs across all 150 rows in a single API sequence, not one dashboard lookup at a time
What If the Data Is Not Quite Ready
Some link IDs in column A have trailing spaces or formatting characters
The IDs were pasted from different exports and some have invisible whitespace that will cause the API call 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 B — note any IDs that still return no result in column C
The sheet mixes link IDs and full short URLs in column A
Some rows have just the ID, others have the full branded 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 B
You need click counts broken out by individual domain
The 150 links span three different branded domains and you want to see subtotals per domain alongside the individual counts.
Fetch 30-day click counts from Short.io for each link ID in column A and write the counts into column B, 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 B, flag missing results in column C, and add a domain subtotal summary below the last data row
You get clean data and a ready-to-present summary without touching the sheet manually.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with Short.io link IDs in column A, then ask it to pull the click stats for the window you care about. Also see how to enrich your link inventory with full metadata, or export domain-level analytics broken down by country and referrer.