How can i get my google sheet data in my cell phone as text message in android

[Suresh Mathew]

I am Suresh Mathew, works for TRIPENTICER holidays. i am getting an average 7 to 8 enquirers everyday,  through my google site contact form . (www.ecogreenkeralaholidays.com). Now i look in google spreadsheet  for to get details. Is there any arrangement to get this enquey data from sheet to my mobile as a text message. Can you help me

[Darren D'Mello]

Yes you can do that using Text Local API.The text local sms provider pricing details are available on their website https://www.textlocal.in/bulk-sms-pricing-india/

We are not affiliated to text local sms provider in any way. However I had done the similar coding for my school. You can contact me https://www.digitalthoughts.science/contact if you are interested for configuration

You must use the on change trigger or if your spreadsheet is updating using the form then you may use on submit trigger. More details are avilable here https://developers.google.com/apps-script/guides/triggers

var url = "https://api.textlocal.in/send/?apikey=<API_KEY>&sender=<SENDER_CODE>&group_id=" + groupId + "&message=" + message

UrlFetchApp.fetch(url);

On Tue, Apr 21, 2020 at 10:53 AM Suresh Mathew <sur...@ecogreenkeralaholidays.com> wrote:

I am Suresh Mathew, works for TRIPENTICER holidays. i am getting an average 7 to 8 enquirers everyday,  through my google site contact form . (www.ecogreenkeralaholidays.com). Now i look in google spreadsheet  for to get details. Is there any arrangement to get this enquey data from sheet to my mobile as a text message. Can you help me

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/39947284-ba0e-44d5-9c3d-0511149cae60%40googlegroups.com.

--

Best,

Darren