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 アプリ
メインメニュー