The Scenario
Your e-commerce platform just dispatched 300 orders. Each customer has a unique tracking number. You have the full list in an Excel workbook: phone numbers in column A, tracking numbers in column B. MSG91 template 'SHIPMENT_UPDATE' is approved with a single variable slot for the tracking number. Every customer expects the right number in their message.
This is the third time this week you've run a send like this.
The bad version:
- Export the workbook to CSV — only to have Excel silently reformat your tracking numbers, stripping leading zeros and converting some to scientific notation.
- Upload to MSG91 Segmento, map the variable column, discover the reformatted numbers don't match the shipment system's records.
- Fix the export in a text editor, re-upload. Three rows still fail. Find and correct them manually.
The send goes out, eventually. But the 45 minutes you spent on prep is 45 minutes you weren't doing anything else.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data, substitutes your tracking numbers into the MSG91 template variable, and fires the send for every row.
For each row in this workbook, send an MSG91 SMS using the phone number in column A, the template 'SHIPMENT_UPDATE', and the tracking number from column B as the variable.
What You Get
- Each row generates one MSG91 send call with the correct tracking number substituted into the template.
- Delivery status is returned cell by cell — no silent skips, no mystery failures.
- The entire send runs from inside the workbook without exporting or touching the MSG91 console.
What If the Data Is Not Quite Ready
Excel reformatted tracking numbers during a prior save
For each row, treat the tracking number in column B as a text string and strip any scientific notation, then send an MSG91 'SHIPMENT_UPDATE' SMS to the phone number in column A with that value as the variable, writing the result to column C.
Some rows were already sent in a prior run
Skip any rows in column C already marked 'sent', and for all remaining rows send an MSG91 'SHIPMENT_UPDATE' SMS to the phone number in column A with the tracking number from column B, writing the result to column C.
Two variables are needed — first name and tracking number
For each row, send a personalised MSG91 SMS to the phone number in column A using template 'SHIPMENT_UPDATE_V2', substituting the first name from column C and the tracking number from column B as the two variables, and write the status to column D.
Validate, clean, personalise, and send in one pass
Check column A for valid phone number format, flag invalid ones in column D, strip non-numeric characters from column B for remaining rows, then send an MSG91 'SHIPMENT_UPDATE' SMS with the cleaned tracking number as the variable and write the result to column E.
SheetXAI sequences the validation, the cleaning, and the send — no manual step between.
Try It
Get the 7-day free trial of SheetXAI and open your dispatch workbook, then ask it to push MSG91 shipment notifications out to every row with a phone number and tracking number. See also the spoke on bulk promotional sends or return to the MSG91 hub.