The 19 best Google Sheets add-ons to boost your productivity

The 19 best Google Sheets add-ons to boost your productivity

Spreadsheet-related tasks—such as gathering data, formatting it, and turning it into easy-to-digest visuals—have a way of sneakily eating up all your precious time. One minute you’re filtering data—the next, you’re editing the x- and y-axis of a bar graph and tweaking the colors to make it less of an eyesore. 

That’s where Google Sheets add-ons come in. 

The Google Marketplace offers hundreds of time-saving add-ons to help you do complex calculations, auto-populate missing data, and send emails, among other things. I’ve tried out some of the top add-ons the Marketplace has to offer—here are the best Google Sheets add-ons to make spreadsheet management easier. 

Table of contents

Google Sheets add-ons vs. Google Sheets extensions

Google Sheets nests add-ons within the Extensions menu. Technically, this makes sense. But practically, it makes some people (me) think Google Sheets add-ons and Google Sheets extensions are the same thing. They’re not. 

  • Google Sheets add-ons are found in Google Marketplace and installed directly within Google Sheets to enhance the app’s functionality. 

  • Google Sheets extensions are found in browser extension stores and added to your browser, making them browser extensions. 

For the purposes of this article, we’re focusing only on Google Sheets add-ons. 

Note: Google Sheets add-ons can be installed via most desktop browsers and the Android mobile app. Add-ons are currently not supported by iPhone or iPad apps. 

How to use Google Sheets add-ons

Here’s how to find Google Sheets add-ons from your desktop. (The steps are similar if you’re using the Android mobile app.) 

  1. Open a new or existing spreadsheet in your browser. 

  2. Click Extensions > Add-ons > Get add-ons.

The Google Marketplace pop-up window will appear, and you can explore add-ons for every Google Workspace app, including Google Sheets. 

Google Marketplace popup with thumbnails of Google Sheets add-ons.

How to install Google Sheets add-ons  

Here’s how to install Google Sheets add-ons. 

  1. Click the add-on you want to install. 

  2. Click Install

  3. A pop-up window will appear, prompting you to give that add-on permission to install. Click Continue. You may also have to sign in to your Google account and then give the add-on access.

  4. Once the add-on has been installed, click Done

  5. To run the add-on, click Extensions, select the add-on you want to run, and click Launch

Expanded view of the Google Sheets Extensions menu with a list of installed Google Sheets add-ons.

If you don’t see the Google Sheets add-on you’ve installed in the Extensions dropdown, check the Google Sheets sidebar—that’s where some of them end up.

How to remove Google Sheets add-ons 

Before you give any apps permission to access your account, be “politely paranoid.” If something feels “off” about the app, listen to your gut. Don’t feel compelled to install it just because you’re afraid of looking paranoid or low-tech. 

Here’s the easiest way to uninstall Google Sheets add-ons.

  1. Click Extensions > Add-ons > Manage add-ons

  2. In the Google Marketplace window that appears, scroll down to Apps Installed by You, and find the app you want to remove. Or, enter the name of the app you want to remove in the search bar. 

  3. Click the Options icon, which looks like three dots stacked vertically (), and click Uninstall

Expanded view of the options menu for an installed Google Sheets add-on in Google Marketplace with the option to uninstall highlighted.

19 Google Sheets add-ons to enhance your work

Now that you know how to install your time-saving Google Sheets add-ons, here are the best ones to make gathering, organizing, and visualizing your data that much faster. 

Note: Most Google Sheets add-ons are free, so each tool listed below is free unless otherwise noted. 

Category

Best for

Supermetrics

Gathering data

Retrieving data from marketing and sales tools

Coupler.io

Gathering data

Exporting data from various apps on a set schedule

Hunter

Gathering data

Finding and verifying email addresses

Google Analytics

Gathering data

Analyzing your website data

GPT for Slides Sheets Docs

Gathering data

Leveraging AI

ChangeCase

Formatting and visualizing data

Changing your text case

Power Tools

Formatting and visualizing data

Formatting and cleaning up your spreadsheets

Awesome Table

Formatting and visualizing data

Turning your data into visual tables

Crop Sheet

Formatting and visualizing data

Cropping sheets automatically

Icons for Slides & Docs

Formatting and visualizing data

Adding customizable icons to your spreadsheets

Lucidchart

Formatting and visualizing data

Adding collaborative diagrams to your spreadsheet

Geocode by Awesome Table

Manipulating data

Finding location data from addresses

Form Publisher

Manipulating data

