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.
应用详情更新日期:2023年8月27日
适用于:
10万+
概览
**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.
其他信息
定价免费
开发者
非交易者
Schedule Reminders”将请求获得以下权限。了解详情
Schedule Reminders”将需要访问您的 Google 账号
这样可让Schedule Reminders
在 Google 表格中创建电子表格,以及查看、修改和删除您在 Google 表格中的所有电子表格
在 Google 应用的提示和边栏中显示和运行第三方网页内容
允许此应用在您不在场的情况下运行
以您的名义发送电子邮件
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单