The Scenario
You're a content marketing manager at a SaaS company. The product launch is in four days and you've got 400 blog post URLs staged in a Google Sheet — column A is the long URL, columns B through D are UTM source, UTM medium, and UTM campaign, and column E holds the tag you want applied to each link. The performance team needs branded short links using the company's custom domain before anything goes live.
The bad version:
- Open Short.io, create each link manually by pasting the URL, selecting the domain, filling in UTM fields individually, and adding the tag — then copy the short URL back into the sheet for that row
- Repeat 400 times across a two-hour block, watching your tab-count climb as you lose your place in the sheet
- Discover at row 300 that you've been entering the UTM medium wrong because you misread the column header and now have to audit every link you already created
Nobody hired you to process link requests. You were supposed to spend this week writing the launch copy, and instead you've spent it doing data entry that a spreadsheet formula couldn't even automate properly.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your columns, connects to Short.io, and creates every link in one operation — writing the results back into the sheet without you touching the dashboard at all.
Bulk-create Short.io short links for every row in this sheet using the URL in column A, UTM parameters in columns B through D, and tags in column E — write the resulting short URL back into column F
What You Get
- Column F fills with branded short links using your custom domain, one per row
- UTM parameters from columns B, C, and D are applied to each link during creation
- Tags from column E are attached to each Short.io link
- Any row that fails (duplicate path, invalid URL format) surfaces an error note in column G so you can fix and re-run that row specifically
What If the Data Is Not Quite Ready
The UTM columns have inconsistent capitalization
Different people added rows over the past week. Some UTM values are lowercase, some mixed-case, and Short.io will treat them as distinct values in analytics.
Before creating links, normalize columns B, C, and D to lowercase throughout the sheet, then bulk-create Short.io short links for every row using column A as the URL, the cleaned UTM values from B through D, and tags from column E — write results into column F
Some rows in column A are missing the https:// prefix
The sheet was populated by a non-technical teammate who pasted bare domain names without the protocol.
For any URL in column A that does not start with https://, prepend https:// before creating the Short.io link — then run the bulk creation using UTM parameters from columns B through D and tags from column E, writing short URLs into column F
The tags in column E use different formats across rows
Some rows have a single tag, some have comma-separated lists, and Short.io expects an array.
Parse the tag field in column E — treating comma-separated values as multiple distinct tags — then bulk-create Short.io short links for each row in the sheet using the URL from column A, UTM parameters from columns B through D, and the parsed tag array from column E, writing results into column F
Full cleanup plus creation in one shot
Normalize all URLs in column A to include https://, lowercase all UTM values in columns B through D, split comma-separated tags in column E into arrays, then bulk-create Short.io short links for every row and write the resulting short URL into column F — flag any rows that fail with an error note in column G
The pattern: you can describe cleanup and the link creation in the same prompt instead of running two separate operations.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of long URLs ready for shortening — then ask it to create the whole batch at once. Also see how to pull click stats back into the same sheet, or enrich existing link IDs with full Short.io metadata.