The Scenario
You are a marketing operations analyst. The campaign segmentation sprint starts next week. Before the team can agree on a tagging strategy, everyone needs to see what tags exist in Spoki — all IDs, names, and colors — in a shared Excel workbook.
Nobody knows the full list. Someone added tags last quarter without telling anyone. The team has been using three versions of "VIP" for six months.
The bad version:
- Log into Spoki
- Open the tags section
- Copy each tag name, ID, and color into Excel by hand
- Miss some because the list paginated
- Try to spot duplicates by eye
- Go into the sprint arguing about whether "vip" and "VIP" are the same tag.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads every Spoki tag and writes the complete directory into the workbook.
Open the SheetXAI sidebar and type:
List all tags in Spoki and write tag_id, tag_name, color, and order into columns A through D of this workbook sorted alphabetically by tag_name.
SheetXAI calls Spoki, writes every tag, and sorts alphabetically. The three versions of "VIP" land within three rows of each other.
What You Get
A complete tag directory:
- Column A — tag ID
- Column B — tag name (alphabetically sorted)
- Column C — color
- Column D — order
- Every tag listed — no pagination gaps
Alphabetical sort surfaces the duplicates. The taxonomy discussion takes fifteen minutes instead of an hour.
What If the Data Is Not Quite Ready
When you want to flag near-duplicate tag names automatically
List all Spoki tags and write tag_id, tag_name, and color into columns A through C sorted alphabetically. In column D, flag any tag_name that shares its first four characters with another tag_name as "POSSIBLE DUPLICATE."
When you want a count of tags per color
List all Spoki tags and write tag_id, tag_name, and color into columns A through C. In a summary section at row 50, count how many tags use each color and write color and count side by side.
When the team wants tags sorted by the Spoki order field
List all Spoki tags and write tag_id, tag_name, color, and order into columns A through D sorted by order ascending.
When you want the tag directory paired with contact usage counts
List all Spoki tags and write tag_id and tag_name into columns A and B. Then for each tag, look up how many contacts have that tag applied and write the count into column C. Sort by count descending so the most-used tags appear at the top.
The pattern: pull the directory, add the analysis the sprint needs, all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to export your Spoki tag directory into any open workbook. The Spoki integration is included in every plan. For related workflows, see how to export Spoki custom field definitions into a workbook or the Spoki in Excel overview.