AvailableSend bulk SMS from Google Sheets
Turn any sheet of names and numbers into personalised SMS — fee reminders, appointment alerts, offers — sent in real time, with delivery status written back to each row.
What you can do
Personalised messages
Use {{Column Name}} placeholders to fill every SMS from your sheet.
Send selected or all rows
Send to the rows you select, or to every row not yet sent.
Real-time sending
Messages go out in batches the moment you click send.
Delivery status in the sheet
Submitted rows update to Delivered or Failed in one click.
Balance check
See your remaining SMS credits from the menu.
Safe for teams
Your API key is stored only for your Google account.
WhatsApp with images
Send the same rows on WhatsApp, with an optional WhatsApp Message column and up to 4 Image URL columns.
Set it up
- 1
Open Apps Script
In your sheet, go to Extensions → Apps Script.
- 2
Add the files
Paste Code.gs, add an HTML file named Settings with Settings.html, and paste appsscript.json into the manifest. Save.
- 3
Reload the sheet
A Bulk SMS India menu appears. Open Settings and add your username, API key and sender ID.
- 4
Prepare columns
Add a Phone column and either a Message column or a template in Settings.
- 5
Send
Choose Send SMS to selected rows or Send SMS to all unsent rows, then Check delivery status a minute later.
Your sheet becomes an SMS campaign
Add a phone column and either a message column or a template. The add-on fills in each row and writes the result back.
- Template placeholders like {{Name}} and {{Due Date}} from your columns
- Rows already sent are skipped automatically
- SMS Status, Message ID and Sent At columns added for you
- Check delivery status for every row in one click
| Name | Phone | Amount | SMS Status |
|---|---|---|---|
| Ravi | 98765 43210 | 1,500 | Delivered |
| Asha | 91234 56789 | 2,000 | Delivered |
| Imran | 99887 76655 | 1,200 | Submitted |
| Neha | 12345 | 900 | Invalid number |
Frequently asked questions
Is the Google Sheets add-on free?
Yes. You only pay for the SMS you send.
How many rows can I send at once?
The add-on sends in batches of 50 and can handle large sheets; Google limits how long a script can run, so very large sheets may need to be sent in parts.
Can I use different messages for each row?
Yes. Add a Message column; it overrides the template for that row.
Does it skip rows already sent?
Yes, when you choose Send SMS to all unsent rows.
Can I send WhatsApp messages from the sheet?
Yes. Add your WhatsApp API key in Settings and use Send WhatsApp to selected rows. Results go to WhatsApp Status and WhatsApp ID columns.
Need help connecting?
Our team helps with setup, DLT templates and test credits.