How to set webhook body to google script dopost for alphanumeric sms

[167]

Hi,

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.

Google script side :

var payload = {
“To”: “+xxxxxxxxxxxx”,
“Body” : “testing message”,
“From” : “company”
};

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 am new to coding, please guide me