The Scenario
You are a digital marketing director. The agency quarterly review is this Thursday. The client wants a report covering all 45 WhatsApp campaigns run in Spoki over the past six months — campaign name, status, scheduled date, and which contact list it went to.
The campaigns are all in Spoki. None of them are in a spreadsheet. You have 48 hours.
The bad version:
- Log into Spoki
- Open the campaigns list
- Scroll through 45 entries
- Copy each one into a Google Sheet by hand: name, status, date, list
- Realize dates are in a different timezone than the client expects
- Go back through and fix the dates
- Sort by date
- Spend two and a half hours on a task that should take five minutes
- Still have to rebuild the whole thing next quarter.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads Spoki and writes the data into the sheet, without you touching the Spoki UI or doing any manual copying.
Open the SheetXAI sidebar and type:
List all Spoki campaigns and write campaign_id, campaign_name, status, and scheduled_datetime into columns A through D of this Google Sheet, sorted by scheduled_datetime descending.
SheetXAI calls Spoki's campaigns endpoint, writes every record into the sheet, and sorts them newest-first. All 45 campaigns. Two minutes instead of two and a half hours.
What You Get
A clean campaign log in your Google Sheet, ready for the quarterly review:
- Column A — campaign ID
- Column B — campaign name
- Column C — status (sent, scheduled, draft)
- Column D — scheduled datetime, sorted newest-first
- One row per campaign — no scrolling through the Spoki UI
The value is repeatability. Next quarter, you run the same prompt. You get the next 45. You do not redo the work.
Want to add the message count or open rate per campaign? Ask SheetXAI to pull those fields too. It reads from whatever Spoki's API returns.
What If the Data Is Not Quite Ready
Raw campaign exports often need a layer of analysis on top before they are presentation-ready. SheetXAI handles the pull and the analysis in the same prompt.
When you only want campaigns from the last 90 days
The full list goes back further than the client period.
List all Spoki campaigns scheduled in the last 90 days and write campaign_name, status, list_id, and scheduled_datetime into columns A through D sorted by scheduled_datetime descending.
When the client wants campaigns grouped by status
The quarterly review deck puts sent campaigns first, then scheduled, then drafts.
List all Spoki campaigns and write them into this sheet. Group by status: all SENT campaigns first, then SCHEDULED, then DRAFT. Within each group, sort by scheduled_datetime descending.
When you need a count of campaigns per list to spot which lists are overused
Before the next quarter's plan, the director wants to know which contact lists are getting the most sends.
List all Spoki campaigns and write campaign_name, status, and list_id into columns A through C. Then in a summary section starting at row 50, count how many campaigns each list_id appears in and write list_id and campaign_count side by side.
When you need campaigns plus the contact count for each list used
The board wants to see estimated reach per campaign, not just which list was used.
List all Spoki campaigns and write campaign_name, status, scheduled_datetime, and list_id into columns A through D. Then for each unique list_id, look up the contact count from Spoki and write it into column E as estimated_reach. Sort by estimated_reach descending.
The pattern: pull the campaigns, then layer in the analysis you actually need, all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your Spoki campaigns into any open sheet. The Spoki integration is included in every plan. For related workflows, see how to export Spoki message templates into a sheet or the Spoki in Google Sheets overview.