#ISTE: Formmule Rocks!

I have been finding myself using Google Forms very often for sign-ups; however, what if there were a way to send confirmation emails to workshop attendees? I recently found a way that I can create a Google Form with several different workshop dates and use a Google Sheets Add-On called Formmule to send an automated and customized message to participants. How did I do it?

Step 1: Create Your Google Form

Make sure that you request an email address from anyone filling out your form. If you are using Google Apps for Education, you can automatically collect this information by restricting who can access the form.

Step 2: View Responses

After you have created your form, you will need to access Form Results (where all of your results are compiled into a spreadsheet).

1. While you are still editing your Google Form, go to the Reponses Menu

2. Choose Form Responses

Step 3: Get the Formmule Add-On

Remember that all of the responses from your Form is compiled into a Google Sheet.

1. In this sheet, choose the Add-Ons menu and select Get Add-ons

2. Search for "formmule"

Step 4: Use Formmule

Check out my brief tutorial video to learn how to do this entire process in less than 5 minutes! Steps 1 - 3 are also mentioned in the clip!