Do you use GoogleForms and/or Google Sheets regularly? I'm amazed at how many neat tools are available to enhance these two Google tools.
Here are a few of the ones I've noticed and, when possible, begun slipping into my arsenal of tools to take these two to the next level:
- autoCrat: A nifty tool for blending your GoogleForm responses into PDF templates. Imagine collecting data via GoogleForm then merging it into a PDF form you can print out. Here's how it's described: "Automates the creation and sharing of personalized (e.g. merged) Google Docs or PDF email attachments from columns of data in a Google Sheet. Optionally merge documents when forms are submitted!"
- FormLimiter: This has to be THE form enhancer that everyone has been clamoring for: "formLimiter automatically sets Google Forms to stop accepting responses after a maximum number of responses, at a specific date and time, or when a spreadsheet cell contains a specified value."
- FormPublisher: This is simply amazing, and solves one of the big challenges for folks--how to "disaggregate" data from GoogleForm responses into separate documents without having to export it into a database program or something else. "Form Publisher Add-On generates Google Docs or Google Sheets from a created template, using a Google Form responses."
- Form Router: Although only available to a "test group" (which it is easy to join, then you get access), "FormRouter appends Google Form question responses to additional Google Spreadsheet destinations." That means, you can send ONE Google Form responses to MANY destinations. That's cool.
- Flubaroo & Forms: This combination allows you to have self-graded assessments, as well as push the ability to notify students of their grades. Rather than use an LMS (e.g. Moodle, Edmodo) to assess teachers on digital citizenship with a multiple choice quiz (yes, we still do those), we used Flubaroo and a GoogleForm. Worked great! You may want to read this blog entry that goes into more detail.
- MailMerge Add-ons: If you're like me, you may have been using a bulk email program of some sort (e.g. MaxBulk Mailer) to get messages out to lists of people. Now that I carry a Chromebook, I want the same ability with GoogleApps.
Although this is the view of "Yet Another Mail Merge" add on, the brightly colored box to the right highlights "Styles" add on for GoogleSheets. It makes it easier for you to format the data in your cells.
- Yet Another Mail Merge - While it may be "yet another" one, I've used this one to great effect. Folks have no idea that you've done a mail merge from a GoogleSheet, and it makes it easier for you as the email sender to customize the information. There are a zillion uses of this in education, especially for campus/district administrators.
- ValMerge - I ran across this one at Spreadsheet Madness and haven't used it yet. Looks fairly straightforward.
Ok, if you're like me, this list is already TOO long and you are going to need some serious playtime. Have fun and check back for the second part of this post on GoogleSheets!
Other neat stuff to check out:
View my Flipboard Magazine.
Make Donations via PayPal below:
Everything posted on Miguel Guhlin's blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure