What Are the Best Add-Ons for Google Docs and Sheets?

June 20, 2016 Jiordan Castle

google

Google introduced add-ons to Google Docs and Sheets last fall, making both apps all the more valuable to users. If you haven’t noticed the change, it’s probably because you haven’t paid attention to the snazzy yet subtle “Add-ons” tab (sandwiched between “Table” and “Help”) at the top of your Docs and Sheets:

WA1

WA2

To save you time, I’ve compiled this list of particularly handy add-ons for both Google Docs and Google Sheets.

HelloFax

We haven’t managed to kill off fax machines quite yet. But we have managed to bring them into the 21st century. With HelloFax, you can — believe it or not — actually send a fax directly from a Google Doc.

Data Everywhere

Even if your company has already gone Google, you may have some holdouts still using Excel. Rather than tearing out your hair when it comes to the great Microsoft vs. Google debate, you can meet in the middle with Data Everywhere. Data Everywhere allows users to link Excel spreadsheets to Google Sheets, pull Salesforce reports directly into Google Sheets, and more.

WA3

Save Emails and Attachments

It doesn’t have a cool name, and that may be because Save Emails and Attachments is a no-nonsense add-on. It allows you to automatically download emails and file attachments from Gmail to Google Drive. Basically, your email threads are converted into high-quality, printable PDFs, and the original file attachments are saved in their original form in Google Drive.

Lucidchart Diagrams

I love Lucidchart because it allows me to fake design skills I don’t actually possess and quickly make beautiful (shareable!) charts, graphs, and diagrams. Lucidchart Diagrams makes things that much simpler; you can now create and insert flowcharts, diagrams, and more directly into your Google Doc.

Mail Merge with Attachments

Though this one is a little complex for my needs, sales and field marketing teams may love Mail Merge with Attachments, an add-on that makes it possible to send mass emails that read personal. The gist: You can send personalized emails with attachments to multiple people (and the emails will read as if it were sent to each individual person). You’ll even be able to tell when people have read your email (which is, let’s face it, equal parts useful and invasive).

WA4

EasyBib Bibliography Creator

Want to easily cite your sources without leaving your Google Doc? EasyBib Bibliography Creator helps you create a bibliography by automatically citing books, articles, and websites just by entering the titles or URLs. Are you a fan of MLA, APA, Chicago style, etc.? Great, because EasyBib’s got ‘em all.

Mapping Sheets

Make Google Maps come to life for you and you alone with Mapping Sheets, an add-on that enables you to plot your own data onto a Google Map directly from a Google Sheet. It’s simple: In your Sheet, put the location names in one column, the addresses in another column, and Mapping Sheets will concoct you a personal Google Map — just like that.

Remove Duplicates

There are few things more detrimental or irksome to a quality spreadsheet than duplicate data. With Remove Duplicates, you can do a couple of useful things: Compare 2 different tables or columns (and remove any duplicates), and/or search for unique and duplicate rows within a single Sheet.

Previous Article
Retail + Google for Work: How to Manage the Transition and Improve Your CX
Retail + Google for Work: How to Manage the Transition and Improve Your CX

Next Article
Today’s Tech Landscape and Things I Learned from My Dad
Today’s Tech Landscape and Things I Learned from My Dad

When we were growing up, my dad spent a lot of time in his home office with a variety of computers and nois...