How to send text messages using Google Sheets and Twilio
Vložit
- čas přidán 9. 09. 2020
- Did you know that you can send text messages via Google Sheets? In this episode of Sheets to Apps, we show you how to easily send text messages with Google Sheets via Twilio - an online communications provider.
Previous Episode → goo.gle/2Dn32Mu
Copy sheet → goo.gle/3biSxqb
Instructions here → goo.gle/2Z1VC9b
Twilio → goo.gle/2EJmhRj
Google Apps Script → goo.gle/3cMWwLz
Beginner tutorial for Apps Script → goo.gle/2zOtDA6
Sheets to Apps playlist → goo.gle/SheetstoApps
Customizing G Suite playlist → goo.gle/2Rp30br
Subscribe to G Suite → goo.gle/GSuite
Product: Google Sheets; fullname: AGV;
#SheetsToApps #CustomizingGoogleWorkspace - Věda a technologie
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.
That comes just at the right time!
Thank you so much! This was really helpful and saved me so much time.
I like it so much! Thank you for your tip!
It's a good tutorial Thank you.
Great video and easy to follow!
do i need to press send or can i do it automatically when a row is created? Thanks ^^
Nice! Thanks for sharing!
Loved your voice..
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?
do this work on voice too?
Can I capture a reply to the text in a sheet?
Thanks very good
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.
How would you create a delay of 1 minute between messages being sent in the script?
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!
Can y’all put in a updated sheet that actually work
It works you just have to update line 62
@@MauriceTHEVOICEWatts I still got error code 401 even I replace line 62
@@manjuenyu6593 Sorry, I've moved on to a Plugin that handles all my SMS & MMS needs with Twilio.
Can you put instructions on how to actually use twilio
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?
How to send an image? I've tried mediaURL. Not working.
Did you find a solution to do this?
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
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?
😎
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
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!!!!!!!!