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.
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
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?
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?
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.
@@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
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.
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.
Great video and easy to follow!
Thank you so much! This was really helpful and saved me so much time.
It's a good tutorial Thank you.
That comes just at the right time!
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!!!!!!!!
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?
Loved your voice..
Can I capture a reply to the text in a sheet?
I like it so much! Thank you for your tip!
do this work on voice too?
How would you create a delay of 1 minute between messages being sent in the script?
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
Thanks very good
Nice! Thanks for sharing!
How to send images and attachments from google sheets to whatsapp??
Nice!
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
Can you put instructions on how to actually use twilio
How to send an image? I've tried mediaURL. Not working.
Did you find a solution to do this?
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
Where is the script that I am replacing?
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.
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?
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?
😎
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
Jet Thomas what are you up to
I don't have what out
I can do Mail Merge for free. Can I do SMS for free?
People respond more to texts though
this is horrible theres no tutorial