ImportJSON is an add-on for Google Sheets that provides a new function to your toolbox =IMPORTJSON( )
With IMPORTJSON, you will be able to import and parse JSON data into a Google Sheets table.
JSON data has never been so easy to manipulate!
One of the main difficulties of working with this kind of data is the complicated tree formatting of JSON that can be confusing to manipulate. This is exactly why ImportJSON converts JSON data into a table in GoogleSheets, making your approach to the information digestible.