Looking for a Better Way
Greetings!
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.
Cheers!
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.
Cheers!
Comments
Post a Comment