The Scenario
You are a WhatsApp campaign specialist. Meta's approval window opens Monday morning. It is Friday. You have an Excel workbook listing 10 new promotional templates — name, category, body text in Italian, language code, and header type — and every one needs to be in Spoki as a DRAFT before you can submit them.
Creating them manually means clicking through the Spoki template builder ten times. Friday afternoon, five fields per template, and you still end up with a typo in template seven.
The bad version:
- Open Spoki's template builder
- Fill in all five fields for template 1
- Save
- Repeat nine more times
- Find the typo in template 7
- Fix it
- Leave the office at 6:30 PM for a twenty-minute task.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the workbook and creates every template in Spoki, writing the returned template ID back per row.
Open the SheetXAI sidebar and type:
For each row in this workbook — template_name (column A), category (column B), body_text (column C), language_code (column D), header_type (column E) — create a new Spoki WhatsApp template and write the returned template_id or error into column F.
SheetXAI reads all ten rows and creates ten templates in Spoki. Column F fills in with the template ID for each success.
What You Get
Ten DRAFT templates in Spoki, created from the workbook:
- Column F populated for every row — template ID or error
- All five fields carried in — name, category, body text, language code, header type
- DRAFT status set automatically — ready for Meta submission
- No Spoki UI required
The template ID in column F makes the approval cycle trackable. After Meta approves or rejects, ask SheetXAI to look up the status of each ID and write the result into column G.
What If the Data Is Not Quite Ready
When body text has placeholder inconsistencies
For each row, normalize any named placeholders in column C to numbered format: replace
{{name}}with{{1}},{{offer}}with{{2}}in order of appearance. Then create each Spoki template and write the template_id into column F.
When some rows are missing a header_type
For any row where column E is blank, set header_type to "NONE" before creating. Then create all templates and write results into column F.
When you want to test one template before running the full batch
Create only the Spoki template from row 2 of this workbook. Write the returned template_id or error into cell F2. Do not process any other rows yet.
When body text needs trimming before creation
For each row, check if column C exceeds 1,024 characters. If it does, trim to 1,024 at the nearest sentence boundary and write the trimmed version back into column C. Then create all Spoki templates and write the template_id into column F.
The pattern: normalize the workbook, create the templates, record the IDs — all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook of template definitions, then ask it to create the templates in Spoki. The Spoki integration is included in every plan. For related workflows, see how to export existing Spoki templates into a workbook or the Spoki in Excel overview.