The Scenario
You are a CRM analyst. The quarterly segmentation review is next Tuesday. Before the team can agree on which contact lists to consolidate, archive, or expand, everyone needs to see what exists in Spoki — all 25 contact lists, with their names, IDs, and how many contacts are in each one.
The lists are all in Spoki. None of this data is in a spreadsheet. The segmentation meeting starts at 2 PM Tuesday and the sheet needs to be shared by 9 AM so people can prepare.
The bad version:
- Log into Spoki
- Open the contact lists view
- Click through each list to see the contact count
- Copy list name, ID, and count into a sheet by hand
- Do this 25 times
- Sort by contact count
- Realize list 14 shows a count of 0 and you are not sure if it is empty or just not loading
- Check it again
- Spend 90 minutes on a task that should take two minutes. Still not sure about list 14.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads Spoki's contact lists and writes everything into the sheet, sorted and ready, without you clicking through the Spoki UI.
Open the SheetXAI sidebar and type:
List all contact lists in Spoki and write list_id, list_name, and contact_count into columns A, B, and C of this Google Sheet sorted by contact_count descending.
SheetXAI calls Spoki, writes all 25 lists, and sorts them largest-first. You have the segmentation audit input before you close your laptop.
What You Get
A complete contact list directory in the sheet:
- Column A — list ID
- Column B — list name
- Column C — contact count, sorted descending
- One row per list — all 25, no clicking through the Spoki UI
Sorting by contact count is the part the Spoki UI makes you do manually. With the sheet sorted descending, the team can immediately see which lists are the biggest, which are near-empty, and which might be duplicates.
What If the Data Is Not Quite Ready
A raw list export is the starting point. The real segmentation work is the analysis on top. SheetXAI handles both.
When the team wants to flag lists below a minimum size threshold
Lists with fewer than 50 contacts are candidates for archival. Flag them automatically.
List all Spoki contact lists and write list_id, list_name, and contact_count into columns A through C sorted by contact_count descending. In column D, flag any list with fewer than 50 contacts with "REVIEW FOR ARCHIVAL."
When the team wants to know which lists have overlapping names
Some lists were created in two different campaigns under similar names and might be duplicates.
List all Spoki contact lists and write list_id, list_name, and contact_count into columns A through C. In column D, flag any list_name that shares its first three words with another list_name as "POSSIBLE DUPLICATE."
When you need a breakdown of total contacts across all lists
The director wants to know the total addressable reach across all Spoki lists before approving next quarter's budget.
List all Spoki contact lists and write list_name and contact_count into columns A and B. At the bottom, add a SUM row in column B showing the total contact count across all lists. Also write the number of lists with zero contacts into cell D1.
When you need to pair the list directory with a recent campaign to see which lists are active
Before deciding which lists to archive, the team wants to know which ones have actually had a campaign sent to them in the last 90 days.
List all Spoki contact lists and write list_id, list_name, and contact_count into columns A through C. Then list all campaigns from the last 90 days and write their list_ids into column D of the row that matches — so each list row shows whether it had a recent send. Flag any list with no recent campaign in column E as "INACTIVE."
The pattern: pull the directory, layer on the analysis the meeting actually needs, all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to export your Spoki contact list directory into any open sheet. The Spoki integration is included in every plan. For related workflows, see how to add contacts to a Spoki list from a sheet or the Spoki in Google Sheets overview.