If you’re a Google Sheets user, you know that the free online spreadsheet tool is easy-to-use, has powerful capabilities, and can save you tons of time. But did you know there’s even more you can do with your spreadsheets using Google Sheet add-ons?
Google offers hundreds of add-ons and extensions that can do everything from creating reports to translate your spreadsheets. To save you the work of going through all these options to find what you need, we’ve picked out our 15 favorite Google Sheets add-ons.
How to install Google Sheets add-ons
To install a Google Sheet add-on, simply open up a new or existing Sheet. Then click ‘Add-ons’ from the upper toolbar and select ‘Get add-ons’ from the drop-down menu. This will open up the Google Workspace Marketplace, where you can search for a specific add-on or browse through their selection.
Once you see an add-on you’d like to add to your Google Sheets workspace, click on it and then press the blue ‘Install’ button. To uninstall any add-ons, just click ‘Manage my add-ons’ from the same ‘Add-ons’ toolbar option. That’s really all there is to it!
Now let’s get to the list.
Unito is a platform with the deepest two-way integrations for some of the market’s top work tools. You can build deep connections between your Google Sheets and any other tool in your stack, from Trello to Slack, Asana to GitHub, and more. Unito has a host of features for empowering the workflows your teams need, including:
- Rules, so you can decide how much information travels between tools
- Custom mappings to get that information exactly where it needs to go every time
- The activity stream, for that bird’s-eye view of everything that’s happening in your workflows
- And more!
You can use Unito for 14 days, absolutely free, with no commitment required. After that, you’ll find that Unito has plans for organizations of every size.
Curious to see how this works? We build a project reporting template for Google Sheets that’s designed to work with Unito so you can automate your reporting workflows. See the template — and how it works — here.
Like the Google Suite, the Google Analytics extension is completely free. It lets you analyze your site’s statistics in a simple way, gather data from a variety of sources and add it to spreadsheets. You’re able to organize and structure data in a way that makes the most sense to you and add visualizations to a dashboard. Once you’ve sourced the data you need, you can also create and schedule reports.
Something to keep in mind: it doesn’t automatically refresh in real-time like other tools in the Google Suite. This means you will have to manually refresh it any time you want to view updated data. However, this lets you instantly compare different data sets and monitor any changes.
If you run any paid campaigns, the AdStage Google Sheets add-on is a must-have. When an ad campaign has a significant budget behind it, you need robust data to track and tweak performance.
The AdStage add-on lets you analyze PPC performance data across multiple ad platforms including Facebook Ads, Twitter Ads, LinkedIn Ads and of course, Google Adwords. This data is added straight into a Google Sheet so you can easily review and use it to inform the structure of future campaigns. Instead of trying to create your ads, switch between a variety of networks and logins, analyze your paid campaign data, and then optimize future campaigns, the AdStage Google Sheets extension streamlines your workflow in one place.
AdStage offers a free trial, with their paid plans starting at $29 a month for unlimited seats and ad accounts.
While you might often use Google Sheets to make straightforward spreadsheets, the Template Gallery add-on shows you just how much more can be done with the tool.
Template Gallery provides more than 100 templates that can help you fill out calendars, create schedules, build invoices and timesheets, create and manage budgets, keep track of your finances, and more. You can search for relevant templates by keyword and then simply copy your selection over to your Google Sheet.
And good news: Template Gallery is completely free to use.
If you have information in a Google Sheet that you’d like to transfer into a Google Form, the Form Builder Google Sheets add-on does exactly that. You can easily import content for the fields, questions, and answers portions of a Google Form right from Google Sheets.
Once your content is transferred, you can customize the configuration and structure of your Google Form, reorganize data, and make quick mass changes for options such as multiple choice or dropdown menus. Form Builder will automatically format your existing Google Sheets and can differentiate between questions and answers in order to import efficiently and accurately.
While not necessarily a drawback, many users who regularly create quizzes have requested more options when it comes to question randomization. They’d like to be able to have Form Builder randomly select a number of questions for them in order to increase the variety of content and limit possibilities for plagiarism.
As for cost, your first 50 imports with Form Builder are free, with paid plans available for professional and business users.
The Twitter Archiver extension is an invaluable tool for social media marketers. To use Twitter Archiver, search for a keyword or Twitter hashtag of your choice. Any Tweets that come up in the results will be automatically saved to a Google Sheet.
This lets you easily monitor any conversations surrounding your brand, the popularity of relevant hashtags, or competitor’s Tweets and mentions. You can also search by geo-tagged content, which shows you the kinds of Twitter conversations happening in specific geographic locations. For example, you could search a geo-location where your organization’s annual industry conference is being held, see the Tweets sent by participants and speakers, and save these all automatically to a Google Sheet.
Something to be aware of is that you may have to manually remove duplicate Tweets since Twitter Archiver will automatically pull all results into a Google Sheet.
The basic version of the Twitter Archiver Google Sheet’s add-on is free to use, while the premium plan costs $29 a year.
Advanced Summary connects your Google Form data with Google Sheets by instantly creating a report from your Form data and results. For businesses, this means you’ll save time manually analyzing survey data from your Google Forms.
One of the key benefits of Advanced Summary is the ability to filter your results based on the demographic and psychographic information collected through your Forms. The tool includes interactive filters so you can find the info you need without hassle or extensive searching.
Advanced Summary will also automatically create the most appropriate chart type (e.g. pie chart, color-coded table, word cloud) for your Form section and visualize your data in a way that makes the most sense. You can then embed these results anywhere, or export to a PDF for quick and secure sharing.
When reviewing your data, you may occasionally encounter a “Not found” error message. This is a rare bug that seems to happen at times when none of your Form respondents choose a select answer, which may impact the visualization of your data. When this occurs, simply close and reopen your Google Sheet.
Advanced Summary’s free plan has a 500 pageview limit, while their unlimited paid plan starts at $39 per user per month.
Translate My Sheet
If you work with organizations across the world, or if your own business is international, the Translate My Sheet Google Sheets add-on is an incredibly valuable tool.
With more than 100 languages available, Translate My Sheet does exactly what its name promises. With just one click you’re able to instantly translate your entire sheet, or a selection of rows and columns. The add-on automatically detects the source language, so all you have to do is select the language you want to translate to.
Translate My Sheet works best with a smaller volume of data — under 100 rows or columns — but will get the job done no matter how large your Sheet is.
The free version of the tool includes everything you’ll need to get started, while the $8 option offers unlimited translations.
If you love visualizing your data, you’ll love the Awesome Table Google Sheets add-on. This extension makes your spreadsheet data understandable and accessible for all viewers.
While some users say that using HTML or CSS empowers you to get the most out of the tool, the overwhelming positive reviews speak for themselves.
Awesome Table is available on a free plan with a 500 pageview limit, while the paid plan starts at $39 per user per month.
Yet Another Mail Merge
Yet Another Mail Merge (or YAMM for short) is a Google Chrome Extension that lets you use Google Sheets to optimize your email strategy. How does it work? First, you import your contacts into a Google Sheet. Then you create a draft email in Gmail and launch the YAMM extension. Once you’ve done that, you can send your emails with just one click right from Google Sheets. You’re able to customize email content directly in Sheets (using commands), and personalize each email to specific recipients.
After you’ve sent your emails, YAMM allows you to track them in real-time in your Sheet. You can see who’s opened your email, who unsubscribed, who responded, and which emails bounced.
YAMM is free for up to 50 emails sent per day, while paid plans start at $28 per year and include scheduled delivery and up to 400 emails per day.
Businesses like GE and ESPN have used the AppSheet add-on to create mobile workplace apps in Google Sheets without having to use any code.
To use, add your data (such as contacts, inventory, products, etc.) to a Google Sheet and connect the AppSheet add-on. From there, customize columns, add images, text, forms, or other branded assets. AppSheet will then automatically create an easy-to-use app from this data.
While some say there’s a slight learning curve if you’re a complete novice, AppSheet’s support and customer service team has stellar reviews.
Using AppSheet to develop apps is free, but prices to publish start at $1 a month per user.
Used by more than 16,000 businesses including Shopify, L’Oreal, and Dyson, Supermetrics is the quintessential marketing add-on for Google Sheets. Supermetrics integrates SEO, SEM, web and social media analytics. It does this by connecting with tools like Google Analytics, Facebook Ads, MailChimp, SEMrush, Moz, and AdWords. With Supermetrics, you can streamline metrics and data from more than 80 different sources and sync it all straight into Google Sheets.
The data you work with in Supermetrics will be clean and ready to analyze, so you don’t have to waste time sifting through and reorganizing it. The tool includes a comprehensive selection of templates, but also lets you build custom reports and dashboards to fit your needs.
According to some users, onboarding can take a little bit of time. However, once you’re familiar with the tool it can save you tons of time when it comes to reporting.
Supermetrics offers a free 14-day trial, with paid plans starting at $69 a month.
The Lucidchart Diagrams Google Sheets add-on is an intuitive, cloud-based tool that helps you build visual flowcharts, mockups, mind maps, diagrams, and other methods of data visualization. With drag-and-drop functionality, you’re able to easily create interactive visuals that present your data in an engaging way.
This extension can integrate with Google Drive, Slack, Jira, Salesforce, Microsoft Office, and Microsoft Teams. Used by more than 15 million people and industry leaders such as Uber, Google, and Visa, Lucidchart Diagrams offers real-time collaboration (including group chat functionality), version control, customized templates, and extensive security features.
One thing to keep in mind is that the Lucidchart Diagrams is free for up to 60 objects, something that may not be immediately clear upon use. After that, their paid plans start at $7.95 per month per user.
Looking to spruce up your Google Sheets? The Flaticon add-on is currently the largest free database of icons for use with the Google Suite. Choose from more than five million customizable icons and simply click to add wherever you see fit.
Flaticon provides an intuitive search function that lets you find icons for tons of situations, whether you want an image of a trophy or an avocado. Once you’ve selected an icon, Flaticon will then show you icons in the same style and palette so your Sheet remains visually consistent and aesthetically pleasing.
Although Flaticon lets you customize icons with color selections, it would be great if businesses could upload their own icon creations to their icon libraries.
As mentioned above, Flaticon is free to use.
The Power Tools add-on for Google Sheets includes more than 30 solutions for some of the most popular tasks in the platform. With Power Tools, you can clean up your data, combine multiple Sheets, delete duplicate information and values, reformat your Sheets, bulk remove empty rows and columns, and much, much more.
Once you’ve used Power Tools for a while, it will save you even more time by remembering the solutions you’ve previously used so you can quickly re-apply them to new data.
While Power Tools mostly has positive reviews, some users have requested more thorough tutorials and help desk resources to speed up the onboarding process.
Power Tools offers a free 30-day trial. After that, paid plans start at $43.20 per year.
Google sheets is an incredibly powerful tool, and as a free alternative to other popular spreadsheet platforms, it’s found its place in tool stacks across a number of industries. But, with the right Google Sheets add-on, you can turn this tool into a robust platform for anything your organization needs done.