The Scenario
Your quarterly marketing review is in two days and the performance lead just messaged asking for a breakdown of every Linkly link created in the last 90 days — short URL, destination, click count, creation date — all in one workbook so she can pivot it herself. You know Linkly has this data. You've never tried to get all 200 links out at once.
The bad version:
- Log into Linkly, find the export option, download a CSV with columns that don't match the workbook template the performance lead sent you
- Open the CSV in a separate worksheet, manually reorder and rename columns to match the expected format
- Paste the cleaned data into the master workbook, discover that Linkly's CSV uses a different date format than the workbook, and spend 20 minutes reformatting column D
Two hundred rows of data that already exist in a system you have access to shouldn't require an afternoon of reformatting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Linkly, pulls every link and its stats, and writes the data into your workbook in whatever shape you specify — without any CSV export or column shuffling.
Export all Linkly links from my workspace and write the short URL, destination URL, click count, and creation date into this workbook starting at row 2
What You Get
- Rows 2 onward fill with one Linkly link per row: short URL in column A, destination in column B, total click count in column C, creation date in column D
- Dates are written in a consistent format (YYYY-MM-DD) so the performance lead can sort and filter immediately
- If the workspace has links across multiple campaigns, all of them are included — nothing is paginated away
- Any link that returns a missing field gets a blank cell and a note in column E rather than causing the entire export to fail
What If the Data Is Not Quite Ready
You only want links created in the last 90 days
The workspace has hundreds of links going back three years. The review only covers Q1.
Export all Linkly links created after 2024-01-01 and write the short URL, destination URL, click count, and creation date into this workbook starting at row 2
The performance lead also wants the UTM parameters
The template she sent includes columns for UTM source, medium, and campaign alongside the basics.
Export all Linkly links from my workspace and for each one write the short URL, destination URL, UTM source, UTM medium, UTM campaign, click count, and creation date into columns A through G starting at row 2
You need to join the Linkly export against campaign names in another worksheet
The "Campaigns" worksheet maps destination URL patterns to campaign names. The performance lead wants campaign name as column A in the final output.
Export all Linkly links from my workspace and for each link, look up the campaign name from the Campaigns worksheet by matching the destination URL, then write campaign name, short URL, click count, and creation date into columns A through D starting at row 2
Pull, join, deduplicate, and sort — all in one shot
Export all Linkly links created after 2024-01-01, join each link's destination URL against the Campaigns worksheet to get the campaign name, remove any duplicate short URLs, sort by click count descending, and write campaign name, short URL, destination URL, UTM source, UTM medium, click count, and creation date into columns A through G starting at row 2 — flag rows with missing campaign matches in column H
The result lands in the shape the performance lead specified, ready for her pivot table.
Try It
Open the workbook where you want your Linkly inventory to land, then Get the 7-day free trial of SheetXAI and ask it to pull your full link export. Also worth reading: how to pull click analytics by country or device and the hub overview for all Linkly + Excel workflows.