You have chosen to sponsor your bid up to a maximum amount of .
NEED THIS DONE URGENTLY!!
Send SMS via e-bulksms.com API based on trigger. API sample is http://e-bulksms.com/smsServerlet.php?obj=bmljaG9sYXM&key=xxxx&to=8888&sms=Testing&sender=9999
I would want variables for;
a) TO number/s b) Message content c) From Number
Message content (b) becomes the trigger variable; any change in current message value triggers an auto-response from e-bulksms.com API.
Ideally I would prefer 3 spreadsheet tabs; 1 for Incoming SMS (refer to 1 above), 2 for Outgoing SMS (refer to 2 above) and 3 for Datasheet. The variables; a) to c) should be cells where data can be inputted automatically or manually (in Outgoing SMS tab 2).
This is for sending BULK SMS so code should address time out issues as To numbers will be lots at any one time.
This is the link to Google Doc spreadsheet with the sample data tabs = > https://docs.google.com/spreadsheet/ccc?key=0AifTCZJ3Wlb-dHB5UWRaMktKZEFkazJDUFB6dTZYdkE&usp=sharing
Copy file and carry out testing and if you can show me the script works perfectly, you will be awarded the project. This should be pretty easy for experienced google script experts.