Limitations

Our add-on runs solely on Google servers and uses AppScript for all the processing. This imposes certain limitations on how, how many and when reminders are sent. Please get familiar with limitations below before starting out.

Free version limits

The add-on is available in 2 versions - Free and Pro, where Pro enables more features and has no usage limits.

Here’s how they compare:

Hours are approximate

When you select to be notified hours before(or after), the actual time when notification is sent can range anywhere between 2 hours to 45 minutes before the specified deadline. It is guaranteed that notification will be sent before the deadline, but the exact time may vary.

Some examples:

• 1 hour before 10 AM, you will get notified between 8:45 AM and 9:15 AM.
• 1 hour before 10:50 AM, you will get notified between 8:45 AM and 9:15 AM.

For highest precision and predictability, it’s best to choose times with 0 minutes for the trigger time, e.g. 10:00 or 14:00 instead of 10:05 or 14:35.

This behaviour is due to Google policy, which limits add-on time triggers to a maximum of once per hour.

Notifications are batched

When there are multiple notifications that need to be sent to the same recipient, the messages will be batched into one. Each message is put on a new line.

For example, let’s say you have following sheet data and you have setup an email reminder with content “Hi!”:

In this case John and Alice will receive 1 email each, with following content:

Hi!
Hi!

The same behaviour applies to Slack, Discord, Teams and Google Chat integrations.

Google Quotas and Limits

Our add-on is subject to Quotas for Google Services. The limits apply to both Free and Pro add-on users.

Some important limits that might affect add-on behaviour: