The Schedule Reminders Add-On allows you to set a schedule of dates on which to send email reminders to specific people. Set it up once and be done.
Fiche mise à jour le :27 août 2023
Compatible avec :
101 k+
Présentation
**Usage Tips**
+This add-on is intended to be run on a single sheet at a time. Running across multiple sheets simultaneously is not supported.
+ Gmail quotas apply.  100 email recipients per day for free gmail accounts and 1500/day for Workspace accounts.
+ Stick to the provided template. Do not move around or delete template columns, as this will cause errors.  You can hide unused columns or , if you need to add in more data, you can do so after the last template column.
+ Make sure that you place only dates in the date fields and ensure that they are formatted as dates, formatted to align with your locale.   Example shows mm/dd/yyyy date format for USA. 
+ Do not delete the sheet that is automatically set up with the template.  If the sheet is deleted, you will need to rerun the setup to create a new one.
+When you are ready to stop using the Add-On, make sure that you Clear Settings first in order to remove all custom settings from your google sheets. 

Features:
+Enter one or more email addresses for the To: and CC: fields
+Define basic content for each email (NOTE: the column layout of the template should not be changed, since the Add-On needs those columns to function.  Additional columns can be added after column K)
+Include both an initial and follow up email for each event.
+Automatically send reminder the morning of the specified dates
+Ability to set Time of daily send
+"Run Now" Feature allows you to do a test run quickly  after setting up your sheet

INSTRUCTIONS
Set Up Sheet
+Use the Settings menu item in the Add-On menu
+Select time you want the daily email check to happen.
+Click on the "Set Up This Sheet" button to activate the current sheet and set the reminders template.

Schedule Reminders
+The template includes Notes in each column header with specific suggestions. 
+ (NOTE: the column layout of the template should not be changed, since the Add-On needs those columns to function.  Additional columns can be added after column K)
+The example shows how one reminder entry can be set up.  
+Use native Googlesheet features like formulas to copy similar rows, for example when sending the reminder to a similar event to different people on different days.
+The Add-On will check your sheet at specified time each day and will send out emails for any row where the reminder dates are the same as the current date.

Update and Clear Settings
+Use Settings to verify that your sheet has been set up and is active.
+Use "Set Up This Sheet" button in a new sheet if you want to change the Googlesheet you are using.
+Clearing settings will stop the nightly email send.
Informations supplémentaires
TarifsSans frais
Développeur
Non-professionnel
Règles de confidentialité
Conditions d'utilisation
Schedule Reminders vous demandera les autorisations ci-dessous. En savoir plus
Schedule Reminders aura besoin d'accéder à votre compte Google
Schedule Reminders pourra ainsi effectuer les actions suivantes :
Consulter, modifier, créer et supprimer toutes vos feuilles de calcul Google Sheets
Afficher et diffuser du contenu Web tiers dans les invites et les barres latérales au sein des applications Google
Autoriser l'exécution de cette application en votre absence
Envoyer des e-mails depuis votre adresse
Afficher l'adresse e-mail principale associée à votre compte Google
Consulter vos informations personnelles, y compris celles que vous avez choisi de rendre disponibles publiquement
Avis
Langue :
Trier par :
Google ne vérifie pas les avis ni les notes. En savoir plus sur les avis
Aucun commentaire
Recherche
Effacer la recherche
Fermer le champ de recherche
Applications Google
Menu principal