The Google Sheets add-on library contains third-party tools you can use within Google Sheets. Jess Stratton shows how to browse the library, install an add-on, and remove it later.
- [Instructor] You can take your Google Sheets use to new levels by using add-ons. Add-ons are third-party or Google developer software applications that are built directly into Google Sheets. You can add them on a one-by-one basis. Some are free, some cost money. To view the add-on library, click Add-ons from the top menu and choose Get add-ons. It's going to open up a new dialog box, and you can scroll to browse the add-on library. You can also search for particular ones by clicking inside the search box.
And you can also filter them by category on the top left-hand side. Clicking on each one will bring up a brief description of what it does. It will tell you how much it costs, and you can click the blue button to add it. I'll click the arrow on the left-hand side to go back to browsing. As you can see, I'm going to be scrolling for a while. There's a lot of add-ons made by a lot of different companies. A few good ones, there's Aylien Text Analysis.
Text Analysis shows you an easy way to view text. You can view them for things like sentiment. For example, positive or negative views by people. This is useful in conjunction with that last video on adding all Twitter mentions to a Google Sheet. This is a great way to find out how people are talking about you on Twitter. Another one that's good is called Mapping Sheets. Mapping Sheets will allow you to create your own data onto a Google Map based on address fields that you have in a spreadsheet.
This one's good for the list of conference attendees that we've been looking at in previous videos. It contains names, states of people where they're from, and full addresses. Let's find an add-on that we can add to Google Sheets and use. I'll pick one called Translate My Sheet. If I want to add it to my sheet, I can click the Free button. It's going to ask permission to access my Google Drive, I'll click the blue Allow button.
And now it's been added. To access your add-ons, click the Add-ons menu again. In fact, when you add an add-on like we just did, it's going to pop up with how to find it to get you started. I'll click the X to close out of this. I'll click Add-ons from the top menu, and you can see that there's now a new entry for Translate My Sheet. Once I click Start a new translation, Google Add-ons usually pops up a new pane on the right-hand side. Here you can see that Translate My Sheet is going to walk you through everything you need to get started.
I can close out of it by clicking the X in the top right-hand side. To work with any add-ons that you have, click Add-ons, and then choose Manage add-ons. If you've installed some add-ons and you decide you just don't need them anymore, find the add-on and click Manage, then scroll all the way to the bottom and select Remove. You can add it again by clicking the blue Free button, or if it cost money, there'd be a total there, or you can click the X in the top right-hand side.
Take some time, browse the add-on library, and see if there's anything that can really help you in your day-to-day work.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons