Google Sheets Import JSON – IMPORTJSON Function

Add the following code to your Apps Script Editor first and then use the function.

How to Use IMPORTJSON Function?

Understand How This Script Works