The Scenario
You're a digital marketing manager at a SaaS company. Every week, the content team sends you a fresh batch of blog post URLs — this week there are 50. Before the social team can post them and the email team can include them in the newsletter, every URL needs to be shortened through RiteKit with the retargeting CTA attached. The pixel has to follow people who click.
You got the URLs at 3 PM. The social team needs the shortened links by 9 AM tomorrow.
The bad version:
- Open RiteKit's link shortener, paste URL 1, select the CTA from the dropdown, copy the result, switch to Excel, paste it into column B. Fifty rounds. Forty-five minutes minimum if nothing goes wrong.
- Write a Power Automate flow that calls RiteKit's API on each row — spend two hours debugging why the CTA parameter isn't attaching correctly and why 8 of the 50 calls returned a 401.
- Send the long URLs to the social team with a note that the short links are "coming later today," knowing you have three other things due by end of day.
Your job is campaign strategy. The link shortening is plumbing. You shouldn't be spending your evening on it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the campaign URLs in column A and, through its built-in RiteKit integration, calls the link shortener with the CTA parameter and writes the shortened links back to column B.
Shorten all 50 URLs in my Excel "Blog Links" worksheet (column A) using RiteKit with CTA "newsletter-signup" and write the short links to column B.
What You Get
- Column B: A RiteKit-shortened URL for each row, with the specified CTA attached
- Every URL in column A gets processed — 50 links, no manual work
- Rows where column A is blank are skipped automatically
What If the Data Is Not Quite Ready
Each URL needs a different CTA — they're listed in column B, and the shortened link should go to column C
For each URL in column A of the "Blog Links" worksheet, shorten it using RiteKit with the CTA ID from column B and write the shortened link to column C. Skip rows where column A is blank.
Some URLs are UTM-tagged with very long query strings — RiteKit sometimes has issues with those
For each URL in column A, attempt to shorten it using RiteKit with CTA "newsletter-signup" and write the result to column B. If RiteKit returns an error for any row, write "ERROR: [reason]" in column B and flag the row with "RETRY" in column C so the team can handle those manually.
The links are split across two worksheets — "Blog Posts" and "Case Studies" — each with a different CTA
For each URL in column A of the "Blog Posts" worksheet, shorten using RiteKit with CTA "blog-reader" and write the short link to column B. For each URL in column A of the "Case Studies" worksheet, shorten with CTA "case-study-retargeting" and write to column B. After both worksheets are processed, create a new worksheet called "Distribution Links" that combines both sets: source worksheet in column A, original URL in column B, short link in column C.
I want to shorten all 50 URLs, confirm each short link resolves, and flag any that are broken — in one pass
For each URL in column A, shorten using RiteKit with CTA "newsletter-signup" and write the short link to column B. After all 50 are shortened, check each short link in column B to confirm it returns a 200 status when followed. Write "LIVE" or "BROKEN" in column C for each. At the bottom of column D, add a count of how many links are LIVE and how many are BROKEN.
Shorten, verify, and tally — one prompt, ready to hand off.
Try It
Get the 7-day free trial of SheetXAI and open your campaign links Excel workbook, then ask it to bulk-shorten every URL in column A with your specified RiteKit CTA. You might also want to see how to generate quote card images for the social posts that go with those links, or return to the RiteKit + Excel overview.