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

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

Practice

1. What is the main purpose of add-ons in Google Sheets?

easy

A. To change the spreadsheet's background color

B. To add new tools and features without writing code

C. To create charts manually

D. To delete rows automatically

Solution

1. Step 1: Understand what add-ons do

   Add-ons provide extra tools and features that are not built-in by default.

2. Step 2: Compare options with add-ons purpose

   Only To add new tools and features without writing code describes adding new tools without coding, which matches add-ons' purpose.

3. Final Answer:

   To add new tools and features without writing code -> Option B

4. Quick Check:

   Add-ons = new tools without coding [OK]

Hint: Add-ons = extra tools without coding [OK]

Common Mistakes:

• Thinking add-ons change colors only
• Confusing add-ons with manual chart creation
• Assuming add-ons delete data automatically

2. Which menu in Google Sheets do you use to install add-ons?

easy

A. Extensions

B. File

C. View

D. Insert

Solution

1. Step 1: Recall where add-ons are installed

   Add-ons are installed from the Extensions menu in Google Sheets.

2. Step 2: Match the correct menu option

   Among the options, only Extensions is the correct menu for add-ons.

3. Final Answer:

   Extensions -> Option A

4. Quick Check:

   Install add-ons from Extensions menu [OK]

Hint: Add-ons come from Extensions menu [OK]

Common Mistakes:

• Choosing File menu instead of Extensions
• Selecting Insert or View menus incorrectly
• Not knowing where to find add-ons

3. You installed an add-on that automatically formats dates in your sheet. What will happen when you enter a date like 3/14/2024?

medium

A. The date will stay as plain text without changes

B. The sheet will show an error message

C. The add-on will format the date according to your chosen style

D. The date will be deleted automatically

Solution

1. Step 1: Understand add-on behavior

   The add-on is designed to format dates automatically when entered.

2. Step 2: Predict the effect on date input

   When you enter a date, the add-on changes its appearance to the chosen format, not deleting or ignoring it.

3. Final Answer:

   The add-on will format the date according to your chosen style -> Option C

4. Quick Check:

   Date formatting add-on changes date style [OK]

Hint: Add-ons automate tasks like formatting [OK]

Common Mistakes:

• Thinking add-ons delete data
• Assuming no change happens to input
• Expecting error messages from formatting add-ons

4. You installed an add-on but it does not appear in the Extensions menu. What is the most likely reason?

medium

A. Add-ons only work on mobile apps

B. Google Sheets does not support add-ons

C. You need to refresh the browser to see the add-on

D. The add-on was not installed properly or needs authorization

Solution

1. Step 1: Check installation and permissions

   If an add-on is missing, it often means it was not installed fully or needs permission to run.

2. Step 2: Evaluate other options

   Google Sheets supports add-ons, refreshing may help but usually authorization is needed, and add-ons work on desktop, not only mobile.

3. Final Answer:

   The add-on was not installed properly or needs authorization -> Option D

4. Quick Check:

   Missing add-on = install or authorize issue [OK]

Hint: Missing add-on? Check install and permissions [OK]

Common Mistakes:

• Assuming Google Sheets lacks add-on support
• Ignoring authorization prompts
• Thinking refresh alone fixes missing add-ons

5. You want to automate sending emails from Google Sheets using an add-on. Which of these steps is NOT required?

hard

A. Write complex scripts manually in the sheet

B. Authorize the add-on to access your Gmail account

C. Install an email automation add-on from Extensions

D. Set up the email template and recipient list in the add-on

Solution

1. Step 1: Understand add-on automation

   Add-ons automate tasks without needing manual script writing.

2. Step 2: Identify unnecessary step

   Writing complex scripts manually is not needed because the add-on handles automation.

3. Final Answer:

   Write complex scripts manually in the sheet -> Option A

4. Quick Check:

   Add-ons automate without manual scripts [OK]

Hint: Add-ons save scripting effort [OK]

Common Mistakes:

• Thinking manual scripts are needed with add-ons
• Skipping authorization steps
• Not setting up templates in add-ons