The Scenario
It's Monday morning and you're launching a 50-ad campaign on Thursday. The brief is finalized: destination URLs, UTM parameters, and custom slugs for every ad are sitting in columns A through D of a Google Sheet. What isn't there yet — what the media buyer needs by end of day tomorrow — is column E: the actual Linkly tracking links.
The bad version:
- Open Linkly, click "Create Link," paste the first destination URL, type in the UTM fields one by one, set the custom slug, save, copy the short URL
- Switch back to the sheet, find row 2, paste the short URL into column E
- Repeat 49 more times, re-checking each row to make sure you didn't transpose a UTM medium or skip a slug
You hired someone to run campaign operations, not to spend two hours building links by hand while the creative team waits on assets that depend on those URLs being live.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data, understands the structure, and talks to Linkly for you — creating every link from your existing columns and writing the results back, all from a single prompt.
Create a Linkly tracking link for each row in this sheet using the URL in column A, UTM source in column B, UTM medium in column C, and UTM campaign in column D, then write the short link into column E
What You Get
- Column E fills with the Linkly short URL for every row — in order, one per row
- UTM parameters are applied exactly as written in columns B, C, and D; no reformatting
- Custom slugs in column C are used where present; Linkly generates a slug for rows where it's blank
- Any row that returns an API error gets a note in column E (e.g., "Error: slug already taken") so you know exactly which ones need attention
What If the Data Is Not Quite Ready
The UTM campaign values have inconsistent capitalization
Campaign naming conventions fall apart when three people contribute to the brief. Column D might have "spring_sale," "Spring_Sale," and "SPRING_SALE" all pointing at the same campaign.
Before creating the Linkly links, normalize all values in column D to lowercase with underscores replacing spaces, then create a tracking link for each row using columns A through D and write the short URL into column E
Some rows are missing a destination URL
Not every row in the brief is ready. Column A is blank for ten rows because those creative assets haven't been approved yet.
Create Linkly tracking links only for rows where column A is not empty, using the UTM source in column B, UTM medium in column C, and UTM campaign in column D, and write the short URL into column E — skip blank rows
The slugs come from a separate reference sheet
Custom slugs were finalized in a "Slug Registry" tab, matched to creative IDs in column F of the main sheet.
For each row in the Campaign sheet, look up the custom slug from the Slug Registry tab using the creative ID in column F, then create a Linkly tracking link using the URL in column A, UTM fields in columns B through D, and the matched slug, and write the short URL into column E
The brief, the normalization, and the link creation are all one job
Normalize column D values to lowercase underscores, skip rows where column A is blank or column F is missing, look up the custom slug from the Slug Registry tab using column F, create a Linkly tracking link for each remaining row with the URL in column A, UTMs in columns B through D, and the matched slug, and write the short URL into column E — flag any API errors in column G
Cleanup and creation in one ask. The sheet is ready for the media buyer before you'd have finished the first ten rows manually.
Try It
Open your campaign brief sheet with destination URLs and UTM columns, then Get the 7-day free trial of SheetXAI and ask it to bulk-create the Linkly tracking links. When you're done, take a look at how the same setup handles pulling click analytics by country or exporting your full link inventory.