
If you've been waiting to upgrade to the
new Google Sheets, here's a big reason to take the plunge:
Add-ons. These are just what they sound like - add on tools for a Google Sheet or Google Doc. Included in these add-ons are refreshed versions of some scripts we've come to know and love, such as
Doctopus,
Autocrat and
Flubaroo.
However, there are many more amazing automations found in the
Add-ons docs gallery and
Add-ons sheets gallery. You can either browse these by scrolling through or filter by topic - such as education, productivity, etc.
Here are a few gems I've found already:
Docs Add-ons:
- Easy Bib: This simply automates and simplifies the creation of bibliographies in MLA, APA or Chicago format.
- eSign / Panda Sign / hello sign: These three similar add-ons allow you to create digitally signable documents.
- Track Changes: Is revision history sometimes a bit hard to follow in a collaborative document? I agree! The Track Changes add-on allows you to accept or reject revisions as they come in, just like a certain popular desktop-based word processor.
- Thesaurus: I am so often opening a new window to find synonyms for words as I write these posts. Having a thesaurus built into the doc will make this so much simpler!
- gliffy / Mind Meister / WebSequence Diagrams: O.M.G. - love these three add-ons. They take text in your doc and turn it into a visual diagram! Mind Meister is probably the easist to use... give them a whirl!
Sheets Add-ons:
- Split Names: Ever import a list of student or staff names then have to alphabetize them by last name... but the names are all in one cell so you need to manually separate them? Not anymore - this add-on does it for you.
- Twitter Curator: Want to curate your tweets in a spreadsheet? Bam.
- DriveEye: Ever want to audit your own Drive to see what docs you've got in there and who they are shared to? I have, and have never been able to do it quickly in the past. This solves that problem!
Once installed, these add-ons will forever appear in the add-ons menu of your Docs or Sheets. No need to reinstall or reauthorize. Moreover, most use a handy side-bar navigation, making the workflow and user interface easy and convenient!
For sheets users, note that besides Doctopus, Autocrat and Flubaroo many other educational Google Scripts have yet to make the move over to the add-ons gallery. Additionally,
there are several features that haven't been completed in the new Google Sheets (such as notification rules and protected sheets/ranges). In this case, you'll want to continue using the older version of Sheets. To tell the difference between new sheets and old sheets, look at the bottom right hand corner of your screen for the green check icon (new sheets) or "Try the new Google Sheets" (old sheets). For more information on switching,
see this help article. (Note: Docs users don't need to switch versions - only sheets.)
To find out more about add-ons, check out
this blog post from the Google Drive blog. Also, if you're a developer or have some savvy coding skills, you can create your own add-ons!
Check out this site for more information.