The Scenario
You're a brand manager preparing for a product launch. You need to create 10 campaign folders in Short.io — one per campaign theme — and then create 30 short links per folder from URLs your team has been collecting for the past week. All of it is already in a Google Sheet: column A has the campaign folder name (repeated for each row in that folder's batch), column B has the long URL to shorten.
The bad version:
- Create each folder in the Short.io dashboard manually: navigate to Folders, create folder "Campaign 1", create folder "Campaign 2", and so on for all 10
- Then go to link creation, create each short link, and assign it to the right folder from the dropdown — 300 times
- On link 130, realize you've been assigning links to "Campaign 3" instead of "Campaign 4" because the dropdown options look similar and you clicked the wrong one
Setting up 300 organized links by hand isn't a launch task. It's data entry that delays every other part of launch week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your campaign names and URLs, creates the folders in Short.io, then creates and assigns each link to its folder — all in one pass.
For each unique campaign name in column A of my sheet, create a Short.io folder, then create a short link for the URL in column B and assign each link to its corresponding 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 with the row number, so you can rerun specific rows without touching the ones that succeeded
What If the Data Is Not Quite Ready
Some folder names in column A have inconsistent capitalization across rows
"Summer Launch" appears in some rows as "summer launch" and in others as "Summer Launch" — Short.io will treat these as different folders.
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, and assign it to the correct folder — write the resulting short URL into column C
You also need to apply a tag to all links within each folder
All links in the "Summer Launch" folder should carry the tag "summer-2026".
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, assign it to the folder from column A, apply the tag from column C as a Short.io tag, and write the resulting short URL into column D
Some URLs in column B are duplicates — same URL, different folder
You want to create separate short links for the same destination across different campaigns (different UTM values implied by folder), not reuse a single link.
Create Short.io short links for every row in the sheet, even if the URL in column B repeats across rows — assign each link to the folder from column A and write the resulting short URL into column C — do not deduplicate by URL
Full folder creation plus tagging plus UTM 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, assign it to the folder from column A, apply UTM source from column C, UTM campaign from column D, and tag from column E — write the resulting short URL into column F and any errors into column G
One prompt, the full campaign link structure live in Short.io before lunch.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you have a structured list of campaign names and URLs ready — then ask it to build the folder hierarchy and link inventory in Short.io. Also see how to bulk-tag links across folders after creation, or pull click stats per folder to compare campaign performance.