The Scenario
Someone handed you a sheet before they left the company. It has 80 rows in column A — all U301 link IDs from campaigns that ran over the past two years. The campaigns are dead. The links are still live in U301, cluttering the account. Your job is to delete them and mark each row in column B so there's a clean audit record of what happened.
The bad version:
- Open U301, go to the link management view, search for the first ID in column A, find it in the list, click delete, confirm the dialog.
- Return to the sheet, copy the next ID, go back to U301, search again — because U301's search doesn't persist between operations.
- Hit a link that doesn't exist anymore — it was already deleted by someone else, or the ID was mistyped in the sheet — and now you're not sure whether to mark it "deleted" or "not found" or leave it blank and come back to it.
This is 80 rows of modal-confirm fatigue, and whoever left this sheet for you didn't exactly leave a guide. The account owner wants it done before the end of the week so the domain usage report is clean for the quarterly review.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data you're working with and handles the U301 API calls directly — deletions, confirmations, writebacks — without you touching the dashboard.
Open the SheetXAI sidebar and paste this prompt:
Delete all U301 short links whose IDs are listed in column A of my sheet — process all rows at once and write "deleted" in column B for each successful removal. If a link ID doesn't exist or returns an error, write "not found" or the specific error in column B instead.
What You Get
- Column B fills with a status for every row in column A — either "deleted" or a specific error message.
- Links that were already gone from U301 are flagged as "not found" rather than silently skipping.
- The entire batch runs in one pass — no 80 individual delete-and-confirm cycles.
- You have a complete audit record in column B that you can filter or export for the quarterly review.
What If the Data Is Not Quite Ready
The IDs have whitespace or formatting inconsistencies
Delete the U301 link IDs in column A. Before processing, trim any leading or trailing whitespace from each ID. Write "deleted," "not found," or the error message in column B for each row.
Some rows are already marked and shouldn't be reprocessed
Delete the U301 link IDs in column A, but skip any row where column B already has a value. Write "deleted" or the error in column B only for rows that were blank before this run.
The IDs are spread across two tabs that need to be merged into one operation
Look at the "Q3 Expired" tab and the "Q4 Expired" tab. Collect all the link IDs from column A on each tab, delete them from U301, and write the result back into column B on the same tab each ID came from.
Validate, clean up bad IDs, delete the valid ones, and summarize
Check all the IDs in column A. Flag any that don't look like valid U301 link ID formats in column B (write "invalid format"). For the rest, attempt deletion and write "deleted" or the error. At the end, add a summary row at the bottom of column A showing how many were deleted, how many were invalid, and how many returned errors.
One prompt can handle the validation, the cleanup, and the deletions — there's no reason to run those as separate passes.
Try It
Get the 7-day free trial of SheetXAI and open your link audit sheet with a column of U301 IDs, then ask it to delete and mark each one. For the companion task — bulk-shortening new URLs — see the bulk URL shortening spoke. Or go back to the U301 overview for a full picture of what's possible.