Google Apps Script Weekly Task Reminders

I want to run the script so that everyone gets a reminder about all tasks in the sheet that are assigned to them via email.


Google Apps Script Weekly Task Reminders script sends out reminders to task owners based on a time trigger (i.e. once a day, once a week). Column A is for the task owner’s email address and Column B is the task info. Only Column B is sent to the email recipient. You can use additional columns for notes or other data, but only Column B is emailed. All the tasks of a person are collected together and then sent out as one email. Everyone only gets one email per notification period.

The email recipient receives a table of all their tasks with a short message:

google apps script email

You can also directly test the script by using the Test option in the menu:

google apps script reminders

Directions on Use

For the Google Apps Script Weekly Task Reminders script to work you will need to create a sheet called Tasks. Fill out the task owners Email in Column A and the Task Name in Column B. Add additional columns to suit your needs!

google apps script sheet


Code (see further instructions below the code): 

The Google Apps Script Weekly Task Reminders script can be copied from

Install Script

1. Open Script Manager by going to Tools->Script Manager in the apps script editor

2. Copy the above code into the Script Manager (don’t forget to save!).google apps script script

4. Authorize the script to run by going back to the spreadsheet, refreshing it, and selecting
Settings->Authorize. You will be prompted to Authorize and receive and email.

google apps script auth


google apps script auth 2

5. Set-up the triggers so that the script runs when the form is submitted.

  • Open up the Script Manager (see above).
  • Select the trigger icon.

google apps script trig

  • Set-up a timed trigger like below. Adjust the settings to fit your needs.
    google apps script trig 2



You May Also Like

About the Author: shodg001

Leave a Reply