The Scenario
Your marketing team is two days out from a campaign launch. The campaign manager just dropped a Google Sheet in the shared drive — a canonical list of 40 tag names, the official taxonomy that every link created for the next six months needs to follow. Client names, channel names, campaign stage labels.
Before any links get created, these tags need to exist in your Dub workspace. Otherwise whoever creates the first link will start inventing tag names freehand and the taxonomy falls apart by day three.
The bad version:
- Open Dub, go to Tags, click "Create tag," type the first name, pick a color, save.
- Repeat 39 more times.
- Notice halfway through that three of the tags you created are missing from the sheet because you lost your place and skipped rows.
- Go back and add the missing ones, then cross-reference the sheet again to make sure nothing is still absent.
The campaign goes live in 48 hours. This is not what you should be doing with them.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your taxonomy list and creates all the tags in Dub in one operation, writing the returned tag IDs back to the sheet for your records.
Open your "Tag Taxonomy" sheet, open SheetXAI in the sidebar, and type:
Create a Dub tag for every name listed in column A of my "Tag Taxonomy" tab and write the returned tag ID back to column B.
What You Get
- Dub creates a tag for each name in column A.
- The returned tag ID from Dub lands in column B on the same row.
- Any tag name that already exists in the workspace is noted in column C as "already exists — tag ID: [id]" rather than creating a duplicate.
- Rows where column A is blank are skipped without error.
What If the Data Is Not Quite Ready
Column A has tag names with inconsistent casing — some are title case, some all lowercase, some mixed
Before creating Dub tags, normalize all values in column A of "Tag Taxonomy" to lowercase with hyphens replacing spaces. Then create a Dub tag for each normalized name and write the tag ID to column B. Write the normalized name to column C so I can see what was actually sent.
I also have hex color codes in column B and I want each tag to use the specified color
Create a Dub tag for every name in column A of "Tag Taxonomy," using the hex color code from column B as the tag color. Write the returned tag ID to column C. Where column B is blank, use the default Dub color.
Some tag names in column A might already exist in my workspace — check before creating and skip duplicates
Before creating any tags, fetch the existing tag list from my Dub workspace. For each name in column A of "Tag Taxonomy," check whether a tag with that name already exists. If it does, write its existing ID to column B and "already exists" to column C. If it doesn't, create it, write the new ID to column B, and write "created" to column C.
Check for duplicates within the sheet itself, normalize names, skip existing workspace tags, and create the new ones in one shot
In the "Tag Taxonomy" tab, first identify any duplicate values in column A and mark them in column D. Then normalize the remaining names to lowercase with hyphens. Fetch existing Dub tags, skip any names that already exist in the workspace, and create the rest. Write tag IDs to column B and the status to column C.
The dedup, normalization, existence check, and creation happen in sequence — you get a clean record of what was created versus what was already there.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a tag taxonomy or naming list, then ask it to seed your Dub workspace in one pass. Once the tags exist, you can use SheetXAI to bulk-create short links with those tags applied, or explore the full Dub + Google Sheets guide.