Import Nobel Prize Data to Google Sheets

Amigo Data is an extension in Google Sheets that will allow you to easily import Nobel Prize Data to Google Sheets. There are two ways in which we can install the extension.

1. Install the Amigo Data add-on directly from the Google Workspace Marketplace through the link here.

2. Or, you can follow the steps below to add it directly to your Google Sheets:

• In a new sheet, go to Extensions → click on Add-ons → click Get Add-ons
• In the search bar, enter “Amigo Data”
• Install the most appropriate result.

Go to Nobel Prize Developer zone

Scroll down to find the link containing the API documentation and click on the latest version.

From the list, select the data you wish to import to Google Sheets. In our example, we will be importing data about the Laureates of the different Nobel prizes.

Click on “Try it out”.

Use the Parameters list to filter the data according to your preferences. In our example, we aim to calibrate a list of the 100 most recent laureates, hence we fill in the relevant parameters accordingly.

Once the parameters have been inputted, scroll down and click on “Execute”.

Copy the highlighted link. This is the API that will be used to import the relevant data.

We obtain the following link
http://api.nobelprize.org/2.1/laureates?limit=100&sort=desc

Go to the sheet in which you want the data to be imported. Click on Extensions → Amigo Data → Connect

Under the “Select source” window, scroll down to find the “Custom API” option and click on it.

Enter the API link obtained previously as shown below and click on Preview.

Continue flattening the data until only the columns relevant to your research are displayed with clean data in them and then click IMPORT, located in the top right corner.

On clicking import, a few seconds later the list of laureates that satisfies the parameters mentioned above will be displayed on your sheet.

Note that you can easily edit the existing data in the Amigo Data add-on by choosing the View Reports option instead of selecting the Custom API option again and again. 

To learn how to automatically update the imported data and receive regular alerts for the same click here.

As mentioned previously, under the Details section, one can add more parameters to filter the imported data. For instance, if we were to specify that the list should contain only American laureates, we could do that by executing the following steps.

Step 1: Click on “+Query”.

Step 2: Enter the query name as “birthCountry” and the value as “USA”. Then, click on “Add Query”.

Note that you can find the query name in the parameter list of the API documentation as shown below.

Step 3: Click Preview → Flatten the data according to what you wish for it to display and then click on Import. The list displayed next would contain only the top 100 recent American Laureates.

To add another filter to the data, one could have added the query in the API URL directly as well. Remember that queries inserted in a URL are separated by an ampersand (&) and it’s value is preceded by an equals to (=) sign as shown below.

The new API URL looks like the following link:
http://api.nobelprize.org/2.1/laureates?limit=100&sort=desc&birthCountry=USA

You can follow the steps mentioned previously after you are ready with the link to import the relevant data into your Google Sheets.

• /nobelPrizes

This endpoint will provide you complete information about all Nobel Prizes. The API URL is mentioned below:

http://api.nobelprize.org/2.1/nobelPrizes

• /nobelprize/ {category} / {year}

This endpoint will allow you to obtain information about those Nobel prizes that fulfil certain criteria. The URL for the same is

http://api.nobelprize.org/2.1/nobelPrize/che/2022

• /laureate / {laureateID}

This endpoint allows users to gather information about a particular laureate on the basis of their unique ID. The API URL is

http://api.nobelprize.org/2.1/laureate/106