I have a sheet that will be collecting data through a form. We want an email to go out to a team of people every Sunday morning as a reminder for them to complete the form for that week. It should include a link to the form.
I was playing around with notifications and tried doing one to test it out. Unfortunately, I haven't been able to get it to work. There is nothing in the sheet itself to trigger this automation. I simply want a notification to go out if it happens to be a Sunday at 7:00 a.m. Is this possible? Normally there has to be some kind of trigger within the sheet, so I'm not sure. I did remove the recipients before creating the attached picture. All help is appreciated. Thanks.