Google Sheets does a remarkable amount out of the box, but add-ons extend it into territory the built-in features don’t reach — sending personalized bulk email, generating PDFs from rows, pulling live data from other apps, industrial-strength cleanup. The catch is that the Marketplace is full of them, many overlapping or abandoned, and each wants access to your data. The skill isn’t installing add-ons; it’s picking the two or three that map to a real bottleneck and vetting them properly. This covers how to install them, the categories worth knowing, and when a built-in feature beats an add-on entirely.
How to install an add-on
Every add-on comes from the Google Workspace Marketplace and installs the same way, with a permissions step you should actually read.
- Open Extensions → Add-ons → Get add-ons to launch the Marketplace.
- Search or browse, click an add-on, and hit Install.
- Review the permissions it requests, then grant them — the add-on now appears under the Extensions menu.
Once installed, an add-on lives in the Extensions menu and runs inside your sheet, usually in a sidebar. Installation is per-account, so an add-on follows you across all your spreadsheets, not just the one you installed it from. That convenience is also why the permissions screen matters — you’re granting access to your Sheets data broadly, not to a single file. Google’s Workspace Marketplace is where they all live, with reviews and developer info worth checking before you install.
Add-ons by the job they do
Add-ons cluster into a few categories, and knowing the categories helps you search for the right tool rather than browsing endlessly.
| Add-on | What it does |
|---|---|
| Power Tools | Bulk data cleanup — remove duplicates, trim spaces, split text, find/replace at scale |
| Yet Another Mail Merge | Send personalized bulk email straight from a sheet of contacts |
| Autocrat | Generate Docs or PDFs — invoices, certificates, reports — from each row |
| Awesome Table | Turn sheet data into interactive tables, cards, and maps you can embed |
| Coupler.io | Import data from other apps on a schedule |
Mail merge and document generation are where add-ons earn their keep most clearly, because Sheets has no native way to do them — turning a hundred rows into a hundred personalized emails or PDF certificates is genuinely hard without one. Data-cleanup suites like Power Tools save time on messy imports, and connector add-ons pull in data from tools that don’t natively talk to Sheets. Match the category to your actual pain point rather than collecting tools you might use someday.
Two more categories round out what people reach for. Visualization add-ons like Awesome Table turn a sheet into interactive cards, maps, or directories you can embed on a website — far beyond what a built-in chart does. And form/workflow add-ons extend Google Forms responses into routed approvals and automated replies. The pattern across all of them is the same: an add-on is worth it when it bridges Sheets to something outside it — email, documents, the web, another app — which is exactly where the built-in toolkit stops.
When a built-in beats an add-on
Before installing anything, check whether Sheets already does it. A surprising number of add-ons duplicate features you already have.
| If you want to… | Use this |
|---|---|
| Pull data from another spreadsheet | IMPORTRANGE (built-in) |
| Filter, group, summarize data | QUERY (built-in) |
| Run a custom repeated task | Apps Script (built-in) |
| Send bulk personalized email | Mail-merge add-on (no built-in) |
| Generate a PDF per row | Autocrat add-on (no built-in) |
For pulling and reshaping data, the QUERY function and IMPORTRANGE handle natively what some connector add-ons charge for. For automation, Apps Script can do custom jobs without a third party touching your data. A built-in always wins on two counts: nothing new gets access to your data, and there’s no add-on to break or start charging when its business model changes. Reach for an add-on when the built-in genuinely can’t do the job — mail merge, document generation, specific external connectors — not when it just looks easier than learning a formula.
Vet before you install
The risk isn’t hypothetical — abandoned add-ons stop working after Sheets updates, and a poorly-built one can be slow or leak data. Sticking to well-reviewed, actively-maintained add-ons from known developers avoids almost all of it. And uninstall what you stop using (Extensions → Add-ons → Manage add-ons): every one you keep installed is standing access to your data for no benefit. A lean set of trusted tools beats a drawer full of half-used ones. For work accounts, there’s an extra layer worth knowing: many organizations restrict which add-ons can be installed, and your admin may need to approve one from the Marketplace before you can use it — so if an Install button is greyed out, that’s usually why, not a bug.
Keep add-ons from slowing you down
Every installed add-on has a cost beyond its permissions: some load with the sheet, run on triggers, or add menu clutter, and a few can noticeably slow a large spreadsheet.
This is the quiet argument for keeping your set small. Two or three well-chosen add-ons you use constantly are worth their overhead; a dozen installed “just in case” each take a slice of performance and a grant of access for nothing in return. Periodically pruning the list keeps both your sheets fast and your data exposure low — a five-minute cleanup every few months is all it takes.
Start with your biggest bottleneck
The mistake is installing ten add-ons at once and using none. The right approach is to name the one task eating your time and find the single add-on that fixes it.
- ✓ Same email to a list every week → a mail-merge add-on
- ✓ Rebuilding PDF reports or certificates by hand → Autocrat
- ✓ Messy imports eating an hour each time → a cleanup suite like Power Tools
- ✓ Data scattered across apps you check daily → a connector add-on
If you send the same email to a list every week, try a mail-merge add-on first. If you rebuild the same PDF reports by hand, Autocrat. If messy imports cost you an hour each time, a cleanup suite. Add one, get fluent with it, and only add another when a new bottleneck appears. Add-ons are genuinely powerful for the jobs Sheets can’t do alone — but they’re a supplement to the built-in tools, not a replacement for learning them. Pick deliberately, vet carefully, and keep the set small, and they’ll save real time without cluttering your sheets or exposing your data.