The Scenario
You are a CRM manager. Tomorrow at 10 AM an exclusive WhatsApp offer goes out to your VIP customers. The offer is configured in Spoki, the template is approved, the list is named "VIP Customers."
There is one problem: the list is empty. The 1,200 VIP customers you need are in a Google Sheet with phone numbers, first names, and a custom membership_id field. Someone needs to get them into that list before 9 AM or the campaign fires with zero recipients.
The bad version:
- Export the sheet as a CSV
- Open Spoki's list manager, find "VIP Customers," open the contact importer
- Map phone, first_name, membership_id by hand
- Run the import
- Wait for the progress bar
- Discover the list has 1,147 contacts instead of 1,200 — 53 rows failed silently
- Dig through logs to find the failures
- The 10 AM send goes out to 1,147 people and you spend the next hour explaining why 53 VIP customers were excluded.
The fast version is one prompt the night before.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the sheet and pushes every contact directly into the named Spoki list, with per-row status so no failure is invisible.
Open the SheetXAI sidebar and type:
Sync all rows from this sheet into Spoki list "VIP Customers" — column A is phone (E.164), column B is first_name, column C is a custom field called membership_id. Batch up to 500 contacts per request and write the result into column D for each row.
SheetXAI reads the 1,200 rows, batches the requests, and writes "added" or any error into column D. You know before you leave for the day whether all 1,200 are in the list.
What You Get
A fully loaded "VIP Customers" list in Spoki with no guesswork:
- Column D populated for every row — "added" or a specific error
- Batching handled automatically — the 500-per-request limit is respected without you counting rows
- membership_id carried in — no manual field mapping in the Spoki importer
- List-targeted sync — contacts go into "VIP Customers," not just the general pool
The difference between this and a CSV import is that you know the exact list count before the campaign fires. If 12 rows failed because of malformed numbers, you see that in column D and you fix it before 9 AM, not at 10:03 when someone asks why their message did not arrive.
What If the Data Is Not Quite Ready
Contact sheets for campaign lists are rarely clean on the first look. SheetXAI handles cleanup and the list sync in the same prompt.
When phone numbers need E.164 normalization
The CRM export uses local Italian format and Spoki needs international format.
Normalize all numbers in column A to E.164 with country code +39. Then sync all rows into Spoki list "VIP Customers" with first_name (B) and membership_id (C). Write the result into column D.
When some rows are missing membership_id
About 80 rows have a blank column C. You still want to add them to the list.
For rows where column C is blank, set membership_id to "UNKNOWN" before syncing. Then sync all rows into Spoki list "VIP Customers" and write results into column D.
When the list already has some of these contacts from a previous import
You ran a partial import last week and are now topping it up. You do not want to double-add people.
Sync all rows to Spoki list "VIP Customers". If a contact already exists in the list, skip them and write "already in list" into column D. For new contacts, add them and write "added."
When you need to split the contacts across two Spoki lists by membership tier
Half the sheet is "Gold" tier, half is "Platinum." Each tier has its own Spoki list for separate messaging.
For rows where column D is "Gold", sync into Spoki list "VIP Gold". For rows where column D is "Platinum", sync into Spoki list "VIP Platinum". Write the result into column E for each row, including which list each contact was added to.
The pattern: the list targeting, the batching, the error handling, and the cleanup all happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any segmented contact sheet, then ask it to push the contacts into a named Spoki list. The Spoki integration is included in every plan. For more, see how to bulk import contacts into Spoki or the Spoki in Google Sheets overview.