How do I import code into Google Sheets?

Can I import JSON into Google Sheets?

I've been looking for a way to be able to import a JSON file into Google Sheets as it is too large to fit on the spreadsheet. The best I've found so far is to be able to create a new CSV column, add a new Google Sheet with the same name and copy/paste the contents from the JSON file to that.

My current script looks like this: function googleSpreadsheetImport(). }

I would love to find a way to only get values based on a key. My current method involves finding the first record and then looping through every record. However, if there's a better way of doing it, that's fine, too.