The Scenario
You are a marketing operations analyst. The campaign segmentation sprint starts next week. Before the team can agree on a tagging strategy for the next quarter's WhatsApp campaigns, everyone needs to see what tags already exist in Spoki — all the IDs, names, and colors.
Nobody knows how many tags there are. Someone added a dozen last quarter without telling anyone. The team has been tagging contacts with three different versions of "VIP" for six months.
The bad version:
- Log into Spoki
- Open the tags section
- Manually read each tag name, ID, and color
- Copy them into a Google Sheet one by one
- Realize you missed some because the list was paginated
- Go back and find the ones you missed
- Try to spot the duplicates by eye
- Go into the sprint with an incomplete tag list and spend the first hour of the meeting 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 sheet, sorted and ready for the taxonomy discussion.
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 Google Sheet sorted alphabetically by tag_name.
SheetXAI calls Spoki, writes every tag into the sheet, and sorts alphabetically. You can see the three versions of "VIP" sitting next to each other in the list immediately.
What You Get
A complete tag directory in the sheet:
- Column A — tag ID
- Column B — tag name (alphabetically sorted)
- Column C — color
- Column D — order
- Every tag listed — no pagination gaps, no manually missed entries
Alphabetical sort is what surfaces the duplicates. "vip," "VIP," and "Vip Customer" land within three rows of each other. The taxonomy discussion takes fifteen minutes instead of an hour.
What If the Data Is Not Quite Ready
A raw tag export is the starting point. The segmentation sprint needs analysis on top.
When you want to flag duplicate or near-duplicate tag names automatically
The team suspects there are duplicate tags. Flag them before the meeting.
List all Spoki tags and write tag_id, tag_name, and color into columns A through C sorted alphabetically by tag_name. In column D, flag any tag_name that shares its first four characters with another tag_name as "POSSIBLE DUPLICATE."
When you want to see a count of how many tags exist per color
The team uses colors to indicate tag categories (red for opt-out risk, green for high-value). Knowing the color breakdown helps assess the taxonomy.
List all Spoki tags and write tag_id, tag_name, and color into columns A through C. In a summary section starting at row 50, count how many tags use each color and write color and count side by side.
When the team wants the tags sorted by order field, not alphabetically
The Spoki UI sorts by order, and the team wants to see the same sequence.
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 a count of contacts using each tag
Before deciding which tags to retire, the team wants to know which ones are actually in use.
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 in Spoki have that tag applied and write the count into column C. Sort by contact_count descending so the most-used tags appear at the top.
The pattern: pull the tag directory, add the analysis the sprint actually 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 sheet. The Spoki integration is included in every plan. For related workflows, see how to export Spoki custom field definitions into a sheet or the Spoki in Google Sheets overview.