The Scenario
You're a web analyst and it's a Tuesday morning. Your CMO sent a message at 7:45 AM: "Can you tell me what happened with traffic yesterday afternoon? We had a spike around 2 PM and I want to know where it came from — country, referrer, device." The branded Short.io domain serves as the top of the funnel for most inbound campaigns. You need raw click event data, not aggregate summaries.
The bad version:
- Open Short.io and navigate to the analytics section for the domain
- Look for a raw click export option — realize it doesn't exist in the UI the way you need it
- Try to pull the data through the Short.io API directly: find the clickstream endpoint, write or run the API call, parse the JSON, paste the fields into a spreadsheet
- By the time you've done all of that, it's 10 AM and the CMO's 9 AM standup already happened without the answer
The spike was real. Something drove traffic yesterday afternoon and leadership wants to know what it was before the day gets further away from the event.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to the Short.io clickstream endpoint, fetches the latest raw click events for your domain, and writes them into the sheet row by row.
Fetch the latest raw click events for my Short.io domain and write each event's timestamp, country, browser, OS, and referrer into columns A through E of my sheet
What You Get
- One row per click event, starting in row 1
- Column A: timestamp of the click
- Column B: country
- Column C: browser
- Column D: operating system
- Column E: referrer source
- Events come back in reverse chronological order so the most recent clicks appear first
What If the Data Is Not Quite Ready
You need events filtered to a specific time window
The spike the CMO mentioned happened between 1 PM and 4 PM yesterday — you don't need the full event history.
Fetch raw click events from Short.io domain ID 1425403 for yesterday between 1 PM and 4 PM UTC and write each event's timestamp, country, browser, OS, and referrer into columns A through E
You want to include the specific short link path that was clicked, not just the domain aggregate
The CMO suspects the spike was driven by one specific link — you need to see which paths were hit during the window.
Fetch the latest raw click events from Short.io domain ID 1425403 and write each event's timestamp, short link path, country, browser, OS, and referrer into columns A through F — sort by timestamp descending
You need a summary pivot built from the raw events automatically
The CMO doesn't want to read 500 rows — she wants a summary of click counts grouped by country for the spike window.
Fetch raw click events from Short.io domain ID 1425403 for yesterday between 1 PM and 4 PM UTC, write the raw events into a tab named "Raw Events" with timestamp, path, country, browser, OS, referrer — then create a "Summary" tab with click counts grouped by country sorted descending
Full intraday spike analysis in one shot
Fetch raw click events from Short.io domain ID 1425403 for yesterday between noon and 6 PM UTC — write each event's timestamp, short link path, country, browser, OS, and referrer into a "Raw Events" tab — then create a Summary tab showing click counts grouped by country in column A/B, by referrer in column D/E, and by short link path in column G/H, all sorted descending by click count
The CMO gets a complete answer before the next standup without you spending three hours in API docs.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull the latest click events from your Short.io domain and write them in. Also see how to export domain analytics broken down by country and referrer for a longer date range, or find which short link paths are driving the most traffic overall.