The Scenario
The new head of marketing ops started three weeks ago. One of her first asks: a full accounting of every short link the company has ever created in Lob — destination URLs, creation dates, which campaign each one was associated with, and a flag on anything pointing to a page that no longer exists.
The Lob dashboard shows links, but it paginates at 25 per page. There are somewhere around 200. She's not going to click through eight pages, manually copy, and paste into a sheet. Neither are you.
You inherited this account from someone who left in January. You don't know what half these links point to or which ones are still active. The audit is supposed to help answer that — but you can't audit what you can't see all at once.
The bad version:
- Export whatever Lob makes available (the export format may or may not match what you need)
- Open the file, realize the column headers don't match your company's campaign tracking sheet structure
- Spend an hour reformatting, then realize the export didn't include campaign metadata
Nobody hired you to wrangle exports. You're supposed to be telling the CMO which links are due for deprecation, not figuring out why the API response has a field called "metadata" that sometimes contains a campaign name and sometimes doesn't.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, pulls your full Lob short link inventory through the API including all paginated results, and writes the complete list into your sheet — every row, properly labeled.
List all short links from my Lob account and write each link's ID, short URL, destination URL, and creation date into this sheet sorted by creation date descending.
What You Get
- One row per short link across the entire account, not just the first 25
- Columns for link ID, short URL, destination URL, and creation date
- Results sorted by creation date descending so the most recent links appear first
- Any links with missing metadata fields written with blanks rather than dropped from the output
What If the Data Is Not Quite Ready
I need campaign metadata pulled from a separate column and matched to each link
List all Lob short links and write the link ID, short URL, destination URL, and creation date into columns A through D. Then look up each link ID against the 'Campaign Tags' tab where column A is link ID and column B is campaign name, and write the matched campaign name into column E. Leave column E blank for links not found in the lookup.
I want to flag links older than 180 days
Pull all Lob short links and write link ID, short URL, destination URL, and creation date into columns A through D. In column E, write 'Stale' for any link with a creation date more than 180 days ago, and 'Active' for everything else.
I only want links that belong to specific campaigns listed in my sheet
Pull all Lob short links associated with each campaign ID in column A and write the short URL, destination URL, and creation date into columns B, C, and D for each matching row.
I need a summary count by month alongside the full inventory
List all Lob short links and write the full inventory into this sheet starting at row 2. Then in a separate tab called 'Monthly Summary', write one row per calendar month showing the month, the count of links created that month, and the count of unique destination domains.
The full inventory and the aggregation in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your complete Lob short link inventory sorted by creation date. From there, check out the spoke on bulk-updating Lob short link destinations and the full Lob integration overview.