Send SMS Text Messages to any Phone Number with Google Sheets and Android

Send SMS messages in bulk directly from your Android phone.

All you need is Google Sheets, a Gmail account and an Android phone with a SIM that has texting enabled. You can send text messages to any number (including international phone numbers).

The messages will go from your phone number (not anonymously) and unlike Twilio or other messaging APIs, you only pay the standard text rates directly to your cellular service provider.

The Android app is built with MIT App Inventor, a no-code solution for building functional Android apps that can even be distributed through the Google Play store.

[labnol]

Learn how to send SMS messages from your phone with Google Sheets and App Inventor.

[prashanthn]

Sir it really served my very search purpose for sending "Text SMS" to my students who get absent to the classes:) Thanks a Lot Sir. I am learning every bit from your valuable videos. You have taken so much of effort to make things understand to a non-coding knowledge person like me. Regards Sir.

[revkenbushey]

Thanks Amit! I had to replace the quotation marks and remove the carriage returns in the cut and pasted script and it worked beautifully. Others have noted that a delay would be helpful to send one text at a time. Not all my texts will send out (I sampled with 30 and 9-12 usually sent). Regardless of how many texts were actually sent, the notifications still count off until the end and the status still updates in the Google sheets for all the rows. Users should note that the notifications and status updates are independent from the actual texts sent. Your work offers a great start for my project! Video and and instruction very well done! Much thanks!!!

[Abrarkhan-fbpl]

That's awesome, can we set delay time(approximately 10-15 seconds) in sending each SMS???

[ashujaggi]

Amit Aggarwal sir you are a real HERO. You are GREAT. I do not have words to thank you. Please carry on good work. Thanks a lot

[anthonyrude]

How many messages can you send at once? Can you pause between messages? I dont want to get in trouble for sending too many messages at once.

[shlm]

Thank you so much for this Tutorial Amit! Didn't know this kind of thing was possible! Saves a lot of redundant effort when texting a huge group.

[MynomadsafariholidaysIndia]

This was for experts...but was interesting sir.

[ibrahimabbas]

Hello amir, is it possible to have a restriction over sim or number to use on mobile if someone has dual sim mobile.

[xitcode]

Thank you so much Amit. Just became a big fan of yours. Your contents are incredible. So creative. Keep it going my dear.

[coretorqueco]

Hi Armit can you advise how to automate this when a Google form is submitted

[BkSathesh]

Hi, is there a limit to the number of SMS's this approach can send? Perhaps under 5000? Any estimate on how long it would take to send 500 sms's?

[nicksonbonke]

Thank you much buddy. This an impeccable application. You are a blessing to us. God bless you

[rtnychemtabad]

Many thanks its works, & solved the problem to send sms in phone via excel.

[RonyJoseph-hosq]

Amit, great tutorial. Am wondering if this will work with Google Voice or only with the carrier system?

[MoSylla]

Wonderful. Absolutely wonderful. Thanks to you i know of MIT App Inventor. This single video is a game changer. Shukria!!!

[anushankark]

sir can u make a tutorial on Send whatsapp message using google sheets

[mov]

AWSOME!!!! Thank you so much for sharing your knowledge in such an understandable and chillied way!!! You helped me a lot, and i never saw such a competence here on youtube really!!!! You are great

[subhajitkarmakarisawesome]

Thanks a lot Amit. It works. I will be using it to send customized messages to NPA borrowers. :-)

[RichDadph]

New subscriber here... I am not a programmer but I will try to do this on my spare time