There are plenty of free APIs that can help you get started with ImportJSON
RestCountries is a free API that give invaluable information that you can use straight into your Google Sheets
After being sure you activated ImportJSON in your current spreadsheet, simply type:
You can find more about this free API provided by the Nobel Prize:
Start typing in your Google Sheets
IMPORTJSON() tries to pivot the data if it finds a common base.
In our example, the elements highlighted in red don’t follow the pattern nobelPrizes/[index]. As a consequence, the function cannot display nobelPrizes/0, nobbelPrizes/1, nobelPrizes/2, etc, in columns
We need to filter our array: