How I created a bulk SMS system using Twilio and Google Sheet with no code
Twilio is the best SMS platform in the world. But you will never be able to use it without writing code. But I found a simple hack that will enable you to send Bulk SMS and single SMSs using only Twilio and Google Sheets. with some help from Zapier.
Follow these simple 4 steps to create your own bulk SMS platform.
1- Create a Twilio account
Easy account creation steps, verify your email and mobile number, nothing much to say here.
Just make sure to have your own number and take note of your SSID
We are going to test the process on your verified number so a free account will do the trick for now.
2- create a Google Sheet
We all know how to do this Google Sheet with columns named.
Create a google sheet and name the first column "Phone Numbers"
3- Create a Zapier account
If you haven't tried Zapier before you are missing a lot in your life. Now create a free Zapier account (also the free account will be enough for the testing but won't hold send bulk SMS, you have to upgrade to a paid account or use the 14 days trial)
4- connect your Twilio to Google Sheet using Zapier
This is the most tricky part of this solution
a- Start a new zap (Google Sheet to Twilio Zap)
b- Connect Zapier to your Twilio account
C- Connect Zapier to your Google account
The concept of this Zap is to send SMS from your Twilio account every time a new row is added to your google sheet.
Will mark that Zap will use the "Phone Number" as the phone number to send the SMS to and the message will be set by you in the Zap.
Now test your Zap, add your number to the phone number field in Google sheet and then wait to recite the SMS on your phone.
Now you can use this as your SMS platform.
Tip: you can use Google form instead of the google sheet and enter the data manually if you want, this data can include the SMS content you want to send.
Twilio is, without a doubt, the best SMS platform available in the market.
But using Twilio without knowing code is almost impossible. If you want to send SMS for your clients, you need to code some PHP or Node.js however in the current No Code environment I was able to create the perfect system to send bulk and individual SMS without coding and using only Google form.
In Egypt, there are regulations that won't allow you to send any SMS with ID if you are not a registered company in Egypt and the SMS ID is part of the registration name in the Commercial record. This is why I used this hack to send SMS for my startup as I'm still validating and will not register my company soon.
