Install and activate the Google Sheets add-on

Installation

ImportJSON, like all the Google Workspace add-ons, is available on the Google Workspace Marketplace

Click here to install the add-on

The installation process takes less than a minute and will take you over a few screens.

One screen might trigger your attention

Let us walk you through the authorizations:

View and manage spreadsheets that this application has been installed in

To provide the service, the add-on needs to interact with the spreadsheet it is used on.

Note that the add-on is not activated by default in your existing spreadsheets nor in the new spreadsheets you will create. As a consequence, it cannot access any of your data outside of the spreadsheets in which it has been activated

Connect to an external service.

Most of the magic takes place on our servers as AppsScript, the default scripting service for Google Workspace, does not provide sufficient capabilities.

Allow this application to run when you are not present

ImportFromWeb allows you to set up triggers that update your data periodically even though the spreadsheet in closed.

Display and run third-party web content in prompts and sidebars inside Google applications

To improve usability, the add-on provides a sidebar which helps you get the most out of your IMPORTJSON() function.

Google Workspace add-ons go through a strict evaluation from the Google team before being released to the marketplace. As a consequence, you can usually trust add-ons listed on the marketplace.

Activate the add-on

The add-on might not be activated by default in your spreadsheet. To activate it, go to the menu Extensions > ImportJSON > Activate add-on. (If you don’t see ImportJSON in the Extensions, just reload the document).

A sidebar will appear on the right of your spreadsheet; you’re now ready to enjoy ImportJSON ! Let’s continue and write your first =IMPORTJSON( ) function.

In some cases, Google sheets may have troubles activating the add-on. It usually happens when you use several Google account in the same Chrome session. To debug, follow our guidelines here.