Google Sheets add-ons work similarly to browser extensions. They are third-party apps you install to Sheets to gain additional features. Some add-ons increase productivity, and some add more extensive capabilities. Here’s how to get started.
Installing an Add-On
To get an add-on, open a new or existing file in Google Sheets, click “Add-ons,” and then click “Get add-ons.”
You can browse the list of all add-ons, use the drop-down menu to sort by category or search using the search bar. Once you find an add-on you like, click the “Free” button to install the add-on (if it’s a paid add-on, this button will reflect the purchase price).
Upon installing add-ons, you need to grant them specific permissions. These are fundamental to the operation of the add-on to function correctly. Make sure you fully understand the permissions and trust the developer before installing any add-on.
Click “Allow.”
Read the remaining 41 paragraphs
Source : The Best Google Sheets Add-Ons