I am back! After a very long break from blogging, I am back with a free gift for the holidays. I created a Google Spreadsheet that combines contact information, contact log, schedule, and automated reminder email system into one spreadsheet. I call the file Contact&Schedule+Ultra as a nod to my family’s favorite anime series. This file simplifies emailing reminders for teletherapy. With one click you can email an entire day’s students/parents to remind them that they have a scheduled session. With two clicks you can open automated emails for all the scheduled day’s sessions with the meeting information for each session.
Unfortunately, there are some limitations to use the file to create emails. As far as I have tested, it only works if you have web email client (Gmail, Outlook.com, etc.) set as default to open your emails. To figure out what your current default email app click on this link. If the link opened another tab or window of your web browser then you should be set. Copy the file at the end of this post and try it out.
If the link opens your Mail app on your computer and asks you what account you want to use, email automation will not work. You can either change your default email app/handler or not use the email automation part of the file. Here are a couple of links to how to change your default email client to Gmail.
https://www.cloudwards.net/how-to-make-gmail-your-default-email-client/
Below is a link to the free Google Sheets File in my Teachers Pay Teachers Store. The first tab is a tutorial on how to use the file.
Educators Don't Get Apples! 