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 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.