I am trying to send alphanumeric SMS but since APPSHEET does not support at this point, I have follow this solution Twilio sms workflow - #13 by LeventK with the help of using webhook and google script.
I have manage to use webhook to trigger google script to send http request to twilio send sms.
I need help on how to construct the json body of the webhook and match with google script side.
I only manage to trigger to send the content that is in the google script but how do I construct the json body of the webhook in appsheet to replace the content.
I trying to send sms reminder to customer
<<[customer contact]>>
<<[customer name]>>
<<[location]>>
<<[timeslot]>>
<<[status]>>
Sample:
Hi <<[customer name]>>,
Your appointment at <<[location]>>, <<[timeslot]>> is <<[status]>>.
Thank you.
I’m pretty sure you can specify a friendly name on the Twilio side, as far as I remember.
I made a few researches, here is what I found:
Please be aware all countries do not suppport this feature, as you can see in the section “Which Countries Support Alphanumeric Sender IDs?” from the last URL.
Also, section: " How to get an Alphanumeric Sender ID"
Twilio did support Aphanumeric sender ID but Appsheet current do not support the request to twilio.
The “from” in the sms task that you mention, only can put Twilio number and not Alphanumeric.
Therefore, base on Twilio sms workflow - #13 by LeventK, we can use appsheet webhook to send request to standalone google script dopost(e) http request to twilio to achieve the alphanumeric sender result.
So the issue here is, I manage to active the trigger but not sure how and where to control the content.
But the key here is ALPHANUMERIC SENDER, i will need to be able to send SMS with company name for the sender instead of showing twilio number.
My country did support alphanumeric sender, so the issue now is how do i amend the SMS content for between the APPSHEET webhook and Google script for the Http request to twilio.
