“Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is most important.” —Bill Gates

Wednesday, September 23, 2015

Looking for a Better Way


In my previous blog post I wrote about my recent use of scripts and add-ons. I was thrilled to have found a way to make my work more efficient and effective. Shortly after, I was faced with a new challenge: How could we send approximately 170 emails (each one containing unique information, such as parent emails, usernames, and passwords) for each one of the second grade students?

In the past, I must confess, I composed one by one, each of the emails. But this time, I was determined to find a better way of doing this. I had a feeling that an add-on would do the trick. I had time to explore beyond the two tools I had just discovered, and that's when I came across formMule.

It didn't take long to figure out how to apply this tool to my personal needs. formMule is a free add-on for Sheets created by NewVisions CloudLab.

I had a Google Sheet already filled out that contained all the information I needed. I opened formMule and with very little configuration we were able to send off 170 emails with one click! Believe me, the time invested searching for the add-on and learning how to use it is just a tiny fraction of how long it would have taken to send one email at a time.

 I have learned that you have two options to apply formMule: On an already filled out spreadsheet, like I did, or triggered by responses coming in from a Google Form.

Yes! I know what you're thinking. This could have solved my previous problem about wanting to send confirmation emails when parents signed up in an even easier way.


No comments:

Post a Comment