The Scenario
You're a brand manager and your agency just handed off a campaign brief with 10 campaign themes and 30 links per theme — 300 links total, all organized in an Excel workbook. Column A has the campaign folder name (repeated for each link in that theme), column B has the long URL to shorten. Everything is ready. The problem is that Short.io's dashboard doesn't have a bulk "create folder + create link + assign" workflow. You have to do each step separately.
The bad version:
- Create each of the 10 campaign folders manually in Short.io's Folders interface
- Then go to link creation, create each short link, select the correct folder from the dropdown, save
- Repeat 300 times, relying on your memory to associate each row's folder dropdown selection with the correct campaign theme
- Discover at link 150 that you've been assigning "Theme 6" links to the "Theme 7" folder for the last 20 rows because the folder names are similar and you clicked the wrong dropdown item without noticing
The agency expects the campaign to be live in Short.io before their client call Friday. It's Wednesday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the campaign names and URLs, creates the folders, generates the links, and assigns each one to the correct folder — all in one pass.
Read my Excel table where column A is folder name and column B is long URL — create the Short.io folders, then create each short link and associate it with its folder
What You Get
- All 10 campaign folders created in Short.io
- All 300 short links created and assigned to the correct folder based on the campaign name in column A
- Column C fills with each resulting short URL
- Any link creation failure surfaces an error note in column D so you can rerun specific rows without touching the ones that succeeded
What If the Data Is Not Quite Ready
Folder names in column A have inconsistent capitalization across rows
The agency's brief used "Summer Launch" in some rows and "summer launch" in others — Short.io will create two separate folders if you don't normalize.
Normalize all values in column A to title case before creating folders — then create each unique folder in Short.io, create the short link from column B for each row, assign it to the correct folder, and write the resulting short URL into column C
You need to apply campaign-specific UTM parameters during link creation
The agency's tracking setup requires UTM source from column C, UTM medium from column D, and UTM campaign derived from the folder name in column A.
For each unique campaign folder name in column A, create the Short.io folder — then for each row, create the short link from column B with UTM source from column C, UTM medium from column D, and UTM campaign matching the folder name from column A — assign each link to its folder and write the short URL into column E
Some URLs in column B repeat across different campaign folders
The same landing page appears in multiple campaign themes with different UTM strings implied by folder assignment — you want separate links, not deduplication.
Create Short.io short links for every row in the workbook, even if the URL in column B repeats across rows — assign each link to the folder from column A and write the short URL into column C
Full folder creation plus UTM tagging plus assignment in one shot
Normalize folder names in column A to title case, create each unique Short.io folder, then for each row create a short link from column B with UTM source from column C, UTM campaign derived from the folder name in column A, apply any tag from column D, assign the link to its folder, and write the resulting short URL into column E — flag errors into column F
The agency campaign is live in Short.io before Friday's client call.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you have a structured list of campaign names and long URLs — then ask it to build the Short.io folder structure and link inventory at once. Also see how to bulk-tag links across folders after creation, or pull click stats per folder to compare campaign performance.