Thanks for the response method.
I did try this code to read the following simple json file. I uploaded the file to the squarespace site rather than trying to call it from google drive.
<script>
fetch('https://www.waileage.org/s/testdata.json')
.then(response => response.json())
.then(data => console.log(data));
document.getElementById("container").innerHTML = data;
</script>
json file = [
['apple', 'fruit', 'red'],
['pear', 'fruit', 'yellow'],
['carrot', 'vegetable', 'orange'],
['eggplant', 'vegetable', 'purple']
]