Below is a collection of Google Sheets add-ons that I believe every teacher and educator should at least be aware of. These are tools that provide you with tons of functionality hacks to enhance your productivity and facilitate your workflow. Some of the things you can do with these add-ons include: creating forms of various types (e.g., quizzes, assignments, surveys, etc), generate PDFs and documents from Sheets’ data, grade and analyze digital assignments, create a class website from spreadsheets, and many more.
An easy way to generate Google Forms to use for various educational purposes including for surveys, quizzes, assignments, feedback, etc.
Enhances teachers workflow by providing teachers with the ability to “mass-copy, share, monitor student progress, and manage grading and feedback for student projects in Google Drive”.
“Flexible, easy to use document merge tool that creates PDF or shared Documents from spreadsheet data”.
Wikipedia and Wikidata tools
This add-on is great for mining data for your classes. You can use Wikipedia and Wikidata tools to do a ton of information gathering, instantly. The add-on provides you with a host of custom lookups such as WIKITRANSLATE and WIKIGEOCOORDINATES. These functions pull live data straight from Wikipedia into a spreadsheet, enabling teachers to compile an up-to-date and accurate database of facts.
A Google Spreadsheets Add-on that helps educators quickly grade and analyze online assignments and assessments, as well as share scores with students!”
Allows you to create a website for your class using Google Sheets.
Allows you to generate documents (e.g., Docs, PDF, Sheets, Slides, Word, Excel, and PowerPoint) from data on Google Forms and Google Sheets.
Originally, Flippity was designed to help you create online flashcards from Google Sheets, but the range of templates now includes everything from quiz shows and crossword puzzles to spelling and typing tests. The add-on has recently been discontinued but all the same great templates are available directly via the Flippity website.