The Scenario
The growth team's weekly report goes out to four stakeholders every Friday at 4 PM. This week, someone added a new slide: clicks on the product launch link broken down by country and device platform. It's Wednesday. You have a Linkly link ID and absolutely no idea what the analytics API looks like.
The bad version:
- Log into Linkly, open the link's analytics dashboard, screenshot the country breakdown chart
- Go back, find the platform breakdown chart, screenshot that too
- Open a new tab in the sheet, manually type in the country names and click counts from memory, realize you misread "Germany" as 847 when it was 748
- Do the same for desktop/mobile/tablet — spending 40 minutes recreating data that Linkly already has in exact form
The growth report goes to the head of product. Eyeballed numbers transcribed from a screenshot are not going to hold up when someone asks a follow-up question.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data you have, calls Linkly's analytics API, and writes the breakdown into whatever columns you specify — no dashboard screenshotting required.
Get click analytics for Linkly link ID abc123 broken down by country and write the country name and click count into columns A and B starting at row 2
What You Get
- Column A fills with country names, column B with the click count for each country — one row per country, sorted by click count descending
- Platform breakdown (desktop / mobile / tablet) follows the same pattern when you ask for it
- Numbers come directly from the Linkly API — no manual transcription, no approximation
- If a country returned zero clicks, it's excluded from the output unless you ask for it to be included
What If the Data Is Not Quite Ready
You need both country and platform in one sheet
The stakeholder slide needs two tables: one for country, one for platform, on the same sheet.
Get click analytics for Linkly link ID abc123 broken down by country and write country and click count into columns A and B; then get the platform breakdown and write platform and click count into columns D and E — both tables start at row 2
You need breakdowns for a list of link IDs, not just one
Column A of this sheet has 12 link IDs. The report needs the top country for each.
For each Linkly link ID in column A, get the top country by click count and write the link ID, top country, and click count into columns C, D, and E
The breakdown should only cover the last 30 days
The product launch was 90 days ago but the slide only covers the most recent month's performance.
Get click analytics for Linkly link ID abc123 broken down by country for the last 30 days and write country name and click count into columns A and B starting at row 2
Pull country breakdown, platform breakdown, filter to the date range, and sort by impact — in one prompt
Get click analytics for Linkly link ID abc123 for the last 30 days, write country and click count into columns A and B sorted by click count descending, then write platform and click count into columns D and E sorted by click count descending — both tables start at row 2
One prompt, two tables, ready for the slide.
Try It
Open a sheet with your Linkly link IDs, then Get the 7-day free trial of SheetXAI and ask it to pull the country or platform breakdown. For time-series trends instead of aggregate totals, see pulling daily click data for trend charts. And for the full picture of what's possible, the hub overview covers all Linkly + Google Sheets workflows.