I was playing with the new Automation feature today and found a useful way to create a master list of date notifications (instead of using a calendar). All you need is a single Automation, and you can create a list that will send notification emails from spreadsheet.com with a specific SUBJECT and MESSAGE to a specific USER.
Here is a screenshot showing how to set up the worksheet.
NOTES: You need to make sure the DATE column is the Date data type (doesn’t currently work with a Column Formula data type). Also, make sure the USER column is the User data type.
Here is a screenshot of the worksheet Automation after it is created.
Here is a more detailed screenshot showing the notification email. It is really cool how you can include fields within the subject and body of the email.
So far, I’ve experimented with a few different formulas for the date, including the following:
Specific day of the year (such as a birthday)
Monthly recurring notification
Last day of the month
Daily quote from a list
And yes, you could create all of these types of notifications (except the random quote) individually using the “Recurring” automation trigger, with greater flexibility in defining the recurrence, but the beauty of this master list is how simple it is to add new notifications by just adding a row to the table (if you are comfortable using or copy/pasting the formula for the Date column).
This simple new feature in spreadsheet.com is going to replace my need for using 3rd party email reminder services.