Send List Emails With Time Trigger Google Sheets

How to use :
In Spreadsheet Menu Click Tools and select Script Editor from spinner to go put your script, in Excel "Visual Basic" on developer mode.
In Spreadsheet Menu Click Tools and select Script Editor from spinner to go put your script, in Excel "Visual Basic" on developer mode.
Open Google Apps Script file or create new one : File > New > Script File and name it with whatever you want .
1- Past the script in the bottom of Article and Save the Script.
2- Save the script.
Click that button to save setup the trigger
In that sample i make time trigger to run function sendEmails every hour !
What you need to change :
Line 6: Sheet name is Emails on default you change it according to your sheet name
Line 18: if status is not ready then skip that Email, if you want to avoid that type // in the start of the line.
Line 21: Avoid sending repeating emails each time.
Script :
Make Copy :
This comment has been removed by a blog administrator.
ReplyDeleteDoes it possible to connect to any other 3rd party SMTP? as gmail have limit number of send per day.
ReplyDelete