The Scenario
You are a WhatsApp marketing manager. Meta's approval window for new templates opens in five days. Before you submit anything new, your head of marketing wants a full audit of the 60 templates already in Spoki — name, category, approval status, and language — so the team can decide what to update, what to retire, and what to submit fresh.
The templates are in Spoki. None of them are in a sheet. The audit needs to be in a shareable Google Sheet by end of day tomorrow.
The bad version:
- Log into Spoki
- Open the templates list
- Click into each template to see its status and category
- Copy everything into a sheet by hand: name, category, status, language
- Do this for all 60 templates
- Remember to add a "NEEDS REVIEW" flag for anything not in APPROVED status
- Miss three of them because you lost track of which page you were on
- Send the wrong list to the head of marketing and spend Wednesday fixing it.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Spoki templates and writes every field into the sheet, including the review flag for anything that is not approved.
Open the SheetXAI sidebar and type:
List all WhatsApp templates from Spoki and write template_id, name, category, status, and language into columns A through E of this Google Sheet. Flag any template not in APPROVED status with "NEEDS REVIEW" in column F.
SheetXAI calls Spoki, writes all 60 templates into the sheet, and adds the flag column. You have the audit done before lunch.
What You Get
A complete template audit in one sheet:
- Column A — template ID
- Column B — template name
- Column C — category (MARKETING, UTILITY, AUTHENTICATION)
- Column D — approval status
- Column E — language
- Column F — "NEEDS REVIEW" for anything not approved, blank otherwise
The flag column is what saves the meeting. Instead of the head of marketing reading through 60 rows to find the five that need attention, they filter column F and see the short list immediately.
What If the Data Is Not Quite Ready
Template audits usually need more than a raw list. SheetXAI handles the pull and the analysis in the same prompt.
When the team wants templates grouped by status for easier review
DRAFT templates first so the team knows what has never been submitted.
List all Spoki templates and write their names, categories, and statuses into this sheet. Group by status so all DRAFT templates appear first, then PENDING, then APPROVED. Add a column F flag for any non-APPROVED template.
When you need to count templates by category to plan the next quarter's mix
Before submitting new templates, the team wants to know the breakdown: how many marketing, how many utility, how many authentication.
List all Spoki templates and write template_name, category, and status into columns A through C. Then in a summary section starting at row 65, count how many templates exist per category and write category and count side by side.
When you want to find templates that share a name root to catch duplicates
The Italian and English versions of the same template sometimes have nearly identical names, which creates confusion at approval time.
List all Spoki templates and write template_name, category, status, and language into columns A through D. In column E, flag any template_name that appears more than once (across any language) with "POSSIBLE DUPLICATE."
When you need the full audit plus the body text of every non-approved template
The head of marketing wants to read the actual copy before deciding what to update.
List all Spoki templates. Write template_id, name, category, status, and language into columns A through E. For any template where status is not APPROVED, fetch the full template body text and write it into column F. Flag those rows with "NEEDS REVIEW" in column G.
The pattern: pull the list, layer on the analysis, and get the information 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 template library into any open sheet. The Spoki integration is included in every plan. For related workflows, see how to bulk create new Spoki templates from a sheet or the Spoki in Google Sheets overview.