Turning your data into documents and presentations

Copy Down

Manipulating data

Adding functions to form responses

AppSheet

Sharing and publishing

Turning your spreadsheet into an app

Export Sheet Data

Sharing and publishing

Exporting your data as XML or JSON files

Yet Another Mail Merge

Email and communication

Importing contacts and sending template messages

Mail Merge with Attachments

Email and communication

Scheduling emails with attachments in a spreadsheet

Form Mule

Email and communication

Sending conditional emails

The best Google Sheets add-ons for gathering data

If you use spreadsheets to manage data collected in another app—for example, leads from forms and emails or tasks in a project management app—you need an efficient way to first pull in the data from those external apps. You could manually export your data as a .csv file and then import it into Google Sheets. Or you can use an add-on to automate the process. 

Here are the best Google Sheets add-ons for retrieving data from websites and external apps. 

Supermetrics

Best for: Retrieving data from marketing and sales tools

Supermetrics is a powerful tool for importing your business data into Google Sheets. It connects to over 100 marketing and sales apps—everything from analytics tools like Google Analytics and Moz to social platforms like Facebook and Instagram to payment services like Stripe. It also offers a variety of premade templates that you can browse through the add-on to help you kickstart the reporting process. 

Supermetrics Google Sheets add-on.

To import data, select the connection and query type, add filters to tell Supermetrics what data to retrieve, and then choose the fields you want to add to your spreadsheet. You can also schedule automatic data refreshes directly through the add-on. 

Pricing: 14-day free trial of any Supermetrics connection; pricing varies depending on the app you want to connect, but starts at $19/month/app (billed annually). 

Coupler.io

Best for: Exporting data from various apps on a set schedule

If you regularly build reports, Coupler.io can automatically export data from popular apps like Airtable, Shopify, and HubSpot into Google Sheets. You can also schedule when you want it to retrieve your data: hourly, daily, monthly, or on specific days of the week. 

Hunter 

Best for: Finding and verifying email addresses

Want to verify the email addresses of potential leads? Or perhaps you need to generate an email list for a run of cold emails. The Hunter for Sheets add-on does this right from your spreadsheet. 

First, create an account with Hunter. When you first use the add-on, you’ll be prompted to enter your API code. Go to Hunter’s home page, click your profile, and then select API. Copy and paste the API key into the Google Sheets prompt. 

API key section of a Hunter profile page.

You can find a list of email addresses based on the company’s email domain (for example company.com). Or, if your spreadsheet contains a list of email addresses, Hunter can verify your list—it’ll output a verification score for each one, indicating how confident it is that the email address is valid. 

Hunter Google Sheets add-on.

Pricing: Free for 25 searches and 50 email verifications/month; from $34/month (billed annually) for the Starter plan, which includes 6,000 searches and 12,000 verifications each year. 

Google Analytics 

Best for: Analyzing your website data

The Google Analytics add-on integrates with your existing Google Analytics data—it’s not a generic data analysis tool—allowing you to create, run, and schedule reports directly from your spreadsheet. 

Google Analytics Google Sheets add-on.

GPT for Slides Sheets Docs 

Best for: Leveraging AI 

The GPT Workspace add-on allows you to interact with AI, powered by OpenAI’s GPT-4 and Gemini Pro models, directly from your spreadsheet. You can interact with your AI assistant directly from a cell using an =GPT formula. 

AI-generated response using the GPT for Slides Sheets Docs add-on in Google Sheets.

Or you can chat with your AI assistant in the side panel, just like you would with Gemini or ChatGPT, and ask it to do things like generate or fill in a table and analyze range data. 

GPT for Docs Slides Sheets chat in the side panel of Google Sheets.

It’s worth mentioning that, in my experience, when I asked the AI assistant to generate a table, sometimes it would generate it in the chat and automatically populate it in the spreadsheet; most other times, it told me to manually copy and paste it into the sheet. 

Automate data gathering with Zapier 

With Zapier, you can accomplish what many of the add-ons listed above do—all from one place. For example, when you connect Google Sheets with ChatGPT, you can prompt ChatGPT from your spreadsheet and automatically save the response in the same sheet. You can also connect Google Sheets with HubSpot to save HubSpot form submissions in your spreadsheet as they come in. Here are a few Zap templates to get you started. 

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

The best Google Sheets add-ons for formatting and visualizing data 

If you’re working with large data sets, a little organization can go a long way in helping readers understand what exactly they’re looking at—without straining their eyes. These Google Sheets add-ons are perfect for speeding up the process of formatting your data and turning it into easy-to-digest visuals. 

