How to send text messages using Google Sheets and Twilio

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/Sheets...
Customizing G Suite playlist → goo.gle/2Rp30br
Subscribe to G Suite → goo.gle/GSuite
Product: Google Sheets; fullname: AGV;
#SheetsToApps #CustomizingGoogleWorkspace

[@vjs717]

Can I capture a reply to the text in a sheet?

[@AnchorHomeOffers]

How would you create a delay of 1 minute between messages being sent in the script?

[@americasfunniestfurbabies2718]

Can y’all put in a updated sheet that actually work

[@MauriceTHEVOICEWatts]

It works you just have to update line 62

[@manjuenyu6593]

@@MauriceTHEVOICEWatts I still got error code 401 even I replace line 62

[@MauriceTHEVOICEWatts]

@@manjuenyu6593 Sorry, I've moved on to a Plugin that handles all my SMS & MMS needs with Twilio.

[@otmanalami6621]

do i need to press send or can i do it automatically when a row is created? Thanks ^^

[@jerichomauricio9005]

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.

[@MauriceTHEVOICEWatts]

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.

[@lucaseroles4539]

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

[@shawnjones5643]

I am having the same issue any luck on the solution?

[@n0oo7]

Yeah I'm getting that error as well

[@musickmann]

Line 64 of the code needs to be changed to: ``` Authorization: 'Basic ' + Utilities.base64Encode(TWILIO_ACCOUNT_SID + ":" + TWILIO_AUTH_TOKEN) ```

[@queenniedublin9967]

@@musickmann thank you so much!! this is working. :)

[@Newlimitshomes]

@@musickmann Still having some trouble with this. Do I need to add this exactly? Or how should I put it in?

[@vikaskaranpage]

Solved: Replace the line 64: with this line of code - "Authorization": "Basic " + Utilities.base64Encode(TWILIO_ACCOUNT_SID+ ":"+ TWILIO_AUTH_TOKEN)

[@thecoachesradar1134]

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

[@jakev1341]

It is now line 62 in the sheets document.

[@shirleyyukang]

@@jakev1341 I still got erorr message🥲

[@stealthcovert]

WORKED PERFECT!!!!!!!!

[@TheCorpOfc]

Nice!

[@FrankB4U]

How would you specify a media url in the cell in order to send mms?

[@shotwithxeph]

Hey mate! Did you find a solution?

[@FrankB4U]

@@shotwithxeph yes, but now à pain to send texts in the USA using Twilio

[@robertforestkinnett4522]

I can do Mail Merge for free. Can I do SMS for free?

[@cj1871]

People respond more to texts though

[@climblife]

this is horrible theres no tutorial

[@anushkanandi2305]

How can we send whatsapp messages via Twilio whatsapp message templates?

[@InsideMyWall]

How to send images and attachments from google sheets to whatsapp??

[@XPEDigital]

Where is the script that I am replacing?

[@abidefromguideposts3216]

How to send an image? I've tried mediaURL. Not working.

[@MauriceTHEVOICEWatts]

Did you find a solution to do this?

[@yanicksaint-elien4132]

That comes just at the right time!

[@ribierahmadalkeni8453]

Thanks very good

[@opekatakata1424]

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?

[@collinrutherford2324]

Any luck finding a solution? I have this same need.

[@jakeblattner6769]

@@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

[@samvan7787]

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?

[@mariastephen9975]

Loved your voice..

[@DaveWaveCaptured]

im having an issue saying the "TO Number is not a vaild number? Working on a Mac Anyone else?

[@oracle_professor]

It's a good tutorial Thank you.

[@baselhakim2080]

how would you be able to personalize each message if sending to a large list with several variables?

[@FrankB4U]

By using concatenate gathering details from the different columns in your contact list

[@jjc6530]

Can you put instructions on how to actually use twilio

[@tonijanezarate6546]

do this work on voice too?

[@gunjanigupta]

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.

[@ruchikadias1741]

Thank you so much! This was really helpful and saved me so much time.

[@karncheabarchue8014]

Great video and easy to follow!

[@NinaBanday]

Nice! Thanks for sharing!

[@ampheremotovlog1926]

I like it so much! Thank you for your tip!

[@janetsmothermon5675]

Jet Thomas what are you up to

[@janetsmothermon5675]

I don't have what out

[@the7odmelmoney]

😎

[@christophermichael3674]

Thank you! Would love a way to select a quantity to send, for example Send 100, then Send Next 100, etc

[@omar1187]

Did you ever figure that out?

[@christophermichael3674]

@@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