Start a new topic

Schedule Emails Based on Data in Google Sheets

Currently you can schedule the DS mailmerge to occur every hour or on form submit. 

 I would like to schedule a daily job based on a date in the spreadsheet.  I have a form for announcements that are scheduled up to a week in advance.  Users indicate the date on which they want the announcement posted/read and then supply a brief announcement message (<150 characters).  The announcements are sent to a committee which is responsible for posting and reading the announcements over a PA system.  

I would like the mailmerge to send the announcements for the next day (or the same day) to the announcers (a group defined in G-suite) based on that announcement date in the form/spreadsheet.  I don't know if this can be done with Document Studio or the Email Scheduler or some other tools from digitalinspirations.

Login or Signup to post a comment