The Scenario
It's Tuesday morning and you have a social media scheduling upload due at noon. The sheet in front of you has 150 rows — column A is UTM-tagged campaign URLs, column B is supposed to hold TinyURL short links for the scheduling tool's character limit. Column B is empty. Every cell of it.
You were supposed to get these from the campaign manager last week. They sent you the long URLs instead.
The bad version:
- Open TinyURL in one browser tab, your sheet in another, paste URL from row 2, copy the short link, switch tabs, paste into B2, move to row 3.
- Realize around row 20 that you pasted B18's result into B19 because you scrolled and lost your place.
- Start the column over from row 18, now 25 minutes into a 45-minute job with 130 rows still waiting.
Your afternoon report is sitting untouched while you do this. The scheduling upload won't wait.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the data, understands your column layout, and uses its TinyURL integration to shorten every URL and write the results back — in one operation. No row-by-row clicking.
For every URL in column A of my "Social Links" tab, create a TinyURL short link and write it into column B. Skip any rows where column B already has a value.
What You Get
- Column B fills with short TinyURL links, one per row, aligned to the corresponding URL in column A.
- Rows where column B already contained a value are left untouched.
- Any URL that TinyURL rejects (malformed, already expired) gets flagged in a note in the adjacent column so you can see exactly which rows need attention.
- The operation runs across all 150 rows in one shot — no pagination, no stopping at row 100.
What If the Data Is Not Quite Ready
Some URLs in column A have trailing spaces or line breaks from a paste
For every URL in column A of my "Social Links" tab, trim whitespace from each URL before creating the TinyURL short link, then write the result into column B
The URL column has mixed content — some cells have full URLs, others have placeholder text like "TBD"
For every row in my "Social Links" tab where column A starts with "http", create a TinyURL short link and write it into column B. Leave rows where column A does not start with "http" blank.
The URLs are split across three tabs — "Facebook", "Instagram", "LinkedIn" — and I need short links on all of them
On each of the tabs "Facebook", "Instagram", and "LinkedIn", shorten every URL in column A using TinyURL and write the result into column B
The URLs need shortening, each one should be tagged with the platform name from column C, and any row missing a URL should be flagged in column D
For every row in my "Social Links" tab where column A is not empty, create a TinyURL short link tagged with the value in column C and write the short link into column B. For rows where column A is empty, write "missing URL" into column D.
The pattern: cleanup and action in a single instruction — no pre-processing step required before you run the shorten operation.
Try It
Get the 7-day free trial of SheetXAI and open your campaign URL sheet, then ask it to shorten the entire column and tag each link by platform. Also worth reading: create branded short links with custom aliases and the TinyURL integration overview.