The Scenario
You're a performance marketer. The quarterly content review is Monday morning and your director wants to know which short link paths across the branded domain drove the most traffic this quarter. You need the top 50 paths ranked by click volume, along with the click counts, ready to present.
The Short.io dashboard shows you a list of links with click counts, but it doesn't give you a clean ranked export by path. You could sort manually in the UI, then copy rows one at a time, but you've done that before and it takes an hour and leaves you with formatting to clean up before the deck is ready.
The bad version:
- Sort the Short.io link list by clicks descending
- Manually copy each row — path, click count — into a sheet, 50 rows
- Discover that Short.io's list pagination resets when you switch tabs, so you have to re-sort and find your place each time
- Get to the deck only to realize you copied the same link twice because the path names were similar and you didn't notice
The quarterly review is about identifying where to invest next. Spending the night before it doing manual data entry is exactly the wrong use of Monday morning prep time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to the Short.io API, retrieves the top-performing link paths for your domain and date range, and writes them ranked into the sheet.
Get the top short link paths for my Short.io domain by click count for Q1 2026 and write them ranked into my sheet with columns for path, click count, and rank
What You Get
- Rank 1 through 50 populated into column A, starting with the highest-traffic path
- Path string in column B, total click count for the period in column C
- Data is pre-sorted so the first row is always the top performer — no additional sorting needed before the deck
What If the Data Is Not Quite Ready
You want the top 50 paths but only for links that still have active status
Some high-click paths are from archived campaigns and shouldn't appear in the current quarter's review.
Get the top 50 most-clicked Short.io link paths on domain ID 1425403 for Q1 2026 — exclude archived links — and write the rank, path, and click count into columns A through C
The director wants to see both path and the full destination URL side by side
The ranked list alone doesn't tell you what each path points to.
Get the top 50 most-clicked paths on my Short.io domain for Q1 2026, then for each path retrieve the destination URL from Short.io and write rank in column A, path in column B, destination URL in column C, and click count in column D
You need to compare Q1 2026 top paths against Q4 2025 top paths side by side
The director's question is always "did performance improve?" — which means you need both quarters in one view.
Get the top 50 most-clicked Short.io paths on domain ID 1425403 for Q4 2025 and Q1 2026 — write the results side by side in the sheet with path and click count for Q4 in columns A and B and path and click count for Q1 in columns D and E, using rank as the row index
Full ranked comparison with destination URLs in one prompt
Get the top 50 short link paths on domain ID 1425403 for Q4 2025 and Q1 2026 by click count — for each path retrieve the destination URL — write rank in column A, then Q4 path, destination URL, and click count in columns B through D, then Q1 path, destination URL, and click count in columns F through H
The Monday morning deck starts from a complete, formatted dataset.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull the top-performing Short.io paths for your domain and date range. Also see how to pull domain analytics broken down by country and referrer, or find every alias ever created for a specific landing page URL.