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

[@labnol]

Learn how to send SMS messages from your phone with Google Sheets and App Inventor. Tutorial: www.labnol.org/send-sms-google-sheets-200402

[@TikoBlane]

Hey Amit thanks for your video. I got an error when I tried to paste to web app. For the sake of time if I donate to your cause can you create this for me?

[@quincygilbert1514]

How much of a Google Sheet List (of contacts), would this method, be able to send per hour & per day ?

[@raymondreyes8782]

Hay Amit Thank you for your video but the status for the spreadsheet can't show SMS send.

[@BuzzingNewz]

Hello Sir, Thanks for sharing this wonderful video. I'd like to know, can we know if sms is delivered or failed?

[@prashanthn777]

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.

[@perfecttek1503]

Can u please share the code and apk please?

[@ronalyncastro4884]

how did you do it? i am planning to make use of this in informing my students parents regarding their attendance. Can you help me out? Thank you so much

[@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!!!

[@gabrielisabelo4025]

Hi ken can you share that project file of yours here?

[@ashujaggi007]

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

[@Abrarkhan-fb4pl]

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

[@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.

[@ibrahimabbas4175]

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

[@coretorqueco]

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

[@AbhishekKumar-cs5ll]

Hey, have you got any related thing to do it? I also want this feature.

[@RonyJoseph-ho3sq]

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

[@AlexandreXavierG]

Thanks a lot! How do I make the message pop up on screen ?

[@BuzzingNewz]

How to add interval timer for each msg?

[@sh3l1m]

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.

[@Viiiiiiii-warrior]

hello sir , could I use android studio to make my application and will this method work???? ................................

[@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?

[@MynomadsafariholidaysIndia]

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

[@xitcode]

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

[@anushankark]

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

[@labnol]

It is currently not possible to send messages with WhatsApp though Google Sheets since WhatsApp APIs aren't available for consumers.

[@NileshAkhade]

you can use twillio REST APIs to send whatsapp messages. You just need to use UrlFetchApp class from Google app script.

[@jintojoseph6898]

You are a very good Teacher....

[@mschoo7420]

Can it fetch and send thousand of SMS at the same time?

[@nicksonbonke2608]

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

[@ibiwwirinov5964]

bro please answer me. i want to know if i do so in this video, can i send message from any name (or number) to other number(that i want)?

[@NathanielCongreso]

how can intigrate this today with appsheets?

[@MoSylla45]

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

[@barqiyaweb9389]

can you copy and paste full script you builded?

[@heswatchnu]

AND is there a way to do this with Google Voice???

[@rajeshkumarratilalvasava74]

In logs error apears. Waiting for logs, please wait.... and there is no response

[@subhajitkarmakarisawesome]

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

[@easycom818]

Thank you sir. Actually I'm no idea on script writing. I found this SMS sending video on youtube and try to create myself. Just copy and past your instruction. And run, SMS send successfully but G-Sheet can't update the "Status" colum after sending SMS. And I want to add an extra options, first one is when I fetch the data, it 's notify me how much SMS fetching. Second one is when I push the fetch button, others button will disable and after fetching complete except fetch button will enable automatically.

[@snowbron720]

Hi @Amit, thanks for great tutorial. Would it be possible to add component that will trigger sending smses remotely? So the phone will be controlled via web?

[@rajuLic2008]

Dear sir, Any AAP's available Google Calendar remember to birthday sms direct to add mobile no.

[@duboisburnell522]

Great video I have been looking for something this. Is there way to fetch and send one text at time from a google sheets list?

[@Goods-mb2rs]

ahm can i just download whatever you've done amit?

[@mov907]

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

[@ovidiuvarvaruc6996]

Everything works fine but for some reason is not filling out the Google Sheet for every text sent all the time, it's always sending the messages but it's always missing filling out the "Status" column for some numbers, never the same ones

[@shamlatapoojary8523]

I m getting generic message failed error. How to rectify.

[@Dreadaxe]

@Shamlata Do you find the solution?

[@rangpurtutormedia6844]

Please make a video about doGet and postGet.

[@gatewayservices7970]

Suppose my Sheet Header at Row 3, which code need to modified ?

[@ludviktrnka]

Hi Amit, that tutorial is really perfect. The only thing I miss is the ability to write back to the sheet that the sms failed to send. An unsuccessful attempt to send to the wrong number, for example, is recorded as "sms sent". I can't find any method in MIT APP INVENTOR to record this feedback. Tahnk you.

[@אריאלסולומון-ה3ל]

Could you send me a private link to the project of the application you built? I did exactly according to the guide one by one. And it writes me errors in the application itself? It will be very helpful. Thank you

[@muliagunawan2977]

Hi sir, is can to connect received sms to google sheet?

[@cube4952]

can you share the coding?? TQ

[@MihailoMilankovic]

Well done bro, congrats! :)

[@boyfromthemountains]

Where can I download this app I'm not able to create one on my own.

[@rtnychemtabad]

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

[@rhumulanay8215]

Does this need a load on sending text ?

[@mozart_34]

Thanks for the tutorial Amit, it is awesome content, just 3 doubts 1 you declared the doGet function as const and why the notation doGet = () => { is it the same as function doGet(){ ? 2 could you tell me where can I learn [header, ...data] = ... to get just the header, I didn't know that : O 3 why did you use setMimeType to the json textoutput! Thanks again.

[@andrewest1635]

More than 5 or 6 messages results in About 5 messages going out only. All of the others are shown as "Not Sent". I need a time delay (or a confirmation before the next message is sent). How can I do that?

[@gabrielisabelo4025]

Did you find a solution for this?

[@jameschannel01182]

is there a way for me to clear the status or fresh it, and also available for me to edit message direct from the app? or how about add a from the group of numbers, edit or delete.

[@webcoding4852]

can help me in this error: TypeError: Cannot read property 'getRange' of null (ligne 32, fichier "Code") (in method doPost)

[@آراء_في_مهب_الريح]

in the worbook make the sheet name "SMS"

[@EduDarshan]

Runtime error invalid dastination address how solve

[@RohitKumar-qu5db]

Hi Amit! This is a really great tutorial, it's easy to use. :) Status in the sheet can't be updated! Please help!

[@subhajitkarmakarisawesome]

Hi Roni. I am getting this Error. Invalid Destination Address. How do I get around this?

[@barqiyaweb9389]

@@subhajitkarmakarisawesome rename your sheet for "SMS" and copy correct sheet URL

[@subhajitkarmakarisawesome]

@@barqiyaweb9389 it worked. Thanks

[@Bimbasheekg]

can this be done for what app?

[@dannygemtanentico9409]

hello sir, i followed the code for the script but encountered this error in doPOST "TypeError: Cannot read property 'parameter' of undefined"

[@badratagility]

Is there any way to write this so that it's sending different messages to the same numbers? I need something where I can send update messages to a group of people throughout the day. I know you can do this with adons like twilio but I need to be able to launch the messages from something easy like an app.

[@atikmahamud5087]

is there any system to send SMS in Facebook messenger from google sheet

[@lordgenesparagoza2556]

this is not available anymore?

[@9766yogesh]

Cannot get sheet data in the browser after deployment. Just get square brackets. Got the sheet data in log. But not in the browser. Please help.

[@ساميسليمانالتاجوري]

This was my issue, but solved Check column headings and letters... eg: don't write phone .. but write Phone the first letter only must capital my Greetings

[@RichDadph]

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

[@HiteshAdventure]

Thank you for the tutorial. I have attempted it however error message ,occurs when I fetch messages. The mesages appears but preceded by "error 1109: the specified url is not valid" Also upon clicking send sms, notification don't appear and messages are not sent. Any help would be appreciated.

[@elitecoders8026]

facing the same issue

[@אריאלסולומון-ה3ל]

Hi Amit, could you send me a private link to the app project you built? I did exactly according to the guide one by one. And it writes me errors in the application itself? This will help a lot. Thanks

[@TheBlessingflow]

Hello Amit. I followed your tuition religiously. The App works. However, for batch SMS. All was sent then a message came back on my phone which says; "tap to resend". I realized my cellular phone provider, take up to 40 sec. to submit 1 SMS. Is it a ridiculous Idea to customize the apps to submit each SMS every 40 sec? How can I fix this problem? Thanks in advance

[@funentertainment2541]

It is good only for 15 to 20 messages. How can I send UpTo 50 to 60 rows data... Approximately 150 sms ... And give module of time delay

[@joearisthyl5071]

hello Amit, can it be configured to send the SMS automatically when there is a new entry row in Google sheet?

[@RahmanRashid0]

I'm looking for this answer to. So that I can automate a google form sheet

[@dwarakanathcheyyur140]

look up triggers / on form submit in google sheets to call the function when form submits

[@zphskomallavaram7393]

Sir, I recently created SMS app as per your Video to send messages to parents of the students who were absent to our school. It's working Effectively. Thank you So much for your for your valuable knowledge shared with us. But When i tried fetch Messages empty rows also reading by the app. will you suggest me to get rid of this problem. Sekhar, Teacher, ZPHS, K O Mallavaram

[@hbshah6204]

Hi Amit, Great Program, simple yet beautiful execution, Extremly useful and power app. indebted to you brother. Guys learn from it. I dont think it can get better than this.

[@F00TB4LITO]

Great work Amit, thanks very much and WELL DONE!

[@אריאלסולומון-ה3ל]

Could you send me a private link to the project of the application you built? I did exactly according to the guide one by one. And it writes me errors in the application itself? It will be very helpful. Thank you

[@guythegeek]

Hi Amit seems to be useful but I tried it and got a doctype error with kodular. Could you help. thanks

[@narasimhanandam525]

@Amit AgarwaI am getting error at Emulator... Anyone can help me

[@shivamdubay617]

Hello Sir, Thank you for creating this video. I am getting an error when fetching data "the operation elements cannot accept the arguments".

[@michabroniewicz8608]

Hi. same here. Did you get it to work? I can see that blocks in this video tutorial are different that on the web page of Amit...

[@alexk6745]

I would prefer to use some Google API to work with my messages.

[@harendergusain350]

I liked the session and to the point instructions.

[@finlandmscs3245]

what i can do if i get error "TypeError: Cannot read property 'getDataRange' of null (line 7, file "SMS")" in google script.?

[@labnol]

Make sure that you have set the sheet name as SMS

[@uzairtanveer666]

@@labnol i have also same Error TypeError: Cannot read property 'getDataRange' of null (line 6, file "Code")

[@uzairtanveer666]

My all files name is SMS

[@tokeyahmmed]

@@labnol Thanks

[@bhumitbhanderi228]

@@uzairtanveer666 till u have same problem or not ?? If not then help me out to fix this problem??

[@deepaksodeepak]

I am getting type error in this step const [header, ...data] = sheet.getDataRange().getDisplayValues(); namely Cannot read properties of null (reading 'getDataRange') Please assist. Amit Sir

[@anujaprakash6125]

Error Attempted to execute myFunction, but could not save.

[@cube4952]

can i modify it to send the message to whatsapp?? can share with me how?? TQ

[@rangpurtutormedia6844]

doGet problem

[@veetisaree]

Great sir, App Inventor is nice It is working

[@wilmaraguilar7499]

Hi friend, thanks for the video. How can I make the messages be sent every 10 seconds, so that my cell phone does not explode.

[@rbjassoc6]

getting 908 error Permission "Send_SMS" has been denied ??

[@mozart_34]

Hi! with the AI Companion throw the error, but when you install the apk in your phone it ask for the permissions to allow the app send the messages (well at least in my case, hope it works for you)

[@ethanma5717]

Hey, Robert. I offer SMS service at a low cost and accept any contents. offer free testing.

[@pauladormson3124]

Thank you Amit, I am glad I tried and it was working. However, I want to also generate the message automatically using cell referencing (ie: concatenating values in different cells to auto-generate my message to be sent to customers when there is a new update, or input, or entry

[@pauladormson3124]

Found my way around it. Thanks

[@אריאלסולומון-ה3ל]

Could you send me a private link to the project of the application you built? I did exactly according to the guide one by one. And it writes me errors in the application itself? It will be very helpful. Thank you

[@adetolasolesi1709]

How many sms can you send at a time. How can I set a limit. I would imagine it would be the while, for function.

[@ethanma5717]

I offer SMS service not limit for amount and contents at a low cost.

[@JaisonRodriguez1jaison9]

Gracias por su video. Cómo se puede agregar un tiempo de espera de envío en medio de cada mensaje. Le agradezco su ayuda.

[@Jithumsyelf]

Amit can u pls help errro mssg wen publishing script function not found :doget

[@thomasroberts9666]

doGet rather than doget

[@Jithumsyelf]

@@thomasroberts9666 hi Thomas it is doGet only

[@raihannewaz125]

Wow! Amazing tutorial. I love it.

[@pawankumarrsingh8178]

Hi, Amit There is a error in doPost Method in given below line please help me

[@pawankumarrsingh8178]

var rowId=Number(e.parameter.row);

[@govugowrishanker4107]

@@pawankumarrsingh8178 did you got any solution for this error please let me know

[@barqiyaweb9389]

@@pawankumarrsingh8178 same issue here

[@آراء_في_مهب_الريح]

The project sends the first message only and for the other messags show "Generic Failure" Message .. Could you help please

[@آراء_في_مهب_الريح]

@David Flores Navas it sends only short messages but long messages it gives "Generic Failure " ?? Could you help please 🥺

[@pankajjoshi8292]

do we hv free sms provider in India

[@FedericoGarcia87]

Excelente Amit! 👏

[@abhayanandcse1752]

Sir, you are great....... Salute 🙏

[@jameschannel01182]

This no longer works for me

[@f2white]

Can this be made to sync with Google Voice?

[@labnol]

I wish I could answer that but Google Voice is not available in our region.

[@ErikPetersonErikTampa]

@@labnol Hello Amit, thank's for the video is helpful , but i have a problem Can u help me please for to fixe it: Error Message : The operation Elements cannot accept the arguments: , ["

[@JadTaylor]

@@ErikPetersonErikTampa Make sure the individual sheet in your Google Sheet is named SMS as indicated in line 2 of the Google Script. Changing the sheet name should fix your issue!

[@ErikPetersonErikTampa]

@@JadTaylor got it to work just fine. Thanks

[@YourWebMarketer]

Im paying!

[@asifamir4335]

Hi, Amit, thank you very much for this ... you have done a great job man.... but here i got a problem..... when I run the Live version on my fone and try to fetch the Messages, i got the following error "Error 1109: The specified URL is not valid"... can you please guide me what went wrong and how this can be corrected...

[@alfonsobarbuto3922]

Hello, first video I follow from you and it's awesome. Just a problem: the Status column is not updated... Any idea why? Somebody else with the same problem? Thanks a lot!

[@vivekjayavel6636]

check the row id of status column and metion the same in script

[@subhajitkarmakarisawesome]

@@vivekjayavel6636 Hi. My Status header is in F1 just like the videos suggests. What should I write in the App Inventor under updateGoogle Sheet block? Please help.

[@ساميسليمانالتاجوري]

@@subhajitkarmakarisawesome This was my issue, but solved Check column headings and letters... eg: don't write phone .. but write Phone the first letter only must capital my Greetings

[@barqiyaweb9389]

Hi,Im getting a error of (DoPost) the line of var rowid = Number(e.parameter.row); ~~TypeError: Cannot read property 'parameter' of undefined~~ Anyone please support me.

[@badguy8672]

Please do it with android studio

[@mar-tes98]

Amazing!! 👍👍👍👍 Thank you Sir!

[@situansitus]

how to send from google sheet to wa

[@pats_collec]

Very useful, thank you for the tutorial. !!!

[@HarshSethia]

This was very informative. Could you make a video on how this could be done for WhatsApp?

[@ibiwwirinov5964]

bro with this video can i send message from any name to other number?

[@Isenhartanis]

Awesome Guide!!

[@jakeihekona7018]

The last stop for sending personlaized bulk sms

[@labnol]

Thank you!

[@nandha29]

Hii sir ... i am getting this error [TypeError: Cannot read property 'getDataRange' of null (line 8, file "Code")] How can i fix it?

[@sameerbhadale6151]

you have to change the tab name at the bottom in google sheet to "SMS" or the name of the sheet. it should resolve your problem.. best luck!