Send SMS Text Messages to any Phone Number with Google Sheets and Android
Vložit
- čas přidán 1. 04. 2020
- Send SMS messages in bulk directly from your Android phone.
Tutorial: www.labnol.org/send-sms-googl...
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.
For help with sending SMS, tweet / labnol or email amit@labnol.org
Learn how to send SMS messages from your phone with Google Sheets and App Inventor.
Tutorial: www.labnol.org/send-sms-google-sheets-200402
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?
How much of a Google Sheet List (of contacts), would this method, be able to send per hour & per day ?
Hay Amit Thank you for your video but the status for the spreadsheet can't show SMS send.
Hello Sir, Thanks for sharing this wonderful video. I'd like to know, can we know if sms is delivered or failed?
Thank you so much Amit. Just became a big fan of yours. Your contents are incredible. So creative. Keep it going my dear.
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.
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!!!
Hi ken can you share that project file of yours here?
I liked the session and to the point instructions.
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
Thank you much buddy. This an impeccable application. You are a blessing to us. God bless you
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
You are a very good Teacher....
Wow! Amazing tutorial. I love it.
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.
Can u please share the code and apk please?
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
Great work Amit, thanks very much and WELL DONE!
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
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.
Very useful, thank you for the tutorial. !!!
Amit, great tutorial. Am wondering if this will work with Google Voice or only with the carrier system?
This was for experts...but was interesting sir.
Wonderful. Absolutely wonderful. Thanks to you i know of MIT App Inventor. This single video is a game changer. Shukria!!!
can you copy and paste full script you builded?
Well done bro, congrats! :)
New subscriber here... I am not a programmer but I will try to do this on my spare time
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?
Many thanks its works, & solved the problem to send sms in phone via excel.
Awesome Guide!!
Thanks a lot Amit. It works. I will be using it to send customized messages to NPA borrowers. :-)
Excelente Amit! 👏
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?
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.
Great sir,
App Inventor is nice
It is working
That's awesome, can we set delay time(approximately 10-15 seconds) in sending each SMS???
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?
Sir, you are great....... Salute 🙏
Hello amir, is it possible to have a restriction over sim or number to use on mobile if someone has dual sim mobile.
Amazing!! 👍👍👍👍 Thank you Sir!
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)?
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.
This is Very helpful
Its really work , thank you sir
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.
Hi Armit can you advise how to automate this when a Google form is submitted
Hey, have you got any related thing to do it? I also want this feature.
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.
Thanks a lot! How do I make the message pop up on screen ?
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.
Superb Sir....
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.
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
Thank you for the tutorial. I have attempted it however error message , occurs when I fetch messages. The messages appears but are 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.
Suppose my Sheet Header at Row 3, which code need to modified ?
Great Info.
hello sir , could I use android studio to make my application and will this method work????
................................
hello sir, i followed the code for the script but encountered this error in doPOST "TypeError: Cannot read property 'parameter' of undefined"
Hi Amit! This is a really great tutorial, it's easy to use. :)
Status in the sheet can't be updated! Please help!
Hi Roni. I am getting this Error. Invalid Destination Address. How do I get around this?
@@subhajitkarmakarisawesome rename your sheet for "SMS" and copy correct sheet URL
@@barqiyaweb9389 it worked. Thanks
Dear sir,
Any AAP's available Google Calendar remember to birthday sms direct to add mobile no.
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
How to add interval timer for each msg?
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
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
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.
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
sir can u make a tutorial on Send whatsapp message using google sheets
It is currently not possible to send messages with WhatsApp though Google Sheets since WhatsApp APIs aren't available for consumers.
you can use twillio REST APIs to send whatsapp messages. You just need to use UrlFetchApp class from Google app script.
In logs error apears. Waiting for logs, please wait.... and there is no response
Hi sir, is can to connect received sms to google sheet?
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...
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
Can it fetch and send thousand of SMS at the same time?
Hello Sir, Thank you for creating this video. I am getting an error when fetching data "the operation elements cannot accept the arguments".
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...
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?
Did you find a solution for this?
This was very informative. Could you make a video on how this could be done for WhatsApp?
bro with this video can i send message from any name to other number?
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
Found my way around it. Thanks
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
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"
Thanks man! It helps me a lot.
hello Amit, can it be configured to send the SMS automatically when there is a new entry row in Google sheet?
I'm looking for this answer to. So that I can automate a google form sheet
look up triggers / on form submit in google sheets to call the function when form submits
is there any system to send SMS in Facebook messenger from google sheet
Please make a video about doGet and postGet.
Hi Amit seems to be useful but I tried it and got a doctype error with kodular. Could you help. thanks
Where can I download this app I'm not able to create one on my own.
this is so technical
Does this need a load on sending text ?
can this be done for what app?
ahm can i just download whatever you've done amit?
AND is there a way to do this with Google Voice???
Getting error in apk after pressing send sms as Runtime Error -Invalid destination Address , please help!
SAME ERROR IN MY PHONE
I got that error first. Now it's ok. Check for any typo.
@@tokeyahmmed Are you talking about typo in the google script? I copy pasted everything from the Amit's website, not sure why I'm getting this error also.
can i modify it to send the message to whatsapp?? can share with me how?? TQ
I would prefer to use some Google API to work with my messages.
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.
Nice video ❤️❤️❤️
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.
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.
I offer SMS service not limit for amount and contents at a low cost.
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!
check the row id of status column and metion the same in script
@@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
@Amit AgarwaI am getting error at Emulator... Anyone can help me
can you share the coding?? TQ
this is not available anymore?
I m getting generic message failed error. How to rectify.
@Shamlata
Do you find the solution?
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 🥺
did make it past the SyntaxError by retyping some of the syntax in that line (for example: I retyped the quotation marks, and it seemed to work).
Now, my challenge is working with the App Inventor and using the Google Script: Again: I do not have the name of the Script Output like you have in your Line 1 of the Google Script So I don't know what to put in Line 1 of the Inventor. How do I generate that correct name if I simply "copy/pasted" the Google Script from your Tutorial?
UPDATE: I was able to figure out and I FIXED the errors and it works! I used the Video Scripts and Code (NOT the Tutorial-which has a few more lines of 'code' in it. I will experiment with the tutorial additions later. I just need to figure out what it means). Thanks so much @Amit!
The quotes were my problem. Thanks Andre!
Hii sir ... i am getting this error [TypeError: Cannot read property 'getDataRange' of null (line 8, file "Code")]
How can i fix it?
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!
Runtime error
invalid dastination address how solve
Please do it with android studio
Error Attempted to execute myFunction, but could not save.
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
This does not work in 2023. Please update the code
do we hv free sms provider in India
what i can do if i get error "TypeError: Cannot read property 'getDataRange' of null (line 7, file "SMS")" in google script.?
Make sure that you have set the sheet name as SMS
@@labnol i have also same Error
TypeError: Cannot read property 'getDataRange' of null (line 6, file "Code")
My all files name is SMS
@@labnol Thanks
@@uzairtanveer666 till u have same problem or not ?? If not then help me out to fix this problem??