The Scenario
You're the operations manager for a retail chain. The sale starts tomorrow. In your Excel workbook: 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:
- Export column A and B to CSV, open it in a text editor, fix the phone number format to add the country code, re-save.
- Upload to MSG91 Segmento, map variables in the console UI, submit — and discover 47 rows failed because Excel silently dropped leading zeros on numbers in the export.
- Fix the 47 rows, re-export, re-upload, re-verify.
That process costs three hours you didn't have. And if anything breaks mid-upload, you're starting over from the CSV.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data and talks to MSG91 for you — no CSV export, no reformatting, no separate console.
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 surface inline — no separate delivery report to pull up.
What If the Data Is Not Quite Ready
Phone numbers are missing country codes
For each row in this workbook, 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 worksheets — opted-in and VIP
Combine all phone numbers from the 'opted-in' worksheet column A and the 'VIP' worksheet 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 worksheet.
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: handle data problems and fire the send in a single instruction — SheetXAI sequences the cleanup and the API call for you.
Try It
Get the 7-day free trial of SheetXAI and open your campaign recipient workbook, 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.