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?
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.
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
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!!!
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.
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?
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.
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
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
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
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.
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
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
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
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...
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.
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!
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 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
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?
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 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
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.
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.
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
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?
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
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?
Amit, great tutorial. Am wondering if this will work with Google Voice or only with the carrier system?
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
That's awesome, can we set delay time(approximately 10-15 seconds) in sending each SMS???
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.
You are a very good Teacher....
Thank you so much Amit. Just became a big fan of yours. Your contents are incredible. So creative. Keep it going my dear.
This was for experts...but was interesting sir.
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.
Thanks a lot! How do I make the message pop up on screen ?
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.
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.
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?
Thank you much buddy. This an impeccable application. You are a blessing to us. God bless you
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?
New subscriber here... I am not a programmer but I will try to do this on my spare time
Hello amir, is it possible to have a restriction over sim or number to use on mobile if someone has dual sim mobile.
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?
Thanks a lot Amit. It works. I will be using it to send customized messages to NPA borrowers. :-)
Many thanks its works, & solved the problem to send sms in phone via excel.
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?
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.
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
hello sir , could I use android studio to make my application and will this method work????
................................
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
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
I liked the session and to the point instructions.
can this be done for what app?
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 to add interval timer for each msg?
Well done bro, congrats! :)
Can it fetch and send thousand of SMS at the same time?
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.
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
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
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.
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
Excelente Amit! 👏
AND is there a way to do this with Google Voice???
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.
ahm can i just download whatever you've done amit?
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?
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
how can intigrate this today with appsheets?
Great sir,
App Inventor is nice
It is working
Please make a video about doGet and postGet.
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
this is not available anymore?
Does this need a load on sending text ?
Sir, you are great....... Salute 🙏
Awesome Guide!!
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...
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
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!
can you share the coding?? TQ
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
doGet problem
Wow! Amazing tutorial. I love it.
Hi sir, is can to connect received sms to google sheet?
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
Hi Amit seems to be useful but I tried it and got a doctype error with kodular. Could you help. thanks
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
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.
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?
Where can I download this app I'm not able to create one on my own.
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
Dear sir,
Any AAP's available Google Calendar remember to birthday sms direct to add mobile no.
Very useful, thank you for the tutorial. !!!
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.
Runtime error
invalid dastination address how solve
hello sir, i followed the code for the script but encountered this error in doPOST "TypeError: Cannot read property 'parameter' of undefined"
Suppose my Sheet Header at Row 3, which code need to modified ?
In logs error apears. Waiting for logs, please wait.... and there is no response
Superb Sir....
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.
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"
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...
I m getting generic message failed error. How to rectify.
@Shamlata
Do you find the solution?
is there any system to send SMS in Facebook messenger from google sheet
Its really work , thank you sir
This is Very helpful
I would prefer to use some Google API to work with my messages.
can i modify it to send the message to whatsapp?? can share with me how?? TQ
Thank you very much for the video. I am getting some errors. Please reply to the email that I have sent.
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
do we hv free sms provider in India
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.
Error Attempted to execute myFunction, but could not save.
Amazing!! 👍👍👍👍 Thank you Sir!
The last stop for sending personlaized bulk sms
Thank you!
Great Program, thank you! Can it be used to send group messages with the same message going to multiple phone numbers?
Why not?!!!Just change the text on the Text column and that's all.
@Amit AgarwaI am getting error at Emulator... Anyone can help me
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??
Great Info.
This does not work in 2023. Please update the code
This no longer works for me
Please do it with android studio
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 🥺