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 a spreadsheet 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 CSV 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 Google Sheet. It calls Dub's link list endpoint — handling pagination for you — and writes every link's details into the sheet row by row.
Open a blank Google Sheet (or an "Inventory" tab), open SheetXAI in the sidebar, and type:
List all links in my Dub workspace and write each link's short key, destination URL, tags, and click count into my Google Sheet starting at row 2. Add column headers in row 1.
What You Get
- Row 1 gets column headers: Short Key, Destination URL, Tags, Click Count.
- 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 sheet records the total link count and the timestamp of the export.
What If the Data Is Not Quite Ready
I need the domain column included too, because the workspace uses multiple branded domains
List all links in my Dub workspace and write each link's domain, short key, destination URL, tags, and click count into my "Inventory" tab starting at row 2. Add headers in row 1. Group the results by domain.
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 short key, destination URL, tag list, and click count into the "Inventory" tab starting at row 2. Write the total count of filtered links at the top of the sheet in cell A1.
I want the creation date included so the client can see how old each link is
List all links in my Dub workspace and write short key, destination URL, tags, click count, and creation date into my "Inventory" tab. Sort the results by creation date ascending so the oldest links appear first.
Pull all links, add a "last active" estimate based on click count, flag links with zero clicks, and format for handoff
Fetch all links from my Dub workspace. For each link, write short key, destination URL, tags, click count, and creation date to the "Inventory" tab. In a "Status" column, write "no clicks" for any link with a click count of zero, and "active" for the rest. Sort by click count descending.
The pull, the flag logic, and the sort happen in one pass — the handoff sheet is ready to send without reformatting.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, 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 + Google Sheets guide.