The Scenario
It's end of quarter and you've just inherited the digital marketing audit from a colleague who left the agency last month. Part of what they left behind: a L2S account with somewhere north of 300 short links accumulated over 18 months of campaigns, no documentation, and a quarterly review with the client on Friday. The client wants to know what's still active, what's pointing at the same destination, and what hasn't been clicked since it was created.
The bad version:
- Log into L2S, page through the dashboard, start recording link details in a new spreadsheet by hand — link_id, destination, creation date, click count, row by row
- Reach link 80 and realise you haven't been checking for duplicates at all — now you have to cross-reference everything you've entered against itself
- Try to export as CSV, discover the export doesn't include click count in the format you need, go back to the dashboard to get those numbers separately
There's no version of this that doesn't take most of a day. The client review is Friday and you have three other accounts to service before then.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It connects to your L2S account, pulls the full link inventory, writes it into a sheet, and runs your audit logic — all from a single prompt.
Open the SheetXAI sidebar and paste this:
List all shortened URLs from my L2S account and write them to an 'L2S Inventory' sheet with columns: link_id, short_url, destination_url, created_date, click_count
What You Get
- A fully populated 'L2S Inventory' sheet with one row per short link across your account
- Columns populated exactly as specified: link_id, short_url, destination_url, created_date, click_count
- No pagination to manage — SheetXAI handles multi-page L2S responses and consolidates them into the sheet
- A clean base for the next prompt: flag duplicates, filter by click count, sort by date
What If the Data Is Not Quite Ready
You need duplicate destination URLs flagged before the review
In the 'L2S Inventory' sheet, find all rows where destination_url appears more than once and write 'Duplicate' in column F — then find all rows where click_count is 0 and write 'Unused' in column F — sort by click_count ascending
You need to isolate links created within a specific campaign window
In 'L2S Inventory', filter to only rows where created_date falls between 2025-10-01 and 2025-12-31, write the results to a new 'Q4 Links' sheet, and include a count of total links in cell A1
You need to check whether any short links are pointing at domains that no longer exist
For each row in 'L2S Inventory' where click_count is greater than 100, write the destination_url to column G of a new 'High-Traffic Links' sheet — flag any destination_url that contains a domain not found in the 'Approved Domains' tab as 'Review' in column H
Full inventory audit and executive summary in one pass
Pull all L2S short links into an 'L2S Inventory' sheet, flag duplicates in column F, flag zero-click links as 'Unused', then create a 'Summary' sheet with: total link count, count of duplicates, count of unused links, and the top 10 links by click_count with their destination URLs
One prompt delivers the raw data, the audit logic, and the executive summary your client is expecting on Friday.
Try It
Open a blank Google Sheet, get the 7-day free trial of SheetXAI, and ask it to pull your full L2S inventory — you'll have a sortable, audit-ready table before your next coffee. For related workflows, see how to bulk shorten URLs from a sheet or return to the L2S hub overview.