The Scenario
You are a WhatsApp campaign specialist. Meta's approval window opens Monday morning. It is Friday. You have a Google Sheet listing 10 new promotional templates — each with a name, category, body text in Italian, language code, and header type — and every one of them needs to exist in Spoki as a DRAFT before you can queue them for submission.
Creating them manually means opening Spoki, clicking "New Template," filling in five fields, saving, and doing it again. Ten times. The kind of task that eats a Friday afternoon and still ends with a typo in template seven.
The bad version:
- Open Spoki's template builder
- Read row 1 from the sheet
- Fill in name, category, body text, language code, header type
- Save as DRAFT
- Repeat nine more times
- Realize template 7 has "promo_maggio" in the name but the body says "giugno"
- Fix it
- Realize you mixed up the language code on template 4
- Fix that too
- Leave the office at 6:30 PM for a task you thought would take 20 minutes.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the sheet and creates every template in Spoki in one go, writing the returned template ID back to the sheet so you have a record.
Open the SheetXAI sidebar and type:
For each row in this sheet — 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 and the error message for any failure. You know which ones worked before you leave the building.
What You Get
Ten DRAFT templates in Spoki, created from the sheet:
- 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 to queue for Meta submission
- No Spoki UI required — you never opened the template builder
The template ID in column F is what makes this repeatable. After Meta approves or rejects the templates, you can ask SheetXAI to look up the status of each ID in column F and write the approval result into column G. The sheet becomes the source of truth for the whole approval cycle.
What If the Data Is Not Quite Ready
Template sheets always have something to fix before creation. SheetXAI handles cleanup and creation in the same prompt.
When body text has placeholder inconsistencies
Some rows use {{1}} for the first variable, some use {{name}}. Spoki expects the numbered format.
For each row, normalize any named placeholders in column C to numbered format: replace
{{name}}with{{1}},{{offer}}with{{2}}, and so on 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
Column E is blank for three templates that are text-only.
For any row where column E is blank, set header_type to "NONE" before creating the template. Then create all templates in Spoki and write results into column F.
When you want to create one template first as a test before running the full batch
Template 1 is the most important. Validate it works before committing to all ten.
Create only the Spoki template from row 2 of this sheet — use template_name (A), category (B), body_text (C), language_code (D), header_type (E). Write the returned template_id or error into cell F2. Do not process any other rows yet.
When body text needs to be reformatted for WhatsApp's character limits before creation
Some rows have body text that is too long and needs trimming plus the creation to happen together.
For each row, check if the body_text in column C exceeds 1,024 characters. If it does, trim it to 1,024 characters at the nearest sentence boundary and write the trimmed version back into column C. Then create all Spoki templates from the sheet and write the returned template_id into column F.
The pattern: normalize the sheet, create the templates, record the IDs — all in one prompt, in the order the work actually needs to happen.
Try It
Get the 7-day free trial of SheetXAI and open any sheet 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 sheet or the Spoki in Google Sheets overview.