Best Google Sheets Add-Ons
The best Google Sheets add-ons for productivity, data cleaning, reporting, and automation. Covers how to install, manage, and remove add-ons.
Sheets Bootcamp
February 26, 2026 · Updated December 7, 2026
Google Sheets add-ons extend what the spreadsheet can do. They connect to external services, automate repetitive tasks, clean data, and add features that Google did not build in. You install them from the Google Workspace Marketplace and access them through the Extensions menu.
This guide covers the most useful add-ons by category, how to install and manage them, and what to consider before granting permissions.
In This Guide
- How to Install an Add-On
- Best Add-Ons for Data Cleaning
- Best Add-Ons for Reporting and Visualization
- Best Add-Ons for Automation and Workflow
- Best Add-Ons for Forms and Data Collection
- How to Manage and Remove Add-Ons
- Security and Permissions
- Tips and Best Practices
- Related Google Sheets Tutorials
- FAQ
How to Install an Add-On
Open the Google Workspace Marketplace
Go to Extensions > Add-ons > Get add-ons. The Marketplace opens in a modal window.
Find and install the add-on
Search by name or browse categories. Click the add-on to see its description, reviews, and required permissions. Click Install, then Continue to review and grant permissions.
Access the add-on
After installation, the add-on appears under Extensions in the menu bar. Click its name to open it. Most add-ons open a sidebar panel on the right side of the screen.
Every add-on requests permissions when you install it. Read the permissions list carefully. A data formatting add-on should not need access to your Gmail or Google Drive files.
Best Add-Ons for Data Cleaning
Power Tools
A collection of data cleaning utilities including removing duplicates, trimming whitespace, changing case, finding and replacing across sheets, splitting and merging cells, and converting data types. The free version covers basic operations. The paid tier adds batch processing and scheduled cleaning.
Remove Duplicates
Dedicated tool for finding, highlighting, and removing duplicate rows. Works across columns, supports partial matching (match on specific columns only), and can move duplicates to a separate sheet instead of deleting them. More focused than the built-in Remove Duplicates feature.
Advanced Find and Replace
Extends the built-in Find and Replace with regex support across all sheets, find and replace in formulas (not values), and batch operations. Useful for large workbooks where the native tool is too limited.
Best Add-Ons for Reporting and Visualization
Supermetrics
Pulls marketing data from Google Analytics, Google Ads, Facebook Ads, LinkedIn, and dozens of other platforms directly into Google Sheets. Set up scheduled refreshes so your reports update automatically. Paid service with a free trial.
Awesome Table
Turns spreadsheet data into interactive web views: filterable tables, card layouts, maps, and Gantt charts. The published view updates when the underlying sheet changes. Useful for sharing data with people who do not need to see the raw spreadsheet.
Coefficient
Connects Google Sheets to Salesforce, HubSpot, Jira, databases, and other business tools. Pulls live data into your sheet and can push updates back to the source system. Useful for teams that use Sheets as a reporting layer.
Best Add-Ons for Automation and Workflow
Autocrat
Generates documents (PDFs, Google Docs, Sheets) from template files using data from your spreadsheet. Commonly used for invoices, certificates, reports, and mail merges. Set trigger conditions so documents generate automatically when new rows are added.
For basic mail merge without an add-on, see our guide on mail merge with Google Sheets and Gmail.
Form Publisher
Converts Google Forms responses into formatted documents. Each form submission generates a PDF, Google Doc, or Google Slides file from a template. Sends the document to the respondent automatically.
Sheetgo
Connects multiple Google Sheets (or Excel files) through automated data transfers. Set up one-way or two-way connections between workbooks. Useful for consolidating data from multiple team members or departments without IMPORTRANGE.
Best Add-Ons for Forms and Data Collection
Form Ranger
Extends Google Forms with dynamic dropdown options pulled from your spreadsheet. When the spreadsheet data changes, the form options update automatically. Also adds features like pre-populated fields and conditional logic.
Formfacade
Customizes the appearance of Google Forms with branded themes, custom CSS, and embedded layouts. Makes Google Forms look professional without building a separate form system.
How to Manage and Remove Add-Ons
See installed add-ons
Go to Extensions > Add-ons > Manage add-ons. This shows every add-on installed on your account, along with options to configure or remove each one.
Remove an add-on
In the Manage add-ons panel, find the add-on, click the three-dot menu icon, and select Uninstall. The add-on is removed from your account and no longer appears in the Extensions menu.
Disable an add-on for a specific file
In Manage add-ons, toggle off the “Use in this document” switch. The add-on stays installed on your account but does not load in the current spreadsheet. This is useful if an add-on slows down a particular file.
Security and Permissions
Add-ons are built by third-party developers, not Google. Before installing:
| Check | Why it matters |
|---|---|
| Reviews and ratings | High-rated add-ons with many users are generally safer |
| Developer identity | Known companies are more accountable than anonymous developers |
| Permissions requested | An add-on should only request access to what it needs. A data formatting tool should not need Drive, Gmail, or Calendar access. |
| Privacy policy | Reputable add-ons link to a privacy policy explaining how your data is used |
Add-ons can read and modify data in your spreadsheets. Avoid installing add-ons on sheets that contain sensitive financial, personal, or confidential business data unless you trust the developer.
Revoke permissions
If you uninstall an add-on but want to revoke its access entirely, go to myaccount.google.com/permissions and remove the add-on from your connected apps list.
Tips and Best Practices
- Start with one add-on per category. Adding too many add-ons can slow down your spreadsheet. Each add-on loads when you open the file, even if you are not using it.
- Check for built-in alternatives first. Google Sheets has added features like UNIQUE, FILTER, SORT, and advanced conditional formatting that replace what older add-ons were built to do.
- Use Apps Script for custom needs. If no add-on does what you need, a custom Apps Script function gives you full control without trusting a third party.
- Review permissions annually. Visit your Google account permissions page to see which add-ons still have access. Remove ones you no longer use.
- Test add-ons on a copy of your data. Before running an add-on on important data, duplicate the sheet and test on the copy. Some add-on operations (like removing duplicates) cannot be undone.
Related Google Sheets Tutorials
- Google Apps Script Basics — Build your own custom tools with JavaScript in Google Sheets
- Keyboard Shortcuts Cheat Sheet — Speed up common tasks without add-ons
- How to Share Google Sheets — Collaborate with teams alongside add-on-powered workflows
- Google Sheets vs Excel — Compare the add-on ecosystem to Excel’s add-in marketplace
FAQ
How do I install an add-on in Google Sheets?
Go to Extensions > Add-ons > Get add-ons. Search for the add-on, click Install, and grant the requested permissions. The add-on then appears under the Extensions menu.
Are Google Sheets add-ons free?
Many add-ons are free or have a free tier with limited features. Some offer premium plans with more functionality. The pricing is shown on the add-on’s page in the Google Workspace Marketplace before you install.
How do I remove an add-on from Google Sheets?
Go to Extensions > Add-ons > Manage add-ons. Find the add-on, click the three-dot menu, and select Uninstall. The add-on is removed from your account.
Are add-ons safe to use?
Add-ons in the Google Workspace Marketplace are reviewed by Google, but they are created by third-party developers. Review the permissions each add-on requests before installing. Avoid add-ons that request more access than they need for their stated purpose.
Do add-ons work on Google Sheets mobile?
Most add-ons do not work on the Google Sheets mobile app. They are designed for the desktop browser version. Some add-ons offer separate mobile apps, but the in-Sheets sidebar experience is desktop only.
Can I build my own add-on?
Yes. Google Sheets add-ons are built with Google Apps Script. You write JavaScript-based code that interacts with the Sheets API. See our Apps Script basics guide for an introduction to building custom tools.