ChangeCase

Best for: Changing your text case 

More often than not, the data you import won’t be perfectly formatted. Some entries may be entirely lowercase, while others are in sentence case. You could use a formula to manually reformat your text into your desired case, but you’re limited to only three options: all lower case, all upper case, or title case (where the first letter of each word is capitalized). 

With ChangeCase, you don’t have to input a formula, you have more formatting options (including sentence case and invert case), and your existing text gets reformatted—it doesn’t populate in a separate cell the way it does with a formula. 

Demo of how to automatically change text to all uppercase using the ChangeCase Google Sheets add-on.

Power Tools 

Best for: Formatting and cleaning up your spreadsheets

Google Sheets has built-in features to clean up data, reformat it, split and merge cells—you get the idea. But you need to dig through hidden menus or enter formulas exactly right to get the job done. 

Power Tools, on the other hand, offers a one-stop shop for all the same tools—no digging required. 

Power Tools Google Sheets add-on.

Awesome Table 

Best for: Turning your data into visual tables

Sorting and filtering data in a spreadsheet is easy enough, especially with pivot tables, but it’s not exactly pretty. Awesome Table gives you a custom interface to browse your spreadsheet data in tables, maps, cards, and Gantt chart visualizations.

You can customize the view, choose the number of rows and columns, and set other view options. Then you can share your Awesome Table design or use it to sort through and filter data with dropdowns and dynamic sliders. It’s like a custom app just for viewing your spreadsheet data.

Awesome Table Google Sheets add-on.

Pricing: Free for 10 imports; from $16/month (billed annually) for the Starter plan, which includes 35 data sources and scheduled data refreshes. 

Crop Sheet

Best for: Cropping sheets automatically 

If you need to quickly show only the data you need, Crop Sheet is the simplest way to do this. You can choose to crop your sheet to present either the existing data or a specific selection, and Crop Sheet will hide everything else. 

Demo of how to automatically crop a spreadsheet to show only the existing data using the Crop Sheet Google Sheets add-on.

Icons for Slides & Docs

Best for: Adding customizable icons to your spreadsheets

Want to add a little personality to your spreadsheets? Or visual cues to help readers know what type of data they’re looking at? Despite the name, the Icons for Google Slides & Google Docs add-on also works in Google Sheets, allowing you to add any of their millions of customizable icons to your spreadsheet for free. 

Icons for Slides and Docs Google Sheets add-on.

Lucidchart

Best for: Adding collaborative diagrams to your spreadsheet

Google Sheets offers built-in functions to turn your data into graphs and charts, but the options are pretty basic. With the Lucidchart add-on, you have more advanced options like flowcharts, wireframes, and organizational charts.

The only downside is that Lucidchart doesn’t offer a way to convert existing spreadsheet data into these visualizations. Instead, the add-on allows you to import diagrams you build in Lucidchart into Google Sheets and access linked spreadsheets within Lucidchart. 

Demo of previewing Google Sheets within Lucidchart.

Pricing: Free plan includes 3 editable documents and 60 shapes/document; from $7.95/month for the Individual Lucidchart plan, which includes unlimited editable documents and objects. 

The best Google Sheets add-ons for manipulating data

There are plenty of functions to calculate straightforward things like the sums, averages, and counts. But for less common data manipulations, like turning addresses into GPS coordinates, these add-ons can help. 

Geocode by Awesome Table

Best for: Finding location data from addresses

If you need to populate precise GPS coordinates for addresses stored in your spreadsheet, use Geocode by Awesome Table. Whether your address is stored in one column or split across multiple columns, Geocode will populate the longitude and latitude of each location in a neighboring column. 

Geocode can also plot each location on a Google Map inside its companion app, Awesome Table. There, you can customize labels and sort through the address in a table. 

List of GPS coordinates plotted in Google Maps.

Form Publisher 

Best for: Turning your data into documents and presentations 

Form Publisher allows you to populate Google Docs, Google Slides, PDF, and Word files with your spreadsheet data. The initial setup takes some work—you have to create a template (or use one of their Google templates) and add markers (tags). Once you’ve finished laying the groundwork, though, Form Publisher will generate a new file for each row of data and automatically fill in any marker fields in your document. It’ll also populate links to the finished product for each row in your spreadsheet, so you can easily access them in the future. 

Form Publisher Google Sheets add-on.

Pricing: Free plan includes 20 documents/month; Individual plan for $99/year includes unlimited documents. 

