0
0
Google Sheetsspreadsheet~5 mins

Add-ons and extensions in Google Sheets - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
Add-ons and extensions let you add new tools and features to Google Sheets. They help you do tasks faster or add functions that are not built-in. This is useful when you want to customize your spreadsheet experience.
When you want to create custom reports automatically without manual work
When you need to connect your spreadsheet to other apps like email or calendars
When you want to clean or format data quickly with special tools
When you want to add new chart types or visualization options
When you want to automate repetitive tasks like sending reminders or updating data
Steps
Step 1: Click
- Extensions menu in the top toolbar
A dropdown menu opens showing options including Add-ons
💡 Look for the word 'Extensions' near the middle of the top menu bar
Step 2: Select
- Extensions > Add-ons > Get add-ons
The Google Workspace Marketplace opens in a new window showing available add-ons
💡 This marketplace has many tools made by Google and others
Step 3: Search
- Search bar at the top of the Google Workspace Marketplace
A list of add-ons matching your search appears
💡 Type keywords like 'calendar', 'report', or 'data cleanup' to find useful add-ons
Step 4: Click
- An add-on you want to install
The add-on details page opens showing description and permissions
💡 Read the description to understand what the add-on does
Step 5: Click
- Install button on the add-on page
A permission request appears asking to allow access to your Google Sheets
💡 Only install add-ons from sources you trust
Step 6: Click
- Allow button on the permission request
The add-on installs and becomes available in the Extensions > Add-ons menu
💡 You may need to refresh your spreadsheet to see the new add-on
Step 7: Use
- Extensions > Add-ons > Your installed add-on
The add-on opens its interface or runs its function inside your spreadsheet
💡 Follow the add-on instructions to use its features
Before vs After
Before
Spreadsheet has only built-in Google Sheets features with no extra tools
After
Spreadsheet has new tools and features from installed add-ons accessible in the Extensions menu
Settings Reference
Manage add-ons
📍 Extensions > Add-ons > Manage add-ons
Control which add-ons are active or remove ones you no longer need
Default: Enabled after installation
Add-on permissions
📍 During installation prompt
Grant or deny access to your Google Sheets and data for the add-on
Default: Deny until allowed
Common Mistakes
Installing add-ons without checking permissions
Some add-ons request access to your data which may risk privacy or security
Always read permission requests carefully and install add-ons only from trusted sources
Not refreshing the spreadsheet after installing an add-on
The new add-on may not appear or work correctly until the sheet reloads
Refresh the browser tab or reopen the spreadsheet after installation
Installing too many add-ons at once
Too many add-ons can slow down your spreadsheet or cause conflicts
Install only the add-ons you really need and remove unused ones
Summary
Add-ons add new tools and features to Google Sheets to help with tasks and automation
You install add-ons from the Extensions menu via the Google Workspace Marketplace
Always check permissions and refresh your sheet after installing add-ons