The Scenario
You're an events coordinator and you're managing 20 different events happening over the next three months — workshops, webinars, networking dinners. Each has its own registration page, and each registration closes on a different date. The rule is clear: once an event closes, its registration link should stop working.
Someone hands you a sheet: column A has the registration URLs, column B has the event names, column C has the expiration dates. Your job is to get a short link for each event into column D before the invitations go out tomorrow.
The bad version:
- Open TinyURL, navigate to the create form, paste the URL from row 2, type the event alias, switch to the expiration field, figure out the date format TinyURL wants, type it, click create, copy the result, go back to the sheet, paste into column D, row 3.
- Realize after six rows that TinyURL's date picker format is MM/DD/YYYY and your sheet has YYYY-MM-DD, so you've been entering wrong dates.
- Go back to the first six rows, recreate all of them with the correct dates.
You have 20 rows and a deadline. You have exactly enough time to do this once correctly — not once correctly after one time incorrectly.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your data, handles the date formatting differences between your sheet and TinyURL's API, and creates every expiring short link in a single operation.
For each row in my "Event Links" tab, create a TinyURL using the URL in column A, the alias from column B formatted as lowercase-hyphenated, and the expiration date from column C. Write the resulting short link into column D.
What You Get
- Column D fills with TinyURL short links, each configured to expire on the date in column C.
- Date values from column C are normalized automatically — whether they're formatted as YYYY-MM-DD, MM/DD/YYYY, or written out like "June 15, 2026."
- Any row where the expiration date is already in the past gets flagged in column E with "date already passed" so you can catch it before the invitation goes out.
- All 20 links generate in one pass.
What If the Data Is Not Quite Ready
The expiration dates are in column C but some cells are blank — those links should have no expiration set
For each row in my "Event Links" tab, create a TinyURL using the URL in column A. If column C has a date, set it as the expiration. If column C is blank, create the link with no expiration. Write all short links into column D.
I want to tag each link with the event type from column E before creating it
For each row in my "Event Links" tab, create a TinyURL using the URL in column A, alias from column B, expiration date from column C, and tag each link with the event type in column E. Write the short link into column D.
The event data is split across two tabs — "Webinars" and "In-Person" — and I need short links on both
On both the "Webinars" and "In-Person" tabs, create a TinyURL for each row using the URL in column A and the expiration date in column C. Write the short links into column D on each tab.
I need to create all expiring links, tag them, flag any with past expiration dates, and write a summary count of how many links expire each month into a separate "Summary" tab
For each row in my "Event Links" tab, create a TinyURL using the URL in column A, alias in column B, expiration in column C, and tag in column E. Write the short link into column D. Flag rows where column C is a past date in column F. Then write a count of links expiring each calendar month into the "Summary" tab starting at cell A1.
One prompt handles the creation, the tagging, the flagging, and the summary — no separate steps.
Try It
Get the 7-day free trial of SheetXAI and open your event registration sheet, then ask it to generate an expiring TinyURL for every row using your date column. Also see: bulk shorten a URL column and the TinyURL integration overview.