If you outgrow Form Publisher’s free plan, Autocrat is another option you can use for free. In my experience, though, it’s less intuitive to use than Form Publisher. 

Copy Down

Best for: Adding functions to form responses

Let’s say you’ve synced your Google Forms with Google Sheets—you can do this by clicking Tools > Create a New Form in Sheets when you initially build your form. Any data collected in your form will then automatically populate in that spreadsheet.   

To calculate values, reformat text, or apply any other functions to these data points, you’ll need to add them in later. Or you can insert your formula once and use Copy Down to automatically copy existing formulas to new rows.

Copy Down Google Sheets add-on.

You can also use Zapier to pull data from other form builders and survey tools into your spreadsheet. Here are a few Zap templates to get you started. 

The best Google Sheets add-ons for sharing and publishing

Now that you’ve gathered, organized, and formatted your data, it’s time to share it with the world. If all you want to do is share a direct link to your spreadsheet, you can stop reading here. But if you want to get more out of your data, these add-ons let you turn it into an app or add it to your website.

AppSheet

Best for: Turning your spreadsheet into an app 

AppSheet allows you to build mobile apps using data from your spreadsheet—no coding required. List all your data (for example, contacts, products, and inventory) in your spreadsheet and connect it with the add-on. You can also choose from a variety of app templates and then tweak them to suit your company’s needs. 

AppSheet Google Sheets add-on.

From there, you can customize the displayed columns, pull in images from Dropbox and other cloud storage apps, chart locations on maps, and tweak its design to fit your branding. You can even add forms to gather text, images, and signatures on the go for a full mobile data collection tool built around your spreadsheet.

Pricing: Free to develop apps and share with up to 10 users; from $5/month/user to publish unlimited apps and access core features. 

Export Sheet Data

Best for: Exporting your data as XML or JSON files

If you want to export your spreadsheet data to another app, but that app supports only XML or JSON files, Export Sheet Data can help. It lets you export your data as XML or JSON files, and you can customize how the data is formatted—for example, default or stringified values, and attributes or child elements. 

It’s also open source, so you and your team can edit the code further to make it work exactly how you need. 

The best Google Sheets add-ons for email and communication

Apart from storing and crunching numbers, spreadsheets are also great for sending personalized messages to your email list or managing your outreach—if you have the right add-ons. 

Yet Another Mail Merge

Best for: Importing contacts and sending template messages

Yet Another Mail Merge (YAMM) is a one-stop shop for sending emails via Gmail to your contacts. It requires some initial setup: you have to create your own email template in Gmail, or you can use one of YAMM’s, and add fields to map data from Google Contacts or Salesforce. 

Once your setup is complete, run YAMM, and it’ll send personalized emails to every contact in your spreadsheet. You can also send yourself a test message beforehand to make sure everything looks perfect, schedule message sends, and track opens and clicks—all from the add-on. 

Pricing: Free for 50 emails/day; from $25/year for the Personal plan, which includes up to 1,500 emails/day and scheduled delivery. 

Mail Merge with Attachments

Best for: Scheduling emails with attachments in a spreadsheet

Mail Merge with Attachments offers the same features as YAMM, but it also lets you include Google Drive files as email attachments. You can even select different files for each recipient, if you want.

Mail Merge with Attachments side panel in Google Sheets.

Pricing: Free for 25 email sends/day; from $49.95/year for a Standard Personal Licence, which includes up to 400 email sends/day and advanced features. 

Form Mule

Best for: Sending conditional emails 

Form Mule offers even more flexibility when it comes to sending personalized messages to your email list. You can set conditions to tell Form Mule which email template to send and when. For example, you can create rules to automatically send welcome emails to new subscribers immediately after they sign up for your product. Or you can run it on a timed schedule. 

The add-on also adds new =RANGETOTABLE() functions to Google Sheets, which can turn your spreadsheet data into an HTML table in a click—it’s much simpler than manually merging cells and hand-coding HTML tables.

Automate Google Sheets 

Instead of toggling between add-ons to speed up your spreadsheet-related tasks, use Zapier’s Google Sheets integration. This way, you can connect with thousands of other apps and automate everything from pulling in lead data from form submissions to sharing summaries of spreadsheet data directly in your team chat app. Learn more about how to automate Google Sheets, or click one of the Zap templates below to get started. 

Related reading:

This article was originally published by Matthew Guay in July 2016 with contributions from Lydia McAllister. The most recent update was in May 2024.

by Zapier