twilio - Send SMS from Google Sheet -

-

i got script send sms rows in google sheet using twilio example.

i want send sms acknowledgement customers below google sheet

https://docs.google.com/spreadsheets/d/1jpka0wn8cq6j6be8ks5vf-jj50ykdcumietrwjai7kw/edit?usp=sharing

i want sms go once customers whom status not starting "sent" , phone number starting "+91"

the sms this

complaint no "ser 160530" registered on "16/5/16" customer "tneb" due "ct failed". please call 18004257865 details

the message made of text , value cells in particular row "status" column must updated "sent sms xxxxxxxx on xxxx @ xx:xx:xx:xx" possible run script every 1 hour automatically? there free alternative send sms google sheet?

to execute script every hour can set time driven trigger. here documentation setting trigger.

here workaround sending texts out of google sheet free, might not work specific need, option:

every mobile phone carrier offers email sms option free. examples of these email addresses here. example if wanting text on sprint network attach phone number domain like: 13032223333@messaging.sprintpcs.com. if able collect or carrier phone numbers can set simple function connect 2 , use mail merge option 1 below send out texts. here documentation the mail merge mark sent messages , prevent multiple texts going out same contact.

// constant written in column c rows email // has been sent successfully. var email_sent = "email_sent";  function sendemails2() {   var sheet = spreadsheetapp.getactivesheet();   var startrow = 2;  // first row of data process   var numrows = 2;   // number of rows process   // fetch range of cells a2:b3   var datarange = sheet.getrange(startrow, 1, numrows, 3)   // fetch values each row in range.   var data = datarange.getvalues();   (var = 0; < data.length; ++i) {     var row = data[i];     var emailaddress = row[0];  // first column     var message = row[1];       // second column     var emailsent = row[2];     // third column     if (emailsent != email_sent) {  // prevents sending duplicates       var subject = "sending emails spreadsheet";       mailapp.sendemail(emailaddress, subject, message);       sheet.getrange(startrow + i, 3).setvalue(email_sent);       // make sure cell updated right away in case script interrupted       spreadsheetapp.flush();     }   } }

Comments

Post a Comment

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

-
this error has shown on many times, seems. prominent answer issue seems restkit 0.20 — coredata: error: failed call designated initializer on nsmanagedobject class however, solution posted doesn't work me. let's start beginning: i want upload file server. want parse response make sure uploaded. if not, try again later. model has boolean variable called nsnumber *senttoserver purpose (in coredata, bool saved nsnumber ) . because don't know whether sending going successful, save entity coredata model first before sending via restkit. when post request successful, server returns json string this: {"id":14,"created":true} notice that, of course, id not set on coredata model yet, both id , created new informations model. here's model: @interface recording : nsmanagedobject @property (nonatomic, retain) nsstring * audiofilepath; @property (nonatomic, retain) nsdate * createdat; @property (nonatomic, retain) nsstring * deviceid; @...
Read more

java - Digest auth with Spring Security using javaconfig -

-
so i'm trying create digest authentication spring following documentation trying translate xml "requirements" in java requirements. let's have xml in docs: <bean id="digestfilter" class= "org.springframework.security.web.authentication.www.digestauthenticationfilter"> <property name="userdetailsservice" ref="jdbcdaoimpl"/> <property name="authenticationentrypoint" ref="digestentrypoint"/> <property name="usercache" ref="usercache"/> </bean> <bean id="digestentrypoint" class= "org.springframework.security.web.authentication.www.digestauthenticationentrypoint"> <property name="realmname" value="contacts realm via digest authentication"/> <property name="key" value="acegi"/> <property name="noncevalidityseconds" value="10"/> </b...
Read more

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -

-
my .env: app_env=local app_debug=true app_key=myappkey app_url=http://localhost db_connection=mysql db_host=localhost db_port=3306 db_database=gestiontaller db_username=root db_password='root' cache_driver=file session_driver=file queue_driver=sync redis_host=127.0.0.1 redis_password=null redis_port=6379 mail_driver=smtp mail_host=mailtrap.io mail_port=2525 mail_username=null mail_password=null mail_encryption=null i've tried password ", ' , without, restarting server every time. i've tried changing localhost 172.0.0.1. yes, password correct, running mysql -u root -p introducing password root in prompt can go mysql. users table: +------------------+-----------+ | user | host | +------------------+-----------+ | debian-sys-maint | localhost | | mysql.sys | localhost | | root | localhost | | root1 | localhost | +------------------+-----------+ i've added homestead.yaml this: database_port: 3306 ...
Read more