One of my sessions at the Alabama Educational Technology Conference related to Google Sheets Add-ons. As promised during the session, this post provides videos on each of those add-ons.
Rather than create the videos, I searched YouTube for what I thought were the clearest demonstrations. In each case, I asked the creators for their permission to publish the videos here. In each case, they quickly responded with an enthusiastic “Yes!”.
The New Google Forms
You may be familiar with Google Forms. Google made some major changes towards the end of November, 2015. The same options are available, but where to find them has changed. The changes are logical but will take some getting used to.
This video is from Shawn Beard, and it demonstrates the new changes. Shawn is the author of The Techy Coach Blog.
Want a possible selection on your Google Form to disappear when a certain number of people have selected it? Choice Eliminator does that for you.
Thanks to Brian Gray for the video he created. Visit Brian at his website: BrianGray.org.
You can always manually turn off a form so that it no longer accept responses. Form Limiter allows you to automate the process. You can have the form stop accepting responses:
- At a certain date and time,
- When the number of responses has reached a pre-defined limit.
- When a certain cell value in your Google Sheet reaches a certain value.
Michael Berago is the creator of this video. You can see more of Michael’s videos on his YouTube channel.
Mail Merge with Attachments
If you need to send the same basic message to many people, but need to personalize it for each one, this add-on is outstanding. You enter your data into a Google Sheet, compose your message with the help of the add-on, and your messages are sent through Gmail.
formMule can automate many workflows in your organization. Using the normal Google Forms and Google Sheets, formMule send emails at various points in the progress.
The first example is from Mickie Mueller. She is demonstrating how a principal can use formMule to collect data during classroom visits and send the results to the teachers.
You can see more of Mickie’s videos on her YouTube channel.
This next formMule example is from Jennifer Judkins. In this example, Jennifer shows how to create an absence request/approval system using formMule.
The final formMule example is from Erik Erickson. He is demonstrating how to use formMule to create a system for technology help requests.
You can view more of Erik’s video on his YouTube channel.
Tables are great for sign-up sheets, even on paper. A shared Google Sheet has replaced its paper counterpart in many schools. Lab Scheduler removes the maintenance aspect of having to clear dates from the past.
Greg Lawrence is the creator of this form. You can watch more of his videos on his YouTube channel.
How do you see using these Google Add-ons in your school or other organization? Are you already using any? Leave me a comment with how they are helping you. If you think this post would help others, please click the social media links to share it.