I need an answer for this too. I'm doing this for our school's automated attendance checker where when a qr code of a student is scanned, the integration will notify the parents via sms.
I have few question: I increased your original google sheet from 3 columns to 8 and was not able to make this work.1) Is there a way to increase the number of columns in the google sheet so I can include other info for the text message and then using the concat function to build a complete message before I send? 2) Can the script used in this "send SMS" be used in a normal excel sheet?
If you're still getting an error message after following @Troy Shimkus advice I got mine to work by replacing LINE 62 not 64 but I'm using a MAC so I don't if that makes a difference. Hope it helps.
What if there is a "meeting time "column on the Google sheet that contains date and time for a meeting and I want the SMS to be sent 1 hour and 10 mins to the time in the meeting time column. How do I go about this?
Thank you 🙏🏽 this worked for me. The code is basically the same except that I changed the quotation from a single to a double quotation mark I still received the same error message as before but right after I received the error message on the sheet, I received a text to both numbers. I had two different numbers. I tested each with its own unique message. first number received the correct message and second number received its unique message too. I will need to find out why I am getting the error message -> Cannot find method getRange(number,number,number,number,number). and yet received the sms
@@omar1187 no sorry, iv considered paying my developer to create a solution like this but with more functionality such as this... Otherwise i guess no one else sees that value
do i need to press send or can i do it automatically when a row is created? Thanks ^^
I need an answer for this too. I'm doing this for our school's automated attendance checker where when a qr code of a student is scanned, the integration will notify the parents via sms.
Such a great solution for smaller organizations. Are there any size limits/API Rate limits etc. to be aware of. Maximum rows for the spreadsheet.
I have few question: I increased your original google sheet from 3 columns to 8 and was not able to make this work.1) Is there a way to increase the number of columns in the google sheet so I can include other info for the text message and then using the concat function to build a complete message before I send? 2) Can the script used in this "send SMS" be used in a normal excel sheet?
That comes just at the right time!
Thank you so much! This was really helpful and saved me so much time.
Great video and easy to follow!
How would you create a delay of 1 minute between messages being sent in the script?
It's a good tutorial Thank you.
Can I capture a reply to the text in a sheet?
how would you be able to personalize each message if sending to a large list with several variables?
By using concatenate gathering details from the different columns in your contact list
How to send images and attachments from google sheets to whatsapp??
If you're still getting an error message after following @Troy Shimkus advice I got mine to work by replacing LINE 62 not 64 but I'm using a MAC so I don't if that makes a difference. Hope it helps.
I like it so much! Thank you for your tip!
Loved your voice..
do this work on voice too?
Thanks very good
What if there is a "meeting time "column on the Google sheet that contains date and time for a meeting and I want the SMS to be sent 1 hour and 10 mins to the time in the meeting time column. How do I go about this?
Any luck finding a solution? I have this same need.
@@collinrutherford2324 I was also looking for a similar solution, or one that would remind people to check in they hadn't already for the day
Nice! Thanks for sharing!
How to send an image? I've tried mediaURL. Not working.
Did you find a solution to do this?
Solved: Replace the line 64: with this line of code - "Authorization": "Basic " + Utilities.base64Encode(TWILIO_ACCOUNT_SID+ ":"+ TWILIO_AUTH_TOKEN)
Thank you 🙏🏽 this worked for me.
The code is basically the same except that I changed the quotation from a single to a double quotation mark
I still received the same error message as before but right after I received the error message on the sheet, I received a text to both numbers. I had two different numbers.
I tested each with its own unique message.
first number received the correct message and second number received its unique message too.
I will need to find out why I am getting the error message -> Cannot find method getRange(number,number,number,number,number). and yet received the sms
It is now line 62 in the sheets document.
@@jakev1341 I still got erorr message🥲
WORKED PERFECT!!!!!!!!
Can you put instructions on how to actually use twilio
Where is the script that I am replacing?
How can we send whatsapp messages via Twilio whatsapp message templates?
im having an issue saying the "TO Number is not a vaild number? Working on a Mac Anyone else?
Can someone please check if script is working? I put the acurate information from my Twilio account but error code 401 keeps showing on status
I am having the same issue any luck on the solution?
Yeah I'm getting that error as well
Line 64 of the code needs to be changed to:
```
Authorization: 'Basic ' + Utilities.base64Encode(TWILIO_ACCOUNT_SID + ":" + TWILIO_AUTH_TOKEN)
```
@@musickmann thank you so much!! this is working. :)
@@musickmann Still having some trouble with this. Do I need to add this exactly? Or how should I put it in?
Nice!
How would you specify a media url in the cell in order to send mms?
Hey mate! Did you find a solution?
@@shotwithxeph yes, but now à pain to send texts in the USA using Twilio
Thank you! Would love a way to select a quantity to send, for example Send 100, then Send Next 100, etc
Did you ever figure that out?
@@omar1187 no sorry, iv considered paying my developer to create a solution like this but with more functionality such as this... Otherwise i guess no one else sees that value
I can do Mail Merge for free. Can I do SMS for free?
People respond more to texts though
😎
Jet Thomas what are you up to
I don't have what out
this is horrible theres no tutorial