Send SMS Text Messages to any Phone Number with Google Sheets and Android
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2024
- Send SMS messages in bulk directly from your Android phone.
Tutorial: www.labnol.org...
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?
That's awesome, can we set delay time(approximately 10-15 seconds) in sending each SMS???
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.
doGet problem
The last stop for sending personlaized bulk sms
Thank you!
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
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 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.
Hello amir, is it possible to have a restriction over sim or number to use on mobile if someone has dual sim mobile.
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.
Thank you much buddy. This an impeccable application. You are a blessing to us. God bless you
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.
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?
Bad arguments to Elements
The operation Elements cannot accept
the arguments: , ["
Please help me on these errors.
@@RiyazAhmed-dk4em Did you find a solution for this issue?
@@ahwendorf2 yes I did. The error was due to the restrictions by my company.
@@RiyazAhmed-dk4em Thanks!
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.
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! 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
I m getting generic message failed error. How to rectify.
@Shamlata
Do you find the solution?
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
Runtime error
invalid dastination address how solve
ahm can i just download whatever you've done amit?
Amit, great tutorial. Am wondering if this will work with Google Voice or only with the carrier system?
Thanks a lot Amit. It works. I will be using it to send customized messages to NPA borrowers. :-)
Thank you very much for the video. I am getting some errors. Please reply to the email that I have sent.
Sir Good App send SMS messages from your phone with Google Sheets and App Inventor but used more than whatsapp sms sir send me whatsapp messages
Many thanks its works, & solved the problem to send sms in phone via excel.
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"
In logs error apears. Waiting for logs, please wait.... and there is no response
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
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)?
AND is there a way to do this with Google Voice???
Thanks a lot! How do I make the message pop up on screen ?
I would prefer to use some Google API to work with my messages.
Can it fetch and send thousand of SMS at the same time?
How to add interval timer for each msg?
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...
can you share the coding?? TQ
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.
facing the same issue
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?
You are a very good Teacher....
Hi,Im getting a error of (DoPost)
~~TypeError: Cannot read property 'parameter' of undefined~~
Anyone please support me.
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.
this is not available anymore?
This was for experts...but was interesting sir.
This does not work in 2023. Please update the code
This no longer works for me
Tofiqahamad abubakar
Tofiqahamad abubakar
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.
Awesome Guide!!
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.
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
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
getting 908 error Permission "Send_SMS" has been denied ??
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)
Hey, Robert. I offer SMS service at a low cost and accept any contents. offer free testing.
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
hello sir , could I use android studio to make my application and will this method work????
................................
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
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
hello sir, i followed the code for the script but encountered this error in doPOST "TypeError: Cannot read property 'parameter' of undefined"
Dear sir,
Any AAP's available Google Calendar remember to birthday sms direct to add mobile no.
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 friend, thanks for the video.
How can I make the messages be sent every 10 seconds, so that my cell phone does not explode.
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
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...
Error Attempted to execute myFunction, but could not save.
Hi Amit seems to be useful but I tried it and got a doctype error with kodular. Could you help. thanks
Tofiq ahamad abubakar
To1234
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??
@Amit AgarwaI am getting error at Emulator... Anyone can help me
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.
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?
can this be done for what app?
can i modify it to send the message to whatsapp?? can share with me how?? TQ
is there any system to send SMS in Facebook messenger from google sheet
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.
Where can I download this app I'm not able to create one on my own.
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
New subscriber here... I am not a programmer but I will try to do this on my spare time
Well done bro, congrats! :)
Please make a video about doGet and postGet.
Suppose my Sheet Header at Row 3, which code need to modified ?
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.
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.
Error Message :
The operation Elements cannot accept the arguments: , ["
I know this is old, but I had the same problem, and it is due to permission. Need to set the Web App for Anyone. If you are under an organization email, make sure they enable it in their admin control.
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?
Hi sir, is can to connect received sms to google sheet?
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.
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
Thank you so much Amit. Just became a big fan of yours. Your contents are incredible. So creative. Keep it going my dear.
Its really work , thank you sir
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.
Does this need a load on sending text ?
Wonderful. Absolutely wonderful. Thanks to you i know of MIT App Inventor. This single video is a game changer. Shukria!!!
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!
I am getting this error. Can someone please help.
TypeError: Cannot read property 'getDataRange' of null (line 6, file "Code")
do check the sheet name is correct...
do we hv free sms provider in India
In India it doesn't work.
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 🥺
This is Very helpful
Great sir,
App Inventor is nice
It is working