Google-apps-script – Send recurring reminders to Google Form respondents

google-apps-scriptgoogle-forms

I need to create a Google form like below :

enter image description here

My objective is to send an reminder of Activity Described in < Your Activity > Question

Then I need to send reminder email to email mentioned in < Email > Question, With Selected Frequency in < Frequency > Question i.e. recurring reminders !

I searched for examples and add-ons but haven't got anything. I think I can program it with someone's kind guidance.

Best Answer

You can do a lot of things with Google Forms responses with basic programming skills and knowing JavaScript as ome tasks with Google Forms responses could be automated with Google Apps Script with a bounded script to the form.

One of the keys for your project is to use Google Apps Script installable triggers, specifically time-driven triggers to be able to do automate recurring tasks like sending recurring reminders.

References