You can explore our Mail Merge addon.
It can send data in Google Sheets at a specified date and time and you can specify it in the sheet itself under the Scheduled Date column.
https://gsuite.google.com/marketplace/app/mail_merge_with_attachments/223404411203
That's really my question. It appears I have to pay the additional $29 to use both Document Studio and MailMerge, but I'm not sure the schedule trigger will work on a "Today" date value.
You can use the basic version of the Mail Merge - if you are sending only a few emails per day, it will work without having to upgrade to premium.
The date is not fixed. The form submission come in up to a week before the Announcement date on which I want to send the emails. This would mean that the trigger would be when the Announcement Date = Today and I don't see how to do that.
MSAG Webmaster
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.