Best way to streamline live data from Asana to Google Sheets

I have been struggling to find out how to export the JSON to google sheets to have a live updating spreadsheet. (The same “live source data” sheet that is created when exporting a portfolio). I would like to be able to use any JSON from any project to a spreadsheet so that I can build live reports that connect to that spreadsheet.