In this article, we will try integrating both ClickSend and Google Sheets. So what we want to achieve here is to send SMS notifications when there's a new row added on your spreadsheet.
So, let's get started.
Under Explore and Automate, Look for Google Sheets app
Then look for ClickSend SMS app
Scroll down a bit and you would be able to see ready templates available for you to choose from
On this article, we would be selecting the second template "When Row is created in Google Sheets, send Message via ClickSend SMS". Click Activate.
Connect your Google Sheets account and specify which spreadsheet and sheet to use
Configure the Send SMS actionFields: To - you can enter fix phone number value or dynamically fetch a phone number from the response data from the previous trigger.
Message - same with To field, you can enter fix message or dynamically fetch a value from the response data from the previous trigger.
Schedule - It has to be unix time stamp format. Leave it blank to send message immediately when trigger takes place.
From - Allows dedicated number, own number and Alpha Tag. Alpha Tags can only allow 11 characters without space. Leave it blank to automatically use our shared numbers.
When done, click Test and Go Live.
With those short and simple steps, your integration is ready and working!
