This post is also available in: 日本語
- 1 Introduction
- 2 What are Google Sheets?
- 3 How Google Sheets Works
- 4 How to use add-ons
- 5 utilly’s Add-on reccomend
- 5.1 Supermetrics
- 5.2 More Fonts
- 5.3 Google Analytics
- 5.4 Company Name Lookup
- 5.5 QR Code Generator
- 5.6 ProjectSheet project planning
- 5.7 AppSheet
- 5.8 Yet Another Mail Merge
- 5.9 Remove Duplicates
- 5.10 Remove Blank Rows
- 5.11 Lucidchart Diagrams for Sheets
- 5.12 Translate My Sheet
- 5.13 Power Tools
- 5.14 Template Gallery
- 5.15 Sort by Color
- 5.16 Email Range
- 5.17 DigitalStamp4Sheet
- 5.18 Twitter Archiver
- 5.19 Mapping Sheets
- 5.20 Advanced Find and Replace
- 6 And finally,
Introduction
Google Sheets is one of the more common ways to work alongside Excel, but it’s actually very deep and extensible.
This post focuses on the Google Sheets extensions: add-ons.
What are Google Sheets?
Google Sheets is a spreadsheet tool from Google.
I think it’s easy to understand if it’s the Google version of Microsoft Excel.
The use of Google Sheets for spreadsheets is on the rise.
How Google Sheets Works
Google Sheets has a lot of benefits that make your job more efficient.
No need for a password
Google Sheets allows you to restrict your sharing to a Google account base. This means you can’t forget your password and open the file, and it won’t open if you accidentally send it.
Also, even if you make a mistake, you won’t be able to access it after you turn it off.
Easy to collaborate
Google Sheets is easy to edit at the same time.
In addition to being accessible by multiple people at the same time, you can work in an interactive way such as exchanging comments.
It also has a history feature, so if you want to go back to the previous version, it’s easy.
There is an add-on.
This is the main point of this entry, but with the “add-ons” extension, you can add more and more required functions.
How to use add-ons
Here’s how to use the Google Sheets add-on.
You can find add-ons by going to Add-ons > Get add-ons.
Recommended Add-On for Google Sheets
There are a number of Google Sheets add-ons, from those provided by Google to those provided by other companies, called third parties.
The main categories of add-ons are:
- Social & Communication
- Business Tools
- Utilities
- Education
- Work efficiency
Here are some of the best utilly add-ons.
utilly’s Add-on reccomend
Supermetrics
Supermetrics is an add-on that organizes marketing data from Google, Facebook, Twitter, and other services into Sheets.
This add-on is useful mainly for marketing purposes such as managing advertisements and aggregating service data.
If you are interested in Supermetrics, we have a separate article on how to use it.
Please look there.
More Fonts
More Fonts is an extension to Google Sheets that extends the font experience.
Google Analytics
Google Analytics, as its name suggests, is an add-on that pulls data from Google Analytics.
This is an add-on provided by Google.
If you want to export data from Google Analytics, this is a handy add-on.
Company Name Lookup
This add-on shows the company name when you enter the URL of the site.
For example, this add-on is useful when you do market research or create a list of new customers.
QR Code Generator
QR Code Generator, as its name suggests, is an add-on that can generate QR codes.
This service allows you to generate a QR code in the specified range immediately.
QR codes can be stored in Google Drive, inserted into Google Docs, and so on.
ProjectSheet project planning
ProjectSheet project planning is an add-on for creating Gantt charts on Sheets.
You probably use Excel or Sheets to create a Gantt chart, but this add-on automatically creates a Gantt chart when you specify the date and time.
AppSheet
AppSheet is just an add-on that lets you create an application from Google Sheets.
For example, it can be used to make a prototype of a database related service such as EC service.
The created application can be operated by AppSheet application (Available on iOS and Android).
Yet Another Mail Merge
Let Another Mail Merge makes it easy to send emails all at once.
You create the body of the mail to send to Gmail beforehand.
You can create a list of recipients in Google Sheets to broadcast mail.
You can customize the email you send based on people and flags, so a project that doesn’t require an email delivery tool is a useful add-on.
Remove Duplicates
Remove Duplicates is an add-on that allows you to extract duplicate or otherwise unique values from a sheet.
For example, you can specify that duplicate data be colored or moved to a different location.
This add-on is useful for final checking and checking your Sheets documents.
Remove Blank Rows
Remove Blank Rows is a tool that allows you to remove unwanted blank rows.
This add-on is useful for adjusting the layout of the sheet you created.
It’s one click away, so if you use Sheets frequently, it’s a handy add-on.
Lucidchart Diagrams for Sheets
Lucidchart Diagrams for Sheets is an add-on that makes it easy to create flowcharts and other objects using Sheets.
The intuitive way to create flowcharts is sure to be useful for a variety of purposes, including project descriptions.
Translate My Sheet
Translate My Sheet is an add-on that lets you translate the contents of Sheets.
It is very simple to use, just specify the source and destination languages.
It is possible to specify the whole sheet or a part of the sheet, so it will be possible to translate the global project without any trouble.
Power Tools
Power Tools is a tool that enhances the editing capabilities of Sheets.
It’s a great way to power up Sheets.
Easily and intuitively edit Sheets with one click to convert matrices, randomize numbers, replace text and numbers, compare ranges, and more.
Template Gallery
As its name suggests, Template Gallery is a gallery add-on that contains a variety of templates that can be used with Sheets.
For example, we have a wide variety of templates for business and private use, from estimates and invoices to schedule management.
Sort by Color
Sort by Color is an add-on that makes it easier to adjust the sorting coloring in Sheets to your liking. You can color sorts for a variety of criteria, from cell color to text color.
Email Range
Email Range is an add-on that allows you to easily insert the contents of Sheets into your email.
You can insert a range of colors and fonts into Gmail.
DigitalStamp4Sheet
DigitalStamp4Sheet is an add-on that provides a digital stamp feature for Google Sheets.
If you use this add-on, you can use the registered seal data to affix an electronic seal to a request or a request for approval.
Twitter Archiver
Twitter Archiver is an add-on that allows you to collect tweets containing hashtags or specific keywords.
For example, if you want to research the reputation of twitter, you can use this add-on to make your work more efficient.
Mapping Sheets
Mapping Sheets is an add-on that lets you transfer data from Google Sheets to Google Maps in just a few clicks.
For example, you can easily see the list of clients on Google Maps at work. In addition, you may be able to add a list of recommended stores to Google Maps.
Advanced Find and Replace
Advanced Find and Replace is an add-on that provides more advanced search capabilities.
It is an add-on that provides advanced search and assignment that is cumbersome with regular Sheets by formula and link.
And finally,
Had we known about the Google Sheets add-on, we could have saved more time! There are a lot of time saving add-ons out there.
Please try it in your daily work.
Google Extensions
In addition to Google Sheets, the Utility also has add-ons that can help with Google services.
Check out the full article below.
Google Docs
The following article lists some useful Google Docs add-ons.
Google Chrome
Here are a number of useful add-ons for Google Chrome.
Please take a look!
