The Scenario
You're the operations manager for a retail chain. The sale starts tomorrow. In your Google Sheet: 500 opted-in customer phone numbers in column A, customer names in column B. MSG91 template 'SALE2025' is already approved. What's left is getting the message out.
The bad version:
- Copy column A into a spreadsheet template that matches MSG91's bulk import format, realise the phone numbers are missing the country code, fix 500 cells manually.
- Upload the formatted CSV to MSG91 Segmento, map the variable fields in the UI, hit submit — and discover 47 rows failed because of number format mismatches you didn't catch.
- Fix the 47 rows individually, re-upload, verify, send.
That process costs three hours you didn't have. And if anything breaks mid-upload, you're starting over from the CSV export.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data and talks to MSG91 for you — no reformatting, no separate console, no upload step.
For each phone number in column A, send an SMS using MSG91 template ID 'SALE2025' with the customer name from column B as the variable, then write 'sent' or the error to column C.
What You Get
- Every phone number in column A gets a send attempt through MSG91 using the approved template.
- Column B's customer name is substituted into the template variable slot automatically.
- Column C fills in with 'sent' for successful delivers, or the error code and reason for failures.
- Failures are visible inline — no separate delivery report to hunt down.
What If the Data Is Not Quite Ready
Phone numbers are missing country codes
For each row in this sheet, prepend '+91' to the phone number in column A if it doesn't already start with '+', then send an MSG91 SMS using template 'SALE2025' with the name from column B as the variable, and write the result to column C.
Customer names are missing for some rows
For each row in column A with a phone number but a blank in column B, use 'Valued Customer' as the name variable when sending the MSG91 'SALE2025' template, and write the send result to column C.
The list spans two tabs — opted-in sheet and VIP sheet
Combine all phone numbers from the 'opted-in' tab column A and the 'VIP' tab column A, remove duplicates, then send the MSG91 'SALE2025' template with the corresponding name from column B as the variable, and write results to column C on each source tab.
Clean, deduplicate, validate, then send — one prompt
Remove duplicate phone numbers from column A, flag any that are not valid Indian mobile numbers in column D, then for all remaining valid numbers send the MSG91 'SALE2025' template with the name from column B, and write the delivery status to column C.
The pattern: address data problems and fire the send in one instruction — SheetXAI handles the sequence rather than making you fix the sheet first and send separately.
Try It
Get the 7-day free trial of SheetXAI and open your campaign recipient sheet, then tell it which MSG91 template to use, which column has the phone numbers, and which columns hold your variables. Explore the sibling spoke on personalised shipment-update SMS or go back to the MSG91 overview.