The Scenario
You're an agency account manager and a client's contract ends next Friday. Your final deliverable is a handoff package: a complete inventory of every short link in their Dub workspace — the short key, destination URL, tags, and total click count — formatted in an Excel workbook the client can take with them.
The client's workspace has somewhere north of 400 links. You have never exported from Dub before.
The bad version:
- Look for a bulk export button in the Dub dashboard. Find that there isn't a native full-export option that includes all metadata fields in one shot.
- Start using the API docs to figure out how to paginate through all links and get the fields you need.
- Realize this requires writing a script or chaining API calls manually.
- Consider asking the engineering team for help, knowing they're already at capacity this week.
The client call is Thursday. The handoff package needs to exist by Wednesday morning so there's time to review it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls Dub's link list endpoint — handling pagination for you — and writes every link's details into the workbook row by row.
Open a blank Excel workbook (or a fresh "Inventory" worksheet), open SheetXAI in the sidebar, and type:
Fetch every link in my Dub workspace with their domain, destination URL, tag list, and creation date, and populate my Excel sheet with one link per row. Add column headers in row 1.
What You Get
- Row 1 gets column headers: Domain, Destination URL, Tags, Creation Date.
- Every link in the workspace populates one row starting at row 2, with all four fields filled in.
- Tags appear as a comma-separated list in the Tags column.
- Pagination is handled automatically — all links are fetched even if the workspace has more than the API's default page size.
- A note at the bottom of the worksheet records the total link count and the timestamp of the export.
What If the Data Is Not Quite Ready
I need the click count column included too for the client's performance summary
Fetch every link in my Dub workspace and write domain, destination URL, tag list, creation date, and total click count into my Excel worksheet starting at row 2. Add headers in row 1. Sort by click count descending.
I only want links that have at least one tag applied — untagged links should be excluded
Fetch all links from my Dub workspace. Filter to only links that have at least one tag. Write the domain, destination URL, tag list, and click count into my "Inventory" worksheet starting at row 2. Write the total count of filtered links in cell A1.
I want the short key included so the client can see the full branded URL structure
List all links in my Dub workspace and write domain, short key, destination URL, tags, and click count into my "Inventory" worksheet. Sort by domain alphabetically, then by short key within each domain group.
Pull all links, add a status column for zero-click links, sort by creation date, and format for handoff
Fetch all links from my Dub workspace. For each link, write domain, short key, destination URL, tags, click count, and creation date to the "Inventory" worksheet. In a "Status" column, write "no clicks" for any link with a click count of zero, and "active" for the rest. Sort by creation date ascending.
The pull, the flag logic, and the sort happen in one pass — the handoff workbook is ready to send without reformatting.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to export your entire Dub link inventory in one shot. You can also use it to bulk-delete the expired links you find in the export or browse the full Dub + Excel guide.